devbox
花生_TL007
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Flask+MySQL学生信息维护系统_flask学生信息管理

作者：花生_TL007 | 2024-04-16 03:35:26

赞

踩

flask学生信息管理

 Python课程期末项目，小白一个

【学生信息维护系统项目概述】

        学生管理系统是一个基于 Python 的 Flask + MySQL 项目，旨在实现对学生信息的管理和查询。该系统主要包括学生信息录入、信息查询、信息修改和信息删除，信息可视化等功能，以提高学校或教育机构对学生信息的管理效率和准确性。

【功能要求】

  1. 学生信息录入：管理员可以添加学生信息，包括学生学号、姓名、性别、年龄等。
  2. 学生信息查询：管理员可以根据学生姓名、学号条件进行学生信息的查询，并展示查询结果。
  3. 学生信息修改：管理员可以根据学生学号进行学生信息的修改，包括姓名、性别、年龄等。
  4. 学生信息删除：管理员可以根据学生学号进行学生信息的删除操作。
  5. 学生信息排序：管理员可以根据学生年龄进行学生信息的升序排序
  6. 数据统计与分析：系统可以进行学生信息的统计和分析，如统计男女性别比例，并以饼状图显示
  7. 登录与访问控制：系统需要实现用户登录功能，并对访问系统的权限进行控制，确保只有授权用户可以进行相关操作

【运行视频】

https://www.bilibili.com/video/BV1BV4y1y7aG/?spm_id_from=333.999.0.0&vd_source=3ea11718fcda196523e3437c32bc83a6

【项目结构】

templates放的是前端代码，static是前端页面的美化文件，chart.png是生成的性别比例饼图

【数据库】

使用的MySQL数据库，8.0.26版本

数据库名flask，表名student

 

【登录功能】

登录功能没有使用数据库连接，直接写死了

可以通过设置Method指定提交方式为GET或者POST提交方式，默认为GET提交方式。

  1. @app.route('/login', methods=['GET', 'POST'])  # 登录功能
  2. def user_login():
  3.     if request.method == 'GET':
  4.         return render_template('login.html')
  5.     username = request.form.get('username')
  6.     password = request.form.get('password')
  7.     if username == 'admin' and password == '123':
  8.         return redirect(url_for('admin'))
  9.     elif username == '' or password == '':
  10.         js_code = "<script>alert('请输入账号密码！'); history.back();</script>"
  11.         return js_code
  12.     else:
  13.         js_code = "<script>alert('登陆失败！'); history.back();</script>"
  14.         return js_code
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <html>
  4. <head>
  5.     <meta charset="utf-8"/>
  6.     <title>Login</title>
  7.     <link rel="stylesheet" type="text/css" href="../static/css/index.css"/>
  8.     <link rel="stylesheet" type="text/css" href="../static/css/iconfont.css"/>
  9. </head>
  10. <body>
  11.  
  12. <form action="/login" method="post">
  13.     <div id="login-box">
  14.         <h1>Login</h1>
  15.         <div class="input-box">
  16.             <i class="iconfont">&#xe609;</i>
  17.             <input name="username" type="text" class="loginuser" value="" placeholder="UserName"/>
  18.         </div>
  19.         <div class="input-box">
  20.             <i class="iconfont">&#xe605;</i>
  21.             <input name="password" type="password" class="loginpwd" value="" placeholder="UserPassword"/>
  22.         </div>
  23.         <button type="submit" class="btn btn-primary">登录</button>
  24.     </div>
  25. </form>
  26. </body>
  27. </html>
  28.

 【添加学生信息】

