地址:http://pymssql.sourceforge.net/
安装过程就不用说了,免得搞得好像外行一样。
同样也是非常简陋的代码:
1# -*- coding: cp936 -*-
2import pymssql
3
4conn_state = 1
5try:
6 conn = pymssql.connect(host="127.0.0.1,2433", user="sa", password="***", database="mydb")
7except:
8 print '连接数据库失败'
9 conn_state = 0
10
11if conn_state == 1:
12 mlist = conn.cursor()
13 msql = "SELECT Site_ID, Site_Name_CN FROM IMI_Site WHERE SiteType_ID = 1"
14 mlist.execute(msql)
15 for (site_Id, site_Name) in mlist.fetchall():
16 print str(site_Id) + "\t" + site_Name
17 conn.close()
18
2import pymssql
3
4conn_state = 1
5try:
6 conn = pymssql.connect(host="127.0.0.1,2433", user="sa", password="***", database="mydb")
7except:
8 print '连接数据库失败'
9 conn_state = 0
10
11if conn_state == 1:
12 mlist = conn.cursor()
13 msql = "SELECT Site_ID, Site_Name_CN FROM IMI_Site WHERE SiteType_ID = 1"
14 mlist.execute(msql)
15 for (site_Id, site_Name) in mlist.fetchall():
16 print str(site_Id) + "\t" + site_Name
17 conn.close()
18
为什么这里的conn不能有state状态值呢,还要我自己生成一个变量太保存状态,真是麻烦,全部写到try里面又不好。
官方的例子:http://pymssql.sourceforge.net/example_pymssql.html