''' ORM Obiect Relationship Mapping 对象关系映射 ''' import mysql.connector
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='zrl5157659',database='JY40') cursor = db.cursor() 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(users[0].id,users[0].name,users[0].pwd)
return users
from PyQt5.QtWidgets import QApplication,QWidget import sys
if __name__ == "__main__": app = QApplication(sys.argv) window = QWidget() window.resize(300,200) window.move(300,300) window.setWindowTitle('测试窗口') window.show()
sys.exit(app.exec_())
from PyQt5.QtWidgets import QApplication,QWidget from PyQt5.QtGui import QIcon
import sys class Example(QWidget):
def __init__(self): # 调用父类的构造方法 super().__init__() self.initUI()
def initUI(self): # 设置窗口大小和位置 self.setGeometry(300,300,300,200) # 设置窗口标题 self.setWindowTitle('图标') # 修改图标 self.setWindowIcon(QIcon('python\day08\m1.png')) # 显示窗口 self.show()
if __name__ == "__main__": app = QApplication(sys.argv) ex = Example() sys.exit(app.exec_())
from PyQt5.QtWidgets import QApplication,QWidget,QPushButton,QToolTip from PyQt5.QtGui import QFont import sys
class Example(QWidget):
def __init__(self): super().__init__() self.initUI()
def initUI(self): # 设置提示的字体 pixel px 像素 QToolTip.setFont(QFont('微软雅黑',10)) # 创建提示 self.setToolTip('这是一个<b>QWidget</b>组件')
# 创建按钮 btn = QPushButton('按钮',self) # 创建提示 btn.setToolTip('这是一个<i>按钮组件</i>') # 移动按钮的位置 btn.move(100,100)
self.setGeometry(300,300,300,300) self.setWindowTitle('提示信息') self.show() if __name__ == "__main__": app = QApplication(sys.argv) ex = Example() sys.exit(app.exec_())
'''表格布局'''
from PyQt5.QtWidgets import QApplication,QWidget,QPushButton,QGridLayout import sys
class Example(QWidget):
def __init__(self): super().__init__() self.initUI()
def initUI(self): # 创建一个表格布局 grid = QGridLayout() self.setLayout(grid)
# 创建所有按钮的标签 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[0],position[1]) grid.addWidget(btn,*position)
# backspace = QPushButton('<——') # grid.addWidget(backspace,1,1)
self.move(500,500) self.setWindowTitle('计算器') self.show()
if __name__ == "__main__": app = QApplication(sys.argv) ex = Example() sys.exit(app.exec_()) |