#coding=utf8
import pymssql
python把字符串轉化為數字,class MSSQL:
def __init__(self,host,user,pwd,db):
self.host = host
python輸入字符串、self.user = user
self.pwd = pwd
self.db = db
python字符串截取,def __getConnect(self):
"""
得到連接信息
python中eval函數作用?返回: conn.cursor()
"""
if not self.db:
python編程?raise(nameError,"沒有設置數據庫信息")
self.conn = pymssql.connect(host=self.host,user=self.user,password=self.pwd,database=self.db,charset="utf8")
cur = self.conn.cursor()
if not cur:
raise(nameError,"數據庫連接失敗")
else:
return cur
def execQuery(self,sql):
"""
執行查詢語句
返回的是一個包含tuple的list,list的元素是記錄行,tuple的元素是每行記錄的字段
調用示例:
ms = MSSQL(host="localhost",user="sa",pwd="123456",db="PythonWeiboStatistics")
resList = ms.execQuery("select id,NickName from WeiBoUser")
for (id,NickName) in resList:
print str(id),NickName
"""
cur = self.__getConnect()
cur.execute(sql)
resList = cur.fetchall()
#查詢完畢后必須關閉連接
self.conn.close()
return resList
def exeNonQuery(self,sql):
"""
執行非查詢語句
調用示例:
cur = self.__getConnect()
cur.execute(sql)
self.conn.commit()
self.conn.close()
"""
cur = self.__getConnect()
cur.execut(sql)
self.conn.commit()
self.conn.close()
def main():
## ms = MSSQL(host="localhost",user="sa",pwd="123456",db="PythonWeiboStatistics")
## #返回的是一個包含tuple的list,list的元素是記錄行,tuple的元素是每行記錄的字段
## ms.exeNonQuery("insert into WeiBoUser values('2','3')")
ms = MSSQL(host="192.168.0.178",user="sa",pwd="xibao.2015",db="fortest")
resList = ms.execQuery("select top 10 ID,Name from CP_Dealer")
for (ID,Name) in resList:
print (str(Name).decode("utf8"))
if __name__ == '__main__':
main()
## print (str(Name).decode("utf8"))此處執行錯誤報錯,報錯內容如下]\
下面這個報錯就是直接打印str(Name)的錯誤。求指導啊~~
版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。
工作时间:8:00-18:00
客服电话
电子邮件
admin@qq.com
扫码二维码
获取最新动态