学生管理系统

import tkinter as tk
from tkinter import messagebox, PhotoImage, Label, Canvas, Frame
import pymysql

# 主窗口
class MainApplication(tk.Tk):
    def __init__(self):
        super().__init__()
        self.geometry("700x650+99+50")
        self.title("学生管理系统 v1.1.0")

        # 自动连接数据库
        self.connection = self.connect_to_database()

        # 背景图设置，使用Canvas铺满窗口
        bg_image = PhotoImage(file="bg_image.png")
        canvas = Canvas(self, width=700, height=650)
        canvas.pack(fill="both", expand=True)
        canvas.create_image(0, 0, image=bg_image, anchor="nw")
        canvas.image = bg_image  # 保持引用，防止图片被回收

        # 创建按钮框架
        frame = tk.Frame(canvas, bg='lightblue', bd=2, relief=tk.SUNKEN)
        canvas.create_window(350, 325, window=frame)  # 使用canvas窗口

        # 主界面按钮
        word_list = ["维护学生信息", "维护课程信息", "维护学生成绩", "统计学生成绩", "学生成绩排名", "查询学生信息"]
        for i, word in enumerate(word_list):
            button = tk.Button(
                frame, text=word, bg='SlateGray', fg='AliceBlue', bd=5,
                command=lambda i=i: self.show_sub_window(i), width=20, font=('宋体', 12),
                activeforeground="pink", activebackground="LavenderBlush"
            )
            button.grid(row=i, column=0, pady=10, padx=20)

    def connect_to_database(self):
        """创建数据库连接"""
        try:
            connection = pymysql.connect(
                host='localhost', user='root', password='root',
                database='s_t_u202312315', charset='utf8mb4', autocommit=True
            )
            return connection
        except pymysql.MySQLError as e:
            messagebox.showerror("连接失败", f"数据库连接错误: {e}")
            self.destroy()

    def show_sub_window(self, button_id):
        """打开子窗口"""
        if button_id == 0:
            SubWindow1(self, self.connection)
        elif button_id == 1:
            SubWindow2(self, self.connection)
        elif button_id == 2:
            SubWindow3(self, self.connection)
        elif button_id == 3:
            SubWindow4(self, self.connection)
        elif button_id == 4:
            SubWindow5(self, self.connection)
        elif button_id == 5:
            SubWindow6(self, self.connection)

# 子窗口示例
class SubWindow1(tk.Toplevel):
    def __init__(self, master, connection):
        super().__init__(master)
        self.title("维护学生信息")
        self.geometry("450x635+900+50")
        self.connection = connection

        # 背景图设置，使用Label铺满窗口
        bg_image = PhotoImage(file="bg_image.png")
        background_label = Label(self, image=bg_image)
        background_label.place(relwidth=1, relheight=1)
        background_label.image = bg_image  # 保存引用以防图片被回收

        # 输入字段和标签的框架
        input_frame = Frame(self, bg="#ffffff")  # 使用透明背景颜色
        input_frame.place(relx=0.5, rely=0.4, anchor="center")  # 中心对齐

        # 字段名和输入框并列显示
        fields = ["学号:", "姓名:", "性别:", "年龄:", "系:", "奖学金:"]
        self.entries = []
        for i, field in enumerate(fields):
            label = tk.Label(input_frame, text=field, font=('Times New Roman', '12'), bg='white', fg='Black')
            label.grid(row=i, column=0, padx=10, pady=15, sticky="e")  # 设置较大的 pady 值
            entry = tk.Entry(input_frame, font=('Times New Roman', '12'), bd=3, bg='lightyellow', fg='Black', width=25)
            entry.grid(row=i, column=1, padx=10, pady=15, sticky="w")  # 设置较大的 pady 值
            self.entries.append(entry)

        # 插入和更新按钮并列排布
        button_frame = Frame(self, bg="white")
        button_frame.place(relx=0.5, rely=0.85, anchor="center")  # 按钮框架位置

        insert_button = tk.Button(
            button_frame, text="确认添加", command=self.insert_student_table, font=('宋体', '14'),
            bg='lightblue', fg='White', bd=6, activeforeground="SpringGreen", activebackground="Wheat"
        )
        insert_button.grid(row=0, column=0, padx=20)

        update_button = tk.Button(
            button_frame, text="确认修改", command=self.update_student_table, font=('宋体', '14'),
            bg='lightblue', fg='White', bd=6, activeforeground="SpringGreen", activebackground="Wheat"
        )
        update_button.grid(row=0, column=1, padx=20)

    def insert_student_table(self):
        """新增学生信息的逻辑"""
        new_sno = self.entries[0].get()
        new_sname = self.entries[1].get()
        new_ssex = self.entries[2].get()
        new_sage = self.entries[3].get()
        new_sdept = self.entries[4].get()
        new_scholarship = self.entries[5].get()
        try:
            with self.connection.cursor() as cursor:
                sql = ("INSERT INTO student(sno, sname, ssex, sage, sdept, scholarship) "
                       "values (%s, %s, %s, %s, %s, %s);")
                cursor.execute(sql, (new_sno, new_sname, new_ssex, int(new_sage), new_sdept, new_scholarship))
            messagebox.showinfo("成功", f"已加入新生{new_sno}信息！")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"新增失败: {e}")

    def update_student_table(self):
        """更新学生信息的逻辑"""
        new_sno = self.entries[0].get()
        new_sname = self.entries[1].get()
        new_ssex = self.entries[2].get()
        new_sage = self.entries[3].get()
        new_sdept = self.entries[4].get()
        new_scholarship = self.entries[5].get()
        try:
            with self.connection.cursor() as cursor:
                sql = ("UPDATE student SET sname=%s, ssex=%s, sage=%s, sdept=%s, scholarship=%s WHERE sno=%s;")
                cursor.execute(sql, (new_sname, new_ssex, int(new_sage), new_sdept, new_scholarship, new_sno))
            messagebox.showinfo("成功", f"已更新学生{new_sno}信息！")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"更新失败: {e}")

