关于#python#的问题:在爬取网页时候遇到name 'execute' is not defined的问题要怎么办呢

在爬取网页时候遇到这个问题是怎么回事呢

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