button_layout = QVBoxLayout() button1 = QPushButton('当日员工工资') button1.clicked.connect(self.show_query1_result) button2 = QPushButton('当日鸡爪领取记录') button2.clicked.connect(self.show_query2_result) button3 = QPushButton('查询历史员工工资') button3.clicked.connect(self.show_query3_result) button4 = QPushButton('查询历史鸡爪领取记录') button4.clicked.connect(self.show_query4_result) button_layout.addWidget(button1) button_layout.addWidget(button2) button_layout.addWidget(button3) button_layout.addWidget(button4)怎么更改这4个按钮的大小

Qt例程源代码QVBoxLayout.7z

layouts.zip

配合本人博客Qt开发总结系列的布局一章。主要包含了4个布局示例，基本布局，边框布局，流动布局以及动态布局等。基于QtQBoxLayout QHBoxLayout QVBoxLayout QFormLayout QGridLayout 具体可参见本人博客详细描述。

QT_学习笔记widget,MainWindow和Dialog的选择使用.doc

* Qt 中有三种 Layout Manager 类：QHBoxLayout，QVBoxLayout，QGridLayout。 * Layout Manager 用于管理 widget 的尺寸和位置。 * 可以通过嵌套使用 Layout Manager 构造非常复杂的 dialog。 QObject 和 tr() 函数...

button_layout = QVBoxLayout() button1 = QPushButton('当日员工工资') button1.setFixedSize(200, 50) button1.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button1.clicked.connect(self.show_query1_result) button2 = QPushButton('当日鸡爪领取记录') button2.setFixedSize(200, 50) button2.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button2.clicked.connect(self.show_query2_result) button3 = QPushButton('查询历史员工工资') button3.setFixedSize(200, 50) button3.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button3.clicked.connect(self.show_query3_result) button4 = QPushButton('查询历史鸡爪领取记录') button4.setFixedSize(200, 50) button4.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button4.clicked.connect(self.show_query4_result) button5 = QPushButton('按员工ID查询员工工资') button5.setFixedSize(200, 50) button5.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button5.clicked.connect(self.show_query5_result) button6 = QPushButton('按员工ID查询鸡爪领取记录') button6.setFixedSize(200, 50) button6.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button6.clicked.connect(self.show_query6_result) button_layout.addStretch() button_layout.addWidget(button1) button_layout.addWidget(button2) button_layout.addWidget(button3) button_layout.addWidget(button4) button_layout.addWidget(button5) button_layout.addWidget(button6) button_layout.addStretch() layout = QHBoxLayout() layout.addStretch() layout.addLayout(button_layout) layout.addStretch() widget = QWidget() widget.setLayout(layout) self.setCentralWidget(widget) # 将按钮布局添加到主窗口布局中 main_layout.addLayout(button_layout) # 创建两个窗口用于展示查询结果 self.query1_window = QueryResultWindow() self.query2_window = QueryResultWindow() self.query3_window = QueryResultWindow() self.query4_window = QueryResultWindow() self.query5_window = QueryResultWindow() self.query6_window = QueryResultWindow()怎么设置按钮位置为两列

