Python实现连接mssql数据库操作

Python 想要和MSSql数据库进行交互&＃xff0c;首先要下载名为"pymssql"的包&＃xff0c;然后import该包

 Python实现连接mssql数据库&＃xff0c;并做简单的操作&＃xff1a;查询和非查询操作&＃xff0c;代码如下&＃xff1a;

#!usr/bin/python# -*- coding:utf-8 -*-import pymssqlclass MSSQL:def __init__(self,host,user,pwd,db):self.host &＃61; hostself.user &＃61; userself.pwd &＃61; pwdself.db &＃61; dbdef __GetConnect(self):if not self.db:raise(NameError,"no ")# 打开数据库连接self.conn &＃61; pymssql.connect(host&＃61;self.host,user&＃61;self.user,password&＃61;self.pwd,database&＃61;self.db,charset&＃61;"utf8")# 使用cursor()方法获取操作游标cur &＃61; self.conn.cursor()if not cur:raise(NameError,"connect database fails") else:return curdef ExecQuery(self,sql):try&＃xff1a;cur &＃61; self.__GetConnect()# 执行SQL语句cur.execute(sql)# 获取所有记录列表rows &＃61; cur.fetchall()cur.close()# 关闭数据库连接self.conn.close()return rowsexcept:print "Error: unable to fecth data"def ExecNonQuery(self,sql):try:cur &＃61; self.__GetConnect()cur.execute(sql)# 提交到数据库执行self.conn.commit()self.conn.close()except:# 发生错误时回滚db.rollback()if __name__ &＃61;&＃61; "__main__":ms &＃61; MSSQL(host&＃61;"localhost",user&＃61;"sa",pwd&＃61;"sasa",db&＃61;"dbname")rows &＃61; ms.ExecQuery("select * from T_EMP")for i in rows:print i

 使用的开发工具为pycharm社区版&＃xff0c;运行上面的代码&＃xff0c;老是通不过&＃xff0c;按照提示的错误在网上查找解决办法&＃xff0c;试了不少问题以依旧&＃xff1b;最后将开发工具pycharm换成专业版的&＃xff0c;上面的代码就能顺利运行了。