import pymysql
# 打开数据库连接(ip/数据库用户名/登录密码/数据库名)
db = pymysql.connect(host='localhost',user='root',password='',database='test',port=3306,charset='utf8')# 使用 cursor() 方法创建一个游标对象 cursor
cursor = db.cursor()
# 使用 execute() 方法执行 SQL 查询
sql_insert="insert into class (id,name,monitor) VALUES ('3','二班','1605040101')"
sql_update="update class set name='你猜猜' WHERE id ='2' "
sql_delete="delete from class WHERE id = '5'"
#增删改
try:
cursor.execute(sql_insert)
print(cursor.rowcount)
cursor.execute(sql_update)
print(cursor.rowcount)
cursor.execute(sql_delete)
print(cursor.rowcount)
except Exception as e:
print(e)
db.rollback() #未完全执行完回滚
#查
sql_query="select * from class"
cursor.execute(sql_query)
date=cursor.fetchall()
print(date)
cursor.close()
db.commit() #提交事务
db.close()