这篇文章将为大家详细讲解有关python和sqlite3数据库如何实现简单登陆注册功能，文章内容质量较高，因此小编分享给大家做个参考，希望大家阅读完这篇文章后对相关知识有一定的了解。

#coding=utf8#登录注册功能齐了importwximportsqlite3classMyFrame(wx.Frame):def__init__(self):wx.Frame.__init__(self,None,-1,'DBEXAMPLE',pos=wx.DefaultPosition,size=(300,150))panel=wx.Panel(self,-1)usernameLabel=wx.StaticText(panel,-1,"用户名：")#设置用户名Labelself.usernameText=wx.TextCtrl(panel,-1,"",size=(175,-1))#设置输入用户名的文本框self.usernameText.SetInsertionPoint(0)pwdLabel=wx.StaticText(panel,-1,"密码：")#设置密码的Labelself.pwdText=wx.TextCtrl(panel,-1,"",size=(175,-1),style=wx.TE_PASSWORD)#设置密码的文本框loginButton=wx.Button(panel,-1,"登录")#登录按钮exitButton=wx.Button(panel,-1,"退出")#退出按钮registerButton=wx.Button(panel,-1,"注册")sizer=wx.FlexGridSizer(cols=2,hgap=6,vgap=6)#sizer设置sizer.AddMany([usernameLabel,self.usernameText,pwdLabel,self.pwdText,loginButton,exitButton,registerButton])#把它们都安在sizer里panel.SetSizer(sizer)self.Bind(wx.EVT_BUTTON,self.OnLogIn,loginButton)#登录按钮绑定事件self.Bind(wx.EVT_BUTTON,self.OnCloseWindow,exitButton)#退出按钮绑定事件self.Bind(wx.EVT_BUTTON,self.OnRegister,registerButton)#注册按钮绑定事件#self.buildingDB()#创建数据库和表，此语句只运行第一次，之后将其注释掉defOnLogIn(self,event):#登录方法self.username=self.usernameText.GetValue()self.password=self.pwdText.GetValue()username=str(self.username.strip())conn=sqlite3.connect('db01')cur=conn.cursor()cur.execute("SELECTpasswordFROMtable01WHEREusername='%s'"%username)t=cur.fetchone()[0]printtifstr(self.password)==str(t):print'Passwordiscorrect!'self.Maximize(True)#窗口最大化，意思意思主界面else:print'failed'defOnCloseWindow(self,event):#关闭窗口self.Close()#defloginmethod(self):##passdefbuildingDB(self):#建立数据库conn=sqlite3.connect("db01")cur=conn.cursor()cur.execute("""CREATETABLEtable01(usernametext,passwordtext,realnametext,accounttext,workingdepttext,phonenumbertext)""")cur.execute("""INSERTINTOtable01values('zhangsan','123','zhangsan','','','')""")cur.execute("""INSERTINTOtable01values('lisi','123','zhangsan','','','')""")cur.execute("""INSERTINTOtable01values('wangwu','123','zhangsan','','','')""")conn.commit()cur.execute("""SELECTusernameFROMtable01WHEREusername='zhangsan'""")#p=cur.fetchone()#printpcur.close()defOnRegister(self,event):#注册方法self.username=self.usernameText.GetValue()self.password=self.pwdText.GetValue()conn=sqlite3.connect("db01")cur=conn.cursor()cur.execute("INSERTINTOtable01VALUES('%s','%s','','','','')"%(self.username,self.password))conn.commit()print"Registeredsuccessfully!"cur.close()if__name__=='__main__':app=wx.PySimpleApp()frame=MyFrame()frame.Show()app.MainLoop()

关于python和sqlite3数据库如何实现简单登陆注册功能就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。