button1.clicked.connect(self.show_query1_result) button_layout.addWidget(button1, 0, 0) button2 = QPushButton('当日鸡爪领取记录') button2.setFixedSize(200, 50) button2.setStyleSheet('QPushButton {...

class MainWindow(QMainWindow): def init(self): super().init() # 设置主窗口大小 self.setFixedSize(800, 600) # 创建主窗口布局 main_layout = QVBoxLayout() central_widget = QWidget() central_widget.setLayout(main_layout) self.setCentralWidget(central_widget) # 创建两个竖向按钮 button_layout = QVBoxLayout() button1 = QPushButton('当日员工工资') button1.setFixedSize(200, 50) button1.clicked.connect(self.show_query1_result) button2 = QPushButton('当日鸡爪领取记录') button2.setFixedSize(200, 50) button2.clicked.connect(self.show_query2_result) button3 = QPushButton('查询历史员工工资') button3.setFixedSize(200, 50) button3.clicked.connect(self.show_query3_result) button4 = QPushButton('查询历史鸡爪领取记录') button4.setFixedSize(200, 50) button4.clicked.connect(self.show_query4_result) button_layout.addStretch() button_layout.addWidget(button1) button_layout.addWidget(button2) button_layout.addWidget(button3) button_layout.addWidget(button4) button_layout.addStretch() layout = QHBoxLayout() layout.addStretch() layout.addLayout(button_layout) layout.addStretch() widget = QWidget() widget.setLayout(layout) self.setCentralWidget(widget) # 将按钮布局添加到主窗口布局中 main_layout.addLayout(button_layout) # 创建两个窗口用于展示查询结果 self.query1_window = QueryResultWindow() self.query2_window = QueryResultWindow() self.query3_window = QueryResultWindow() self.query4_window = QueryResultWindow() def show_query1_result(self): # 查询数据 db = pymysql.connect(host='39.99.214.172', user='root', password='Solotion.123', db='jj_tset') cursor = db.cursor() db_sql = """ """ cursor.execute(db_sql) result = cursor.fetchall() db.close() if len(result) == 0: QMessageBox.information(self, "提示", "今日无员工工资记录") return # 清空表格 self.query1_window.table_widget.setRowCount(0) self.query1_window.table_widget.setColumnCount(len(result[0])) self.query1_window.table_widget.setHorizontalHeaderLabels \ (["员工ID", "员工姓名", "日期", "领取鸡爪重量（KG）", "效率（每小时KG）", "出成率", "基础工资", "重量奖励", "当日总工资"]) # 添加数据到表格 for row_num, row_data in enumerate(result): self.query1_window.table_widget.insertRow(row_num) for col_num, col_data in enumerate(row_data): self.query1_window.table_widget.setItem(row_num, col_num, QTableWidgetItem(str(col_data))) # 显示窗口 self.query1_window.show()数据展示页面怎么设置筛选器按ID筛选结果并展示

self.filter_button.clicked.connect(self.filter_result) button_layout.addWidget(self.filter_edit) button_layout.addWidget(self.filter_button) 2. 创建一个方法 filter_result 用于筛选结果。该方法...

class MainWindow(QMainWindow): def init(self): super().init() self.setFixedSize(800, 600) main_layout = QVBoxLayout() central_widget = QWidget() central_widget.setLayout(main_layout) self.setCentralWidget(central_widget) button_layout = QVBoxLayout() button1 = QPushButton('当日员工工资') button1.setFixedSize(200, 50) button1.clicked.connect(self.show_query1_result) button_layout.addStretch() button_layout.addWidget(button1) button_layout.addStretch() layout = QHBoxLayout() layout.addStretch() layout.addLayout(button_layout) layout.addStretch() widget = QWidget() widget.setLayout(layout) self.setCentralWidget(widget) main_layout.addLayout(button_layout) self.query1_window = QueryResultWindow() def show_query1_result(self): db = pymysql.connect(host='39.99.214.172', user='root', password='Solotion.123', db='jj_tset') cursor = db.cursor() db_sql = """ """ cursor.execute(db_sql) result = cursor.fetchall() db.close() if len(result) == 0: QMessageBox.information(self, "提示", "今日无员工工资记录") return self.query1_window.table_widget.setRowCount(0) self.query1_window.table_widget.setColumnCount(len(result[0])) self.query1_window.table_widget.setHorizontalHeaderLabels( ["员工ID", "员工姓名", "日期", "领取鸡爪重量（KG）", "效率（每小时KG）", "出成率", "基础工资", "重量奖励", "当日总工资"]) for row_num, row_data in enumerate(result): self.query1_window.table_widget.insertRow(row_num) for col_num, col_data in enumerate(row_data): self.query1_window.table_widget.setItem(row_num, col_num, QTableWidgetItem(str(col_data))) self.query1_window.show() class QueryResultWindow(QWidget): def init(self): super().init() self.setFixedSize(800, 600) self.table_widget = QTableWidget() self.table_widget.setEditTriggers(QTableWidget.NoEditTriggers) self.table_widget.setSelectionBehavior(QTableWidget.SelectRows) layout = QVBoxLayout() layout.addWidget(self.table_widget) self.setLayout(layout) if name == 'main': app = QApplication(sys.argv) loginWindow = LoginWindow() loginWindow.show() sys.exit(app.exec_()))数据展示页面怎么设置筛选器按ID筛选结果并展示的整体代码

