PyQT5一起学做图书管理系统（11）借阅状态查询

ゝ一世哀愁。 2022-03-14 14:38 211阅读 0赞

# PyQT5一起学做图书管理系统（11）借阅状态查询 #

## 环境 ##

系统：windows10系统  
编辑器：Sublime3  
编程语言：python3+pyqt5

## 前言 ##

记得要初始化数据库哈，参考第二节内容

## 分析 ##

功能上分为两块，已经归还书籍，未归还书籍  
在UI实现上，可以类比书籍查询系统，将这两部分都做成一个tabelView，结合数据库将其展现出来就好了

代码

#!/usr/bin/env python
    # -*- coding: utf-8 -*-
    # @Date    : 2018-12-05 21:37:24
    # @Author  : Jimy_Fengqi (jmps515@163.com)
    # @Link    : https://blog.csdn.net/qiqiyingse/
    
    import sys
    from PyQt5.QtWidgets import *
    from PyQt5.QtGui import *
    from PyQt5.QtCore import Qt
    import qdarkstyle
    from PyQt5.QtSql import *
    from db.userInfoManager import dbpath
    import images
    
    class BorrowStatusViewer(QWidget):
        def __init__(self, userid):
            super(BorrowStatusViewer, self).__init__()
            self.resize(700, 500)
            self.userid = userid
            self.setWindowTitle("欢迎使用图书馆管理系统")
            self.setUpUI()
    
        def setUpUI(self):
            self.db = QSqlDatabase.addDatabase("QSQLITE")
            #self.db.setDatabaseName('./db/LibraryManagement.db')
            self.db.setDatabaseName(dbpath)
            self.db.open()
            # 分为两块，上方是已借未归还书，下方是已归还书
            self.layout = QVBoxLayout(self)
            # Label设置
            self.borrowedLabel = QLabel("未归还:")
            self.returnedLabel = QLabel("已归还:")
            self.borrowedLabel.setFixedHeight(32)
            self.borrowedLabel.setFixedWidth(60)
            self.returnedLabel.setFixedHeight(32)
            self.returnedLabel.setFixedWidth(60)
            font = QFont()
            font.setPixelSize(18)
            self.borrowedLabel.setFont(font)
            self.returnedLabel.setFont(font)
    
            # Table和Model
            self.borrowedTableView = QTableView()
            self.borrowedTableView.horizontalHeader().setStretchLastSection(True)
            self.borrowedTableView.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
            self.borrowedTableView.setEditTriggers(QAbstractItemView.NoEditTriggers)
            self.returnedTableView = QTableView()
            self.returnedTableView.horizontalHeader().setStretchLastSection(True)
            self.returnedTableView.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
            self.returnedTableView.setEditTriggers(QAbstractItemView.NoEditTriggers)
    
            self.borrowedQueryModel = QSqlQueryModel()
            self.returnedQueryModel = QSqlQueryModel()
            self.borrowedTableView.setModel(self.borrowedQueryModel)
            self.returnedTableView.setModel(self.returnedQueryModel)
            self.borrowedQuery()
            self.borrowedQueryModel.setHeaderData(0, Qt.Horizontal, "书名")
            self.borrowedQueryModel.setHeaderData(1, Qt.Horizontal, "书号")
            self.borrowedQueryModel.setHeaderData(2, Qt.Horizontal, "作者")
            self.borrowedQueryModel.setHeaderData(3, Qt.Horizontal, "分类")
            self.borrowedQueryModel.setHeaderData(4, Qt.Horizontal, "出版社")
            self.borrowedQueryModel.setHeaderData(5, Qt.Horizontal, "出版时间")
            self.borrowedQueryModel.setHeaderData(6, Qt.Horizontal, "借出时间")
    
            self.returnedQuery()
            self.returnedQueryModel.setHeaderData(0, Qt.Horizontal, "书名")
            self.returnedQueryModel.setHeaderData(1, Qt.Horizontal, "书号")
            self.returnedQueryModel.setHeaderData(2, Qt.Horizontal, "作者")
            self.returnedQueryModel.setHeaderData(3, Qt.Horizontal, "分类")
            self.returnedQueryModel.setHeaderData(4, Qt.Horizontal, "出版社")
            self.returnedQueryModel.setHeaderData(5, Qt.Horizontal, "出版时间")
            self.returnedQueryModel.setHeaderData(6, Qt.Horizontal, "借阅时间")
            self.returnedQueryModel.setHeaderData(7, Qt.Horizontal, "归还时间")
    
            self.layout.addWidget(self.borrowedLabel)
            self.layout.addWidget(self.borrowedTableView)
            self.layout.addWidget(self.returnedLabel)
            self.layout.addWidget(self.returnedTableView)
            return
    
        def borrowedQuery(self):
            sql = "SELECT Book.BookName,Book.BookID,Auth,Category,Publisher,PublishTime,BorrowTime  FROM Book,User_Book WHERE Book.BookID=User_Book.BookID AND User_Book.BorrowState=1 AND userid='%s'" % self.userid
            self.borrowedQueryModel.setQuery(sql)
            return
    
        def returnedQuery(self):
            sql = "SELECT Book.BookName,Book.BookID,Auth,Category,Publisher,PublishTime,BorrowTime,ReturnTime  FROM Book,User_Book WHERE Book.BookID=User_Book.BookID AND User_Book.BorrowState=0 AND userid='%s'" % self.userid
            self.returnedQueryModel.setQuery(sql)
            return
    
    
    if __name__ == "__main__":
        app = QApplication(sys.argv)
        app.setWindowIcon(QIcon(":/images/MainWindow_1.png"))
        app.setStyleSheet(qdarkstyle.load_stylesheet_pyqt5())
        mainMindow = BorrowStatusViewer("PB15000135")
        mainMindow.show()
        sys.exit(app.exec_())

效果图

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FpcWl5aW5nc2U_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FpcWl5aW5nc2U_size_16_color_FFFFFF_t_70]: /images/20220312/bb5cfb5a6d2b47b7b0a85162d43e967d.png