第二个程序:用pymssql连接mssql数据库
pymssql好像很久没更新了,sf也被和谐了,只好从别处找了一个。
地址:http://pymssql.sourceforge.net/
安装过程就不用说了,免得搞得好像外行一样。
同样也是非常简陋的代码:
为什么这里的conn不能有state状态值呢,还要我自己生成一个变量太保存状态,真是麻烦,全部写到try里面又不好。
官方的例子:http://pymssql.sourceforge.net/example_pymssql.html
地址:http://pymssql.sourceforge.net/
安装过程就不用说了,免得搞得好像外行一样。
同样也是非常简陋的代码:
1
# -*- coding: cp936 -*-
2
import pymssql
3![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
conn_state = 1
5
try:
6
conn = pymssql.connect(host="127.0.0.1,2433", user="sa", password="***", database="mydb")
7
except:
8
print '连接数据库失败'
9
conn_state = 0
10![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
if 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![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
为什么这里的conn不能有state状态值呢,还要我自己生成一个变量太保存状态,真是麻烦,全部写到try里面又不好。
官方的例子:http://pymssql.sourceforge.net/example_pymssql.html