# 登錄頁面控件
lable1 = tkinter.Label(root, text="賬號：", font=('Arial', 15), width=10)  # 創(chuàng)建賬號標簽
lable1.place(x=80, y=10)  # 設置賬號標簽的位置
text1 = tkinter.Text(root, width=10, height=1, bg="white", fg="black", font=("宋體", 18), bd='0')  # 創(chuàng)建賬號輸入文本框
text1.place(x=170, y=10)  # 設置賬號輸入文本框的位置

lable2 = tkinter.Label(root, text="密碼：", font=('Arial', 15), width=10)  # 創(chuàng)建密碼標簽
lable2.place(x=80, y=80)  # 設置密碼標簽的位置
text2 = tkinter.Entry(root, show="*", width=10, bg="white", fg="black", font=("宋體", 18), bd='0')  # 創(chuàng)建密碼輸入文本框
text2.place(x=170, y=80)  # 設置密碼輸入文本框的位置

button0 = tkinter.Button(root, text="登錄", command=open_login_window)  # 創(chuàng)建登錄按鈕，并將按鈕與登錄函數關聯
button0.place(x=180, y=150)  # 設置登錄按鈕位置
button1 = tkinter.Button(root, text="退出", command=root.quit)  # 創(chuàng)建退出按鈕，并設置點擊事件為退出程序
button1.place(x=250, y=150)  # 設置退出按鈕位置

# 注冊按鈕
register_button = tkinter.Button(root, text="注冊", command=open_register_window)
register_button.place(x=110, y=150)

# 注冊頁面控件
register_window = tkinter.Toplevel(root)
register_window.title("注冊")
register_window.geometry("400x250")
register_window.protocol("WM_DELETE_WINDOW", close_register_window)  # 隱藏窗口而不是關閉
register_window.withdraw()  # 隱藏窗口

register_lable1 = tkinter.Label(register_window, text="賬號：", font=('Arial', 15), width=10)
register_lable1.place(x=80, y=10)
register_text1 = tkinter.Text(register_window, width=10, height=1, bg="white", fg="black", font=("宋體", 18), bd='0')
register_text1.place(x=170, y=10)

register_lable2 = tkinter.Label(register_window, text="密碼：", font=('Arial', 15), width=10)
register_lable2.place(x=80, y=80)
register_text2 = tkinter.Entry(register_window, show="*", width=10, bg="white", fg="black", font=("宋體", 18), bd='0')
register_text2.place(x=170, y=80)

register_button = tkinter.Button(register_window, text="注冊", command=register)
register_button.place(x=180, y=150)

def open_login_window():
    # 創(chuàng)建游標對象
    cursor = connection.cursor()

    sql = """SELECT username, password FROM admin"""  # sql查詢語句，查找admin表中username和password兩個值
    cursor.execute(sql)  # 執(zhí)行查詢語句

    # 返回數據庫查詢的所有信息
    results = cursor.fetchall()
    # print(results)
    # 關閉游標
    cursor.close()
    username = text1.get("1.0", tkinter.END).strip()  # 從文本框中獲取輸入的賬戶信息
    password = text2.get().strip()  # 從文本框中獲取輸入的密碼信息

    login_success = False
    for temp in results:
        if username == temp[0] and password == temp[1]:
            login_success = True
            break

    if login_success:
        messagebox.showinfo('成功', '登錄成功')
        root.quit()
    else:
        messagebox.showinfo('Error', '賬號或密碼錯誤，請重試')

def register():
    username = register_text1.get("1.0", tkinter.END).strip()
    password = register_text2.get().strip()
    if username and password:
        cursor = connection.cursor()
        sql = "INSERT INTO admin (username, password) VALUES (%s, %s)"
        cursor.execute(sql, (username, password))
        connection.commit()
        cursor.close()
        messagebox.showinfo('成功', '注冊成功，請登錄')
        register_window.withdraw()
        root.deiconify()
    else:
        messagebox.showinfo('Error', '賬號或密碼不能為空')

# 建立數據庫連接
connection = pymysql.connect(
    host='localhost',  # 數據庫主機名,一般為localhost
    port=3306,               # 數據庫端口號，默認為3306
    user='root',             # 你的數據庫用戶名,一般為root
    passwd='database_password',         # 你的數據庫密碼
    db='database_name',               # 數據庫名稱
    charset='utf8'           # 字符編碼
)

def open_register_window():
    register_window.deiconify()
    root.withdraw()


def close_register_window():
    register_window.withdraw()
    root.deiconify()