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()
python连接MySQL获取表中数据
于 2024-09-06 17:29:52 首次发布