1 import pymysql
2 import wx
3 class MyFrame(wx.Frame):
4 def __init__(self,parent,id):
5 wx.Frame.__init__(self,parent,id,'班级信息收集',size=(400,300))
6 panel = wx.Panel(self)
7 self.bt_storage = wx.Button(panel,label="保存")
8 self.bt_storage.Bind(wx.EVT_BUTTON,self.OnclickStorage)
9 self.bt_inquire = wx.Button(panel,label ='查询')
10 self.bt_inquire.Bind(wx.EVT_BUTTON,self.OnclickInquire)
11 self.title =wx.StaticText(panel,label ="保存信息请输入用户的学号班级和姓名\n\t查询请输入姓名或学号")
12 self.label_class =wx.StaticText(panel,label ="班级：")
13 self.text_class =wx.TextCtrl(panel,style =wx.TE_LEFT)
14 self.label_user =wx.StaticText(panel,label ="姓名：")
15 self.text_user =wx.TextCtrl(panel,style =wx.TE_LEFT)
16 self.label_number = wx.StaticText(panel,label ="学号：")
17 self.text_number = wx.TextCtrl(panel,style =wx.TE_LEFT)
18 hsizer_class =wx.BoxSizer(wx.HORIZONTAL)
19 hsizer_class.Add(self.label_class,proportion=0,flag=wx.ALL,border=5)
20 hsizer_class.Add(self.text_class,proportion=1,flag=wx.ALL,border=5)
21 hsizer_user = wx.BoxSizer(wx.HORIZONTAL)
22 hsizer_user.Add(self.label_user,proportion=0,flag=wx.ALL,border=5)
23 hsizer_user.Add(self.text_user,proportion=1,flag =wx.ALL,border=5)
24 hsizer_number =wx.BoxSizer(wx.HORIZONTAL)
25 hsizer_number.Add(self.label_number,proportion=0,flag=wx.ALL,border=5)
26 hsizer_number.Add(self.text_number,proportion=1,flag=wx.ALL,border=5)
27 hsizer_button =wx.BoxSizer(wx.HORIZONTAL)
28 hsizer_button.Add(self.bt_storage,proportion=0,flag=wx.ALIGN_CENTER,border=5)
29 hsizer_button.Add(self.bt_inquire,proportion=0,flag=wx.ALIGN_CENTER,border=5)
30 vsizer_all = wx.BoxSizer(wx.VERTICAL)
31 vsizer_all.Add(self.title,proportion=0,flag=wx.BOTTOM |wx.TOP |wx.ALIGN_CENTER,border=15)
32 vsizer_all.Add(hsizer_class,proportion=0,flag=wx.EXPAND |wx.LEFT |wx.RIGHT,border=45)
33 vsizer_all.Add(hsizer_user,proportion=0,flag=wx.EXPAND |wx.LEFT |wx.RIGHT,border=45)
34 vsizer_all.Add(hsizer_number,proportion=0,flag=wx.EXPAND |wx.LEFT |wx.RIGHT,border=45)
35 vsizer_all.Add(hsizer_button,proportion=0,flag=wx.ALIGN_CENTER |wx.TOP,border=15)
36 panel.SetSizer(vsizer_all)
37
38 def OnclickStorage(self,event):
39 "单击保存按钮"
40 db =pymysql.connect(host='localhost',user='root',password='L3918374',database="xinji_inf",charset='utf8')
41 message =""
42 classname =self.text_class.GetValue()
43 username =self.text_user.GetValue()
44 number =self.text_number.GetValue()
45 cursor = db.cursor()
46 if classname =="" or username =="" or number =="":
47 message ='班级或名字或密码不能为空'
48 else:
49 data = [(classname,username,number)]
50 try:
51 sql="insert into accountpassword(class, name, number) values(%s,%s,%s)"
52 cursor.executemany(sql,data)
53 db.commit()
54 message ='保存成功'
55 except:
56 db.rollback()
57 db.close()
58 wx.MessageBox(message)
59
60 def OnclickInquire(self,event):
61 "单击查询按钮"
62 username =self.text_user.GetValue()
63 number =self.text_number.GetValue()
64 db =pymysql.connect(host='localhost',user='root',password='L3918374',database="xinji_inf",charset='utf8')
65 cursor = db.cursor()
66 sql =""
67 message =""
68 if username !="" and number !="":
69 sql ="SELECT * FROM ACCOUNTPASSWORD \
70 WHERE NUMBER = %s"
71 try:
72 cursor.execute(sql,number)
73 results =cursor.fetchall()
74 if results:
75 for row in results:
76 classname = row[0]
77 username_sql =row[1]
78 number_sql =row[2]
79 if username_sql == username:
80 message ="班级：{}\n姓名：{}\n学号：{}\n".format(classname,username_sql,number_sql)
81 else:
82 message ="姓名与学号不匹配"
83 except:
84 message = "没有该学号"
85
86 elif username !="" and number =="":
87 sql ="SELECT * FROM ACCOUNTPASSWORD \
88 WHERE NAME = %s"
89 try:
90 cursor.execute(sql,username)
91 results =cursor.fetchall()
92 for row in results:
93 classname = row[0]
94 username =row[1]
95 number =row[2]
96 message ="班级：{}\n姓名：{}\n学号：{}\n".format(classname,username,number)
97 except:
98 message ="没有这个名字"
99 elif number !="" and username =="":
100 sql ="SELECT * FROM ACCOUNTPASSWORD \
101 WHERE NUMBER = %s"
102 try:
103 cursor.execute(sql,number)
104 results =cursor.fetchall()
105 for row in results:
106 classname = row[0]
107 username =row[1]
108 number =row[2]
109 message ="班级：{}\n姓名：{}\n学号：{}\n".format(classname,username,number)
110 except:
111 message ="没有这个学号"
112 else:
113 message ="班级或名字或密码不能为空"
114 db.close()
115 wx.MessageBox(message)
116 if __name__ =='__main__':
117 app = wx.App()
118 frame = MyFrame(parent=None,id=-1)
119 frame.Show()
120 app.MainLoop()
