#默认会安装pip3依赖
yum install python3

mkdir .pip
vim .pip/pip.conf
[global]
index-url = https://pypi.tuna.tsinghua.edu.cn/simple

pip3 install pymssql

[root@hdpprdd02 ~]# cat sql.py 
# coding=utf-8
import pymssql

class SQLServer:
    def __init__(self,server,user,password,database):
    # 类的构造函数，初始化DBC连接信息
        self.server = server
        self.user = user
        self.password = password
        self.database = database

    def __GetConnect(self):
    # 得到数据库连接信息，返回conn.cursor()
        if not self.database:
            raise(NameError,"没有设置数据库信息")
        self.conn = pymssql.connect(server=self.server,user=self.user,password=self.password,database=self.database)
        cur = self.conn.cursor()
        if not cur:
            raise(NameError,"连接数据库失败")  # 将DBC信息赋值给cur
        else:
            return cur

    def ExecQuery(self,sql):
        '''
        执行查询语句
        返回一个包含tuple的list，list是元素的记录行，tuple记录每行的字段数值
        '''
        cur = self.__GetConnect()
        cur.execute(sql) # 执行查询语句
        result = cur.fetchall() # fetchall()获取查询结果
        # 查询完毕关闭数据库连接
        self.conn.close()
        return result

def main():
    msg = SQLServer(server="sqlserverIP",user="username",password="password",database="dbname")
    sqlstr="YOUR  sql "
    result = msg.ExecQuery(sqlstr)
    for (Value) in result:
        print(Value)

if __name__ == '__main__':
    main()