Python连接SQLServer2000

import pymssql

# 获取连接
conn = pymssql.connect(‘127.0.0.1‘,‘sa‘,‘ddh123‘,"aaa")

# 获取游标
cursor = conn.cursor()

# 执行sql
sql = ‘‘‘
    insert into t_user 
      (username,password,age,height)
    values 
      (‘alice2‘,‘1213‘,19,172)  
‘‘‘
num = cursor.execute(sql)  # 为占位符%s赋值

# 提交事务
conn.commit()

# 关闭资源
cursor.close()
conn.close()

from os import getenv
import pymssql

server = getenv("PYMSSQL_TEST_SERVER")
user = getenv("PYMSSQL_TEST_USERNAME")
password = getenv("PYMSSQL_TEST_PASSWORD")

conn = pymssql.connect(server,user,"tempdb")
cursor = conn.cursor()
cursor.execute("""
IF OBJECT_ID(‘persons‘,‘U‘) IS NOT NULL
    DROP TABLE persons
CREATE TABLE persons (
    id INT NOT NULL,name VARCHAR(100),salesrep VARCHAR(100),PRIMARY KEY(id)
)
""")
cursor.executemany(
    "INSERT INTO persons VALUES (%d,%s,%s)",[(1,‘John Smith‘,‘John Doe‘),(2,‘Jane Doe‘,‘Joe Dog‘),(3,‘Mike T.‘,‘Sarah H.‘)])
# you must call commit() to persist your data if you don‘t set autocommit to True
conn.commit()

cursor.execute(‘SELECT * FROM persons WHERE salesrep=%s‘,‘John Doe‘)
row = cursor.fetchone()
while row:
    print("ID=%d,Name=%s" % (row[0],row[1]))
    row = cursor.fetchone()

conn.close()

conn = pymssql.connect(server,"tempdb")
cursor = conn.cursor()
cursor.execute(‘SELECT * FROM persons WHERE salesrep=%s‘,‘John Doe‘)

for row in cursor:
    print(‘row = %r‘ % (row,))

conn.close()