button1.clicked.connect(self.show_query1_result) button_layout.addStretch() button_layout.addWidget(button1) button_layout.addStretch() layout = QHBoxLayout() layout.addStretch() layout....

button_layout = QGridLayout() button1 = QPushButton('当日员工工资') button1.setFixedSize(200, 50) button1.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button1.clicked.connect(self.show_query1_result) button_layout.addWidget(button1, 0, 0) button2 = QPushButton('当日鸡爪领取记录') button2.setFixedSize(200, 50) button2.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button2.clicked.connect(self.show_query2_result) button_layout.addWidget(button2, 0, 1) button3 = QPushButton('查询历史员工工资') button3.setFixedSize(200, 50) button3.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button3.clicked.connect(self.show_query3_result) button_layout.addWidget(button3, 1, 0) button4 = QPushButton('查询历史鸡爪领取记录') button4.setFixedSize(200, 50) button4.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button4.clicked.connect(self.show_query4_result) button_layout.addWidget(button4, 1, 1) button5 = QPushButton('按员工ID查询员工工资') button5.setFixedSize(200, 50) button5.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button5.clicked.connect(self.show_query5_result) button_layout.addWidget(button5, 2, 0) button6 = QPushButton('按员工ID查询鸡爪领取记录') button6.setFixedSize(200, 50) button6.setStyleSheet('QPushButton {background-color: #A3C1DA; color: black; font-weight: bold;}') button6.clicked.connect(self.show_query6_result) button_layout.addWidget(button6, 2, 1) button_layout.setColumnStretch(2, 1) # 添加空白列来填充布局 v_layout = QVBoxLayout() v_layout.addStretch() # 添加弹性空间，使按钮布局垂直居中 v_layout.addLayout(button_layout) v_layout.addStretch()，其中self.setStyleSheet( """ QPushButton { background-color: #A3C1DA; color: black; font-weight: bold; border-radius: 5px; border: 2px solid #555555; padding: 5px; } QPushButton:hover { background-color: #C9E2F3; color: #555555; } """ )该加在什么地方

button1.clicked.connect(self.show_query1_result) button_layout.addWidget(button1, 0, 0) # 添加其他按钮到布局 v_layout = QVBoxLayout() v_layout.addStretch() v_layout.addLayout(button_layout) v_...

def query(self,sql): # 执行 SQL 查询语句 self.cursor.execute(sql) # 创建一个新窗口，并设置其属性 new_window = QWidget(self) new_window.setWindowTitle("查询员工信息") new_window.setGeometry(200, 200, 400, 300) # 创建返回按钮并设置其属性 return_button = QPushButton("返回", new_window) return_button.setGeometry(200, 200, 400, 300) return_button.clicked.connect(new_window.close) # 获取查询结果并显示在表格中 rows = self.cursor.fetchall() self.table = QTableWidget() if rows: self.table.setRowCount(len(rows)) self.table.setColumnCount(len(rows[0])) for i, row in enumerate(rows): for j, col in enumerate(row): item = QTableWidgetItem(str(col)) self.table.setItem(i, j, item) self.table.setHorizontalHeaderLabels(["部门", "姓名", "性别", '职位', '工号', '状态']) self.table.horizontalHeader().setVisible(True) self.input_box = QLineEdit(new_window) self.status_label.setText("输入需要查询的数据,格式为:部门/姓名/性别/职位/工号/状态,对象") self.v_layout = QVBoxLayout(new_window) self.v_layout.addWidget(self.input_box) query_button = QPushButton("单个查询", new_window) query_button.setGeometry(300, 100, 50, 30) query_button.clicked.connect(lambda: self.query_data(new_window)) # 添加表格到新窗口中 self.v_layout.addWidget(self.table) new_window.setLayout(self.v_layout) new_window.show() def query_data(self, new_window): # 获取输入框中的数据 data = self.input_box.text().split(",") if len(data) != 2 or not all(map(lambda x: x.strip(), data)): self.status_label.setText("输入格式错误！请按照部门/姓名/性别/职位/工号/状态,对象格式输入。") return # 检查是否有存在的表 if self.table: self.v_layout.removeWidget(self.table) self.table = None # 执行 SQL 查询语句 sql = "select * from Staff where {} = (?)".format(data[0]) self.cursor.execute(sql, (data[1],)) # 获取查询结果并显示在表格中 rows = self.cursor.fetchall() self.table = QTableWidget() if rows: self.table.setRowCount(len(rows)) self.table.setColumnCount(len(rows[0])) for i, row in enumerate(rows): for j, col in enumerate(row): item = QTableWidgetItem(str(col)) self.table.setItem(i, j, item) self.table.setHorizontalHeaderLabels(["部门", "姓名", "性别", '职位', '工号', '状态']) self.table.horizontalHeader().setVisible(True) # 添加表格到新窗口中 self.v_layout = QVBoxLayout(new_window) self.v_layout.addWidget(self.table) new_window.setLayout(self.v_layout) new_window.show()改错中文

