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()

2、Python连接MYSQL

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()

标签：com lse oca tuple fail cut mysq server 游标