from tkinter import *
from tkinter import messagebox as msgbox
from tkinter import Label,ttk  
import tkinter as tk
import sys
import re
from re import search, split, fullmatch
import pymysql
import os
from PIL import ImageTk, Image
class windows(tk.Tk):
    def __init__(self): 
        super().__init__()  
        self.geometry("600x400")  
        self.title("登录界面")  
        self.geometry("600x600")

        background_image = ImageTk.PhotoImage(Image.open("denglu.jpg"))
        background_label = Label(self, image=background_image)
        background_label.place(x=0, y=0, relwidth=1, relheight=1)

        self.username = Entry(self)
        self.passwd = Entry(self,show="*") 
        self.username.place(x=300, y=125)
        self.passwd.place(x=300, y=175)

        
        name1 = Label(self, text="用户名：", font=('宋体', 15), width=10)
        name1.place(x=150, y=125)
        name2 = Label(self, text="密码：", font=('宋体', 15), width=10)
        name2.place(x=150, y=175)
 
        
        button = Button(self, text="登录", font=('宋体', 15), width=10, command=self.js)
        button.place(x=150, y=225)
        button1 = Button(self, text="注册", font=('宋体', 15), width=10, command=self.zhucece)
        button1.place(x=350, y=225)
         
        self.message_label = Label(self, text="", font=('宋体', 15), width=10)  
        self.message_label.place(x=450, y=175) 
        
        self.mainloop()
    def js(self):
       
        username = self.username.get()
        passwd1 = self.passwd.get()
        try:  
            db = pymysql.connect(host="localhost", user="root", password="123456", database="denglu")  
            cur = db.cursor()  
          
          
            sqlQuery = 'SELECT username, password FROM denglujiemian WHERE username=%s'  
            cur.execute(sqlQuery, (username,))   
            result = cur.fetchone()   
            if result==None:
                self.message_label.config(text="用户名错误，登录失败")
            elif result[1]==passwd1:
                self.message_label.config(text="登录成功") 
                self.login_success()  
            else:
                self.message_label.config(text="密码错误，登录失败")
        except Exception as e:
            self.message_label.config(text="登录失败，失败原因为：%s"% e)
        finally:
            
             cur.close()  
             db.close()
    def login_success(self):  
         
        self.destroy()  
         
        js1_window = Js1Window()  
        js1_window.mainloop()
    def zhucece(self):  
          
        self.destroy()  
        
        js1_ = js1()  
        js1_.mainloop()
class NextWindow(tk.Tk):  
    def __init__(self):  
        super().__init__()  
        self.geometry("1500x600")  
        self.title("主界面")  
      
        self.menu_frame = tk.Frame(self, width=200, bg='#ADD8E6')  
        self.menu_frame.pack(side=tk.LEFT, fill=tk.Y)  
          
        self.content_frame = tk.Frame(self)  
        self.content_frame.pack(side=tk.LEFT, fill=tk.BOTH, expand=True,padx=10)  
       
        self.create_menu_items() 
  
    def create_menu_items(self):  
        menu_items = [  
            ("首页", self.on_home_clicked),  
            ("个人中心", self.on_profile_clicked),  
            ("管理员管理", self.on_admin_clicked),  
            ("基础数据管理", self.on_data_management_clicked),  
            ("公告管理", self.on_announcement_management_clicked),  
            ("课程管理", self.on_course_management_clicked),  
            ("老师管理", self.on_teacher_management_clicked),  
            ("学生管理", self.on_student_management_clicked),  
            ("资料库管理", self.on_library_management_clicked)  
        ]  
  
        for text, callback in menu_items:  
            button = ttk.Button(self.menu_frame, text=text, command=lambda c=callback: c())  
            button.pack(side=tk.TOP, fill=tk.X, expand=True,padx=5, pady=5)  
   
    def on_home_clicked(self):  
        print("点击了: 首页")  
    def on_profile_clicked(self):  
        print("点击了: 个人中心")   
    def on_admin_clicked(self): 
        print("点击了: 管理员管理") 
    def on_data_management_clicked(self):  
        print("点击了: 公告管理")
    def on_announcement_management_clicked(self):
        print("点击了: 课程管理")  
    def on_course_management_clicked(self):
        # 设置Treeview的列  
        self.tree = ttk.Treeview(self)  
        self.tree["columns"] = ("索引", "老师姓名", "老师手机号", "老师头像", "课程编号", "课程名称", "上课地点", "课程附件", "课程类型", "课程开始时间", "课程结束时间")  
        self.tree.column("索引", width=50)  
        self.tree.column("老师姓名", width=100)  
        self.tree.column("老师手机号", width=120)  
        self.tree.column("老师头像", width=50, stretch=False)  # 假设这里只是占位，不显示真实头像  
        self.tree.column("课程编号", width=80)  
        self.tree.column("课程名称", width=150)  
        self.tree.column("上课地点", width=100)  
        self.tree.column("课程附件", width=100)  
        self.tree.column("课程类型", width=80)  
        self.tree.column("课程开始时间", width=120)  
        self.tree.column("课程结束时间", width=120)  
        self.tree.heading("索引", text="索引")  
        self.tree.heading("老师姓名", text="老师姓名")  
        self.tree.heading("老师手机号", text="老师手机号")  
        self.tree.heading("老师头像", text="老师头像")  
        self.tree.heading("课程编号", text="课程编号")  
        self.tree.heading("课程名称", text="课程名称")  
        self.tree.heading("上课地点", text="上课地点")  
        self.tree.heading("课程附件", text="课程附件")  
        self.tree.heading("课程类型", text="课程类型")  
        self.tree.heading("课程开始时间", text="课程开始时间")  
        self.tree.heading("课程结束时间", text="课程结束时间")  
        self.tree.pack(fill="both", expand=True)  
   
        self.populate_tree()  
    def populate_tree(self):  
        try:  
            db = pymysql.connect(host="localhost", user="root", password="123456", database="denglu", charset='utf8mb4')  
            cur = db.cursor()  

            sqlQuery = """  
            SELECT   
                ROW_NUMBER() OVER (ORDER BY some_column) AS 索引,  -- 这里用ROW_NUMBER模拟索引，您可能需要调整  
                teacher_name AS '老师姓名',  
                teacher_phone AS '老师手机号',  
                '头像占位符' AS '老师头像',   
                course_id AS '课程编号',  
                course_name AS '课程名称',  
                classroom AS '上课地点',  
                attachment_link AS '课程附件',  
                course_type AS '课程类型',  
                start_time AS '课程开始时间',  
                end_time AS '课程结束时间'  
            FROM your_table_name  -- 替换为您的表名  
            """  
            cur.execute(sqlQuery)  
            results = cur.fetchall()  
   
            for item in self.tree.get_children():  
                self.tree.delete(item)  
   
            for row in results:  
                self.tree.insert("", "end", values=row)  
  
            cur.close()  
            db.close()  
        except pymysql.MySQLError as e:  
            print(f"Error: {e}")  
    def on_teacher_management_clicked(self):
        print("点击了: 老师管理")  
    def on_student_management_clicked(self): 
        print("点击了: 学生管理") 
  
    def on_library_management_clicked(self):  
        print("点击了: 资料库管理")  