# 子窗口2：课程信息维护
class SubWindow2(tk.Toplevel):
    def __init__(self, master, connection):
        super().__init__(master)
        self.title("维护课程信息")
        self.geometry("450x635+900+50")
        self.connection = connection

        # 背景图设置
        bg_image = PhotoImage(file="bg_image.png")
        background_label = Label(self, image=bg_image)
        background_label.place(relwidth=1, relheight=1)
        background_label.image = bg_image  # 保持引用以防图片被回收

        # 输入字段和标签框架
        input_frame = Frame(self, bg="white")
        input_frame.place(relx=0.5, rely=0.4, anchor="center")  # 居中放置

        fields = ["课程号:", "课程名:", "先行课:", "学分:"]
        self.entries = []
        for i, field in enumerate(fields):
            label = tk.Label(input_frame, text=field, font=('Times New Roman', '12'), bg='white', fg='Black')
            label.grid(row=i, column=0, padx=10, pady=15, sticky="e")  # 标签在框架内右对齐
            entry = tk.Entry(input_frame, font=('Times New Roman', '12'), bd=3, bg='lightyellow', fg='Black', width=25)
            entry.grid(row=i, column=1, padx=10, pady=15, sticky="w")  # 输入框在框架内左对齐
            self.entries.append(entry)

        # 插入和更新按钮并列排布
        button_frame = Frame(self, bg="white")
        button_frame.place(relx=0.5, rely=0.85, anchor="center")  # 按钮框架位置

        insert_button = tk.Button(
            button_frame, text="确认添加", command=self.insert_course, font=('宋体', '14'),
            bg='lightblue', fg='White', bd=6, activeforeground="SpringGreen", activebackground="Wheat"
        )
        insert_button.grid(row=0, column=0, padx=20)

        update_button = tk.Button(
            button_frame, text="确认修改", command=self.update_course, font=('宋体', '14'),
            bg='lightblue', fg='White', bd=6, activeforeground="SpringGreen", activebackground="Wheat"
        )
        update_button.grid(row=0, column=1, padx=20)

        delete_button = tk.Button(
            button_frame, text="确认删除", command=self.update_course, font=('宋体', '14'),
            bg='lightblue', fg='White', bd=6, activeforeground="SpringGreen", activebackground="Wheat"
        )
        delete_button.grid(row=0, column=2, padx=20)

        tk.Button(button_frame, text="确认添加", command=self.insert_course, font=('宋体', '14')).grid(row=0, column=0, padx=10)
        tk.Button(button_frame, text="确认修改", command=self.update_course, font=('宋体', '14')).grid(row=0, column=1, padx=10)
        tk.Button(button_frame, text="确认删除", command=self.delete_course, font=('宋体', '14')).grid(row=0, column=2, padx=10)

    def insert_course(self):
        """新增课程信息"""
        new_cno = self.entries[0].get()
        new_cname = self.entries[1].get()
        new_cpno = self.entries[2].get()
        new_credit = self.entries[3].get()
        try:
            with self.connection.cursor() as cursor:
                sql = "INSERT INTO course (cno, cname, cpno, ccredit) VALUES (%s, %s, %s, %s)"
                cursor.execute(sql, (new_cno, new_cname, new_cpno, int(new_credit)))
            messagebox.showinfo("成功", f"已成功添加课程 {new_cno} 信息！")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"添加失败: {e}")

    def update_course(self):
        """更新课程信息"""
        new_cno = self.entries[0].get()
        new_cname = self.entries[1].get()
        new_cpno = self.entries[2].get()
        new_credit = self.entries[3].get()
        try:
            with self.connection.cursor() as cursor:
                sql = "UPDATE course SET cname=%s, cpno=%s, ccredit=%s WHERE cno=%s"
                cursor.execute(sql, (new_cname, new_cpno, int(new_credit), new_cno))
            messagebox.showinfo("成功", f"已更新课程 {new_cno} 信息！")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"更新失败: {e}")

    def delete_course(self):
        """删除课程信息（无选课记录的课程）"""
        try:
            with self.connection.cursor() as cursor:
                sql = "DELETE FROM course WHERE NOT EXISTS (SELECT * FROM sc WHERE sc.cno=course.cno)"
                cursor.execute(sql)
            messagebox.showinfo("成功", "已删除无选课记录的课程信息！")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"删除失败: {e}")

