class User:
def __init__(self,id,name,pwd):
self.id=id
self.name=name
self.pwd=pwd
class UserDB:
def find_all(self):
#查询user表中所有数据,并封装为一个列表
cursor.execute('select * from user')
result = cursor.fetchall()
#print(result)
users=[]
for record in result:
#将数据库中的一条记录,封装为一个user对象
user=User(record[0],record[1],record[2])
users.append(user)
print(record)
return users
def find_by_id(self,id):
# '''根据id查询指定用户信息'''
cursor.execute('select * from user where id=%s',(id,))
#user= User()
u = cursor.fetchone()
print(u)
def insert(self,name,pwd):
cursor.execute('insert into user (name,pwd) values(%s,%s)',(name,pwd))
db.commit()
# '''添加新用户'''
def delete(self,id):
cursor.execute('delete from user where id=%s',(id,))
db.commit()
def update(self,pwd,id):
cursor.execute('update user set pwd=%s where id=%s',(pwd,id))
db.commit()
labels = ['<——','CE','C','Close',
'7','8','9','/',
'4','5','6','*',
'1','2','3','-',
'0','.','=','+']
#创建按钮的位置参数
positions = [(x,y) for x in range(5) for y in range(4)]
#print(positions)
#创建按钮并添加到表格中
for label,position in zip(labels,positions):
btn= QPushButton(label)
grid.addWidget(btn,*position)
#grid.addWidget(label,position[0],position[1])
class User:
def __init__(self,id,name,pwd):
self.id=id
self.name=name
self.pwd=pwd
class UserDB:
def find_all(self):
#查询user表中所有数据,并封装为一个列表
cursor.execute('select * from user')
result = cursor.fetchall()
#print(result)
users=[]
for record in result:
#将数据库中的一条记录,封装为一个user对象
user=User(record[0],record[1],record[2])
users.append(user)
print(record)
return users
def find_by_id(self,id):
# '''根据id查询指定用户信息'''
cursor.execute('select * from user where id=%s',(id,))
#user= User()
u = cursor.fetchone()
print(u)
def insert(self,name,pwd):
cursor.execute('insert into user (name,pwd) values(%s,%s)',(name,pwd))
db.commit()
# '''添加新用户'''
def delete(self,id):
cursor.execute('delete from user where id=%s',(id,))
db.commit()
def update(self,pwd,id):
cursor.execute('update user set pwd=%s where id=%s',(pwd,id))
db.commit()