forked from chanwoood/product_sell_admin
-
Notifications
You must be signed in to change notification settings - Fork 0
/
main.py
57 lines (49 loc) · 2.16 KB
/
main.py
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
52
53
54
55
56
57
from tkinter import *
from tkinter.messagebox import *
from MainPage import *
import pymssql
conn = pymssql.connect(host="127.0.0.1:1433",user="root",password="xxxx",database="product_sell_admin")
cur = conn.cursor()
class LoginPage(object):
def __init__(self, master=None):
self.root = master #定义内部变量root
self.root.geometry('%dx%d' % (300, 180)) #设置窗口大小
self.username = StringVar()
self.password = StringVar()
self.createPage()
def createPage(self):
self.page = Frame(self.root) #创建Frame
self.page.pack()
Label(self.page).grid(row=0, stick=W)
Label(self.page, text = '账户: ').grid(row=1, stick=W, pady=10)
Entry(self.page, textvariable=self.username).grid(row=1, column=1, stick=E)
Label(self.page, text = '密码: ').grid(row=2, stick=W, pady=10)
Entry(self.page, textvariable=self.password, show='*').grid(row=2, column=1, stick=E)
Button(self.page, text='登陆', command=self.login).grid(row=3, stick=W, pady=10)
Button(self.page, text='注册', command=self.register).grid(row=3, column=1, stick=E)
def login(self):
user = self.username.get()
psw = self.password.get()
cur.execute('select * from 用户')
if (user, psw) in cur.fetchall():
self.page.destroy()
MainPage(self.root)
else:
showinfo(title = '错误', message="用户名或密码有误!")
def register(self):
user = self.username.get()
psw = self.password.get()
cur.execute('select 用户名 from 用户')
if (user,) in cur.fetchall() :
showinfo(title='错误', message='该用户已注册!请输入其他用户名')
else:
showinfo(title = '成功', message="注册成功!已以{}身份登入".format(user))
self.page.destroy()
MainPage(self.root)
cur.execute('insert into 用户 values(%s, %s)', (user, psw))
root = Tk()
root.title('产品销售管理系统')
LoginPage(root)
root.mainloop()
conn.commit()
cur.close()