上程序!
#登录
def denglu(close=False):
import tkinter
import xlrd
file = xlrd.open_workbook('d.xls')
data = file.sheet_by_index(0)
names = data.row_values(0)
find = False
print(names)
print(data.ncols)
window = tkinter.Tk()
window.minsize(500,200)
window.maxsize(500,200)
window.title("简易登录")
feet = tkinter.StringVar()
feet1 = tkinter.StringVar()
def call_back(*args):
global find
if len(feet.get()) == 0 or len(feet1.get()) == 0:
e = tkinter.Tk()
e.minsize(200,200)
e.maxsize(200,200)
e.title("错误")
lab2 = tkinter.Label(e,text="账号或密码不能为空",
font=("微软雅黑",10),)
lab2.place(x=30,y=10)
def call_back2(*args):
e.destroy()
btn3 = tkinter.Button(e,text="关闭",
font=("微软雅黑",10),)
btn3.place(x=70,y=80,width=70,height=30)
btn3.bind("<Button-1>",call_back2)
e.mainloop()
else:
#正确!
for i in range(data.ncols):
t = [feet.get(), feet1.get()]
print(i,data.col_values(i),t)
if data.col_values(i) == t:
find = True
if close:
window.destroy()
return True
#返回
if not find:
no = tkinter.Tk()
no.minsize(300, 300)
no.maxsize(150, 50)
no.title("密码错误")
lab3 = tkinter.Label(no, text="密码错误",font=("微软雅黑", 30), )
lab3.place(x=50, y=70)
no.mainloop()
lab0 = tkinter.Label(window,text="账号:",
font=("微软雅黑",10),)
lab0.place(x=70,y=20)
ent0 = tkinter.Entry(window,textvariable=feet)
ent0.place(x=130,y=20,width=300,height=25)
lab1 = tkinter.Label(window,text="密码:",
font=("微软雅黑",10),)
lab1.place(x=70,y=70)
ent1 = tkinter.Entry(window,textvariable=feet1)
ent1.place(x=130,y=70,width=300,height=25)
btn0 = tkinter.Button(window, text = "登 录",
font=("微软雅黑",15),
fg="black", bd=5)
btn0.place(x=70, y=120,width=320,height=40)
btn0.bind("<Button-1>",call_back)
window.mainloop()
if __name__ == '__main__':
denglu(close=True)
当然,需要在同目录添加 d.xls ,嫌名字不好在第5行改
d.xls:
1:用户名
2: 密码