Python连接SQLServer2000或连接mysql代码示例

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

# 获取游标，相当于java中的Statement
cursor = db.cursor()

# 执行sql
sql = ‘‘‘
    insert into t_user 
      (username,password,age,height)
    values 
      (‘jlw‘,‘23333‘,31,172)  
‘‘‘
try:
   cursor = db.cursor()
   cursor.execute(sql)
   print(‘Successfu_sqlserver‘)
   db.commit()
except:
   print(‘Failed_sqlserver‘)
   db.rollback()

cursor.close()
db.close()

import pymysql
db = pymysql.connect(host=‘localhost‘,user=‘root‘,password=‘123‘,port=3306,db=‘aaa‘)
data = {
    ‘username‘: ‘abc333d‘,‘password‘: ‘123456‘,‘age‘: 21,‘height‘:176
}
table = ‘t_user‘
keys = ‘,‘.join(data.keys())
values = ‘,‘.join([‘%s‘] * len(data))

sql = ‘INSERT INTO {table}({keys}) VALUES ({values})‘.format(table=table,keys=keys,values=values)
try:
   cursor = db.cursor()
   cursor.execute(sql,tuple(data.values()))
   print(‘Successful‘)
   db.commit()
except:
   print(‘Failed‘)
   db.rollback()
cursor.close()
db.close()