名称错误：名称'db'未定义，任何人都可以向我解释一下，我是该领域的新手，需要指南

Question

dbc_in_file = sqlite3.connect('park') #create db in file if not exists
dbc_in_file.close()
dbc_in_file = sqlite3.connect('park1') #connect to db
db_cursor = dbc_in_file.cursor() 
################################################
#TABLE FOR CUSTOMER INFO
db_cursor.execute('''CREATE TABLE PARK_INFO
(CUSTOMER_ID INT PRIMARY KEY NOT NULL,
SLOTS_RESERVED  INT ,
SLOTS_OCCUPIED INT);''')
tup1=(100,3,1)
tup2=(101,2,0)
tup3=(102,15,8)
data=[tup1,tup2,tup3]
db_cursor.executemany("insert into PARK_INFO values (?, ?, ?)",data)
dbc_in_file.commit()
db_cursor.execute("SELECT CUSTOMER_ID, SLOTS_RESERVED, SLOTS_OCCUPIED from PARK_INFO")
print(db_cursor.fetchall())
db_cursor.execute("drop table PARK_INFO") 
#################################################
#TABLE FOR VECHILE INFO OF CUSTOMERS
db_cursor.execute('''CREATE TABLE VECHILEEe_INFO
(CUSTOMER_ID INT PRIMARY KEY NOT NULL,
VECHILE_TYPE TEXT NOT NULL,
TIME_REQUIRED_HRS INT);''' )
tup1=(101,'car',4)
tup2=(102,'truck',10)
tup3=(103,'bike',2)
data=[tup1,tup2,tup3]
db_cursor.executemany("insert into VECHILEEe_INFO values (?, ?, ?)",data)
dbc_in_file.commit()
db.cursor.execute("SELECT CUSTOMER_ID, VECHILE_TYPE, TIME_REQUIRED_HRS from VECHILEEe_INFO")
print(db_cursor.fetchall())
db_cursor.execute("drop table VECHILEEe_INFO")

有时它还告诉我们表vechilee_info已经存在，如何解决这个问题呢

代码中还有其他错误吗？

Answer 1

如果已经存在，则删除表

DROP TABLE IF EXISTS vechileee_info;

也不应该

db.cursor.execute("SELECT CUSTOMER_ID, VECHILE_TYPE, TIME_REQUIRED_HRS from VECHILEEe_INFO")

是

db_cursor.execute("SELECT CUSTOMER_ID, VECHILE_TYPE, TIME_REQUIRED_HRS from VECHILEEe_INFO")

可能是什么原因导致数据库未定义错误