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
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)
25. app = Flask(__name__)
26. app.secret_key = 'your_secret_key' # Change this to a secure secret key
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'
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
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()
60. def check_admin_login(connection, table_name, account, password, role):
62. try:
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}'"
70. # Implement your database query logic here
71. cursor.execute(query)
72. result = cursor.fetchone()
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}'"
81. # Implement your database query logic here
82. cursor.execute(query)
83. result = cursor.fetchone()
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}'"
93. # Implement your database query logic here
94. cursor.execute(query)
95. result = cursor.fetchone()
97. if result:
98. # Save login record in data_8
99. save_login_record(connection, role, account)
101. return bool(result)
102. except mysql.connector.Error as err:
103. print(f"Error: {err}")
104. return False
105. finally:
106. cursor.close()
108. @app.route('/')
109. def index():
110. return render_template('login.html')
112. @app.route('/login', methods=['POST'])
113. def login():
114. account = request.form['account']
115. password = request.form['password']
116. role = request.form['role']
118. connection = connect_to_database()
119. if connection is None:
120. return render_template('login_failed.html', message='Failed to connect to the database.')
122. table_name = get_table_name(role)
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.')
133. @app.route('/admin/dashboard')
134. def admin_dashboard():
135. role = session.get('role')
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)
145. elif role == '老师':
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)
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'))
171. # Add routes for other pages as needed
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
184. def fetch_login_records():
185. data_8 = []
186. try:
187. connection = connect_to_database()
188. if connection is None:
189. return []
191. cursor = connection.cursor()
192. query = "SELECT * FROM login_record"
193. cursor.execute(query)
195. login_records = cursor.fetchall()
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. })
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()
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. )
225. cursor = connection.cursor()
227. # Execute a query to fetch data from the admin table
228. query = "SELECT Mainid, Username, Password, Name FROM admin"
229. cursor.execute(query)
231. # Fetch all rows from the result
232. rows = cursor.fetchall()
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. })
243. except mysql.connector.Error as err:
244. print(f"Error: {err}")
246. finally:
247. # Close the cursor and connection
248. cursor.close()
249. connection.close()
251. return data

百度云链接：

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

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