import pymysql # 1.创建数据库连接 import pymysql as pymysql conn=pymysql.connect( user='future', password="123456", host='www.bai.com',database='loan',port=3306,charset="utf8",cursorclass=pymysql.cursors.DictCursor) # 2.创建游标 cursor=conn.cursor() # 3.执行sql语句 sql='select * from member limit 10' cursor.execute(sql) # 4.获取查询结果 res=cursor.fetchall() print(res) # 5.关闭游标 cursor.close() # 6.关闭连接 conn.close()
