# *.* coding=utf-8 *.*
import pymssql
server = "127.0.0.1"
# 连接服务器地址
user = 'sqluser'
# 连接帐号
password = "password"
# 连接密码
with pymssql.connect(server,user,password,'YOURDATABASE',charset="UTF-8") as conn:
with conn.cursor(as_dict=True) as cursor: # 数据存放到字典中
cursor.execute('SELECT * FROM AccessLevel_Table WHERE RecordID=1')
for row in cursor:
print("ID=%d" % (row['RecordID']))
通过以上可以把数据库的ID打印出来,能打印出来就说明连接成功了