# 导入tkinter库
from tkinter import *
import pymysql
# 连接数据库
try:
conn = pymysql.connect(host="localhost", user="root", passwd="root", database="mytest")
print("数据库连接成功!")
cursor = conn.cursor()
cursor.execute('select * from 登录表 order by 账号')
D = cursor.fetchone() # 获取上一个查询结果的值
# print(D[0])
except Exception as err:
print("数据库连接失败"+str(err))
# 设置登录窗口
win = Tk()
win.title('登陆')
win.geometry('300x150')
win.resizable(0, 0)
# 设置账号
Label(text='账号:').place(x=50, y=30)
uname = Entry(win)
uname.place(x=100, y=30)
# 设置密码
Label(text='密码:').place(x=50, y=70)
pwd = Entry(win)
pwd.place(x=100, y=70)
# 登陆
def login():
username = uname.get()
password = pwd.get()
if username == D[0] and password == D[1]:
print('登陆成功')
else:
print('账号或者密码错误')
# 登陆按钮
Button(text='登陆', command=login).place(x=100, y=110)
win.mainloop()
Python与MySQL图形界面
最新推荐文章于 2022-12-20 09:00:00 发布