day05-pymysql进行数据库操作

import pymysql

def sql_execute():
    con = pymysql.connect(database="JD",host="localhost",port=3306,user="root",password="123456789")
    cursor = con.cursor()
    sql = "select * from goods;"
    cursor.execute(sql)
    #获取查询结果
    data = cursor.fetchall()
    for line in data:
        print(line)
    usql = "update goods set price=2888.88 where id=1"
    cursor.execute(usql)
    #! 涉及到修改数据的必须用con.commit()来进行更新数据库
    con.commit()
    cursor.execute(sql)
    data = cursor.fetchall()
    for line in data:
        print(line)
         
    cursor.close()
    
if __name__ == "__main__":
    sql_execute()