class SubWindow3(tk.Toplevel):
    def __init__(self, master, connection):
        super().__init__(master)
        self.title("维护学生成绩")
        self.geometry("450x635+900+50")
        self.connection = connection

        # 背景图设置
        bg_image = PhotoImage(file="bg_image.png")
        background_label = Label(self, image=bg_image)
        background_label.place(relwidth=1, relheight=1)
        background_label.image = bg_image  # 保持引用以防图片被回收

        # 输入字段和标签框架
        input_frame = Frame(self, bg="white")
        input_frame.place(relx=0.5, rely=0.4, anchor="center")  # 居中放置

        fields = ["学号:", "课程号:", "成绩:"]
        self.entries = []
        for i, field in enumerate(fields):
            label = tk.Label(input_frame, text=field, font=('Times New Roman', '12'), bg='white', fg='Black')
            label.grid(row=i, column=0, padx=10, pady=15, sticky="e")  # 标签在框架内右对齐
            entry = tk.Entry(input_frame, font=('Times New Roman', '12'), bd=3, bg='lightyellow', fg='Black', width=25)
            entry.grid(row=i, column=1, padx=10, pady=15, sticky="w")  # 输入框在框架内左对齐
            self.entries.append(entry)

        # 按钮布局
        button_frame = Frame(self, bg="white")
        button_frame.place(relx=0.5, rely=0.85, anchor="center")

        insert_button = tk.Button(
            button_frame, text="确认添加", command=self.insert_sc_table, font=('宋体', '14'),
            bg='lightblue', fg='White', bd=6, activeforeground="SpringGreen", activebackground="Wheat"
        )
        insert_button.grid(row=0, column=0, padx=20)

        update_button = tk.Button(
            button_frame, text="确认修改", command=self.update_sc_table, font=('宋体', '14'),
            bg='lightblue', fg='White', bd=6, activeforeground="SpringGreen", activebackground="Wheat"
        )
        update_button.grid(row=0, column=1, padx=20)

        tk.Button(button_frame, text="确认添加", command=self.insert_sc_table, font=('宋体', '14')).grid(row=0, column=0, padx=10)
        tk.Button(button_frame, text="确认修改", command=self.update_sc_table, font=('宋体', '14')).grid(row=0, column=1, padx=10)

    def insert_sc_table(self):
        new_sno = self.entries[0].get()
        new_cno = self.entries[1].get()
        new_grade = self.entries[2].get()
        try:
            with self.connection.cursor() as cursor:
                sql = "INSERT INTO sc(sno, cno, grade) VALUES (%s, %s, %s);"
                cursor.execute(sql, (new_sno, new_cno, new_grade))
            messagebox.showinfo("成功", f"已添加成绩信息！")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"添加失败: {e}")

    def update_sc_table(self):
        new_sno = self.entries[0].get()
        new_cno = self.entries[1].get()
        new_grade = self.entries[2].get()
        try:
            with self.connection.cursor() as cursor:
                sql = "UPDATE sc SET grade=%s WHERE sno=%s AND cno=%s;"
                cursor.execute(sql, (new_grade, new_sno, new_cno))
                self.connection.commit()  # 提交事务
                messagebox.showinfo("成功", f"已更新成绩信息！")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"更新失败: {e}")
        except Exception as e:
            messagebox.showerror("错误", f"发生未知错误: {e}")