通过前端获取的信息进行判断，再进入数据库

  1. @app.route('/add', methods=['GET', 'POST'])  # 添加学生
  2. def add():
  3.     if request.method == 'GET':
  4.         return render_template('add.html')
  5.     else:
  6.         id = request.form.get('id')
  7.         name = request.form.get('name')
  8.         sex = request.form.get('sex')
  9.         age = request.form.get('age')
  10.         stu = getStudent(id)
  11.         if id == "" or name == "" or sex == "" or age == "":
  12.             js_code = "<script>alert('请填写完整信息！'); history.back();</script>"
  13.             return js_code
  14.         elif stu:
  15.             js_code = "<script>alert('学生已存在！'); history.back();</script>"
  16.             return js_code
  17.         else:
  18.             addstudent(id, name, sex, age)
  19.             return redirect(url_for('admin'))
  20.  
  21. def addstudent(id, name, sex, age):
  22.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  23.     cursor = db.cursor()
  24.     sql = "insert into student (id,name,sex,age) values ('" + id + "','" + name + "','" + sex + "','" + age + "')"
  25.     cursor.execute(sql)
  26.     db.commit()
  27.     db.close()
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <html>
  4. <head>
  5.     <meta charset="utf-8"/>
  6.     <title>新增数据</title>
  7.     <link rel="stylesheet" type="text/css" href="../static/css/bootstrap.css"/>
  8. </head>
  9. <body>
  10. <form action="/add" style="width: 400px; margin: 100px auto" method="post">
  11.     <div class="mb-3">
  12.         <label for="id" class="form-label">学号</label>
  13.         <input type="text" class="form-control" id="id" aria-describedby="emailHelp" name="id">
  14.     </div>
  15.     <div class="mb-3">
  16.         <label for="name" class="form-label">姓名</label>
  17.         <input type="text" class="form-control" id="name" name="name">
  18.     </div>
  19.     <div class="mb-3">
  20.         <label for="english" class="form-label">性别</label>
  21.         <input type="text" class="form-control" id="sex" name="sex">
  22.     </div>
  23.     <div class="mb-3">
  24.         <label for="python" class="form-label">年龄</label>
  25.         <input type="text" class="form-control" id="age" name="age">
  26.     </div>
  27.     <button type="submit" class="btn btn-primary">添加</button>
  28. </form>
  29. </body>
  30. </html>
  31.

【删除学生信息】

通过判断获取id是否存在数据库中进行删除操作

  1. @app.route('/delete/<id>', methods=['GET'])  # 删除学生
  2. def delete(id):
  3.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  4.     cursor = db.cursor()
  5.     sql = "delete from student where id=" + str(id)
  6.     cursor.execute(sql)
  7.     db.commit()
  8.     db.close()
  9.     return redirect(url_for('admin'))
  1. <form action="/delete/{{ stu[0] }}" method="get" style="display: inline-block;">
  2.     <button type="submit" class="btn btn-outline-danger btn-sm">删除</button>
  3. </form>

【修改学生信息】

先根据学生id读取数据库学生信息，显示在前端表单

