菁英科技（卓目鸟学苑）- 专注软件测试菁英教育

标题: python-张荣亮-2021.01.26 [打印本页]

作者: 张荣亮 时间: 2021-1-26 19:19
标题: python-张荣亮-2021.01.26

'''

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_())

欢迎光临菁英科技（卓目鸟学苑）- 专注软件测试菁英教育 (http://www.zmnxy.com/)