一、 无需实现model.py文件获取实例对象就能直接通过连接数据库进行数据的增删改查操作
# 连接数据库用于查询(查询单个或多个)
def db_query(sql):
# 打开数据库连接
db = pymysql.connect(host="localhost", user="用户名", password="密码", database="数据库名")
# 使用cursor()方法获取操作游标
cursor = db.cursor()
# 创建数据表SQL语句
cursor.execute(sql)
results = cursor.fetchall()
countries = []
try:
# 获取查询全部数据
# for i in results:
# print(i)
# countries.append(i)
# 查询得到某一字段
for i in results:
# 过滤重复城市名
if i in countries:
continue
# print(i)
countries.append(i)
except:
print("查询出错")
# 关闭数据库连接
cursor.close()
db.close()
return countries
# 连接数据库用于增删改
def db_update(sql):
db = pymysql.connect(host="localhost", user="用户名", password="密码", database="数据库名")
cursor = db.cursor()
try:
cursor.execute(sql)
# 提交修改
db.commit()
except:
db.rollback()
db.close()
调用
# 查询所有
for i in range(0,len(crops)):
sql = """SELECT *FROM othersproduction WHERE crops like "%s" AND years = 1961""" % (f'%{crops[i]}%')
results = db_query(sql)
print(results)
# 查单个
sql="select *from rate where id = 5245"
db_query(sql)
# 增
sql = """insert into rate values(5245,"china", 2022,1111,0,'成功了!!!')"""
db_update(sql)