Python连接数据库

import  pymssql
# 连接数据库服务器
getConn = pymssql.connect('192.168.XXXXX','admin','123456','XXXXXX')
# 获取游标
getCursor=getConn.cursor()
# 执行SQL语句
getCursor.execute("select * from T_YY_MAINTENANCERECORD where repairOrder='1542347553075'")
result = getCursor.fetchone()
# 去掉,
results = (','.join(result))
print(results)
posted @ 2019-02-13 09:31  樊熙芈  阅读(174)  评论(0编辑  收藏  举报