在爬取网页时候遇到这个问题是怎么回事呢
dbpath="book2501.db"
def init_db(dbpath):
sql='''
create table book2501
(
id integer primary key,
bookname text,
author text,
pubtime text,
price numeric,
rating_nums numeric,
quote text
)
'''
conn=sqlite3.connect(dbpath)
cursor=conn.cursor()
cuosor=execute(sql)
conn.commit()
conn.close()
def saveDataDB(datalist,dbpath):
init_db(dbpath)
conn=sqlite3.connect(dbpath)
cur=conn.cursor()
conn=sqlite3.connect(dbpath)
cur=conn.cursor()
i=1
for data in datalist:
dbdata=[]
dbdata.append(str(i))
for key,value in data.items():
if(key!='price'and key!='rating_nums'):
value='""'+value+'""'
if(key=='price'):
value=value.rstrip('元')
dbdata.append(value)
sql='''
insert into book2501
(id,bookname,author,pubtime,price,rating_nums,quote)
value(%s)'''%",".join(dbdate)
cur.execute(sql)
conn.commit()
i=i+1
cur.close()
conn.close()
print(...)
saveDataDB(books,dbpath)
报错是这样的
NameError: name 'execute' is not defined
17行的execute是数据库的对象方法吖,你要像16行那样子用conn.execute