使用框架:pymysql
安装:pip install pymysql
# 导入方法
import pymysql
host = '' # 数据库地址
port = '' # 端口
user = '' # 用户名
password = '' # 密码
class mysql_help():
# 封装execute方法,执行sql和提交sql并返回conn和cursor
def execute(self,sql,db=''):
# db-数据库名称,可默认赋值常用的数据库名
# 连接数据库
conn = pymysql.connect(host=host,port=port,user=user,password=password,db=db)
# 创建游标
cursor = conn.cursor()
# 执行sql
cursor.execute(sql)
# 提交sql
conn.commit()
return conn,cursor
# 关闭连接
def close_(conn,cursor)
cursor.close()
conn.close()
# 读取表数据
def select_():
try:
sql = f'select {查询内容} from {表名} where {查询条件}'
conn,cursor = self.execute(sql) # 执行sql
result = cursor.fetchall() # 获取返回结果
return result # 返回结果
finally:
# 关闭连接
self.close_(conn,cursor)
# 修改数据
def update_():
try:
sql = f'update {表名} set {修改字段} where {修改条件}'
conn,cursor = self.execute(sql) # 执行sql
finally:
self.close_(conn,cursor)
# 删除数据
def delete_():
try:
sql = f'delete from {表名} where {删除条件}'
conn,cursor = self.execute(sql)
finally:
self.close_(conn,cursor)
# 增加数据
def insert_():
try:
sql = f'insert into {表名} ({字段名}) values({字段值})'
conn,cursor = self.execute(sql)
finally:
self.close_(conn,cursor)
# 需要经常重复执行增删改查的操作可以把sql按上面的方法封装好方便反复调用
---------------------------------------------------------------------------------
# 单次查询sql可以再次分装一下增删改查
# i- 1-查,其他-删改增
def sql_execute(sql,i=1,db=''):
try:
conn,cursor = self.execute(sql,db)
if i == 1:
result = cursor.fetchall()
else:
result = '删改增'
return result
finally:
self.close_(conn,cursor)
# select 查询的返回结果是元祖格式((),(),())