query_button.clicked.connect(lambda: self.query_data(new_window)) # 添加表格到新窗口中 self.v_layout.addWidget(self.table) new_window.setLayout(self.v_layout) new_window.show() def query_...

def query(self, sql): # 创建一个新窗口，并设置其属性 new_window = QWidget(self) new_window.setWindowTitle("添加员工信息") new_window.setGeometry(100, 100, 800, 600) # 创建返回按钮并设置其属性 return_button = QPushButton("返回", new_window) return_button.setGeometry(10, 10, 50, 30) return_button.clicked.connect(new_window.close) # 执行 SQL 查询语句 self.cursor.execute(sql) # 获取查询结果并显示在表格中 rows = self.cursor.fetchall() self.table = QTableWidget() if rows: self.table.setRowCount(len(rows)) self.table.setColumnCount(len(rows[0])) for i, row in enumerate(rows): for j, col in enumerate(row): item = QTableWidgetItem(str(col)) self.table.setItem(i, j, item) self.table.setHorizontalHeaderLabels(["部门", "姓名", "性别", '职位', '工号', '状态']) self.table.horizontalHeader().setVisible(True) # 将表格添加到新窗口中 self.v_layout = QVBoxLayout(new_window) self.v_layout.addWidget(self.table) self.v_layout.addWidget(return_button) # 显示新窗口 new_window.setLayout(self.v_layout) new_window.show()在这个例子中如何在打开新窗口时关闭父窗口

close_query_button.clicked.connect(self.close_query_window) 在这个按钮的点击事件中，我们调用了 self.close_query_window() 方法，用于关闭查询窗口并显示父窗口。完整代码示例： python import ...

def query(self, sql): self. # 执行 SQL 查询语句 self.cursor.execute(sql) # 创建一个新窗口，并设置其属性 new_window = QWidget(self) new_window.setWindowTitle("查询员工信息") new_window.setGeometry(200, 200, 400, 300) # 创建返回按钮并设置其属性 return_button = QPushButton("返回", new_window) return_button.clicked.connect(new_window.close) # 获取查询结果并显示在表格中 rows = self.cursor.fetchall() self.table = QTableWidget() if rows: self.table.setRowCount(len(rows)) self.table.setColumnCount(len(rows[0])) for i, row in enumerate(rows): for j, col in enumerate(row): item = QTableWidgetItem(str(col)) self.table.setItem(i, j, item) self.table.setHorizontalHeaderLabels(["部门", "姓名", "性别", '职位', '工号', '状态']) self.table.horizontalHeader().setVisible(True) self.input_box = QLineEdit(new_window) # 修改状态标签的内容 self.status_label.setText("输入需要查询的数据,格式为:部门/姓名/性别/职位/工号/状态,对象") self.v_layout = QVBoxLayout(new_window) self.v_layout.addWidget(self.input_box) # 单个查询按键 query_button = QPushButton("单个查询", new_window) query_button.clicked.connect(lambda: self.query_data(new_window)) # 添加表格、按键到新窗口中 self.v_layout.addWidget(self.table) self.v_layout.addWidget(query_button) self.v_layout.addWidget(return_button) new_window.setLayout(self.v_layout) new_window.show() 如何关闭父窗口

self.close() 如果您的主窗口是通过QWidget类创建的，可以使用以下代码关闭父窗口： python self.parent().close() 请注意，这两个方法都会关闭父窗口及其所有子窗口。如果您只想关闭父窗口而不关闭...

