import pymysql #定义数据库连接 db = pymysql.connect( host = '127.0.0.1', user = 'root', password = '123456', port = 3306, database = 'bookmanager', ) #cursor = db.connect() siteid = 1 sitename = '起点' siteurl = 'https://www.qidian.com' #1.插入数据 try: with db.cursor() as cursor: insert = 'insert into siteinfo (siteid, sitename,siteurl) values (%s, %s, %s)' data = (siteid,sitename,siteurl) cursor.execute(insert,data) db.commit() except: print('something wrong') db.rollback() finally: db.close() #2.更新数据 #update siteinfo set siteurl = %s where siteid = %s try: with db.cursor() as cursor: update = 'update siteinfo set siteurl = %s where siteid = %s' data = (siteurl, siteid) cursor.execute(update,data) db.commit() except: print('something wrong') db.rollback() finally: db.close()