我要删除database里面的文件,如果删除的时候无意输入database里不存在的文件就会prompt出一个error说"No such movie in database",我应该要怎么code呢?如果我用try except的话又要code在哪里呢?
def deleteMovie():
name=txtName.get()
if name=="":
messagebox.showinfo("Delete","Please enter <Name> to delete!")
else:
conn = sqlite3.connect('myMovieApp.db')
sql="Delete from movie where name=?"
conn.execute(sql,(name,))
conn.commit()
messagebox.showinfo("Success","<"+name+"> Delete Successful")
|