class SubWindow4(tk.Toplevel):
    def __init__(self, master, connection):
        super().__init__(master)
        self.title("统计学生成绩")
        self.geometry("450x635+900+50")
        self.connection = connection

        # 背景图设置
        bg_image = PhotoImage(file="bg_image.png")
        background_label = Label(self, image=bg_image)
        background_label.place(relwidth=1, relheight=1)
        background_label.image = bg_image  # 保持引用以防图片被回收

        # 输入字段和标签框架
        input_frame = Frame(self, bg="white")
        input_frame.place(relx=0.5, rely=0.4, anchor="center")

        # 字段名和输入框
        fields = ["系:", "课程号:"]
        self.entries = []
        for i, field in enumerate(fields):
            label = tk.Label(input_frame, text=field, font=('Times New Roman', '12'), bg='white', fg='Black')
            label.grid(row=i, column=0, padx=10, pady=15, sticky="e")
            entry = tk.Entry(input_frame, font=('Times New Roman', '12'), bd=3, bg='lightyellow', fg='Black', width=25)
            entry.grid(row=i, column=1, padx=10, pady=15, sticky="w")
            self.entries.append(entry)

        # 操作按钮框架
        button_frame = Frame(self, bg="white")
        button_frame.place(relx=0.5, rely=0.85, anchor="center")

        # 四个查询按钮并排排列
        buttons = [
            ("查询平均成绩", self.query_average_score),
            ("查询最高成绩", self.query_highest_score),
            ("查询最低成绩", self.query_lowest_score),
            ("查询不及格人数", self.query_fail_count),
            ("查询优秀率", self.query_excellent_rate)  # 新增优秀率按钮
        ]

        for i, (text, command) in enumerate(buttons):
            button = tk.Button(
                button_frame, text=text, command=command, font=('宋体', '12'),
                bg='lightblue', fg='White', bd=6, activeforeground="SpringGreen", activebackground="Wheat"
            )
            button.grid(row=i // 2, column=i % 2, padx=10, pady=10)  # 两行两列排列

        # 查询结果显示
        self.result_text = tk.Text(self, height=6, width=37, font=('Times New Roman', '12'), bg="lightyellow")
        self.result_text.place(relx=0.5, rely=0.6, anchor="center")

    def query_average_score(self):
        """查询平均成绩"""
        sdept = self.entries[0].get()
        cno = self.entries[1].get()
        try:
            with self.connection.cursor() as cursor:
                sql = """
                SELECT ROUND(AVG(grade), 2) FROM sc 
                JOIN student ON sc.sno = student.sno 
                WHERE student.sdept = %s AND sc.cno = %s;
                """
                cursor.execute(sql, (sdept, cno))
                result = cursor.fetchone()
                self.result_text.insert(tk.END, f"平均成绩: {result[0] if result[0] else '无数据'}\n")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"查询失败: {e}")

    def query_highest_score(self):
        """查询最高成绩"""
        sdept = self.entries[0].get()
        cno = self.entries[1].get()
        try:
            with self.connection.cursor() as cursor:
                sql = """
                SELECT MAX(grade) FROM sc 
                JOIN student ON sc.sno = student.sno 
                WHERE student.sdept = %s AND sc.cno = %s;
                """
                cursor.execute(sql, (sdept, cno))
                result = cursor.fetchone()
                self.result_text.insert(tk.END, f"最高成绩: {result[0] if result[0] else '无数据'}\n")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"查询失败: {e}")

    def query_lowest_score(self):
        """查询最低成绩"""
        sdept = self.entries[0].get()
        cno = self.entries[1].get()
        try:
            with self.connection.cursor() as cursor:
                sql = """
                SELECT MIN(grade) FROM sc 
                JOIN student ON sc.sno = student.sno 
                WHERE student.sdept = %s AND sc.cno = %s;
                """
                cursor.execute(sql, (sdept, cno))
                result = cursor.fetchone()
                self.result_text.insert(tk.END, f"最低成绩: {result[0] if result[0] else '无数据'}\n")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"查询失败: {e}")

    def query_fail_count(self):
        """查询不及格人数"""
        sdept = self.entries[0].get()
        cno = self.entries[1].get()
        try:
            with self.connection.cursor() as cursor:
                sql = """
                SELECT COUNT(*) FROM sc 
                JOIN student ON sc.sno = student.sno 
                WHERE student.sdept = %s AND sc.cno = %s AND grade < 60;
                """
                cursor.execute(sql, (sdept, cno))
                result = cursor.fetchone()
                self.result_text.insert(tk.END, f"不及格人数: {result[0] if result[0] else '0'}\n")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"查询失败: {e}")

    def query_excellent_rate(self):
        """查询优秀率 (成绩 > 80)"""
        sdept = self.entries[0].get()
        cno = self.entries[1].get()
        try:
            with self.connection.cursor() as cursor:
                # 计算优秀人数和总人数
                sql = """
                SELECT 
                    COUNT(*) AS excellent_count,
                    (SELECT COUNT(*) FROM sc WHERE cno = %s AND student.sdept = %s) AS total_count
                FROM sc 
                JOIN student ON sc.sno = student.sno 
                WHERE student.sdept = %s AND sc.cno = %s AND grade > 80;
                """
                cursor.execute(sql, (cno, sdept, sdept, cno))
                result = cursor.fetchone()
                excellent_count = result[0] if result[0] else 0
                total_count = result[1] if result[1] else 0
                excellent_rate = (excellent_count / total_count * 100) if total_count > 0 else 0
                self.result_text.insert(tk.END, f"优秀率: {excellent_rate:.2f}%\n")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"查询失败: {e}")

