班级信息收集

`import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3

class ClassInfoApp:
def init(self, root):
self.root = root
self.root.title("班级信息收集系统")
self.root.geometry("600x450")
self.root.resizable(False, False)

    # 创建数据库连接
    self.conn = sqlite3.connect("class_info.db")
    self.create_table()
    
    # 创建主框架
    self.main_frame = ttk.Frame(root, padding="20")
    self.main_frame.pack(fill=tk.BOTH, expand=True)
    
    # 创建标签页
    self.tab_control = ttk.Notebook(self.main_frame)
    
    # 注册页面
    self.register_tab = ttk.Frame(self.tab_control)
    self.tab_control.add(self.register_tab, text="注册信息")
    self.create_register_tab()
    
    # 查询页面
    self.query_tab = ttk.Frame(self.tab_control)
    self.tab_control.add(self.query_tab, text="查询信息")
    self.create_query_tab()
    
    self.tab_control.pack(expand=1, fill="both")
    
    # 底部状态栏
    self.status_var = tk.StringVar()
    self.status_var.set("就绪")
    self.status_bar = ttk.Label(root, textvariable=self.status_var, relief=tk.SUNKEN, anchor=tk.W)
    self.status_bar.pack(side=tk.BOTTOM, fill=tk.X)
    
def create_table(self):
    """创建数据库表"""
    with self.conn:
        cursor = self.conn.cursor()
        cursor.execute('''
            CREATE TABLE IF NOT EXISTS class_info (
                student_id TEXT PRIMARY KEY,
                class_name TEXT NOT NULL,
                name TEXT NOT NULL
            )
        ''')

def create_register_tab(self):
    """创建注册页面"""
    # 标题
    ttk.Label(self.register_tab, text="学生信息注册", font=("Arial", 14, "bold")).grid(row=0, column=0, columnspan=2, pady=10)
    
    # 学号
    ttk.Label(self.register_tab, text="学号:").grid(row=1, column=0, sticky=tk.W, pady=5)
    self.student_id_var = tk.StringVar()
    ttk.Entry(self.register_tab, textvariable=self.student_id_var, width=30).grid(row=1, column=1, pady=5)
    
    # 班级
    ttk.Label(self.register_tab, text="班级:").grid(row=2, column=0, sticky=tk.W, pady=5)
    self.class_name_var = tk.StringVar()
    ttk.Entry(self.register_tab, textvariable=self.class_name_var, width=30).grid(row=2, column=1, pady=5)
    
    # 姓名
    ttk.Label(self.register_tab, text="姓名:").grid(row=3, column=0, sticky=tk.W, pady=5)
    self.name_var = tk.StringVar()
    ttk.Entry(self.register_tab, textvariable=self.name_var, width=30).grid(row=3, column=1, pady=5)
    
    # 注册按钮
    register_btn = ttk.Button(self.register_tab, text="注册", command=self.register_student)
    register_btn.grid(row=4, column=0, columnspan=2, pady=20)
    
    # 状态标签
    self.register_status_var = tk.StringVar()
    ttk.Label(self.register_tab, textvariable=self.register_status_var, foreground="green").grid(row=5, column=0, columnspan=2)

def create_query_tab(self):
    """创建查询页面"""
    # 标题
    ttk.Label(self.query_tab, text="班级同学信息查询", font=("Arial", 14, "bold")).grid(row=0, column=0, columnspan=3, pady=10)
    
    # 查询条件
    ttk.Label(self.query_tab, text="按班级查询:").grid(row=1, column=0, sticky=tk.W, pady=5)
    self.query_class_var = tk.StringVar()
    ttk.Entry(self.query_tab, textvariable=self.query_class_var, width=20).grid(row=1, column=1, pady=5)
    
    # 查询按钮
    query_btn = ttk.Button(self.query_tab, text="查询", command=self.query_students)
    query_btn.grid(row=1, column=2, padx=10)
    
    # 结果表格
    columns = ("学号", "班级", "姓名")
    self.tree = ttk.Treeview(self.query_tab, columns=columns, show="headings")
    
    for col in columns:
        self.tree.heading(col, text=col)
        self.tree.column(col, width=150, anchor=tk.CENTER)
    
    self.tree.grid(row=2, column=0, columnspan=3, pady=10, sticky=(tk.N, tk.S, tk.W, tk.E))
    
    # 滚动条
    scrollbar = ttk.Scrollbar(self.query_tab, orient=tk.VERTICAL, command=self.tree.yview)
    self.tree.configure(yscroll=scrollbar.set)
    scrollbar.grid(row=2, column=3, sticky=(tk.N, tk.S))
    
    # 设置列宽和行高
    self.query_tab.grid_columnconfigure(0, weight=1)
    self.query_tab.grid_columnconfigure(1, weight=1)
    self.query_tab.grid_columnconfigure(2, weight=1)
    self.query_tab.grid_rowconfigure(2, weight=1)

def register_student(self):
    """注册学生信息"""
    student_id = self.student_id_var.get().strip()
    class_name = self.class_name_var.get().strip()
    name = self.name_var.get().strip()
    
    if not student_id or not class_name or not name:
        messagebox.showerror("错误", "请填写完整的学生信息！")
        return
    
    try:
        with self.conn:
            cursor = self.conn.cursor()
            cursor.execute(
                "INSERT INTO class_info (student_id, class_name, name) VALUES (?, ?, ?)",
                (student_id, class_name, name)
            )
        self.register_status_var.set(f"学生 {name} (学号: {student_id}) 注册成功！")
        self.status_var.set(f"注册成功: {name} ({student_id})")
        
        # 清空输入框
        self.student_id_var.set("")
        self.class_name_var.set("")
        self.name_var.set("")
        
    except sqlite3.IntegrityError:
        messagebox.showerror("错误", f"学号 {student_id} 已存在！")
        self.register_status_var.set("")

def query_students(self):
    """查询班级学生信息"""
    class_name = self.query_class_var.get().strip()
    
    if not class_name:
        messagebox.showerror("错误", "请输入要查询的班级！")
        return
    
    # 清空表格
    for item in self.tree.get_children():
        self.tree.delete(item)
    
    try:
        with self.conn:
            cursor = self.conn.cursor()
            cursor.execute(
                "SELECT student_id, class_name, name FROM class_info WHERE class_name = ? ORDER BY student_id",
                (class_name,)
            )
            students = cursor.fetchall()
        
        if not students:
            messagebox.showinfo("提示", f"未找到班级 {class_name} 的学生信息！")
            self.status_var.set(f"查询班级: {class_name} (未找到记录)")
            return
        
        # 填充表格
        for student in students:
            self.tree.insert("", tk.END, values=student)
        
        self.status_var.set(f"查询成功: {len(students)} 条记录")
        
    except Exception as e:
        messagebox.showerror("错误", f"查询失败: {str(e)}")
        self.status_var.set("查询失败")

if name == "main":
root = tk.Tk()
app = ClassInfoApp(root)
root.mainloop() `