"""中级封装python 封装 mysql"""
from contextlib import contextmanager
from pymysql import connect
@contextmanager
def DB(database):
# 初始化链接
# 创建connection 链接
conn = connect(host='localhost', port=3306, user='root', password='xxxx', database=database, charset='utf8')
# 获取cursor 对象
cs = conn.cursor()
yield conn, cs # 返回操作对象
# 关闭链接
cs.close()
conn.close()
with DB("xxx") as (conn, cs):
sql = """select * from goods"""
cs.execute(sql)
table_content = cs.fetchall()
conn.commit()
# 打印结果
for temp in table_content:
print(temp)
python操作mysql上下文版(三)
最新推荐文章于 2022-12-07 18:25:36 发布