class SubWindow5(tk.Toplevel):
    def __init__(self, master, connection):
        super().__init__(master)
        self.title("学生成绩排名")
        self.geometry("450x635+900+50")
        self.connection = connection

        # 背景图设置
        bg_image = PhotoImage(file="bg_image.png")
        background_label = Label(self, image=bg_image)
        background_label.place(relwidth=1, relheight=1)
        background_label.image = bg_image  # 防止图片被回收

        # 输入字段和标签框架
        input_frame = Frame(self, bg="white")
        input_frame.place(relx=0.5, rely=0.4, anchor="center")

        # 字段名和输入框
        fields = ["系:", "课程号:"]
        self.entries = []
        for i, field in enumerate(fields):
            label = tk.Label(input_frame, text=field, font=('Times New Roman', '12'), bg='white', fg='Black')
            label.grid(row=i, column=0, padx=10, pady=15, sticky="e")
            entry = tk.Entry(input_frame, font=('Times New Roman', '12'), bd=3, bg='lightyellow', fg='Black', width=25)
            entry.grid(row=i, column=1, padx=10, pady=15, sticky="w")
            self.entries.append(entry)

        # 按钮框架
        button_frame = Frame(self, bg="white")
        button_frame.place(relx=0.5, rely=0.85, anchor="center")

        # 查询按钮
        rank_button = tk.Button(
            button_frame, text="查询成绩排名", command=self.query_rankings, font=('宋体', '14'),
            bg='lightblue', fg='White', bd=6, activeforeground="SpringGreen", activebackground="Wheat"
        )
        rank_button.grid(row=0, column=0, padx=20)

        # 查询结果显示
        self.result_text = tk.Text(self, height=6, width=37, font=('Times New Roman', '12'), bg="lightyellow")
        self.result_text.place(relx=0.5, rely=0.6, anchor="center")

    def query_rankings(self):
        """查询学生成绩排名"""
        sdept = self.entries[0].get()
        cno = self.entries[1].get()
        try:
            with self.connection.cursor() as cursor:
                sql = """
                SELECT student.sno, student.sname, sc.grade 
                FROM sc 
                JOIN student ON sc.sno = student.sno 
                WHERE student.sdept = %s AND sc.cno = %s 
                ORDER BY sc.grade DESC;
                """
                cursor.execute(sql, (sdept, cno))
                results = cursor.fetchall()
                self.result_text.delete(1.0, tk.END)
                if results:
                    for rank, (sno, sname, grade) in enumerate(results, start=1):
                        self.result_text.insert(tk.END, f"第{rank}名: {sno} {sname} 成绩: {grade}\n")
                else:
                    self.result_text.insert(tk.END, "无数据")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"查询失败: {e}")

