import pymysql# 连接数据库
conn = pymysql.connect(host='localhost',user='root',password='root',db='test',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor
)def data_upload(key, value):# print(f"Key:{key},Value:{value}")print(f"{key},{value}")try:# 创建游标对象with conn.cursor() as cursor:# 执行查询语句sql = "SELECT * FROM student WHERE id = %s"cursor.execute(sql, ('88',))# 获取查询结果result = cursor.fetchone()# 输出查询结果print(result)print(type(result))if result is not None and isinstance(result, dict):for key, value in result.items():data_upload(key, value)else:print("dict is null")finally:# 关闭数据库连接conn.close()