再获取修改后的信息，更新数据库

  1. @app.route('/modify/<id>', methods=['GET', 'POST'])  # 修改学生
  2. def modify(id):
  3.     if request.method == 'GET':
  4.         students = getStudents()
  5.         editStudent = getStudent(id)
  6.         id = editStudent[0]
  7.         name = editStudent[1]
  8.         sex = editStudent[2]
  9.         age = editStudent[3]
  10.         return render_template('modify.html', students=students, id=id, name=name, sex=sex, age=age)
  11.     else:
  12.         id = request.form.get('id')
  13.         name = request.form.get('name')
  14.         sex = request.form.get('sex')
  15.         age = request.form.get('age')
  16.         if name == '' or sex == '' or age == '':
  17.             js_code = "<script>alert('请输入修改信息！'); history.back();</script>"
  18.             return js_code
  19.         else:
  20.             updateStudent(id, name, sex, age)
  21.             return redirect(url_for('admin'))
  22.  
  23. def updateStudent(id, name, sex, age):
  24.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  25.     cursor = db.cursor()
  26.     sql = "update student set name='%s',sex='%s', age='%s' WHERE id=%s" % (name, sex, age, id)
  27.     cursor.execute(sql)
  28.     print(sql)
  29.     db.commit()
  30.     db.close()
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <html>
  4. <head>
  5.     <meta charset="utf-8"/>
  6.     <title>修改数据</title>
  7.     <link rel="stylesheet" type="text/css" href="../static/css/bootstrap.css"/>
  8. </head>
  9. <body>
  10. <form action="/modify/{{ id }}" style="width: 400px; margin: 100px auto" method="post">
  11.     <div class="mb-3">
  12.         <label for="id" class="form-label">学号</label>
  13.         <input type="text" class="form-control" id="id" name="id" value="{{ id }}"readonly>
  14.     </div>
  15.     <div class="mb-3">
  16.         <label for="name" class="form-label">姓名</label>
  17.         <input type="text" class="form-control" id="name" name="name" value="{{ name }}">
  18.     </div>
  19.     <div class="mb-3">
  20.         <label for="english" class="form-label">性别</label>
  21.         <input type="text" class="form-control" id="sex" name="sex" value="{{ sex }}">
  22.     </div>
  23.     <div class="mb-3">
  24.         <label for="python" class="form-label">年龄</label>
  25.         <input type="text" class="form-control" id="age" name="age" value="{{ age }}">
  26.     </div>
  27.  
  28.     <button type="submit" class="btn btn-primary">修改</button>
  29. </form>
  30.  
  31. </body>
  32. </html>
  33.

【查询学生信息】

根据姓名查询为模糊查询

根据学号查询诶精准查询

  1. @app.route('/search', methods=['POST'])  # 查询学生
  2. def search():
  3.     if request.form.get('name') != '':  # 根据姓名查询
  4.         name = request.form.get('name')
  5.         students = searchstudents(name)
  6.         return render_template('admin.html', student=students)
  7.     elif request.form.get('id') != '':  # 根据学号查询
  8.         id = request.form.get('id')
  9.         students1 = searchstu1(id)
  10.         return render_template('admin.html', student=students1)
  11.     elif request.form.get('id') == '' and request.form.get('name') == '':
  12.         js_code = "<script>alert('请输入查询内容！'); history.back();</script>"
  13.         return js_code
  14. def searchstudents(name):
  15.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  16.     cursor = db.cursor()
  17.     sql = "select * from student where name like '%" + name + "%'"
  18.     cursor.execute(sql)
  19.     rows = cursor.fetchall()
  20.     for row in rows:
  21.         print(row[1])
  22.     db.close()
  23.     return rows
  24. def searchstu1(id):
  25.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  26.     cursor = db.cursor()
  27.     sql = f"select * from student where id={id}"
  28.     cursor.execute(sql)
  29.     rows = cursor.fetchall()
  30.     for row in rows:
  31.         print(row[1])
  32.     db.close()
  33.     return rows
  1. <form action="/search" class="row g-3" method="post">
  2.     <div class="col-auto">
  3.         <label class="visually-hidden">学号</label>
  4.         <input type="text" class="form-control" name="id" placeholder="学号">
  5.     </div>
  6.     <div class="col-auto">
  7.         <label class="visually-hidden">姓名</label>
  8.         <input type="text" class="form-control" name="name" placeholder="姓名">
  9.     </div>
  10.     <div class="col-auto">
  11.         <button type="submit" class="btn btn-outline-success mb-3">查找</button>
  12.     </div>
  13. </form>

【排序学生信息】

读取学生年龄，ASC升序排序

  1. @app.route('/sort', methods=['GET'])  # 根据年龄排序
  2. def sort():
  3.     students = get_Sort_Students()
  4.     return render_template('admin.html', student=students)
  5. def get_Sort_Students():
  6.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  7.     cursor = db.cursor()
  8.     sql = "select * from student order by  age asc"
  9.     cursor.execute(sql)
  10.     row = cursor.fetchall()
  11.     db.close()
  12.     return row
  1. <form action="/sort" class="row g-3">
  2.     <div class="col-auto">
  3.         <button type="submit" class="btn btn-outline-info mb-3">排序</button>
  4.     </div>
  5. </form>

