班级管理系统

STARSpace8888

于 2021-12-12 10:57:06 发布

阅读量428

点赞数

文章标签： python gui

本文链接：https://blog.csdn.net/STARSpace8888/article/details/121884290

版权

这是一个使用Python的wx库创建GUI界面，结合pymysql库进行数据库操作的用户登录和注册系统。用户可以输入姓名查询学号，如果未注册，输入的名字和学号将自动注册到数据库中。程序通过wx.EVT_BUTTON事件处理查询和注册操作，并通过conn.commit()提交数据库事务。

摘要由CSDN通过智能技术生成

这个系统用到wx库和pymsql库

需要用wx制作一个窗口

点击查询转到查询事件中，调用selectOne方法查询数据并返回

点击注册转到注册事件中，调用insertOne方法将数据传入数据库

最后要用conn.commit()提交

代码如下

import wx
import pymysql

#主要窗口类
class LoginFrame(wx.Frame):
    def __init__(self,parent,id):
        wx.Frame.__init__(self,parent,id,'用户登录及注册',pos = (700,400),size=(400,250))
        panel = wx.Panel(self)
        
        self.bt_confirm = wx.Button(panel,label = '查询')
        self.bt_confirm.Bind(wx.EVT_BUTTON,self.selectController)
        self.bt_cancel = wx.Button(panel,label = '注册')
        self.bt_cancel.Bind(wx.EVT_BUTTON,self.registerController)
        
        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_userid = wx.StaticText(panel, label = '学号')
        self.text_userid = wx.TextCtrl(panel, style = wx.TE_LEFT)
        
        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_userid = wx.BoxSizer(wx.HORIZONTAL)
        hsizer_userid.Add(self.label_userid, proportion = 0,flag = wx.ALL,border = 5)
        hsizer_userid.Add(self.text_userid, proportion = 1,flag = wx.ALL,border = 5)
        hsizer_button = wx.BoxSizer(wx.HORIZONTAL)
        hsizer_button.Add(self.bt_confirm, proportion = 0,flag = wx.ALL,border = 5)
        hsizer_button.Add(self.bt_cancel, proportion = 0,flag = wx.ALL,border = 5)
        
        viszer_all = wx.BoxSizer(wx.VERTICAL)
        viszer_all.Add(self.title, proportion = 0, flag = wx.BOTTOM|wx.TOP|wx.ALIGN_CENTER, border = 15)
        viszer_all.Add(hsizer_user, proportion = 0, flag = wx.EXPAND|wx.LEFT|wx.RIGHT, border = 45)
        viszer_all.Add(hsizer_userid, proportion = 0, flag = wx.EXPAND|wx.LEFT|wx.RIGHT, border = 45)
        viszer_all.Add(hsizer_button, proportion = 0, flag = wx.ALIGN_CENTER|wx.TOP, border = 15)
        panel.SetSizer(viszer_all)
        
    '''
        没将判断逻辑做好
        查询要是不存在在数据库中那直接就不能在后面继续使用，没找到解决办法
    '''
    #控制查询方法
    def selectController(self, event):
        username = self.text_user.GetValue()
        result = selectOne(username)
        wx.MessageBox(username+'的学号为:'+result[0])
        
     #控制写入方法  
    def registerController(self, event):
        insertOne(self.text_userid.GetValue(),self.text_user.GetValue())
        wx.MessageBox('添加成功')

#链接数据库并查询语句        
def selectOne(username):
        conn = pymysql.connect(host='localhost',user='root',password='1002466752asdfgHJKL',database='studentinformation')
        cursor = conn.cursor()
        cursor.execute("select * from information where username = %s",(username,))
        result = cursor.fetchone()
        cursor.close()
        conn.close()
        return result

#链接数据库并输入语句    
def insertOne(userid,username):
        conn = pymysql.connect(host='localhost',user='root',password='1002466752asdfgHJKL',database='studentinformation')
        cursor = conn.cursor()
        cursor.execute("insert into information (userid,username) values (%s,%s)",(userid,username))
        cursor.close()
        conn.commit()
        conn.close()
    
if __name__ == '__main__':
    app = wx.App()
    frame = LoginFrame(parent = None, id = -1)
    frame.Show()
    app.MainLoop()

结果如下