python3+PyQt5数据库编程–增删改实例_pyqt数据库 - CSDN文库

127 浏览量更新于2023-03-03 评论 2 收藏 44KB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

python3+PyQt5 数据库编程数据库编程–增删改实例增删改实例

本文通过python3+pyqt5改写实现了python Qt gui 编程变成15章的excise例子。

#!/usr/bin/env python3

import os

import sys

from PyQt5.QtCore import (QFile, QVariant, Qt)

from PyQt5.QtWidgets import (QApplication, QDialog, QDialogButtonBox, QMenu,

QMessageBox, QTableView, QVBoxLayout)

from PyQt5.QtSql import (QSqlDatabase, QSqlQuery, QSqlTableModel)

MAC = True

try:

from PyQt5.QtGui import qt_mac_set_native_menubar

except ImportError:

MAC = False

ID, CATEGORY, SHORTDESC, LONGDESC = range(4)

class ReferenceDataDlg(QDialog):

def __init__(self, parent=None):

super(ReferenceDataDlg, self).__init__(parent)

self.model = QSqlTableModel(self)

self.model.setTable("reference")

self.model.setSort(ID, Qt.AscendingOrder)

self.model.setHeaderData(ID, Qt.Horizontal, "ID")

self.model.setHeaderData(CATEGORY, Qt.Horizontal,"Category")

self.model.setHeaderData(SHORTDESC, Qt.Horizontal,"Short Desc.")

self.model.setHeaderData(LONGDESC, Qt.Horizontal,"Long Desc.")

self.model.select()

self.view = QTableView()

self.view.setModel(self.model)

self.view.setSelectionMode(QTableView.SingleSelection)

self.view.setSelectionBehavior(QTableView.SelectRows)

self.view.setColumnHidden(ID, True)

self.view.resizeColumnsToContents()

buttonBox = QDialogButtonBox()

addButton = buttonBox.addButton("&Add",

QDialogButtonBox.ActionRole)

deleteButton = buttonBox.addButton("&Delete",

QDialogButtonBox.ActionRole)

sortButton = buttonBox.addButton("&Sort",

QDialogButtonBox.ActionRole)

if not MAC:

addButton.setFocusPolicy(Qt.NoFocus)

deleteButton.setFocusPolicy(Qt.NoFocus)

sortButton.setFocusPolicy(Qt.NoFocus)

menu = QMenu(self)

sortByCategoryAction = menu.addAction("Sort by &Category")

sortByDescriptionAction = menu.addAction("Sort by &Description")

sortByIDAction = menu.addAction("Sort by &ID")

sortButton.setMenu(menu)

closeButton = buttonBox.addButton(QDialogButtonBox.Close)

layout = QVBoxLayout()

layout.addWidget(self.view)

layout.addWidget(buttonBox)

self.setLayout(layout)

addButton.clicked.connect(self.addRecord)

deleteButton.clicked.connect(self.deleteRecord)

sortByCategoryAction.triggered.connect(lambda:self.sort(CATEGORY))

sortByDescriptionAction.triggered.connect(lambda:self.sort(SHORTDESC))

本内容试读结束，登录后可阅读更多

下载后可阅读完整内容，剩余2页未读，立即下载

评论0

weixin_38616120

粉丝: 7
资源: 944

会员权益专享

图片转文字

全年可省5，000元立即开通

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