def saveData2DB(datalist,dbpath): init_db(dbpath) conn=sqlite3.connect(dbpath) cur=conn.cursor() for data in datalist: for index in range(len(data)): if index==4 or index==5: continue data[index]='"'+data[index]+'"' sql=''' insert into movie250( info_link,pic_link,cname,ename,score,rated,instroduction,info) values (%s)''' % (",").join(data) print(sql) cur.execute(sql) conn.commit() cur.close() conn.close()def init_db(dbpath): sql=''' create table movie250 ( id integer primary key autoincrement, info_link text, pic_link text, cname varchar, ename varchar, score numeric, rated numeric, instroduction text, info text ) ''' #创建数据表 conn=sqlite3.connect(dbpath) cursor=conn.cursor() cursor.execute(sql) conn.commit() conn.close()