【学生信息可视化】

将数据库读取到的性别比例写为列表，再创建饼图

  1. @app.route('/home')
  2. def home():
  3.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  4.     cursor = db.cursor()
  5.     query = "select sex, count(*) from student group by sex"
  6.     cursor.execute(query)
  7.     data = cursor.fetchall()
  8.     # 将查询结果转换为列表形式
  9.     gender_data = [{'gender': row[0], 'count': row[1]} for row in data]
  10.     cursor.close()
  11.     db.close()
  12.     # 提取性别列表和数量列表
  13.     genders = [row['gender'] for row in gender_data]
  14.     counts = [row['count'] for row in gender_data]
  15.     explode = [0.1, 0]
  16.     # 创建饼图
  17.     matplotlib.rcParams['font.sans-serif'] = ['SimHei']
  18.     plt.pie(counts, labels=genders, autopct='%1.1f%%', explode=explode, shadow=True,
  19.             textprops={'fontsize': 16, 'color': 'white'})
  20.     plt.axis('equal')
  21.     # 保存饼图为图片
  22.     chart_path = 'static/chart.png'
  23.     plt.savefig(chart_path, transparent=True)
  24.     # 渲染模板并传递饼图路径
  25.     return render_template('home.html', chart_path=chart_path)
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <title>性别比例饼图</title>
  6.     <link rel="stylesheet" href="../static/css/bootstrap.css">
  7. </head>
  8. <body>
  9. <div class="container">
  10.     <div class="row align-items-start">
  11.         <div class="col">
  12.             <ul class="nav flex-column" style="width: 120px; margin: 40px auto">
  13.                 <li class="nav-item">
  14.                     <a class="nav-link active" aria-current="page" href="/admin">管理功能</a>
  15.                 </li>
  16.                 <li class="nav-item">
  17.                     <a class="nav-link" href="/home">可视化功能</a>
  18.                 </li>
  19.                 <li class="nav-item">
  20.                     <a class="nav-link" href="/login">退出登录</a>
  21.                 </li>
  22.             </ul>
  23.         </div>
  24.         <div class="col">
  25.             <div class="text-center" style="width: 933px; margin: 15px auto">
  26.                 <h1>性别比例饼图</h1>
  27.                 <img src="{{ chart_path }}" alt="Gender Chart">
  28.             </div>
  29.         </div>
  30.     </div>
  31. </div>
  32.  
  33. </body>
  34. </html>

【完整代码】

