class User:
def __init__(self,id,name,pwd):
self.id = id
self.name = name
self.pwd = pwd
class UserDB:
def find_all(self):
'''查询user表中的所有数据,并封装为一个列表'''
db = mysql.connector.connect(host='localhost',user='root',password='',database='jy40')
cursor = db.cursor()
cursor.execute('select * from user')
result = cursor.fetchall()
users = []
for record in result:
# 将数据库中的一条记录,封装为一个user对象
user =
user)
return users
def find_by_id(self,id):
'''根据id查询指定用户信息'''
user = User()
return user
def insert(self,user):
'''添加新用户'''
pass
def delete(self,id):
'''删除用户'''
pass
def update(self,user):
'''修改数据'''
pass
from PyQt5.QtWidgets import QApplication,QWidget
import sys
if __name__ == "__main__":
app = QApplication(sys.argv)
ex = Example()
sys.exit(app.exec_())
from PyQt5.Qport QApplication,QWidget,QPushButton
from PyQt5.QtCore import QCoreApplication
import sys