import pymysql
# 获取数据库连接
from service.vr_whms import mysql_info
db = pymysql.connect(
host=mysql_info['host'],
port=mysql_info['port'],
user=mysql_info['user'],
password=mysql_info['password'],
charset='utf8',
database=mysql_info['database']
)
cursor = db.cursor()
# 查询一条数据
def query_one(sql):
try:
cursor.execute(sql)
one = cursor.fetchone()
return list(one)
finally:
cursor.close()
db.close()
# 查询三条数据
def query_many(sql):
try:
cursor.execute(sql)
one = cursor.fetchmany(size=3)
return list(one)
finally:
cursor.close()
db.close()
# 查询所有数据
def query_all(sql):
try:
cursor.execute(sql)
one = cursor.fetchall()
return list(one)
finally:
cursor.close()
db.close()
# 执行插入、更新、删除操作
def update(sql):
try:
cursor.execute(sql)
db.commit()
except Exception as e:
print(e)
db.rollback()
finally:
cursor.close()
db.close()
python连接mysql数据库
最新推荐文章于 2024-09-15 22:31:42 发布