manage.py

  1. # -*- coding: utf-8 -*-
  2. # time: 2023/6/18 10:09
  3. # file: manage.py
  4. # author: sober
  5.  
  6. import matplotlib
  7. from flask import Flask, request, render_template, redirect, url_for
  8. import pymysql
  9. from matplotlib import pyplot as plt
  10.  
  11. app = Flask(__name__)
  12.  
  13. dbhost = '127.0.0.1'
  14. dbuser = 'root'
  15. dbpass = '123456'
  16. dbname = 'flask'
  17.  
  18.  
  19. def getStudents():
  20.     # 打开数据库连接 主机地址  用户名 密码 数据库
  21.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  22.     cursor = db.cursor()
  23.     sql = "select * from student"
  24.     cursor.execute(sql)
  25.     rows = cursor.fetchall()
  26.     db.close()
  27.     return rows
  28.  
  29.  
  30. def getStudent(id):
  31.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  32.     cursor = db.cursor()
  33.     sql = "select * from student where id=" + str(id)
  34.     cursor.execute(sql)
  35.     row = cursor.fetchone()
  36.     db.close()
  37.     return row
  38.  
  39.  
  40. @app.route('/')
  41. def index():
  42.     return redirect(url_for('user_login'))
  43.  
  44.  
  45. @app.route('/login', methods=['GET', 'POST'])  # 登录功能
  46. def user_login():
  47.     if request.method == 'GET':
  48.         return render_template('login.html')
  49.     username = request.form.get('username')
  50.     password = request.form.get('password')
  51.     if username == 'admin' and password == '123':
  52.         return redirect(url_for('admin'))
  53.     elif username == '' or password == '':
  54.         js_code = "<script>alert('请输入账号密码！'); history.back();</script>"
  55.         return js_code
  56.     else:
  57.         js_code = "<script>alert('登陆失败！'); history.back();</script>"
  58.         return js_code
  59.  
  60.  
  61. @app.route('/admin', methods=['POST', 'GET'])  # 管理功能
  62. def admin():
  63.     students = getStudents()
  64.     return render_template('admin.html', student=students)
  65.  
  66.  
  67. @app.route('/home')
  68. def home():
  69.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  70.     cursor = db.cursor()
  71.     query = "select sex, count(*) from student group by sex"
  72.     cursor.execute(query)
  73.     data = cursor.fetchall()
  74.     # 将查询结果转换为列表形式
  75.     gender_data = [{'gender': row[0], 'count': row[1]} for row in data]
  76.     cursor.close()
  77.     db.close()
  78.     # 提取性别列表和数量列表
  79.     genders = [row['gender'] for row in gender_data]
  80.     counts = [row['count'] for row in gender_data]
  81.     explode = [0.1, 0]
  82.     # 创建饼图
  83.     matplotlib.rcParams['font.sans-serif'] = ['SimHei']
  84.     plt.pie(counts, labels=genders, autopct='%1.1f%%', explode=explode, shadow=True,
  85.             textprops={'fontsize': 16, 'color': 'white'})
  86.     plt.axis('equal')
  87.     # 保存饼图为图片
  88.     chart_path = 'static/chart.png'
  89.     plt.savefig(chart_path, transparent=True)
  90.     # 渲染模板并传递饼图路径
  91.     return render_template('home.html', chart_path=chart_path)
  92.  
  93.  
  94. @app.route('/add', methods=['GET', 'POST'])  # 添加学生
  95. def add():
  96.     if request.method == 'GET':
  97.         return render_template('add.html')
  98.     else:
  99.         id = request.form.get('id')
  100.         name = request.form.get('name')
  101.         sex = request.form.get('sex')
  102.         age = request.form.get('age')
  103.         stu = getStudent(id)
  104.         if id == "" or name == "" or sex == "" or age == "":
  105.             js_code = "<script>alert('请填写完整信息！'); history.back();</script>"
  106.             return js_code
  107.         elif stu:
  108.             js_code = "<script>alert('学生已存在！'); history.back();</script>"
  109.             return js_code
  110.         else:
  111.             addstudent(id, name, sex, age)
  112.             return redirect(url_for('admin'))
  113.  
  114.  
  115. def addstudent(id, name, sex, age):
  116.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  117.     cursor = db.cursor()
  118.     sql = "insert into student (id,name,sex,age) values ('" + id + "','" + name + "','" + sex + "','" + age + "')"
  119.     cursor.execute(sql)
  120.     db.commit()
  121.     db.close()
  122.  
  123.  
  124. @app.route('/sort', methods=['GET'])  # 根据年龄排序
  125. def sort():
  126.     students = get_Sort_Students()
  127.     return render_template('admin.html', student=students)
  128.  
  129.  
  130. def get_Sort_Students():
  131.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  132.     cursor = db.cursor()
  133.     sql = "select * from student order by  age asc"
  134.     cursor.execute(sql)
  135.     row = cursor.fetchall()
  136.     db.close()
  137.     return row
  138.  
  139.  
  140. @app.route('/search', methods=['POST'])  # 查询学生
  141. def search():
  142.     if request.form.get('name') != '':  # 根据姓名查询
  143.         name = request.form.get('name')
  144.         students = searchstudents(name)
  145.         return render_template('admin.html', student=students)
  146.     elif request.form.get('id') != '':  # 根据学号查询
  147.         id = request.form.get('id')
  148.         students1 = searchstu1(id)
  149.         return render_template('admin.html', student=students1)
  150.     elif request.form.get('id') == '' and request.form.get('name') == '':
  151.         js_code = "<script>alert('请输入查询内容！'); history.back();</script>"
  152.         return js_code
  153.  
  154.  
  155. def searchstudents(name):
  156.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  157.     cursor = db.cursor()
  158.     sql = "select * from student where name like '%" + name + "%'"
  159.     cursor.execute(sql)
  160.     rows = cursor.fetchall()
  161.     for row in rows:
  162.         print(row[1])
  163.     db.close()
  164.     return rows
  165.  
  166.  
  167. def searchstu1(id):
  168.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  169.     cursor = db.cursor()
  170.     sql = f"select * from student where id={id}"
  171.     cursor.execute(sql)
  172.     rows = cursor.fetchall()
  173.     for row in rows:
  174.         print(row[1])
  175.     db.close()
  176.     return rows
  177.  
  178.  
  179. @app.route('/modify/<id>', methods=['GET', 'POST'])  # 修改学生
  180. def modify(id):
  181.     if request.method == 'GET':
  182.         students = getStudents()
  183.         editStudent = getStudent(id)
  184.         id = editStudent[0]
  185.         name = editStudent[1]
  186.         sex = editStudent[2]
  187.         age = editStudent[3]
  188.         return render_template('modify.html', students=students, id=id, name=name, sex=sex, age=age)
  189.     else:
  190.         id = request.form.get('id')
  191.         name = request.form.get('name')
  192.         sex = request.form.get('sex')
  193.         age = request.form.get('age')
  194.         if name == '' or sex == '' or age == '':
  195.             js_code = "<script>alert('请输入修改信息！'); history.back();</script>"
  196.             return js_code
  197.         else:
  198.             updateStudent(id, name, sex, age)
  199.             return redirect(url_for('admin'))
  200.  
  201.  
  202. def updateStudent(id, name, sex, age):
  203.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  204.     cursor = db.cursor()
  205.     sql = "update student set name='%s',sex='%s', age='%s' WHERE id=%s" % (name, sex, age, id)
  206.     cursor.execute(sql)
  207.     print(sql)
  208.     db.commit()
  209.     db.close()
  210.  
  211.  
  212. @app.route('/delete/<id>', methods=['GET'])  # 删除学生
  213. def delete(id):
  214.     db = pymysql.connect(host=dbhost, user=dbuser, password=dbpass, database=dbname)
  215.     cursor = db.cursor()
  216.     sql = "delete from student where id=" + str(id)
  217.     cursor.execute(sql)
  218.     db.commit()
  219.     db.close()
  220.     return redirect(url_for('admin'))
  221.  
  222.  
  223. if __name__ == '__main__':
  224.     app.run('127.0.0.1', 5002, debug=True)

