import tkinter as tk from tkinter import messagebox, ttk import random import sqlite3 import datetime from points_system import PointsSystem class AttendanceSystem: def __init__(self): # 创建主窗口 self.root = tk.Tk() self.root.title("课堂点名系统 - 完整版") self.root.geometry("800x600") # 初始化积分系统 self.points_system = PointsSystem() # 创建标签页 self.notebook = ttk.Notebook(self.root) self.notebook.pack(fill='both', expand=True, padx=10, pady=10) # 点名页面 self.create_attendance_tab() # 积分排名页面 self.create_ranking_tab() # 关于页面 self.create_about_tab() # 初始加载数据 self.load_students() def create_attendance_tab(self): """创建点名标签页""" self.attendance_frame = ttk.Frame(self.notebook) self.notebook.add(self.attendance_frame, text="课堂点名") # 标题 title_label = tk.Label(self.attendance_frame, text="课堂随机点名系统", font=("Arial", 18, "bold")) title_label.pack(pady=10) # 控制按钮框架 button_frame = tk.Frame(self.attendance_frame) button_frame.pack(pady=10) # 导入按钮 import_button = tk.Button(button_frame, text="导入学生名单", font=("Arial", 12), command=self.import_students, bg="lightgreen", width=15) import_button.grid(row=0, column=0, padx=5) # 随机点名按钮 self.random_button = tk.Button(button_frame, text="随机点名", font=("Arial", 12), command=self.random_pick, bg="lightblue", width=15) self.random_button.grid(row=0, column=1, padx=5) # 权重点名按钮 self.weighted_button = tk.Button(button_frame, text="权重点名", font=("Arial", 12), command=self.weighted_pick, bg="orange", width=15) self.weighted_button.grid(row=0, column=2, padx=5) # 结果显示 self.result_label = tk.Label(self.attendance_frame, text="请先导入学生名单", font=("Arial", 20, "bold"), fg="red", height=3) self.result_label.pack(pady=10) # 积分操作按钮 points_frame = tk.Frame(self.attendance_frame) points_frame.pack(pady=5) tk.Button(points_frame, text="重复问题+0.5", command=lambda: self.add_special_points("repeat_question"), width=12).grid(row=0, column=0, padx=2) tk.Button(points_frame, text="回答正确+2", command=lambda: self.add_special_points("answer_correct"), width=12).grid(row=0, column=1, padx=2) tk.Button(points_frame, text="回答错误-1", command=lambda: self.add_special_points("answer_wrong"), width=12).grid(row=0, column=2, padx=2) # 重置积分按钮 reset_frame = tk.Frame(self.attendance_frame) reset_frame.pack(pady=5) tk.Button(reset_frame, text="重置所有积分", command=self.reset_points, font=("Arial", 10), bg="lightcoral", width=15).pack() # 学生名单显示 list_frame = tk.Frame(self.attendance_frame) list_frame.pack(fill='both', expand=True, padx=10, pady=10) tk.Label(list_frame, text="学生名单", font=("Arial", 12, "bold")).pack() # 创建表格样式的名单显示 columns = ("学号", "姓名", "专业", "积分") self.tree = ttk.Treeview(list_frame, columns=columns, show="headings", height=8) for col in columns: self.tree.heading(col, text=col) self.tree.column(col, width=100) self.tree.pack(fill='both', expand=True) def create_ranking_tab(self): """创建积分排名标签页""" self.ranking_frame = ttk.Frame(self.notebook) self.notebook.add(self.ranking_frame, text="积分排名") # 标题 tk.Label(self.ranking_frame, text="学生积分排行榜", font=("Arial", 16, "bold")).pack(pady=10) # 按钮框架 button_frame = tk.Frame(self.ranking_frame) button_frame.pack(pady=5) # 刷新按钮 tk.Button(button_frame, text="刷新排名", command=self.show_ranking, font=("Arial", 12), bg="lightyellow", width=10).pack(side='left', padx=5) # 导出按钮 tk.Button(button_frame, text="导出CSV", command=self.export_data, font=("Arial", 12), bg="lightgreen", width=10).pack(side='left', padx=5) # 显示图表按钮 tk.Button(button_frame, text="显示图表", command=self.show_chart, font=("Arial", 12), bg="lightcoral", width=10).pack(side='left', padx=5) # 排名显示 self.ranking_text = tk.Text(self.ranking_frame, height=15, width=60, font=("Arial", 11)) self.ranking_text.pack(padx=10, pady=10, fill='both', expand=True) # 初始显示排名 self.show_ranking() def create_about_tab(self): """创建关于页面""" self.about_frame = ttk.Frame(self.notebook) self.notebook.add(self.about_frame, text="关于") # 标题 title_label = tk.Label(self.about_frame, text="课堂点名系统", font=("Arial", 20, "bold")) title_label.pack(pady=20) # 版本信息 info_text = """ 开发信息： • 版本：v1.0 • 开发者：单人开发 • 开发时间：2024年11月 • 技术栈：Python + Tkinter + SQLite 系统功能： ✓ 学生名单导入 ✓ 随机点名 ✓ 权重点名（积分低优先） ✓ 积分管理系统 ✓ 数据可视化 ✓ CSV导出 积分规则： • 正常点名：+1分 • 重复问题：+0.5分 • 回答正确：+2分 • 回答错误：-1分 • 权重点名：积分越低越容易被点 """ info_label = tk.Label(self.about_frame, text=info_text, font=("Arial", 11), justify="left") info_label.pack(pady=10) def import_students(self): """导入学生名单""" test_students = [ ("031902100", "张三", "计算机科学与技术"), ("031902101", "李四", "软件工程"), ("031902102", "王五", "计算机科学与技术"), ("031902103", "赵六", "软件工程"), ("031902104", "钱七", "计算机科学与技术"), ("031902105", "孙八", "软件工程"), ("031902106", "周九", "计算机科学与技术"), ("031902107", "吴十", "软件工程") ] # 使用积分系统的方法来操作数据库 conn = sqlite3.connect('students.db') cursor = conn.cursor() # 清空现有数据 cursor.execute("DELETE FROM students") # 插入测试数据 for student_id, name, major in test_students: cursor.execute( "INSERT INTO students (student_id, name, major) VALUES (?, ?, ?)", (student_id, name, major) ) conn.commit() conn.close() # 更新显示 self.load_students() messagebox.showinfo("导入成功", f"成功导入 {len(test_students)} 名学生！") self.show_ranking() def load_students(self): """加载学生名单到表格""" # 清空表格 for item in self.tree.get_children(): self.tree.delete(item) # 直接从数据库读取 conn = sqlite3.connect('students.db') cursor = conn.cursor() cursor.execute("SELECT student_id, name, major, points FROM students") students_data = cursor.fetchall() conn.close() for student_id, name, major, points in students_data: self.tree.insert("", "end", values=(student_id, name, major, points)) # 更新结果显示 if students_data: self.result_label.config(text="准备就绪，可以开始点名") else: self.result_label.config(text="请先导入学生名单") def random_pick(self): """完全随机点名""" if not self.points_system.has_students(): messagebox.showwarning("提示", "请先导入学生名单！") return # 直接从数据库读取 conn = sqlite3.connect('students.db') cursor = conn.cursor() cursor.execute("SELECT student_id, name FROM students") students = cursor.fetchall() conn.close() if not students: messagebox.showwarning("提示", "请先导入学生名单！") return student_id, name = random.choice(students) self.show_pick_result(student_id, name, "random") def weighted_pick(self): """权重随机点名（积分低的更容易被选）""" if not self.points_system.has_students(): messagebox.showwarning("提示", "请先导入学生名单！") return result = self.points_system.get_weighted_random_student() if not result: messagebox.showwarning("提示", "请先导入学生名单！") return student_id, name, points = result self.show_pick_result(student_id, name, "weighted") def show_pick_result(self, student_id, name, pick_type): """显示点名结果""" # 更新积分 points_added = self.points_system.add_points(student_id, "attendance") # 显示结果 result_text = f"{name} ({student_id})" if pick_type == "weighted": result_text += "\n[权重模式：积分低优先]" self.result_label.config(text=result_text) # 刷新显示 self.load_students() self.show_ranking() messagebox.showinfo("点名结果", f"被点到的同学是：{name}\n" f"学号：{student_id}\n" f"积分+{points_added}") def add_special_points(self, points_type): """添加特殊积分""" # 获取当前选中的学生 selection = self.tree.selection() if not selection: messagebox.showwarning("提示", "请先点名选择一个学生！") return # 获取选中学生的学号 item = self.tree.item(selection[0]) student_id = item['values'][0] # 添加积分 points_added = self.points_system.add_points(student_id, points_type) # 刷新显示 self.load_students() self.show_ranking() point_names = { "repeat_question": "重复问题", "answer_correct": "回答正确", "answer_wrong": "回答错误" } messagebox.showinfo("积分更新", f"{point_names[points_type]}\n" f"积分{points_added:+}") def reset_points(self): """重置积分确认""" if not self.points_system.has_students(): messagebox.showwarning("提示", "请先导入学生名单！") return if messagebox.askyesno("确认", "确定要重置所有学生的积分吗？"): self.points_system.reset_all_points() self.load_students() self.show_ranking() messagebox.showinfo("成功", "所有积分已重置为0") def show_ranking(self): """显示积分排名""" ranking = self.points_system.get_ranking(10) self.ranking_text.delete(1.0, tk.END) if not ranking: self.ranking_text.insert(1.0, "暂无数据，请先导入学生名单") return # 显示排名 header = "排名 姓名 学号 积分\n" header += "=" * 35 + "\n" self.ranking_text.insert(1.0, header) for i, (name, student_id, points) in enumerate(ranking, 1): rank_text = f"{i:2d} {name:8} {student_id} {points:3d}分\n" self.ranking_text.insert(tk.END, rank_text) def export_data(self): """导出数据到CSV""" try: filename = self.points_system.export_to_csv() messagebox.showinfo("导出成功", f"数据已导出到：\n{filename}") except Exception as e: messagebox.showerror("导出失败", f"导出时出错：{str(e)}") def show_chart(self): """显示积分图表""" try: # 尝试使用matplotlib import matplotlib.pyplot as plt students_data = self.points_system.get_all_students_data() if not students_data: messagebox.showwarning("提示", "没有数据可显示") return names = [student[0] for student in students_data] points = [student[1] for student in students_data] # 创建图表 plt.figure(figsize=(12, 6)) # 柱状图 plt.subplot(1, 2, 1) bars = plt.bar(names, points, color=['#FF6B6B', '#4ECDC4', '#45B7D1', '#96CEB4', '#FFEAA7']) plt.title('学生积分柱状图', fontsize=14, fontweight='bold') plt.xlabel('学生姓名') plt.ylabel('积分') plt.xticks(rotation=45) # 在柱子上显示数值 for bar, point in zip(bars, points): plt.text(bar.get_x() + bar.get_width()/2, bar.get_height() + 0.1, str(point), ha='center', va='bottom') # 饼图（前5名） plt.subplot(1, 2, 2) top_names = names[:5] top_points = points[:5] # 如果数据不足5个，使用所有数据 if len(top_names) < 5: top_names = names top_points = points colors = ['#FF9999', '#66B2FF', '#99FF99', '#FFD700', '#FFB6C1'] plt.pie(top_points, labels=top_names, autopct='%1.1f%%', colors=colors[:len(top_names)]) plt.title('积分分布饼图（前5名）', fontsize=14, fontweight='bold') plt.tight_layout() plt.show() except ImportError: # 如果matplotlib不可用，显示文本图表 self.show_text_chart() def show_text_chart(self): """显示文本格式的图表（matplotlib不可用时）""" students_data = self.points_system.get_all_students_data() if not students_data: messagebox.showwarning("提示", "没有数据可显示") return chart_window = tk.Toplevel(self.root) chart_window.title("积分图表") chart_window.geometry("600x400") tk.Label(chart_window, text="积分排行榜 - 文本图表", font=("Arial", 16, "bold")).pack(pady=10) # 创建文本显示区域 text_widget = tk.Text(chart_window, font=("Consolas", 10), width=80, height=20) text_widget.pack(padx=10, pady=10, fill='both', expand=True) # 生成文本图表 chart_text = "积分柱状图（文本版）：\n" chart_text += "=" * 50 + "\n\n" max_points = max(student[1] for student in students_data) if students_data else 1 for name, points in students_data: # 计算柱状图长度（最大20个字符） bar_length = int((points / max_points) * 20) if max_points > 0 else 0 bar = "█" * bar_length chart_text += f"{name:6} [{points:2d}分] {bar}\n" chart_text += f"\n导出时间：{datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')}\n" chart_text += f"总学生数：{len(students_data)}人" text_widget.insert(1.0, chart_text) text_widget.config(state='disabled') # 设为只读 def run(self): """启动程序""" self.root.mainloop() if __name__ == "__main__": print("=== 课堂点名系统启动 ===") app = AttendanceSystem() app.run()