reserveBook.py

# Form implementation generated from reading ui file 'reserveBook.ui'
#
# Created by: PyQt6 UI code generator 6.4.2
#
# WARNING: Any manual changes made to this file will be lost when pyuic6 is
# run again.  Do not edit this file unless you know what you are doing.


from PyQt6 import QtCore, QtGui, QtWidgets


class Ui_Form(QtWidgets.QWidget):
    def __init__(self, cursor, sid=None):
        super().__init__()
        self.cursor = cursor
        self.sid = sid
        self.setupUi(self)
        self.initBookTable()

    def setupUi(self, Form):
        Form.setObjectName("Form")
        Form.resize(800, 600)
        self.BookTable = QtWidgets.QTableWidget(parent=Form)
        self.BookTable.setGeometry(QtCore.QRect(40, 111, 721, 211))
        self.BookTable.setObjectName("BookTable")
        self.BookTable.setColumnCount(4)
        self.BookTable.setRowCount(0)
        item = QtWidgets.QTableWidgetItem()
        self.BookTable.setHorizontalHeaderItem(0, item)
        item = QtWidgets.QTableWidgetItem()
        self.BookTable.setHorizontalHeaderItem(1, item)
        item = QtWidgets.QTableWidgetItem()
        self.BookTable.setHorizontalHeaderItem(2, item)
        item = QtWidgets.QTableWidgetItem()
        self.BookTable.setHorizontalHeaderItem(3, item)
        self.groupBox = QtWidgets.QGroupBox(parent=Form)
        self.groupBox.setGeometry(QtCore.QRect(40, 20, 721, 71))
        self.groupBox.setObjectName("groupBox")
        self.label = QtWidgets.QLabel(parent=self.groupBox)
        self.label.setGeometry(QtCore.QRect(20, 30, 53, 15))
        self.label.setObjectName("label")
        self.label_2 = QtWidgets.QLabel(parent=self.groupBox)
        self.label_2.setGeometry(QtCore.QRect(220, 30, 53, 15))
        self.label_2.setObjectName("label_2")
        self.label_3 = QtWidgets.QLabel(parent=self.groupBox)
        self.label_3.setGeometry(QtCore.QRect(420, 30, 53, 15))
        self.label_3.setObjectName("label_3")
        self.searchSure = QtWidgets.QPushButton(parent=self.groupBox)
        self.searchSure.setGeometry(QtCore.QRect(640, 20, 81, 31))
        self.searchSure.setObjectName("searchSure")
        self.selectBid = QtWidgets.QLineEdit(parent=self.groupBox)
        self.selectBid.setGeometry(QtCore.QRect(70, 30, 113, 21))
        self.selectBid.setObjectName("selectBid")
        self.selectBname = QtWidgets.QLineEdit(parent=self.groupBox)
        self.selectBname.setGeometry(QtCore.QRect(270, 30, 113, 21))
        self.selectBname.setObjectName("selectBname")
        self.selectAuthor = QtWidgets.QLineEdit(parent=self.groupBox)
        self.selectAuthor.setGeometry(QtCore.QRect(470, 30, 113, 21))
        self.selectAuthor.setObjectName("selectAuthor")
        self.groupBox_2 = QtWidgets.QGroupBox(parent=Form)
        self.groupBox_2.setGeometry(QtCore.QRect(40, 330, 721, 251))
        self.groupBox_2.setObjectName("groupBox_2")
        self.formLayoutWidget = QtWidgets.QWidget(parent=self.groupBox_2)
        self.formLayoutWidget.setGeometry(QtCore.QRect(10, 20, 311, 171))
        self.formLayoutWidget.setObjectName("formLayoutWidget")
        self.formLayout = QtWidgets.QFormLayout(self.formLayoutWidget)
        self.formLayout.setContentsMargins(10, 10, 10, 10)
        self.formLayout.setHorizontalSpacing(10)
        self.formLayout.setVerticalSpacing(20)
        self.formLayout.setObjectName("formLayout")
        self.label_5 = QtWidgets.QLabel(parent=self.formLayoutWidget)
        self.label_5.setObjectName("label_5")
        self.formLayout.setWidget(0, QtWidgets.QFormLayout.ItemRole.LabelRole, self.label_5)
        self.viewBid = QtWidgets.QLineEdit(parent=self.formLayoutWidget)
        self.viewBid.setObjectName("viewBid")
        self.formLayout.setWidget(0, QtWidgets.QFormLayout.ItemRole.FieldRole, self.viewBid)
        self.label_6 = QtWidgets.QLabel(parent=self.formLayoutWidget)
        self.label_6.setObjectName("label_6")
        self.formLayout.setWidget(1, QtWidgets.QFormLayout.ItemRole.LabelRole, self.label_6)
        self.viewBname = QtWidgets.QLineEdit(parent=self.formLayoutWidget)
        self.viewBname.setObjectName("viewBname")
        self.formLayout.setWidget(1, QtWidgets.QFormLayout.ItemRole.FieldRole, self.viewBname)
        self.label_7 = QtWidgets.QLabel(parent=self.formLayoutWidget)
        self.label_7.setObjectName("label_7")
        self.formLayout.setWidget(2, QtWidgets.QFormLayout.ItemRole.LabelRole, self.label_7)
        self.viewAuthor = QtWidgets.QLineEdit(parent=self.formLayoutWidget)
        self.viewAuthor.setObjectName("viewAuthor")
        self.formLayout.setWidget(2, QtWidgets.QFormLayout.ItemRole.FieldRole, self.viewAuthor)
        self.label_8 = QtWidgets.QLabel(parent=self.formLayoutWidget)
        self.label_8.setObjectName("label_8")
        self.formLayout.setWidget(3, QtWidgets.QFormLayout.ItemRole.LabelRole, self.label_8)
        self.viewPublisher = QtWidgets.QLineEdit(parent=self.formLayoutWidget)
        self.viewPublisher.setObjectName("viewPublisher")
        self.formLayout.setWidget(3, QtWidgets.QFormLayout.ItemRole.FieldRole, self.viewPublisher)
        self.viewCover = QtWidgets.QGraphicsView(parent=self.groupBox_2)
        self.viewCover.setGeometry(QtCore.QRect(350, 20, 181, 161))
        self.viewCover.setObjectName("viewCover")
        self.reserveSure = QtWidgets.QPushButton(parent=self.groupBox_2)
        self.reserveSure.setGeometry(QtCore.QRect(640, 150, 81, 31))
        self.reserveSure.setObjectName("reserveSure")

        self.retranslateUi(Form)
        QtCore.QMetaObject.connectSlotsByName(Form)

        # 绑定事件
        self.searchSure.clicked.connect(self.searchBook)
        self.BookTable.clicked.connect(self.viewBook)
        # 设置预览信息不可编辑，设置背景颜色
        self.viewBid.setReadOnly(True)
        self.viewBname.setReadOnly(True)
        self.viewAuthor.setReadOnly(True)
        self.viewPublisher.setReadOnly(True)
        self.viewBid.setStyleSheet("background-color: #eee;")
        self.viewBname.setStyleSheet("background-color: #eee;")
        self.viewAuthor.setStyleSheet("background-color: #eee;")
        self.viewPublisher.setStyleSheet("background-color: #eee;")
        # 预约按钮
        self.reserveSure.clicked.connect(self.reserveBook)

    def retranslateUi(self, Form):
        _translate = QtCore.QCoreApplication.translate
        Form.setWindowTitle(_translate("Form", "预约图书"))
        item = self.BookTable.horizontalHeaderItem(0)
        item.setText(_translate("Form", "编号"))
        item = self.BookTable.horizontalHeaderItem(1)
        item.setText(_translate("Form", "书名"))
        item = self.BookTable.horizontalHeaderItem(2)
        item.setText(_translate("Form", "作者"))
        item = self.BookTable.horizontalHeaderItem(3)
        item.setText(_translate("Form", "出版社"))
        self.groupBox.setTitle(_translate("Form", "筛选"))
        self.label.setText(_translate("Form", "编   号："))
        self.label_2.setText(_translate("Form", "书   名："))
        self.label_3.setText(_translate("Form", "作   者："))
        self.searchSure.setText(_translate("Form", "搜索"))
        self.groupBox_2.setTitle(_translate("Form", "预览"))
        self.label_5.setText(_translate("Form", "编   号："))
        self.label_6.setText(_translate("Form", "书   名："))
        self.label_7.setText(_translate("Form", "作   者："))
        self.label_8.setText(_translate("Form", "出版社："))
        self.reserveSure.setText(_translate("Form", "预约"))

    def initBookTable(self):
        self.BookTable.setRowCount(0)
        self.cursor.execute("select bid, bname, author, publisher from book where status = 0")
        data = self.cursor.fetchall()
        for i in range(len(data)):
            self.BookTable.insertRow(i)
            for j in range(4):
                self.BookTable.setItem(i, j, QtWidgets.QTableWidgetItem(str(data[i][j])))
        self.BookTable.verticalHeader().setVisible(False)
        self.BookTable.setEditTriggers(QtWidgets.QAbstractItemView.EditTrigger.NoEditTriggers)
        self.BookTable.horizontalHeader().setSectionResizeMode(QtWidgets.QHeaderView.ResizeMode.Stretch)

    def searchBook(self):
        bid = self.selectBid.text()
        bname = self.selectBname.text()
        author = self.selectAuthor.text()
        self.BookTable.setRowCount(0)
        sql = "select bid, bname, author, publisher from book where bid like '%{}%' and bname like '%{}%' and author like '%{}%' and status = 0".format(bid, bname, author)
        self.cursor.execute(sql)
        data = self.cursor.fetchall()
        for i in range(len(data)):
            self.BookTable.insertRow(i)
            for j in range(4):
                self.BookTable.setItem(i, j, QtWidgets.QTableWidgetItem(str(data[i][j])))

    # 预览书籍信息
    def viewBook(self):
        row = self.BookTable.currentRow()
        bid = self.BookTable.item(row, 0).text()
        sql = "select * from book where bid = {}".format(bid)
        self.cursor.execute(sql)
        data = self.cursor.fetchone()
        self.viewBid.setText(str(data[0]))
        self.viewBname.setText(data[2])
        self.viewAuthor.setText(data[3])
        self.viewPublisher.setText(data[4])
        img = QtGui.QImage.fromData(data[1])
        cover = QtGui.QPixmap.fromImage(img).scaled(self.viewCover.width() - 10, self.viewCover.height() - 10)
        scene = QtWidgets.QGraphicsScene()
        scene.addPixmap(cover)
        self.viewCover.setScene(scene)

    # 预约书籍
    def reserveBook(self):
        # 获得书籍编号
        bid = self.viewBid.text()
        # 打开预约表单
        from reserveForm import Ui_Form
        self.reserveForm = Ui_Form(bid, self)
        self.reserveForm.show()


if __name__ == "__main__":
    import sys
    import pymysql
    app = QtWidgets.QApplication(sys.argv)
    db = pymysql.connect(
        host="localhost",
        user="root",
        password="10086",
        database="library",
        charset="utf8"
    )
    cursor = db.cursor()
    ui = Ui_Form(cursor, 1)
    ui.show()
    sys.exit(app.exec())