08每周总结

08每周总结

发表时间：23.4.12

　　这周学会了用python连接数据库，代码如下

 

from pymysql import Connection

 

conn=Connection(

    host="localhost",

    port=3306,

    user="root",

    password="1234"

)

conn.select_db("mybatis")

cursor=conn.cursor()

 

cursor.execute("select * from student")

result=cursor.fetchall()

# print(result)

for r in result:

    print(r)

conn.close()