def delete():
"""删除书目"""
bookID = request.form.get('bookID')
sql = f'delete from book where id = {bookID}'
student.Sql(sql)
booklist = admin.bookList('select * from book')
return render_template('admin.html', books=booklist)
def adminUI():
'''管理员界面'''
actnumber = request.form.get('actnumber')
password = request.form.get('password')
if actnumber == 'superUser' and password == '123456':
sql = 'select * from book'
booklist = admin.bookList(sql)
return render_template('admin.html', books=booklist)
else:
return index()
def adResult():
book = []
bookname = request.form.get('bookName')
if bookname == '':
return '请输入书名'
else:
sql = "select * from book where bookname like '%{}%' ".format(bookname)
book = admin.bookList(sql)
return render_template('adminResult.html', bookitem=book)
def index():
"""首页 显示所有书目"""
sql = 'select * from book'
booklist = admin.bookList(sql)
return render_template('index.html', books=booklist)