8-4【任務(wù)8-4】在數(shù)據(jù)表中批量添加多條記錄

【任務(wù)8-4】在books數(shù)據(jù)表中批量添加多條記錄【任務(wù)描述】（1）在項目Unit08創(chuàng)建Python程序文件8-4.py。（2）連接已存在的MySQL數(shù)據(jù)庫“eCommerce”。（3）定義列表bookData，該列表的元素為元組，包含6個元素，每一個元素存放一本圖書的相關(guān)數(shù)據(jù)，對應(yīng)數(shù)據(jù)表中一條記錄的數(shù)據(jù)。（4）在數(shù)據(jù)表“books”中插入6條記錄數(shù)據(jù)?！救蝿?wù)實施】在PyCharm項目Unit08中創(chuàng)建Python程序文件8-4.py。在程序文件8-4.py中編寫程序代碼，實現(xiàn)所需功能?！救蝿?wù)實施】importpymysql#打開數(shù)據(jù)庫連接conn=pymysql.connect(host="localhost",user="root",password="123456",database="eCommerce",charset="utf8")#使用cursor()方法創(chuàng)建一個游標對象cursorcursor=conn.cursor()cursor.execute("deletefrombooks")#數(shù)據(jù)列表bookData=[("12528944","PPT設(shè)計從入門到精通",79.00,\"9787115454614","張曉景","人民郵電出版社","2019-1-1",1),("12563157","給Python點顏色青少年學編程",59.80,\"9787115512321","佘友軍","人民郵電出版社","2019-9-1",1),("12451724","Python從入門到項目實踐（全彩版）",99.80,\"9787569226614","明日科技","吉林大學出版社","2018-8-1",1),("12520987","樂學Python編程-做個游戲很簡單",69.80,\"9787302519867","王振世","清華大學出版社","2019/4/1",1),("12550531","Python編程錦囊（全彩版）",79.80,\"9787569250244","明日科技","吉林大學出版社","2019-6-1",1),("12325352","Python程序設(shè)計",39.60,\"9787040493726","黃銳軍","高等教育出版社","2018-3-1",1),]try:#執(zhí)行sql語句，插入多條數(shù)據(jù)

cursor.executemany("InsertIntobooks(商品編號,圖書名稱,價格,ISBN,作者,出版社,出版日期,版次)\values(%s,%s,%s,%s,%s,%s,%s,%s)",bookData)#提交數(shù)據(jù)

mit()exceptExceptionaserror:#發(fā)生錯誤時回滾

conn.rollback()print(error)#使用execute()方法執(zhí)行SQL查詢cursor.execute("Select*frombooks")data=cursor.fetchall()print("數(shù)據(jù)表中記錄數(shù):",len(da