import pymysql
db = pymysql.connect(host='localhost', user='root', password='123456')
db.select_db('test')
db.set_charset('utf8')
cursor = db.cursor()
# 开启事务
db.begin()
try:
sql = 'insert into user(username, password, gid) values("xiaoming", "123456", 2)'
# 对于DML:返回的是受影响的行数
rowcount = cursor.execute(sql)
# raise Exception('出现异常')
print(rowcount)
# 提交事务
db.commit()
# 最后插入数据的自增id
print(cursor.lastrowid)
except Exception as e:
print(e)
# 回滚所有操作
db.rollback()
cursor.close()
db.close()