def delete_data(self): # 创建一个新窗口，并设置其属性 status_label = QLabel() new_window = QWidget(self) new_window.setWindowTitle("删除员工信息") new_window.setGeometry(200, 200, 500, 300) # 创建返回按钮并设置其属性 return_button = QPushButton("返回", new_window) return_button.clicked.connect(new_window.close) return_button.clicked.connect(self.window.show) # 设置输入框 self.input_box = QLineEdit(new_window) status_label.setText("输入需要删除的对象,格式为:部门/姓名/性别/职位/工号/状态,对象") # 设置删除按钮 delete_button = QPushButton("删除",new_window) delete_button.clicked.connect(self.delete) # 添加表格、按键到新窗口中 self.v_layout = QVBoxLayout(new_window) self.v_layout.addWidget(status_label) self.v_layout.addWidget(self.input_box) self.v_layout.addWidget(return_button) self.v_layout.addWidget(status_label) new_window.setLayout(self.v_layout) new_window.show() def delete(self): # 获取输入框中的数据 data = self.input_box.text().split(",") if len(data) != 2 or not all(map(lambda x: x.strip(), data)): self.status_label.setText("输入格式错误！请按照部门/姓名/性别/职位/工号/状态,对象的格式输入。") return # 执行 SQL 删除语句 sql = "DELETE FROM Staff WHERE {} = (?)".format(data[0]) self.cursor.execute(sql, (data[1],)) try: self.cursor.execute(sql, data[0]) self.cnxn.commit() self.query("SELECT * FROM Staff") self.status_label.setText("数据删除成功！") except: self.status_label.setText("数据删除失败！")查错

self.query("SELECT * FROM Staff") self.status_label.setText("数据删除成功！") except: self.status_label.setText("数据删除失败！") 修改后再次运行程序，应该可以正常执行删除操作了。

def delete_data(self): # 创建一个新窗口，并设置其属性 status_label = QLabel() new_window = QWidget(self) new_window.setWindowTitle("删除员工信息") new_window.setGeometry(200, 200, 500, 300) # 创建返回按钮并设置其属性 return_button = QPushButton("返回", new_window) return_button.clicked.connect(new_window.close) return_button.clicked.connect(self.window.show) # 设置输入框 self.input_box = QLineEdit(new_window) status_label.setText("输入需要删除的对象,格式为:部门/姓名/性别/职位/工号/状态,对象") # 获取输入框中的数据 data = self.input_box.text().split(",") if len(data) != 2 or not all(map(lambda x: x.strip(), data)): status_label.setText("输入格式错误！请按照部门/姓名/性别/职位/工号/状态,对象的格式输入。") return # 执行 SQL 删除语句 sql = "DELETE FROM Staff WHERE {} = (?)".format(data[0]) self.cursor.execute(sql, (data[1],)) try: self.cursor.execute(sql, data[0]) self.cnxn.commit() self.query("SELECT * FROM Staff") status_label.setText("数据删除成功！") except: status_label.setText("数据删除失败！") # 添加表格、按键到新窗口中 self.v_layout = QVBoxLayout(new_window) self.v_layout.addWidget(status_label) self.v_layout.addWidget(self.input_box) self.v_layout.addWidget(return_button) self.v_layout.addWidget(status_label) new_window.setLayout(self.v_layout) new_window.show()输出窗口什么都没有

self.v_layout.addWidget(self.input_box) 添加到输入框设置和 SQL 语句执行之前，即在以下这段代码的前面： data = self.input_box.text().split(",") if len(data) != 2 or not all(map(lambda x: x....

相关推荐

Qt例程源代码QVBoxLayout.7z

layouts.zip

QT_学习笔记widget,MainWindow和Dialog的选择使用.doc

如何在我给你的代码基础上使用self.parent().hide()

垂直布局（QVBoxLayout）

python+pyqt5实现KFC点餐收银系统.doc

Qt5开发及实例-CH304.rar,Qt5如何使用基本布局管理的代码

ydcd___tools

最新推荐

rockyou.txt

ASP+ACCESS网上人才信息管理系统(源代码+论文)【ASP】.zip

zigbee-cluster-library-specification

管理建模和仿真的文件

MATLAB结构体与对象编程：构建面向对象的应用程序，提升代码可维护性和可扩展性

详细描述一下STM32F103C8T6怎么与DHT11连接

JSBSim Reference Manual

"互动学习：行动中的多样性与论文攻读经历"

MATLAB结构体与数据库交互：无缝连接数据存储与处理，实现数据管理自动化

Link your Unity