pyodbc模块
pyodbc是ODBC的一个python封装,它允许任何平台上的python具有使用ODBC API的能力。要想与SqlServer数据库进行交互,需要先导入pyodbc模块。pyodbc的最新版是pyodbc3.0.7,下载地址为:https://pypi.python.org/pypi/pyodbc/
读取mysql的实例
'''
Created on Sep 11, 2014
@author: liu.chunming
'''
import pyodbc
def get_sms_operator(sectorNumber='0'):
cnxn=pyodbc.connect("DRIVER={SQL SERVER};SERVER=10.86.9.171;DATABASE=MCASDB;UID=mcas;PWD=Bdclab123")
cur=cnxn.cursor()
select="Select smsOperatorTag from [MCASDB].[dbo].[CaSMSOperator] where sectorNumber="+str(sectorNumber)
cur.execute(select)
#rows=cur.fetchall()
row=cur.fetchone()
if row:
return row
else:
raise Exception,"There seems no operator on sector:"+str(sectorNumbe