class SubWindow6(tk.Toplevel):
    def __init__(self, master, connection):
        super().__init__(master)
        self.title("查询学生信息")
        self.geometry("450x635+900+50")
        self.connection = connection

        # 背景图设置
        bg_image = PhotoImage(file="bg_image.png")
        background_label = Label(self, image=bg_image)
        background_label.place(relwidth=1, relheight=1)
        background_label.image = bg_image  # 防止图片被回收

        # 输入字段和标签框架
        input_frame = Frame(self, bg="white")
        input_frame.place(relx=0.5, rely=0.4, anchor="center")

        # 字段名和输入框
        fields = ["学号:", "姓名:"]
        self.entries = []
        for i, field in enumerate(fields):
            label = tk.Label(input_frame, text=field, font=('Times New Roman', '12'), bg='white', fg='Black')
            label.grid(row=i, column=0, padx=10, pady=15, sticky="e")
            entry = tk.Entry(input_frame, font=('Times New Roman', '12'), bd=3, bg='lightyellow', fg='Black', width=25)
            entry.grid(row=i, column=1, padx=10, pady=15, sticky="w")
            self.entries.append(entry)

        # 查询按钮框架
        button_frame = Frame(self, bg="white")
        button_frame.place(relx=0.5, rely=0.85, anchor="center")

        # 查询按钮
        search_button = tk.Button(
            button_frame, text="查询学生信息", command=self.query_student_info, font=('宋体', '14'),
            bg='lightblue', fg='White', bd=6, activeforeground="SpringGreen", activebackground="Wheat"
        )
        search_button.grid(row=0, column=0, padx=20)

        # 查询结果显示
        self.result_text = tk.Text(self, height=7, width=37, font=('Times New Roman', '12'), bg="lightyellow")
        self.result_text.place(relx=0.5, rely=0.6, anchor="center")

    def query_student_info(self):
        """查询学生信息"""
        sno = self.entries[0].get().strip()
        sname = self.entries[1].get().strip()

        try:
            with self.connection.cursor() as cursor:
                if sno:
                    # 查询学生基本信息
                    sql = "SELECT * FROM Student WHERE sno = %s"
                    cursor.execute(sql, (sno,))
                elif sname:
                    # 查询学生基本信息
                    sql = "SELECT * FROM Student WHERE sname = %s"
                    cursor.execute(sql, (sname,))
                else:
                    self.result_text.insert(tk.END, "请输入学号或姓名进行查询。\n")
                    return

                student_info = cursor.fetchone()
                self.result_text.delete(1.0, tk.END)
                if student_info:
                    sno, sname, ssex, sage, sdept, scholarship = student_info
                    self.result_text.insert(
                        tk.END,
                        f"学号: {sno}\n姓名: {sname}\n性别: {ssex}\n年龄: {sage}\n系别: {sdept}\n奖学金:{scholarship}\n"
                    )
                    # 查询选课信息
                    course_sql = """
                        SELECT c.cname 
                        FROM SC sc
                        JOIN Course c ON sc.cno = c.cno
                        WHERE sc.sno = %s
                    """
                    cursor.execute(course_sql, (sno,))
                    courses = cursor.fetchall()
                    if courses:
                        self.result_text.insert(tk.END, "选课信息:")
                        for course in courses:
                            self.result_text.insert(tk.END, f"- {course[0]}\n")
                    else:
                        self.result_text.insert(tk.END, "无选课信息。\n")
                else:
                    self.result_text.insert(tk.END, "无匹配的学生信息。\n")
        except pymysql.MySQLError as e:
            messagebox.showerror("错误", f"查询失败: {e}")



# 运行应用
if __name__ == "__main__":
    app = MainApplication()
    app.mainloop()