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

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

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

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

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

register_lable1 = tkinter.Label(register_window, text="賬號(hào)：", 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="注冊(cè)", command=register)
register_button.place(x=180, y=150)

def open_login_window():
    # 創(chuàng)建游標(biāo)對(duì)象
    cursor = connection.cursor()

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

    # 返回?cái)?shù)據(jù)庫(kù)查詢(xún)的所有信息
    results = cursor.fetchall()
    # print(results)
    # 關(guān)閉游標(biāo)
    cursor.close()
    username = text1.get("1.0", tkinter.END).strip()  # 從文本框中獲取輸入的賬戶(hù)信息
    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', '賬號(hào)或密碼錯(cuò)誤，請(qǐng)重試')

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('成功', '注冊(cè)成功，請(qǐng)登錄')
        register_window.withdraw()
        root.deiconify()
    else:
        messagebox.showinfo('Error', '賬號(hào)或密碼不能為空')

# 建立數(shù)據(jù)庫(kù)連接
connection = pymysql.connect(
    host='localhost',  # 數(shù)據(jù)庫(kù)主機(jī)名,一般為localhost
    port=3306,               # 數(shù)據(jù)庫(kù)端口號(hào)，默認(rèn)為3306
    user='root',             # 你的數(shù)據(jù)庫(kù)用戶(hù)名,一般為root
    passwd='database_password',         # 你的數(shù)據(jù)庫(kù)密碼
    db='database_name',               # 數(shù)據(jù)庫(kù)名稱(chēng)
    charset='utf8'           # 字符編碼
)

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


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