pymsql事物管理

1,conn 建立连接
2,cursor 建立游标
3,ping测试
4,建立查询语句
5,cursor.execute 执行

import pymysql
from pymysql.cursors import DictCursor

conn = pymysql.connect('192.168.106.128', 'xinzhu', '123456', 'test')
cursor = conn.cursor(DictCursor)
conn.ping(False)
sql = 'select * from employees'
cursor.execute(sql)
print(cursor.fetchall())

上下文:
连接类进入上下文,退出时提交更改,但是需要手动关闭conn(连接)
游标类使用上下文,退出时关闭游标对象

conn = pymysql.connect('192.168.106.128', 'xinzhu', '123456', 'test')
with conn as cursor:
    with cursor:
        sql = 'select * from employees'
        cursor.execute(sql)
        print(cursor.fetchmany(3))

conn.close()