环境
系统:windows10系统
编辑器:PyCharm
编程语言:python3+pyqt5
分析
功能上分为两块,已经归还书籍,未归还书籍
在UI实现上,可以类比书籍查询系统,将这两部分都做成一个tabelView,结合数据库将其展现出来就好了
代码
""""
brief:借阅状态查询
date:2020-10-05
author:chenyijun
version: python V3.8.1 pyqt5 V5.14.0
"""
import sys
from PyQt5.QtWidgets import *
from PyQt5.QtGui import *
from PyQt5.QtCore import Qt
import qdarkstyle
from PyQt5.QtSql import *
from initDB import dbpath
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("AAA")
mainMindow.show()
sys.exit(app.exec_())
参考:
https://blog.csdn.net/weixin_38312031/article/details/80153198