import wx
import sqlite3

#嵌入信息库

#conn = sqlite3.connect('student information')
#cursor = conn.cursor()
#cursor.execute('insert into user (id,name,sr) values ("310143122","aaa","20021209")')
#cursor.execute('insert into user (id,name,sr) values ("310143123","bbb","20011106")')
#cursor.close()
#conn.commit()
#conn.close()

 

class MyFrame(wx.Frame):
def __init__(self, parent, id):
wx.Frame.__init__(self, parent, id, '用户登录', size=(400, 300))
# 创建面板
panel = wx.Panel(self)
# 创建”确定“和”取消“按键，并绑定事件
self.bt_confirm = wx.Button(panel, label='确定')
self.bt_confirm.Bind(wx.EVT_BUTTON, self.OnclickSubmit)
self.bt_cancel = wx.Button(panel, label='取消')
self.bt_cancel.Bind(wx.EVT_BUTTON, self.OnclickCancel)
# 创建文本，左对齐
self.title = wx.StaticText(panel, label="请输入用户名和密码")
self.label_user = wx.StaticText(panel, label='用户名')
self.text_user = wx.TextCtrl(panel, style=wx.TE_LEFT)
self.label_pwd = wx.StaticText(panel, label='密 码')
self.text_password = wx.TextCtrl(panel, style=wx.TE_PASSWORD)
# 添加容器，容器中控件横向排列
hsizer_user = wx.BoxSizer(wx.HORIZONTAL)
hsizer_user.Add(self.label_user, proportion=0, flag=wx.ALL, border=5)
hsizer_user.Add(self.text_user, proportion=1, flag=wx.ALL, border=5)
hsizer_pwd = wx.BoxSizer(wx.HORIZONTAL)
hsizer_pwd.Add(self.label_pwd, proportion=0, flag=wx.ALL, border=5)
hsizer_pwd.Add(self.text_password, proportion=1, flag=wx.ALL, border=5)
hsizer_button = wx.BoxSizer(wx.HORIZONTAL)
hsizer_button.Add(self.bt_confirm, proportion=0, flag=wx.ALIGN_CENTER, border=5)
hsizer_button.Add(self.bt_cancel, proportion=0, flag=wx.ALIGN_CENTER, border=5)
# 添加容器，容器中的控件纵向排列
vsizer_all = wx.BoxSizer(wx.HORIZONTAL)
vsizer_all.Add(self.title, proportion=0, flag=wx.BOTTOM | wx.TOP | wx.ALIGN_CENTER, border=15)
vsizer_all.Add(hsizer_user, proportion=0, flag=wx.EXPAND | wx.LEFT | wx.RIGHT, border=45)

vsizer_all.Add(hsizer_pwd, proportion=0, flag=wx.EXPAND | wx.LEFT | wx.RIGHT, border=45)
vsizer_all.Add(hsizer_button, proportion=0, flag=wx.ALIGN_CENTER | wx.TOP, border=15)
panel.SetSizer(vsizer_all)

def OnclickSubmit(self, event):
message = []
username = self.text_user.GetValue()
password = self.text_password.GetValue()
if username == '' and password == '':
message = '用户名或密码不能为空'
elif username == 'aaa' and password == '310143122':
message = '姓名：aaa \n学号：310143122'
else :
message = "用户名跟密码不匹配"
wx.MessageBox(message)

def OnclickCancel(self,event):
self.text_user.SetValue("")
self.text_password.SetValue("")

 

if __name__ == '__main__':
app = wx.App()
frame = MyFrame(parent=None, id=-1)
frame.Show()
app.MainLoop()