pymssql
TEXT
1
import pymssql
建立连接
TEXT
1
conn = pymssql.connect(server='server_name', user='username', password='password', database='database_name', port=port_number)
创建游标
TEXT
1
cursor = conn.cursor()
执行查询
TEXT
1
cursor.execute('SELECT * FROM table_name')
获取结果
获取一行结果
TEXT
1
row = cursor.fetchone()
获取所有结果
TEXT
1
rows = cursor.fetchall()
提交更改
TEXT
1
conn.commit()
关闭连接
TEXT
1
conn.close()