对象关系映射ORM Object 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='',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)
window =idget()
window.res
00,300)
window.setWindowTitle('测试窗口')
window.show()
sys.exit(app.exec_())
fr
rt 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.Qmport 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.Qport QApplication,QWidget,QPushButton
from PyQt5.QtCore import QCoreApplication
import sys
class Example(QWidget):
def __init__(self):
super().__init__()
self.initUI()
def initUI(self):
# 创建按钮
btn = QPushButton('按钮',self)
# 移动按钮位置
btn.move(100,100)
# 给按钮绑定功能
# btn.clicked.connect(self.f)
btn.clicked.(QCoration.instance().quit)
self.setLayout(vbox)
self.setGeometry(300,300,300,200)
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 = QG
grid)
# 创建所有按钮的标签
labels = ['<——','CE','C','Close',
'7','8','9','/',
'4','5','6','*',
'1','2','3','-',
# 创建按钮的位置参数
positions = [(x,y) for x in range(5) for y in range(4)]
# 创建按钮并添加到表格中
for label,position in zip(labels,positions):
btn = QPushBn(label)
# grid.addWidget(btn,position[0],position[1])
grid.addWidget(bt,*position)
self.move(500,500)
self.setWindowTitle('计算器')
self.show()
if __name__ == "__main__":
app = QApplication(sys.argv)
ex = Example()
sys.exit(app.exec_())
|