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)