Python PyQt5实战：SQLite数据库查询器完整实现流程
发布时间：2026-10-14 |
4人浏览过
本文详细介绍基于Python PyQt5和SQLite3构建的数据库查询器项目。重点解析主界面与添加、删除、修改三个子界面的交互机制，包括信号槽通信、界面状态锁定及数据持久化逻辑。通过完整代码示例，展示如何实现数据的增删改查功能及自增ID重置处理，适合希望掌握PyQt5实战开发的开发者参考。
简介
本项目旨在利用PyQt5构建图形界面，底层对接sqlite3数据库，实现数据管理功能。核心难点在于主界面与多个子界面之间的交互逻辑，具体涉及一个主窗口与三个功能子窗口（添加、删除、修改）的协同工作，从而完成对数据库数据的增、删、改操作。
主界面
class MainWidget(QMainWindow):
def __init__(self):
super(MainWidget,self).__init__()
self.ui_init()
self.connect_init()
self.sql_init()
def ui_init(self):
self.setWindowTitle('信息查询')
self.resize(600,700)
self.addwidget = AddWidget()
self.deletewidget = DeleteWidget()
self.updatewidget = UpdateWidget()
self.show_view = QTextBrowser()
self.find_text = QLineEdit()
self.find_btn = QPushButton()
self.find_btn.setText('查询')
self.update_btn = QPushButton()
self.update_btn.setText('更改')
self.delete_btn = QPushButton()
self.delete_btn.setText('删除')
self.add_btn = QPushButton()
self.add_btn.setText('添加')
self.status_bar = self.statusBar()
self.widget = QWidget()
self.h1_layout = QHBoxLayout()
self.h2_layout = QHBoxLayout()
self.v_layout = QVBoxLayout()
self.h1_layout.addWidget(self.find_text)
self.h1_layout.addWidget(self.find_btn)
self.h2_layout.addWidget(self.update_btn)
self.h2_layout.addWidget(self.delete_btn)
self.h2_layout.addWidget(self.add_btn)
self.v_layout.addLayout(self.h1_layout)
self.v_layout.addLayout(self.h2_layout)
self.v_layout.addWidget(self.show_view)
self.widget.setLayout(self.v_layout)
self.setCentralWidget(self.widget)
def connect_init(self):
'''
信号与槽
'''
'''查询功能'''
self.find_btn.clicked.connect(lambda:self.find_slot(self.find_text.text()))
'''添加功能'''
self.add_btn.clicked.connect(self.add_slot)
self.addwidget.add_close_signal.connect(lambda:self.setEnabled(True))
self.addwidget.add_start_signal.connect(self.add_start_slot)
'''删除功能'''
self.delete_btn.clicked.connect(self.delete_slot)
self.deletewidget.delete_close_signal.connect(lambda:self.setEnabled(True))
self.deletewidget.delete_start_signal.connect(self.delete_start_slot)
'''更新功能'''
self.update_btn.clicked.connect(self.update_slot)
self.updatewidget.update_close_signal.connect(lambda:self.setEnabled(True))
self.updatewidget.update_name_signal.connect(self.update_name_slot)
self.updatewidget.update_show_signal.connect(self.update_show_slot)
def sql_init(self):
'''
sqllite3初始化
'''
try:
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('select * from design')
cursor.close()
conn.close()
except:
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('create table design (id integer PRIMARY KEY AUTOINCREMENT,name varchar(20),show varchar(100))')
cursor.close()
conn.close()
'''查询槽'''
def find_slot(self,content):
try:
result = self.find_func(content)
self.status_bar.showMessage('查询成功')
if result:
self.show_view.append('<font size="5" color="red">共查询 {} 条数据</font>'.format(len(result)))
for i in range(len(result)):
self.show_view.append('id:' + str(result[i][0]))
self.show_view.append('名称：' + result[i][1])
self.show_view.append('说明：' + result[i][2])
else:
self.show_view.append('<font size="5" color="red">共查询 {} 条数据</font>'.format(len(result)))
except Exception as e:
self.status_bar.showMessage('查询失败')
print(e)
'''添加槽'''
def add_slot(self):
self.addwidget.show()
self.setEnabled(False)
def add_start_slot(self,name,show):
try:
self.insert_func(name,show)
self.status_bar.showMessage('添加成功')
except Exception as e:
self.status_bar.showMessage('添加失败')
self.setEnabled(True)
self.addwidget.name_text.clear()
self.addwidget.show_text.clear()
self.addwidget.close()
'''删除槽'''
def delete_slot(self):
self.deletewidget.show()
self.setEnabled(False)
def delete_start_slot(self,id):
try:
self.delete_func(id)
self.reset_func()
self.status_bar.showMessage('删除成功')
except Exception as e:
self.status_bar.showMessage('删除失败')
self.setEnabled(True)
self.deletewidget.close()
'''更新槽'''
def update_slot(self):
self.updatewidget.show()
self.setEnabled(False)
def update_name_slot(self,id,name):
try:
self.update_name_func(id,name)
self.status_bar.showMessage('更新名称成功')
except Exception as e:
self.status_bar.showMessage('更新名称失败')
self.setEnabled(True)
self.updatewidget.close()
def update_show_slot(self,id,name):
try:
self.update_show_func(id,name)
self.status_bar.showMessage('更新名称成功')
except Exception as e:
self.status_bar.showMessage('更新名称失败')
self.setEnabled(True)
self.updatewidget.close()
'''数据库函数'''
def insert_func(self,name,show):
'''
插入信息
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('insert into design (id,name,show) values (null,"{}","{}")'.format(name,show))
cursor.close()
conn.commit()
conn.close()
def find_func(self,content):
'''
查询信息
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('SELECT * FROM design WHERE name LIKE "%{}%"'.format(content))
result1 = cursor.fetchall()
cursor.close()
conn.close()
return result1
def count_func(self):
'''
信息数目
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('select * from design')
result = cursor.fetall()
count = len(result)
cursor.close()
conn.close()
return count
def update_name_func(self,id,name):
'''
更新名称信息
'''
print(id,name)
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('update design set name = ? where id = ?',(name,id))
cursor.close()
conn.commit()
conn.close()
def update_show_func(self,id,name):
'''
更新说明信息
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('update design set show = ? where id = ?',(name,id))
cursor.close()
conn.commit()
conn.close()
def delete_func(self,id):
'''
删除信息
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('delete from design where id = ?',(id,))
cursor.close()
conn.commit()
conn.close()
def reset_func(self):
'''
自增列归零
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute("DELETE FROM sqlite_sequence WHERE name = 'design'")
cursor.close()
conn.commit()
conn.close()
主界面类封装了数据库操作函数及与其他界面的交互逻辑。为确保数据一致性，当子界面处于打开状态时，主界面将被禁用（不可用）。子界面向主界面发送信号，而具体的功能实现代码均编写在主界面类中。子界面实例需在主界面中预先声明，例如：self.addwidget = AddWidget()
添加功能槽
'''添加槽'''
def add_slot(self):
self.addwidget.show()
self.setEnabled(False)
def add_start_slot(self,name,show):
try:
self.insert_func(name,show)
self.status_bar.showMessage('添加成功')
except Exception as e:
self.status_bar.showMessage('添加失败')
self.setEnabled(True)
self.addwidget.name_text.clear()
self.addwidget.show_text.clear()
self.addwidget.close()
def add_slot(self):
self.addwidget.show()
self.setEnabled(False)
该函数用于启动添加界面，并将主界面设置为不可用状态，防止用户在其他界面操作。
def add_start_slot(self,name,show):
try:
self.insert_func(name,show)
self.status_bar.showMessage('添加成功')
except Exception as e:
self.status_bar.showMessage('添加失败')
self.setEnabled(True)
self.addwidget.name_text.clear()
self.addwidget.show_text.clear()
self.addwidget.close()
此函数负责执行添加功能的核心逻辑，调用数据库插入函数。数据插入完成后，清除添加子界面中的文本内容，最后关闭该子界面。其他功能槽（如删除、修改）的实现逻辑与此类似。
def reset_func()
def reset_func(self):
'''
自增列归零
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute("DELETE FROM sqlite_sequence WHERE name = 'design'")
cursor.close()
conn.commit()
conn.close()
此函数作用有限，主要用于处理sqlite3数据库的系统表sqlite_sequence。当数据库创建时，该表会自动生成，包含两列：name（存储表名）和seq（保存对应表的RowID最大值）。当表中增加记录时，该表会自动更新；删除记录时，对应记录也会自动删除。原本希望实现数据删除后ID值重新更新，但该方法仅在所有数据全部删除时才会重置ID。
添加数据的界面
class AddWidget(QWidget):
'''
添加功能界面
'''
add_start_signal = pyqtSignal(str,str)
add_close_signal = pyqtSignal()
def __init__(self):
super(AddWidget,self).__init__()
self.ui_init()
self.connect_init()
def ui_init(self):
self.setWindowTitle('添加信息')
self.setFixedSize(300,200)
self.name_text = QLineEdit()
self.show_text = QTextEdit()
self.start_btn = QPushButton()
self.start_btn.setText('添加')
self.cancel_btn = QPushButton()
self.cancel_btn.setText('取消')
self.name_label = QLabel()
self.name_label.setText('名称：')
self.show_label = QLabel()
self.show_label.setText('说明：')
self.h1_layout = QHBoxLayout()
self.h2_layout = QHBoxLayout()
self.h3_layout = QHBoxLayout()
self.v_layout = QVBoxLayout()
self.h1_layout.addWidget(self.name_label)
self.h1_layout.addWidget(self.name_text)
self.h2_layout.addWidget(self.show_label)
self.h2_layout.addWidget(self.show_text)
self.h3_layout.addWidget(self.start_btn)
self.h3_layout.addWidget(self.cancel_btn)
self.v_layout.addLayout(self.h1_layout)
self.v_layout.addLayout(self.h2_layout)
self.v_layout.addLayout(self.h3_layout)
self.setLayout(self.v_layout)
def connect_init(self):
self.start_btn.clicked.connect(self.start_slot)
self.cancel_btn.clicked.connect(self.close_slot)
def start_slot(self):
name = self.name_text.text()
show = self.show_text.toPlainText()
self.add_start_signal.emit(name,show)
def close_slot(self):
self.close()
self.add_close_signal.emit()
def closeEvent(self, event):
'''重写关闭事件'''
self.add_close_signal.emit()
这是添加数据的界面设计。自定义了两个信号：1. 添加数据信号：当按下添加按钮时，该界面向主界面传输两个字符串参数；2. 结束界面信号：无论是点击关闭按钮（重写了关闭事件）还是取消按钮，均向主界面发送信号，以恢复主界面的可用性。
删除数据的界面
class DeleteWidget(QWidget):
'''
删除功能界面
'''
delete_cancel_signal = pyqtSignal()
delete_start_signal = pyqtSignal(str)
delete_close_signal = pyqtSignal()
def __init__(self):
super(DeleteWidget,self).__init__()
self.ui_init()
self.connect_init()
def ui_init(self):
self.setWindowTitle('删除信息')
self.setFixedSize(300,100)
self.id_text = QLineEdit()
self.start_btn = QPushButton()
self.start_btn.setText('删除')
self.cancel_btn = QPushButton()
self.cancel_btn.setText('取消')
self.id_label = QLabel()
self.id_label.setText('要删除的id：')
self.h1_layout = QHBoxLayout()
self.h2_layout = QHBoxLayout()
self.v_layout = QVBoxLayout()
self.h1_layout.addWidget(self.id_label)
self.h1_layout.addWidget(self.id_text)
self.h2_layout.addWidget(self.start_btn)
self.h2_layout.addWidget(self.cancel_btn)
self.v_layout.addLayout(self.h1_layout)
self.v_layout.addLayout(self.h2_layout)
self.setLayout(self.v_layout)
def connect_init(self):
self.start_btn.clicked.connect(self.start_slot)
self.cancel_btn.clicked.connect(self.close_slot)
def start_slot(self):
id = self.id_text.text()
self.delete_start_signal.emit(id)
def close_slot(self):
self.close()
self.delete_close_signal.emit()
def closeEvent(self, event):
self.delete_close_signal.emit()
这是删除数据的界面，其布局与之前的界面基本一致。
修改数据的界面
class UpdateWidget(QWidget):
'''
更新功能界面
'''
update_name_signal = pyqtSignal(int,str)
update_show_signal = pyqtSignal(int,str)
update_close_signal = pyqtSignal()
def __init__(self):
super(UpdateWidget,self).__init__()
self.ui_init()
self.connect_init()
def ui_init(self):
self.setWindowTitle('修改信息')
self.setFixedSize(300,150)
self.content_text = QLineEdit()
self.id_text = QLineEdit()
self.name_btn = QPushButton()
self.name_btn.setText('修改名称')
self.show_btn = QPushButton()
self.show_btn.setText('修改说明')
self.cancel_btn = QPushButton()
self.cancel_btn.setText('取消')
self.content_label = QLabel()
self.content_label.setText('修改内容：')
self.id_label = QLabel()
self.id_label.setText('选择id为:')
self.h1_layout = QHBoxLayout()
self.h2_layout = QHBoxLayout()
self.h3_layout = QHBoxLayout()
self.v_layout = QVBoxLayout()
self.h1_layout.addWidget(self.id_label)
self.h1_layout.addWidget(self.id_text)
self.h2_layout.addWidget(self.content_label)
self.h2_layout.addWidget(self.content_text)
self.h3_layout.addWidget(self.name_btn)
self.h3_layout.addWidget(self.show_btn)
self.h3_layout.addWidget(self.cancel_btn)
self.v_layout.addLayout(self.h1_layout)
self.v_layout.addLayout(self.h2_layout)
self.v_layout.addLayout(self.h3_layout)
self.setLayout(self.v_layout)
def connect_init(self):
self.name_btn.clicked.connect(self.update_name_slot)
self.show_btn.clicked.connect(self.update_show_slot)
self.cancel_btn.clicked.connect(self.close_slot)
def update_name_slot(self):
id = self.id_text.text()
id = int(id)
content = self.content_text.text()
self.update_name_signal.emit(id,content)
def update_show_slot(self):
id = self.id_text.text()
id = int(id)
content = self.content_text.text()
self.update_show_signal.emit(id,content)
def close_slot(self):
self.close()
self.update_close_signal.emit()
def closeEvent(self, event):
self.update_close_signal.emit()
此更新数据的界面，布局与之前的界面基本相同。
全部代码
import sys
from PyQt5.QtCore import pyqtSignal
from PyQt5.QtWidgets import QApplication, QMainWindow, QWidget, QPushButton, QTextEdit, QHBoxLayout, QVBoxLayout, QLineEdit, QLabel,QTextBrowser
import sqlite3
class MainWidget(QMainWindow):
def __init__(self):
super(MainWidget,self).__init__()
self.ui_init()
self.connect_init()
self.sql_init()
def ui_init(self):
self.setWindowTitle('信息查询')
self.resize(600,700)
self.addwidget = AddWidget()
self.deletewidget = DeleteWidget()
self.updatewidget = UpdateWidget()
self.show_view = QTextBrowser()
self.find_text = QLineEdit()
self.find_btn = QPushButton()
self.find_btn.setText('查询')
self.update_btn = QPushButton()
self.update_btn.setText('更改')
self.delete_btn = QPushButton()
self.delete_btn.setText('删除')
self.add_btn = QPushButton()
self.add_btn.setText('添加')
self.status_bar = self.statusBar()
self.widget = QWidget()
self.h1_layout = QHBoxLayout()
self.h2_layout = QHBoxLayout()
self.v_layout = QVBoxLayout()
self.h1_layout.addWidget(self.find_text)
self.h1_layout.addWidget(self.find_btn)
self.h2_layout.addWidget(self.update_btn)
self.h2_layout.addWidget(self.delete_btn)
self.h2_layout.addWidget(self.add_btn)
self.v_layout.addLayout(self.h1_layout)
self.v_layout.addLayout(self.h2_layout)
self.v_layout.addWidget(self.show_view)
self.widget.setLayout(self.v_layout)
self.setCentralWidget(self.widget)
def connect_init(self):
'''
信号与槽
'''
'''查询功能'''
self.find_btn.clicked.connect(lambda:self.find_slot(self.find_text.text()))
'''添加功能'''
self.add_btn.clicked.connect(self.add_slot)
self.addwidget.add_close_signal.connect(lambda:self.setEnabled(True))
self.addwidget.add_start_signal.connect(self.add_start_slot)
'''删除功能'''
self.delete_btn.clicked.connect(self.delete_slot)
self.deletewidget.delete_close_signal.connect(lambda:self.setEnabled(True))
self.deletewidget.delete_start_signal.connect(self.delete_start_slot)
'''更新功能'''
self.update_btn.clicked.connect(self.update_slot)
self.updatewidget.update_close_signal.connect(lambda:self.setEnabled(True))
self.updatewidget.update_name_signal.connect(self.update_name_slot)
self.updatewidget.update_show_signal.connect(self.update_show_slot)
def sql_init(self):
'''
sqllite3初始化
'''
try:
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('select * from design')
cursor.close()
conn.close()
except:
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('create table design (id integer PRIMARY KEY AUTOINCREMENT,name varchar(20),show varchar(100))')
cursor.close()
conn.close()
'''查询槽'''
def find_slot(self,content):
try:
result = self.find_func(content)
self.status_bar.showMessage('查询成功')
if result:
self.show_view.append('<font size="5" color="red">共查询 {} 条数据</font>'.format(len(result)))
for i in range(len(result)):
self.show_view.append('id:' + str(result[i][0]))
self.show_view.append('名称：' + result[i][1])
self.show_view.append('说明：' + result[i][2])
else:
self.show_view.append('<font size="5" color="red">共查询 {} 条数据</font>'.format(len(result)))
except Exception as e:
self.status_bar.showMessage('查询失败')
print(e)
'''添加槽'''
def add_slot(self):
self.addwidget.show()
self.setEnabled(False)
def add_start_slot(self,name,show):
try:
self.insert_func(name,show)
self.status_bar.showMessage('添加成功')
except Exception as e:
self.status_bar.showMessage('添加失败')
self.setEnabled(True)
self.addwidget.name_text.clear()
self.addwidget.show_text.clear()
self.addwidget.close()
'''删除槽'''
def delete_slot(self):
self.deletewidget.show()
self.setEnabled(False)
def delete_start_slot(self,id):
try:
self.delete_func(id)
self.reset_func()
self.status_bar.showMessage('删除成功')
except Exception as e:
self.status_bar.showMessage('删除失败')
self.setEnabled(True)
self.deletewidget.close()
'''更新槽'''
def update_slot(self):
self.updatewidget.show()
self.setEnabled(False)
def update_name_slot(self,id,name):
try:
self.update_name_func(id,name)
self.status_bar.showMessage('更新名称成功')
except Exception as e:
self.status_bar.showMessage('更新名称失败')
self.setEnabled(True)
self.updatewidget.close()
def update_show_slot(self,id,name):
try:
self.update_show_func(id,name)
self.status_bar.showMessage('更新名称成功')
except Exception as e:
self.status_bar.showMessage('更新名称失败')
self.setEnabled(True)
self.updatewidget.close()
'''数据库函数'''
def insert_func(self,name,show):
'''
插入信息
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('insert into design (id,name,show) values (null,"{}","{}")'.format(name,show))
cursor.close()
conn.commit()
conn.close()
def find_func(self,content):
'''
查询信息
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('SELECT * FROM design WHERE name LIKE "%{}%"'.format(content))
result1 = cursor.fetchall()
cursor.close()
conn.close()
return result1
def count_func(self):
'''
信息数目
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('select * from design')
result = cursor.fetchall()
count = len(result)
cursor.close()
conn.close()
return count
def update_name_func(self,id,name):
'''
更新名称信息
'''
print(id,name)
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('update design set name = ? where id = ?',(name,id))
cursor.close()
conn.commit()
conn.close()
def update_show_func(self,id,name):
'''
更新说明信息
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('update design set show = ? where id = ?',(name,id))
cursor.close()
conn.commit()
conn.close()
def delete_func(self,id):
'''
删除信息
'''
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute('delete from design where id = ?',(id,))
cursor.close()
conn.commit()
conn.close()
def reset_func(self):
conn = sqlite3.connect('find.db')
cursor = conn.cursor()
cursor.execute("DELETE FROM sqlite_sequence WHERE name = 'design'")
cursor.close()
conn.commit()
conn.close()
class AddWidget(QWidget):
'''
添加功能界面
'''
add_start_signal = pyqtSignal(str,str)
add_close_signal = pyqtSignal()
def __init__(self):
super(AddWidget,self).__init__()
self.ui_init()
self.connect_init()
def ui_init(self):
self.setWindowTitle('添加信息')
self.setFixedSize(300,200)
self.name_text = QLineEdit()
self.show_text = QTextEdit()
self.start_btn = QPushButton()
self.start_btn.setText('添加')
self.cancel_btn = QPushButton()
self.cancel_btn.setText('取消')
self.name_label = QLabel()
self.name_label.setText('名称：')
self.show_label = QLabel()
self.show_label.setText('说明：')
self.h1_layout = QHBoxLayout()
self.h2_layout = QHBoxLayout()
self.h3_layout = QHBoxLayout()
self.v_layout = QVBoxLayout()
self.h1_layout.addWidget(self.name_label)
self.h1_layout.addWidget(self.name_text)
self.h2_layout.addWidget(self.show_label)
self.h2_layout.addWidget(self.show_text)
self.h3_layout.addWidget(self.start_btn)
self.h3_layout.addWidget(self.cancel_btn)
self.v_layout.addLayout(self.h1_layout)
self.v_layout.addLayout(self.h2_layout)
self.v_layout.addLayout(self.h3_layout)
self.setLayout(self.v_layout)
def connect_init(self):
self.start_btn.clicked.connect(self.start_slot)
self.cancel_btn.clicked.connect(self.close_slot)
def start_slot(self):
name = self.name_text.text()
show = self.show_text.toPlainText()
self.add_start_signal.emit(name,show)
def close_slot(self):
self.close()
self.add_close_signal.emit()
def closeEvent(self, event):
self.add_close_signal.emit()
class DeleteWidget(QWidget):
'''
删除功能界面
'''
delete_cancel_signal = pyqtSignal()
delete_start_signal = pyqtSignal(str)
delete_close_signal = pyqtSignal()
def __init__(self):
super(DeleteWidget,self).__init__()
self.ui_init()
self.connect_init()
def ui_init(self):
self.setWindowTitle('删除信息')
self.setFixedSize(300,100)
self.id_text = QLineEdit()
self.start_btn = QPushButton()
self.start_btn.setText('删除')
self.cancel_btn = QPushButton()
self.cancel_btn.setText('取消')
self.id_label = QLabel()
self.id_label.setText('要删除的id：')
self.h1_layout = QHBoxLayout()
self.h2_layout = QHBoxLayout()
self.v_layout = QVBoxLayout()
self.h1_layout.addWidget(self.id_label)
self.h1_layout.addWidget(self.id_text)
self.h2_layout.addWidget(self.start_btn)
self.h2_layout.addWidget(self.cancel_btn)
self.v_layout.addLayout(self.h1_layout)
self.v_layout.addLayout(self.h2_layout)
self.setLayout(self.v_layout)
def connect_init(self):
self.start_btn.clicked.connect(self.start_slot)
self.cancel_btn.clicked.connect(self.close_slot)
def start_slot(self):
id = self.id_text.text()
self.delete_start_signal.emit(id)
def close_slot(self):
self.close()
self.delete_close_signal.emit()
def closeEvent(self, event):
self.delete_close_signal.emit()
class UpdateWidget(QWidget):
'''
更新功能界面
'''
update_name_signal = pyqtSignal(int,str)
update_show_signal = pyqtSignal(int,str)
update_close_signal = pyqtSignal()
def __init__(self):
super(UpdateWidget,self).__init__()
self.ui_init()
self.connect_init()
def ui_init(self):
self.setWindowTitle('修改信息')
self.setFixedSize(300,150)
self.content_text = QLineEdit()
self.id_text = QLineEdit()
self.name_btn = QPushButton()
self.name_btn.setText('修改名称')
self.show_btn = QPushButton()
self.show_btn.setText('修改说明')
self.cancel_btn = QPushButton()
self.cancel_btn.setText('取消')
self.content_label = QLabel()
self.content_label.setText('修改内容：')
self.id_label = QLabel()
self.id_label.setText('选择id为:')
self.h1_layout = QHBoxLayout()
self.h2_layout = QHBoxLayout()
self.h3_layout = QHBoxLayout()
self.v_layout = QVBoxLayout()
self.h1_layout.addWidget(self.id_label)
self.h1_layout.addWidget(self.id_text)
self.h2_layout.addWidget(self.content_label)
self.h2_layout.addWidget(self.content_text)
self.h3_layout.addWidget(self.name_btn)
self.h3_layout.addWidget(self.show_btn)
self.h3_layout.addWidget(self.cancel_btn)
self.v_layout.addLayout(self.h1_layout)
self.v_layout.addLayout(self.h2_layout)
self.v_layout.addLayout(self.h3_layout)
self.setLayout(self.v_layout)
def connect_init(self):
self.name_btn.clicked.connect(self.update_name_slot)
self.show_btn.clicked.connect(self.update_show_slot)
self.cancel_btn.clicked.connect(self.close_slot)
def update_name_slot(self):
id = self.id_text.text()
id = int(id)
content = self.content_text.text()
self.update_name_signal.emit(id,content)
def update_show_slot(self):
id = self.id_text.text()
id = int(id)
content = self.content_text.text()
self.update_show_signal.emit(id,content)
def close_slot(self):
self.close()
self.update_close_signal.emit()
def closeEvent(self, event):
self.update_close_signal.emit()
if __name__ == '__main__':
app = QApplication(sys.argv)
dispaly = MainWidget()
dispaly.show()
sys.exit(app.exec_())
展示
到此这篇关于Python PyQt5实战项目之查询器的实现流程详解的文章就介绍到这了,更多相关Python PyQt5 查询器内容请搜索本站以前的文章或继续浏览下面的相关文章希望大家以后多多支持本站！
本站声明
本文内容仅供参考，不代表本站观点。转载或引用请注明出处。如发现内容问题，请通过联系我们页面反馈。
