1、安装epel源：yum-yinstallepel-release2。安装pip：yum-yinstallpython-pip3。清除缓存：yumcleanall4。升级pip：pipinstall--upgradepip5。安装pymssql:pipinstallpymssql1#!/usr/bin/envpython2#-*-coding:utf-8-*-34importpymssql56classMSSQL:7def__init__(self,host,user,pwd,db):8self.host=host9self.user=user10self.pwd=pwd11self.db=db1213def__GetConnect(self):14ifnotself.db:15raise(NameError,"Nodatabaseinformationset")16self.conn=pymssql。connect(host=self.host,user=self.user,password=self.pwd,database=self.db,charset="utf8")17cur=self.conn.cursor()18ifnotcur:19raise(NameError,"无法连接到数据库")20else:21returncur2223defExecQuery(self,sql):24cur=self.__GetConnect()25cur.execute(sql)26resList=cur.fetchall()2728#query完成后必须关闭连接29self.conn.close()30returnresList3132defExecNonQuery(self,sql):33cur=self.__GetConnect()34cur.execute(sql)35self.conn.commit()36self.conn.close()3738ms=MSSQL(host="10.7.125.1",user="sa",pwd="test",db="test1")39reslist=ms.ExecQuery("select"field"from"tablename"where"conditionfield"=5")40foriinreslist:41print(i)4243newsql="update"表名"set"field"='%s'where"conditionfield"="valuebeforechange"%u'valueafterchange'44print(newsql)45ms.ExecNonQuery(newsql.encode('utf-8'))
