class UserPage(object):
def __init__(self):
self.root = tkinter.Tk()
self.root.title("用户管理")
Utils.set_screen(self.root, 450, 200)
self.page = tkinter.Frame(self.root, width=850, height=650)
self.page.pack(side='top')
self.user = User()
self.user.userId = tkinter.StringVar()
self.user.username = tkinter.StringVar()
self.user.phone = tkinter.StringVar()
self.msg = tkinter.StringVar()
self.userName_find = tkinter.StringVar()
self.userName_find.set('请输入用户名称')
tkinter.Label(self.page, text='用户名称:', font=('Terminal', 12)).grid(row=1, column=1)
tkinter.Entry(self.page, textvariable=self.user.username, width=20).grid(row=1, column=2, columnspan=2)
tkinter.Label(self.page, text='用户电话:', font=('Terminal', 12)).grid(row=2, column=1, pady=5)
tkinter.Entry(self.page, textvariable=self.user.phone, width=20).grid(row=2, column=2, columnspan=2)
tkinter.Button(self.page, text='保存', font=('Terminal', 12), command=self.save).grid(row=3, column=2,)
tkinter.Entry(self.page, textvariable=self.userName_find, width=20).grid(row=5, column=1, columnspan=4,pady=30)
tkinter.Button(self.page, text='查询', font=('Terminal', 12), command=self.get_User).grid(row=5, column=4,columnspan=1)
tkinter.Label(self.page, textvariable=self.msg, font=('Terminal', 12)).grid(row=6, column=1)
self.root.mainloop()
# 查询基础配置
def get_User(self):
session = SqlHelper().session
results = session.query(User).where(User.username==self.userName_find.get()).all()
string = ''
for row in results:
string = ' '+ '用户ID:' + str(row.userId) + ' 用户名称:' + row.username + ' 电话:' + row.phone
messagebox.showinfo('提示信息', string)
session.close()
def save(self):
sql_helper = SqlHelper()
saveUser = User()
saveUser.username = self.user.username.get();
saveUser.phone = self.user.phone.get()
sql_helper.update(saveUser)
messagebox.showinfo('提示信息','保存成功')
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12.
- 13.
- 14.
- 15.
- 16.
- 17.
- 18.
- 19.
- 20.
- 21.
- 22.
- 23.
- 24.
- 25.
- 26.
- 27.
- 28.
- 29.
- 30.
- 31.
- 32.
- 33.
- 34.
- 35.
- 36.
- 37.
- 38.
- 39.
- 40.
- 41.
- 42.
- 43.
- 44.
- 45.
- 46.
- 47.
- 48.
- 49.
- 50.
- 51.