循环插入sqlite

code

import sqlite3
cx = sqlite3.connect("/Users/macname/Downloads/temp/ibook/db.sqlite3")
if(cx):
    print("success")
for i in range(1,70):
    cx.execute("insert into booklist_bookinfoc(id,book_name,book_user_name,book_url,book_passwd,book_pic,book_category,book_synopsis,book_type) values("+str(i)+",'CC至正四明续志"+str(i)+"','比尔·盖茨,乔布斯', 'https://pan.baidu.com/s/1J18zCTYoj_rYTuro17bKGw','ijui','/pic/22.jpg','CCfrfrfrfrf','CCfrfrfrfrfrf','C')")
cx.commit()
print("ok!!!!")

 

 

 

 

 

 

 

 

posted @ 2020-12-23 21:03  anobscureretreat  阅读(648)  评论(0编辑  收藏  举报