2022/3/15 python连接mysql

from pymysql import Connection

conn=Connection(
    host="localhost",
    port=3306,
    user="root",
    password="1234"
)
print(conn)
conn.select_db("mybatis")
cursor=conn.cursor()
cursor.execute("")
cursor.execute("select * from route")
result=cursor.fetchall()
# print(result)
for r in result:
    print(r)
conn.close()