class Js1Window(tk.Tk):  
    def __init__(self):  
        super().__init__()  
        self.geometry("600x600")  
        self.title("欢迎界面")  

        background_image = ImageTk.PhotoImage(Image.open("denglu.jpg"))
        background_label = Label(self, image=background_image)
        background_label.place(x=0, y=0, relwidth=1, relheight=1)  
        
        self.welcome_label = Label(self, text="欢迎进入大学生信息管理系统")  
        self.welcome_label.pack(pady=20)  
  
        self.quit_button = Button(self, text="退出", command=self.quit)  
        self.quit_button.pack(side=tk.BOTTOM, pady=10)   
         
        self.after(3000, self.open_next_window) 
        
        self.mainloop() 
    def open_next_window(self):  
        self.destroy()  
        next_window = NextWindow()  
        next_window.mainloop()  
class js1(tk.Tk):  
    def __init__(self):  
        super().__init__()  
        self.geometry("600x600")  
        self.title("注册界面")  
 
        background_image = ImageTk.PhotoImage(Image.open("denglu.jpg"))
        background_label = Label(self, image=background_image)
        background_label.place(x=0, y=0, relwidth=1, relheight=1)
   
        self.username1 = Entry(self)
        self.passwd1 = Entry(self, show="*")
        self.passwd2 = Entry(self, show="*")
        self.username1.place(x=300, y=125)
        self.passwd1.place(x=300, y=175)
        self.passwd2.place(x=300, y=225)

        name4 = Label(self, text="用户名：", font=('宋体', 15), width=10)
        name4.place(x=150, y=125)
        name5 = Label(self, text="密码：", font=('宋体', 15), width=10)
        name5.place(x=150, y=175)
        name6 = Label(self, text="确认密码：", font=('宋体', 15), width=10)
        name6.place(x=150, y=225)

        button = Button(self, text="返回", font=('宋体', 15), width=10, command=self.windows)
        button.place(x=350, y=300)
        button1 = Button(self, text="注册", font=('宋体', 15), width=10, command=self.register)
        button1.place(x=200, y=300)
 
        self.message_label = Label(self, text="", font=('宋体', 10), width=20)  
        self.message_label.place(x=450, y=125)  
       
        self.message_label = Label(self, text="", font=('宋体', 10), width=20)  
        self.message_label.place(x=450, y=225) 
 
        self.mainloop()
    def windows(self):  
        self.destroy()  
       
        windows_window = windows()  
        windows_window.mainloop()
    def register(self):
        username = self.username1.get()
        passwd1 = self.passwd1.get()
        passwd2 = self.passwd2.get()
        try:  
            db = pymysql.connect(host="localhost", user="root", password="123456", database="denglu")  
            cur = db.cursor()  
            sqlQuery = 'SELECT username FROM denglujiemian WHERE username=%s'  
            cur.execute(sqlQuery, (username,))   
            result = cur.fetchone() 

            if passwd1 != passwd2:  
                self.message_label.config(text="失败！两次输入的密码不一致，请重新输入！")
            else:
                if not result:    
                    insert_user_sql = "INSERT INTO denglujiemian (username, password) VALUES (%s, %s)"  
                    cur.execute(insert_user_sql, (username, passwd1))  
                    db.commit()  
                    self.message_label.config(text="成功！恭喜你注册成功！")  
                else:  
                    self.message_label.config(text="失败！用户名已存在，请重新输入！")  
              
        except pymysql.Error as e:  
            self.message_label.config(text="注册失败！数据库错误：" + str(e))
        finally:
             cur.close()  
             db.close()
if __name__ == '__main__':
    app = windows()  
    app.mainloop()