admin.html

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <title>学生信息管理</title>
  6.     <link rel="stylesheet" href="../static/css/bootstrap.css">
  7. </head>
  8.  
  9. <body>
  10. <div class="container">
  11.     <div class="row align-items-start">
  12.         <div class="col">
  13.             <ul class="nav flex-column " style="width: 120px; margin: 40px auto">
  14.                 <li class="nav-item">
  15.                     <a class="nav-link active" aria-current="page" href="/admin">管理功能</a>
  16.                 </li>
  17.                 <li class="nav-item">
  18.                     <a class="nav-link" href="/home">可视化功能</a>
  19.                 </li>
  20.                 <li class="nav-item">
  21.                     <a class="nav-link" href="/login" >退出登录</a>
  22.                 </li>
  23.             </ul>
  24.         </div>
  25.         <div class="col">
  26.             <table class="table" style="width: 900px; margin: 40px auto">
  27.                 <thead>
  28.                 <tr>
  29.                     <th scope="col">
  30.                         <form action="/search" class="row g-3" method="post">
  31.                             <div class="col-auto">
  32.                                 <label class="visually-hidden">学号</label>
  33.                                 <input type="text" class="form-control" name="id" placeholder="学号">
  34.                             </div>
  35.                             <div class="col-auto">
  36.                                 <label class="visually-hidden">姓名</label>
  37.                                 <input type="text" class="form-control" name="name" placeholder="姓名">
  38.                             </div>
  39.                             <div class="col-auto">
  40.                                 <button type="submit" class="btn btn-outline-success mb-3">查找</button>
  41.                             </div>
  42.                         </form>
  43.                     </th>
  44.                     <th scope="col">
  45.                         <form action="/add" class="row g-3">
  46.                             <div class="col-auto">
  47.                                 <button type="submit" class="btn btn-outline-info mb-3">添加学生</button>
  48.                             </div>
  49.                         </form>
  50.                     </th>
  51.                     <th scope="col">
  52.                         <form action="/sort" class="row g-3">
  53.                             <div class="col-auto">
  54.                                 <button type="submit" class="btn btn-outline-info mb-3">排序</button>
  55.                             </div>
  56.                         </form>
  57.                     </th>
  58.                     <th scope="col">
  59.                         <form action="/admin" class="row g-3">
  60.                             <div class="col-auto">
  61.                                 <button type="submit" class="btn btn-outline-info mb-3">返回</button>
  62.                             </div>
  63.                         </form>
  64.                     </th>
  65.                 </tr>
  66.                 </thead>
  67.                 <tr>
  68.                     <td colspan="4">
  69.                         <div class="table-responsive">
  70.                             <table class="table table-hover" style="width: 900px; margin: 0 auto">
  71.                                 <thead>
  72.                                 <tr>
  73.                                     <th scope="col">学号</th>
  74.                                     <th scope="col">姓名</th>
  75.                                     <th scope="col">性别</th>
  76.                                     <th scope="col">年龄</th>
  77.                                     <th scope="col">操作</th>
  78.                                 </tr>
  79.                                 </thead>
  80.                                 <tbody>
  81.                                 {#
  82.             需要将 Python 对象的数据显示到浏览器上， 模板语法
  83.             jinja2(flask) numjucks(javascript) moka(django) vue
  84.  
  85.             jinja2 可以直接在HTML中写 Python 的逻辑
  86.         #}
  87.                                 {% for stu in student %}
  88.                                     <tr>
  89.                                         <th>{{ stu[0] }}</th>
  90.                                         <td>{{ stu[1] }}</td>
  91.                                         <td>{{ stu[2] }}</td>
  92.                                         <td>{{ stu[3] }}</td>
  93.                                         <td>
  94.                                             <form action="/delete/{{ stu[0] }}" method="get"
  95.                                                   style="display: inline-block;">
  96.                                                 <button type="submit" class="btn btn-outline-danger btn-sm">删除
  97.                                                 </button>
  98.                                             </form>
  99.                                             <form action="/modify/{{ stu[0] }}" method="get"
  100.                                                   style="display: inline-block;">
  101.                                                 <button type="submit" class="btn btn-outline-warning btn-sm">修改
  102.                                                 </button>
  103.                                             </form>
  104.                                         </td>
  105.                                     </tr>
  106.                                 {% endfor %}
  107.                                 </tbody>
  108.                             </table>
  109.                         </div>
  110.                     </td>
  111.                 </tr>
  112.  
  113.             </table>
  114.         </div>
  115.     </div>
  116. </div>
  117.  
  118.  
  119. </body>
  120. </html>

【项目截图】

 

 

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/花生_TL007/article/detail/432138
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号