• Python Flask Web + PyQt 前后端分离的项目—学习成绩可视化分析系统

    简介

    使用工具：

    Python，PyQt ，Flask ，MySQL

    注：制作重点在网页端，因此网页端的功能更全

    WEB界面展示:

    系统登录分为管理员，老师，学生3部分

    管理员统一管理所有的账号信息以及登录信息

    老师管理，添加，修改班级，学生的成绩信息

    学生只能查看成绩信息，不能做出修改

     

     

    PYQT界面展示：

     

    数据库创建：

    项目目录

    Project-

           - PYQT                                      # 存放软件端的代码文件（运行login.py启动程序）

                       

           - static                                          # 存放静态资源（图片等）

           - templates                                   # 存放网页端的代码

                       

           - app.py                                        # 启动网页端系统

           - student.sql                                 # 数据库文件

    代码

    简单放一个登录的代码

    1. from flask import Flask, jsonify, render_template, request, redirect, url_for, session
    2. import mysql.connector
    3. import matplotlib.pyplot as plt
    4. import pandas as pd
    5. import matplotlib
    6. matplotlib.use('agg')
    7. from matplotlib.font_manager import FontProperties
    8. from io import BytesIO
    9. import base64
    10. from flask import render_template_string
    11. import os
    12. from datetime import datetime
    13. from collections import defaultdict
    14.  
    15.  
    16.  
    17. # 预设字体格式，并传给rc方法
    18. font = {'family': 'SimHei', "size": 12}
    19. matplotlib.rc('font', **font)  # 一次定义终身使用
    20. # Set font properties for Chinese characters
    21. font_prop = FontProperties(fname=r'C:\Windows\Fonts\simhei.ttf', size=12)
    22.  
    23.  
    24.  
    25. app = Flask(__name__)
    26. app.secret_key = 'your_secret_key'  # Change this to a secure secret key
    27.  
    28. # Replace these placeholders with your database connection details
    29. DB_HOST = 'localhost'
    30. DB_USER = 'root'
    31. DB_PASSWORD = '123456'
    32. DB_DATABASE = 'Student'
    33.  
    34. def connect_to_database():
    35.     try:
    36.         connection = mysql.connector.connect(
    37.             host=DB_HOST,
    38.             user=DB_USER,
    39.             password=DB_PASSWORD,
    40.             database=DB_DATABASE
    41.         )
    42.         return connection
    43.     except mysql.connector.Error as err:
    44.         print(f"Error: {err}")
    45.         return None
    46.  
    47. def save_login_record(connection, role, account):
    48.     try:
    49.         cursor = connection.cursor()
    50.         login_time = datetime.now().strftime('%Y-%m-%d %H:%M:%S')
    51.         query = f"INSERT INTO login_record (role, account, login_time) VALUES ('{role}', '{account}', '{login_time}')"
    52.         cursor.execute(query)
    53.         connection.commit()
    54.     except mysql.connector.Error as err:
    55.         print(f"Error: {err}")
    56.     finally:
    57.         cursor.close()
    58.  
    59.  
    60. def check_admin_login(connection, table_name, account, password, role):
    61.  
    62.     try:
    63.  
    64.         if role == '管理员':
    65.             table_name = 'admin'
    66.             cursor = connection.cursor()
    67.             print(table_name,account,password,role)
    68.             query = f"SELECT * FROM {table_name} WHERE Mainid='{account}' AND password='{password}'"
    69.  
    70.             # Implement your database query logic here
    71.             cursor.execute(query)
    72.             result = cursor.fetchone()
    73.  
    74.         elif role == '老师':
    75.             table_name = 'admin_teachers'
    76.             # Check administrator login
    77.             cursor = connection.cursor()
    78.             print(table_name,account,password,role)
    79.             query = f"SELECT * FROM {table_name} WHERE Teacherid='{account}' AND password='{password}'"
    80.  
    81.             # Implement your database query logic here
    82.             cursor.execute(query)
    83.             result = cursor.fetchone()
    84.  
    85.  
    86.         elif role == '学生':
    87.             table_name = 'admin_students'
    88.             # Check administrator login
    89.             cursor = connection.cursor()
    90.             print(table_name,account,password,role)
    91.             query = f"SELECT * FROM {table_name} WHERE Studentid='{account}' AND password='{password}'"
    92.  
    93.             # Implement your database query logic here
    94.             cursor.execute(query)
    95.             result = cursor.fetchone()
    96.  
    97.         if result:
    98.             # Save login record in data_8
    99.             save_login_record(connection, role, account)
    100.  
    101.         return bool(result)
    102.     except mysql.connector.Error as err:
    103.         print(f"Error: {err}")
    104.         return False
    105.     finally:
    106.         cursor.close()
    107.  
    108. @app.route('/')
    109. def index():
    110.     return render_template('login.html')
    111.  
    112. @app.route('/login', methods=['POST'])
    113. def login():
    114.     account = request.form['account']
    115.     password = request.form['password']
    116.     role = request.form['role']
    117.  
    118.     connection = connect_to_database()
    119.     if connection is None:
    120.         return render_template('login_failed.html', message='Failed to connect to the database.')
    121.  
    122.     table_name = get_table_name(role)
    123.  
    124.     if check_admin_login(connection, table_name, account, password, role):
    125.         session['role'] = role
    126.         if role == '学生':
    127.             session['account'] = account
    128.             print("===================",session['account'])
    129.         return redirect(url_for('admin_dashboard'))
    130.     else:
    131.         return render_template('login_failed.html', message='Invalid username or password.')
    132.  
    133. @app.route('/admin/dashboard')
    134. def admin_dashboard():
    135.     role = session.get('role')
    136.  
    137.     if role == '管理员':
    138.         data = fetch_admin_data()
    139.         data_1 = fetch_admin_teacher_data()
    140.         data_2 = fetch_admin_student_data()
    141.         data_8 = fetch_login_records()
    142.         data_10 = populate_tree_model_10()
    143.         return render_template('admin_dashboard.html', role=role, data=data, data_1=data_1, data_2=data_2, data_8 = data_8, data_10 = data_10)
    144.     
    145.     elif role == '老师':
    146.         
    147.         data_2 = fetch_admin_student_data()
    148.         data_3 = populate_tree_model_2()
    149.         data_4 = populate_tree_model_6()
    150.         data_5 = populate_tree_model_4()
    151.         data_6 = populate_tree_model_7()
    152.         data_7 = populate_tree_model_5()
    153.         data_9 = populate_tree_model_9()
    154.         scatter_plot_files = show_images()
    155.         data_10 = populate_tree_model_10()
    156.         return render_template('teacher_dashboard.html',scatter_plot_files = scatter_plot_files, role=role, data_2=data_2, data_3=data_3, data_4=data_4, data_5=data_5, data_6=data_6, data_7=data_7, data_9=data_9, data_10 = data_10)
    157.     
    158.     elif role == '学生':
    159.         account = session.get('account')
    160.         data_3 = populate_tree_model_2()
    161.         data_4 = populate_tree_model_6()
    162.         data_5 = populate_tree_model_4()
    163.         data_6 = populate_tree_model_7()
    164.         data_7 = populate_tree_model_5()
    165.         data_8 = show_info()
    166.         print("===================----------------",session['account'])
    167.         return render_template('student_dashboard.html', studentID=account, data_3=data_3, data_4=data_4, data_5=data_5, data_6=data_6, data_7=data_7, data_8=data_8)
    168.     else:
    169.         return redirect(url_for('index'))
    170.  
    171. # Add routes for other pages as needed
    172.  
    173. def get_table_name(role):
    174.     # Implement logic to determine the table name based on the role
    175.     if role == '管理员':
    176.         return 'admin'
    177.     elif role == '老师':
    178.         return 'admin_teachers'
    179.     elif role == '学生':
    180.         return 'admin_students'
    181.     else:
    182.         return None
    183.  
    184. def fetch_login_records():
    185.     data_8 = []
    186.     try:
    187.         connection = connect_to_database()
    188.         if connection is None:
    189.             return []
    190.  
    191.         cursor = connection.cursor()
    192.         query = "SELECT * FROM login_record"
    193.         cursor.execute(query)
    194.  
    195.         login_records = cursor.fetchall()
    196.  
    197.         # Convert rows to a list of dictionaries
    198.         for row in login_records:
    199.             data_8.append({
    200.                 'role': row[0],
    201.                 'account': row[1],
    202.                 'login_time': row[2]
    203.             })
    204.  
    205.         return data_8
    206.     except mysql.connector.Error as err:
    207.         print(f"Error: {err}")
    208.         return []
    209.     finally:
    210.         cursor.close()
    211.         if connection:
    212.             connection.close()
    213.  
    214. def fetch_admin_data():
    215.     data = []
    216.     try:
    217.         # Connect to the MySQL database
    218.         connection = mysql.connector.connect(
    219.             host='localhost',
    220.             user='root',
    221.             password='123456',
    222.             database='Student'
    223.         )
    224.  
    225.         cursor = connection.cursor()
    226.  
    227.         # Execute a query to fetch data from the admin table
    228.         query = "SELECT Mainid, Username, Password, Name FROM admin"
    229.         cursor.execute(query)
    230.  
    231.         # Fetch all rows from the result
    232.         rows = cursor.fetchall()
    233.  
    234.         # Convert rows to a list of dictionaries
    235.         for row in rows:
    236.             data.append({
    237.                 'Mainid': row[0],
    238.                 'Username': row[1],
    239.                 'Password': row[2],
    240.                 'Name': row[3]
    241.             })
    242.  
    243.     except mysql.connector.Error as err:
    244.         print(f"Error: {err}")
    245.  
    246.     finally:
    247.         # Close the cursor and connection
    248.         cursor.close()
    249.         connection.close()
    250.  
    251.     return data
    252.  
    253.

    百度云链接：

    链接：https://pan.baidu.com/s/13HtbUm0Wwd0RT_cY61M57A?pwd=o102 
    提取码：o102 
    --来自百度网盘超级会员V5的分享

    系统可能还存在某些不完善的地方，欢迎讨论

  • 相关阅读:
    线性代数基础1向量
    Redis 6.0学习指南
    HTTP状态码及其描述
    Java TCP网络编程
    [SwiftUI 开发] Combine使用方法
    influxdb导出数据
    论文 | REACT: SYNERGIZING REASONING AND ACTING INLANGUAGE MODELS
    LeetCode刷题---合并两个有序链表
    【脑机接口】基于运动想象的康复指导在脑卒中偏瘫患者中的应用
    Spring Boot项目优雅实现读写分离
  • 原文地址：https://blog.csdn.net/weixin_45897172/article/details/136168721