刚开始学习python &＃xff0c;之前学习一直是用mysql数据库&＃xff0c;一直连接成功&＃xff0c;今天项目需要连接mssql数据一直测试不成功&＃xff0c;搞了一天python3.6连接mssql2016 成功&＃xff0c;记录一下&＃xff1a;
在cmd下pip install pymssql 提示缺少Visual C&＃43;&＃43;14 &＃xff0c;网上下载下来安装&＃xff0c;提示卸载vs &＃xff0c;这个玩的比较大&＃xff0c;其实原因不在这里&＃xff0c;网上查看文章先下载pymssql-2.1.3-cp36-cp36m-win_amd64.whl 再初始化&＃xff1a;pip install E:\pymssql-2.1.3-cp36-cp36m-win_amd64.whl
在pycharm 里面也可以看到了 File->Settings->Project:项目名称->Project Interpreter
初始化包成功后就可以写代码了&＃xff0c;如下&＃xff1a;
#!/usr/bin/env python
# -*- coding: UTF-8 -*-
import pymssql
class MSSQL(object):
&＃39;&＃39;&＃39;
对pymssql的简单封装
pymssql库&＃xff0c;该库到这里下载&＃xff1a;http://www.lfd.uci.edu/~gohlke/pythonlibs/#pymssql
使用该库时&＃xff0c;需要在Sql Server Configuration Manager里面将TCP/IP协议开启
用法&＃xff1a;
&＃39;&＃39;&＃39;
def __init__(self,host,user,pwd,db):
self.host&＃61;host
self.user&＃61;user
self.pwd&＃61;pwd
self.db&＃61;db
def GetConnect(self):
&＃39;&＃39;&＃39;
得到链接信息
:return:
&＃39;&＃39;&＃39;
if not self.db:
raise (NameError,"没有设置数据库信息")
self.connect&＃61;pymssql.connect(host&＃61;self.host,user&＃61;self.user,password&＃61;self.pwd,database&＃61;self.db,charset&＃61;"utf8")
cur&＃61;self.connect.cursor()
if not cur:
raise (NameError,"链接数据库失败")
else:
return cur
def ExecQuery(self,sql):
&＃39;&＃39;&＃39;
执行查询语句
返回的是一个包含tuple的list&＃xff0c;list的元素是记录行&＃xff0c;tuple的元素是每行记录的字段
调用示例&＃xff1a;
ms &＃61; MSSQL(host&＃61;"localhost",user&＃61;"sa",pwd&＃61;"123456",db&＃61;"PythonWeiboStatistics")
resList &＃61; ms.ExecQuery("SELECT id,NickName FROM WeiBoUser")
for (id,NickName) in resList:
print str(id),NickName
:param sql: sql语句
:return:
&＃39;&＃39;&＃39;
cur&＃61;self.GetConnect()
cur.execute(sql)
resList &＃61; cur.fetchall()
#查询完毕后必须关闭连接
self.connect.close()
return resList
def ExecNonQuery(self, sql):
"""
执行非查询语句
调用示例&＃xff1a;
cur &＃61; self.__GetConnect()
cur.execute(sql)
self.conn.commit()
self.conn.close()
"""
cur &＃61; self.__GetConnect()
cur.execute(sql)
self.connect.commit()
self.connect.close()
def test():
## ms &＃61; MSSQL(host&＃61;"localhost",user&＃61;"sa",pwd&＃61;"123456",db&＃61;"PythonWeiboStatistics")
## #返回的是一个包含tuple的list&＃xff0c;list的元素是记录行&＃xff0c;tuple的元素是每行记录的字段
## ms.ExecNonQuery("insert into WeiBoUser values(&＃39;2&＃39;,&＃39;3&＃39;)")
ms &＃61; MSSQL(host&＃61;"172.16.2.248", user&＃61;"sa", pwd&＃61;"qazwsx", db&＃61;"cytest")
resList &＃61; ms.ExecQuery("SELECT * FROM t_user")
print(resList)
if __name__ &＃61;&＃61; &＃39;__main__&＃39;:
test()
python 连接各类主流数据库简单示例&＃xff1a;http://blog.csdn.net/a87b01c14/article/details/51546727
京公网安备 11010802041100号