刘艺运维.zip

from flask import Flask, render_template, request import pymysql app = Flask(__name__) # 打开数据库连接 db = pymysql.connect(host='localhost', port=3306, user='root', password='123456', database='liuyi') # 使用cursor()方法获取操作游标 cursor = db.cursor() @app.route('/') def home(): return render_template('home.html') @app.route('/enternew') def new_student(): return render_template('student.html') @app.route('/delete/<name>', methods=['POST', 'GET']) def delete(name): try: # SQL 删除语句 sql = "DELETE FROM LibraryManagementSystem WHERE name = '%s'" % (name) # 执行SQL语句 cursor.execute(sql) # 提交修改 db.commit() msg = "记录删除成功!" except: # 发生错误时回滚 db.rollback() msg = "记录删除失败!" finally: return render_template("result.html", msg=msg) # 关闭连接 db.close() @app.route('/edit/<name>', methods=['POST', 'GET']) def edit(name): try: sql = "select * from LibraryManagementSystem where name='%s'" % (name) # 执行SQL语句 cursor.execute(sql) # 获取所有记录列表 row = cursor.fetchone() print(row) except: msg = "记录读取失败!" finally: return render_template("edit.html", row=row) # 关闭连接 db.close() @app.route('/editsuc/<name>', methods=['POST', 'GET']) def edit_success(name): if request.method == 'POST': try: name = request.form['name'] academy = request.form['academy'] book = request.form['book'] number = request.form['number'] # SQL 更新语句 sql = "UPDATE LibraryManagementSystem SET academy='%s',book='%s',number='%s' WHERE name='%s'" % (academy, book, number, name) # 执行SQL语句 cursor.execute(sql) # 提交到数据库执行 db.commit() msg = "记录更新成功!" except: # 发生错误时回滚 db.rollback() msg = "记录更新失败!" finally: return render_template("result.html", msg=msg) # 关闭数据库连接 db.close() @app.route('/addrec', methods=['POST', 'GET']) def addrec(): if request.method == 'POST': try: name = request.form['name'] # 姓名 academy = request.form['academy'] # 书院 book = request.form['book'] # 书名 number = request.form['number'] # 号码 # SQL 插入语句 sql = "INSERT INTO LibraryManagementSystem(name,academy,book,number) VALUES ('%s', '%s', '%s', '%s')" % (name, academy, book, number) print(sql) # 执行sql语句 cursor.execute(sql) # 执行sql语句 db.commit() msg = "记录添加成功!" except: # 发生错误时回滚 db.rollback() msg = "记录添加失败!" finally: return render_template("result.html", msg=msg) db.close() @app.route('/list') def list(): try: # SQL 查询语句 sql = "SELECT * FROM LibraryManagementSystem" # 执行SQL语句 cursor.execute(sql) # 获取所有记录列表 rows = cursor.fetchall() # print(rows) except: msg = "记录读取失败!" finally: return render_template("list.html", rows=rows) db.close() if __name__ == '__main__': app.run(debug=True)