python实现科研管理系统（带用户界面和mysql数据库）

r囧r小猫 2023-09-30 14:25 1阅读 0赞

用python简单实现了一个科研管理系统的数据库大作业，有用户界面，可以实现增删改查功能

下面是6个主要模块，有需要源码的可以私信

1：连接模块 根据自己的mysql数据库输入参数即可连接

import pymysql
    def connect():
        conn = pymysql.connect(host='localhost', user='root',password=' ',database='',autocommit=True)#连接数据库library，用户和密码按需修改
        cursor = conn.cursor()
    
        return cursor, conn

2：登录模块 实现登录界面并且有三种身份，根据数据库里账号密码来判断登录是否正确

from PyQt5 import QtCore, QtGui, QtWidgets
 
 
 class Ui_Login(object):
 def setupUi(self, Login):
 #登录界面
 Login.setObjectName("Login")
 Login.setWindowModality(QtCore.Qt.ApplicationModal)
 Login.resize(800, 600)
 self.label = QtWidgets.QLabel(Login)
 self.label.setGeometry(QtCore.QRect(20, 20, 100, 30))
 self.label.setTextFormat(QtCore.Qt.AutoText)
 self.label.setObjectName("label")
 #用户界面
 self.user = QtWidgets.QLabel(Login)
 self.user.setGeometry(QtCore.QRect(160, 100, 60, 60))
 self.user.setObjectName("user")
 #密码界面
 self.password = QtWidgets.QLabel(Login)
 self.password.setGeometry(QtCore.QRect(160, 150, 60, 26))
 self.password.setObjectName("password")
 #身份界面
 self.identify = QtWidgets.QLabel(Login)
 self.identify.setGeometry(QtCore.QRect(140, 180, 91, 59))
 self.identify.setObjectName("identify")
 #用户行
 self.userline = QtWidgets.QLineEdit(Login)
 self.userline.setGeometry(QtCore.QRect(290, 100, 191, 21))
 self.userline.setObjectName("userline")
 #密码行
 self.pwline = QtWidgets.QLineEdit(Login)
 self.pwline.setGeometry(QtCore.QRect(290, 150, 191, 21))
 self.pwline.setEchoMode(QtWidgets.QLineEdit.Password)
 self.pwline.setObjectName("pwline")
 #ID盒
 self.idbox = QtWidgets.QComboBox(Login)
 self.idbox.setGeometry(QtCore.QRect(320, 200, 121, 22))
 self.idbox.setObjectName("idbox")
 self.idbox.addItem("")
 self.idbox.addItem("")
 self.idbox.addItem("")
 
 #登录按钮
 self.loginbt = QtWidgets.QPushButton(Login)
 self.loginbt.setGeometry(QtCore.QRect(250, 270, 93, 28))
 self.loginbt.setObjectName("loginbt")
 #退出按钮
 self.exitbt = QtWidgets.QPushButton(Login)
 self.exitbt.setGeometry(QtCore.QRect(420, 270, 93, 28))
 self.exitbt.setObjectName("exitbt")
 
 self.retranslateUi(Login)
 QtCore.QMetaObject.connectSlotsByName(Login)
 
 def retranslateUi(self, Login):
 _translate = QtCore.QCoreApplication.translate
 Login.setWindowTitle(_translate("Login", "SCUT科研管理系统"))
 self.label.setText(_translate("Login", "<html><head/><body>SCUT</body></html>"))
 self.user.setText(_translate("Login", "<html><head/><body>用户</body></html>"))
 self.password.setText(_translate("Login", "<html><head/><body>密码</body></html>"))
 self.identify.setText(_translate("Login", "<html><head/><body>身份类型</body></html>"))
 self.idbox.setItemText(0, _translate("Login", "秘书"))
 self.idbox.setItemText(1, _translate("Login", "主任"))
 self.idbox.setItemText(2, _translate("Login", "科研人员"))
 self.loginbt.setText(_translate("Login", "登录"))
 self.exitbt.setText(_translate("Login", "退出"))

3：秘书模块 实现了登录成功后秘书的界面及秘书所能执行的操作

![ca58d5139e724c5caa1d94fabb11b86b.png][]

import time
    from PyQt5 import QtCore, QtGui, QtWidgets
    from PyQt5.QtWidgets import QTableWidgetItem,QMessageBox
    from connect import *
    import  pymysql
    cursor,conn=connect()     #连接数据库
    class Ui_Reader(object):
        #创建UI
        def setupUi(self, Reader):
            self.loginID=self.getreaderid()
            Reader.setObjectName("Reader")
            Reader.resize(719, 742)
            self.readertab = QtWidgets.QTabWidget(Reader)
            self.readertab.setGeometry(QtCore.QRect(11, 11, 701, 721))
            self.readertab.setObjectName("readertab")
            self.borrowbook = QtWidgets.QWidget()
            self.borrowbook.setObjectName("borrowbook")
           
            self.returnbookid = QtWidgets.QLineEdit(self.layoutWidget1)
            self.returnbookid.setObjectName("returnbookid")
            self.horizontalLayout_3.addWidget(self.returnbookid)
            self.returnbookbt = QtWidgets.QPushButton(self.layoutWidget1)
            sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Fixed, QtWidgets.QSizePolicy.Fixed)
            sizePolicy.setHorizontalStretch(0)
            sizePolicy.setVerticalStretch(0)
            sizePolicy.setHeightForWidth(self.returnbookbt.sizePolicy().hasHeightForWidth())
            self.returnbookbt.setSizePolicy(sizePolicy)
            self.returnbookbt.setObjectName("returnbookbt")
            self.horizontalLayout_3.addWidget(self.returnbookbt)
            
            self.label_5.setObjectName("label_5")
            self.horizontalLayout_6.addWidget(self.label_5)
            self.author = QtWidgets.QLineEdit(self.widget)
            self.author.setObjectName("author")
            self.horizontalLayout_6.addWidget(self.author)
            self.verticalLayout_4.addLayout(self.horizontalLayout_6)
            self.horizontalLayout_7 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_7.setObjectName("horizontalLayout_7")
            self.label_6 = QtWidgets.QLabel(self.widget)
            self.label_6.setObjectName("label_6")
            self.horizontalLayout_7.addWidget(self.label_6)
            self.type = QtWidgets.QLineEdit(self.widget)
            self.type.setObjectName("type")
            self.horizontalLayout_7.addWidget(self.type)
            self.verticalLayout_4.addLayout(self.horizontalLayout_7)
            self.horizontalLayout_8 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_8.setObjectName("horizontalLayout_8")
            self.label_7 = QtWidgets.QLabel(self.widget)
            self.label_7.setObjectName("label_7")
            self.horizontalLayout_8.addWidget(self.label_7)
            self.press = QtWidgets.QLineEdit(self.widget)
            self.press.setObjectName("press")
            self.horizontalLayout_8.addWidget(self.press)
            self.verticalLayout_4.addLayout(self.horizontalLayout_8)
            self.horizontalLayout_9.addLayout(self.verticalLayout_4)
            self.verticalLayout = QtWidgets.QVBoxLayout()
            self.verticalLayout.setObjectName("verticalLayout")
            self.pushButton = QtWidgets.QPushButton(self.widget)
            self.pushButton.setObjectName("pushButton")
            self.verticalLayout.addWidget(self.pushButton)
            self.checkbt = QtWidgets.QPushButton(self.widget)
            self.checkbt.setObjectName("checkbt")
            self.verticalLayout.addWidget(self.checkbt)
            self.horizontalLayout_9.addLayout(self.verticalLayout)
            self.readertab.addTab(self.checkbook, "")
            self.userinfo = QtWidgets.QWidget()
            self.userinfo.setObjectName("userinfo")
            self.verticalLayout_9 = QtWidgets.QVBoxLayout(self.userinfo)
            self.verticalLayout_9.setObjectName("verticalLayout_9")
            self.verticalLayout_8 = QtWidgets.QVBoxLayout()
            self.verticalLayout_8.setObjectName("verticalLayout_8")
            self.horizontalLayout_14 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_14.setObjectName("horizontalLayout_14")
            self.verticalLayout_7 = QtWidgets.QVBoxLayout()
            self.verticalLayout_7.setObjectName("verticalLayout_7")
            self.horizontalLayout_10 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_10.setObjectName("horizontalLayout_10")
            self.label_8 = QtWidgets.QLabel(self.userinfo)
            self.label_8.setObjectName("label_8")
            self.horizontalLayout_10.addWidget(self.label_8)
            self.lineEdit_8 = QtWidgets.QLineEdit(self.userinfo)
            self.lineEdit_8.setObjectName("lineEdit_8")
            self.horizontalLayout_10.addWidget(self.lineEdit_8)
            self.verticalLayout_7.addLayout(self.horizontalLayout_10)
            self.horizontalLayout_11 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_11.setObjectName("horizontalLayout_11")
            self.label_9 = QtWidgets.QLabel(self.userinfo)
            self.label_9.setObjectName("label_9")
            self.horizontalLayout_11.addWidget(self.label_9)
            self.lineEdit_9 = QtWidgets.QLineEdit(self.userinfo)
            self.lineEdit_9.setObjectName("lineEdit_9")
            self.horizontalLayout_11.addWidget(self.lineEdit_9)
            self.verticalLayout_7.addLayout(self.horizontalLayout_11)
            self.horizontalLayout_12 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_12.setObjectName("horizontalLayout_12")
            self.verticalLayout_7.addLayout(self.horizontalLayout_12)
            self.horizontalLayout_13 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_13.setObjectName("horizontalLayout_13")
            self.label_11 = QtWidgets.QLabel(self.userinfo)
            self.label_11.setObjectName("label_11")
            self.horizontalLayout_13.addWidget(self.label_11)
            self.lineEdit_11 = QtWidgets.QLineEdit(self.userinfo)
            self.lineEdit_11.setObjectName("lineEdit_11")
            self.horizontalLayout_13.addWidget(self.lineEdit_11)
            self.verticalLayout_7.addLayout(self.horizontalLayout_13)
            self.horizontalLayout_14.addLayout(self.verticalLayout_7)
            self.pushButton_5 = QtWidgets.QPushButton(self.userinfo)
            self.pushButton_5.setObjectName("pushButton_5")
            self.horizontalLayout_14.addWidget(self.pushButton_5)
            self.verticalLayout_8.addLayout(self.horizontalLayout_14)
            self.textBrowser_2 = QtWidgets.QTextBrowser(self.userinfo)
            self.textBrowser_2.setObjectName("textBrowser_2")
            self.verticalLayout_8.addWidget(self.textBrowser_2)
            self.verticalLayout_9.addLayout(self.verticalLayout_8)
            self.readertab.addTab(self.userinfo, "")
            self.pay_2 = QtWidgets.QWidget()
            self.pay_2.setObjectName("pay_2")
            self.gridLayout = QtWidgets.QGridLayout(self.pay_2)
            self.gridLayout.setObjectName("gridLayout")
            self.money = QtWidgets.QLabel(self.pay_2)
            self.money.setText("")
            self.money.setObjectName("money")
            self.gridLayout.addWidget(self.money, 0, 1, 1, 1)
            self.label_12 = QtWidgets.QLabel(self.pay_2)
            self.label_12.setObjectName("label_12")
            self.gridLayout.addWidget(self.label_12, 0, 0, 1, 1)
            self.alipay = QtWidgets.QPushButton(self.pay_2)
            self.alipay.setObjectName("alipay")
            self.gridLayout.addWidget(self.alipay, 1, 2, 1, 1)
            self.wepay = QtWidgets.QPushButton(self.pay_2)
            self.wepay.setObjectName("wepay")
            self.gridLayout.addWidget(self.wepay, 1, 1, 1, 1)
            self.readertab.addTab(self.pay_2, "")
    
            self.retranslateUi(Reader)
            self.getreaderinfo()
            # self.textBrowser_2.setText(self.readerlogin
            self.readertab.setCurrentIndex(0)
            QtCore.QMetaObject.connectSlotsByName(Reader)
            self.borrowcheckbt.clicked.connect(self.borrowidcheck)
            self.borrowokbt.clicked.connect(self.submit)
            self.returnbookbt.clicked.connect(self.ReturnBook)
            self.pushButton.clicked.connect(self.selectallbook)
            self.checkbt.clicked.connect(self.selectbook)
            self.pushButton_5.clicked.connect(self.alterinfo)
            self.wepay.clicked.connect(self.paymoney)
            self.alipay.clicked.connect(self.paymoney)
        def retranslateUi(self, Reader):
            _translate = QtCore.QCoreApplication.translate
            Reader.setWindowTitle(_translate("Reader", "读者系统"))
            self.label.setText(_translate("Reader", "秘书个人信息"))
            self.borrowcheckbt.setText(_translate("Reader", "查询"))
            item = self.borrowtable.verticalHeaderItem(0)
            item.setText(_translate("Reader", "1"))
            item = self.borrowtable.horizontalHeaderItem(0)
            item.setText(_translate("Reader", "秘书姓名"))
            item = self.borrowtable.horizontalHeaderItem(1)
            item.setText(_translate("Reader", "秘书工号"))
            item = self.borrowtable.horizontalHeaderItem(2)
            item.setText(_translate("Reader", "秘书性别"))
            item = self.borrowtable.horizontalHeaderItem(3)
            item.setText(_translate("Reader", "秘书归属实验室"))
            item = self.borrowtable.horizontalHeaderItem(4)
            item.setText(_translate("Reader", ""))
            self.borrowokbt.setText(_translate("Reader", "末尾分界线"))
            self.readertab.setTabText(self.readertab.indexOf(self.borrowbook), _translate("Reader", "秘书信息查询"))
            #2
            self.returnbo.setText(_translate("Reader", "修改"))
            self.returnbookbt.setText(_translate("Reader", "确定"))
            self.readertab.setTabText(self.readertab.indexOf(self.returnbook), _translate("Reader", "修改秘书信息"))
            #3
            item = self.tableWidget.horizontalHeaderItem(0)
            item.setText(_translate("Reader", "秘书姓名"))
            item = self.tableWidget.horizontalHeaderItem(1)
            item.setText(_translate("Reader", "秘书工号"))
            item = self.tableWidget.horizontalHeaderItem(2)
            item.setText(_translate("Reader", "秘书性别"))
            item = self.tableWidget.horizontalHeaderItem(3)
            item.setText(_translate("Reader", "秘书归属实验室"))
            item = self.tableWidget.horizontalHeaderItem(4)
            item.setText(_translate("Reader", ""))
    
            self.label_3.setText(_translate("Reader", "秘书姓名"))
            self.label_4.setText(_translate("Reader", "秘书工号"))
            self.label_5.setText(_translate("Reader", "秘书性别"))
            self.label_6.setText(_translate("Reader", "秘书归属实验室"))
            self.label_7.setText(_translate("Reader", ""))
            self.pushButton.setText(_translate("Reader", "增加秘书信息"))
            self.checkbt.setText(_translate("Reader", "查询添加后的结果"))
            self.readertab.setTabText(self.readertab.indexOf(self.checkbook), _translate("Reader", "增加秘书信息"))
            #4
            self.label_8.setText(_translate("Reader", "秘书姓名"))
            self.label_9.setText(_translate("Reader", "秘书性别"))
            self.label_11.setText(_translate("Reader", ""))
            self.pushButton_5.setText(_translate("Reader", "删除"))
            self.readertab.setTabText(self.readertab.indexOf(self.userinfo), _translate("Reader", "删除秘书信息"))
           #5
            self.label_12.setText(_translate("Reader", "科研成果"))
            self.alipay.setText(_translate("Reader", "论文"))
            self.wepay.setText(_translate("Reader", "专利"))
            self.readertab.setTabText(self.readertab.indexOf(self.pay_2), _translate("Reader", "查询秘书科研成果"))  #####
        #第一个界面的查询
        def borrowidcheck(self):
            bookin=self.borrowbookid.text()
            sql='select * from secreatry'
            res = cursor.execute(sql)
            display=cursor.fetchall()
            print(display)
        #
        def getreaderid(self):
            nowtime = time.strftime("%Y-%m-%d", time.localtime())
            sql='SELECT * FROM secreatry'
            cursor.execute(sql)
    
        #
        def getreaderinfo(self):
            sql='SELECT * FROM secreatry '
            cursor.execute(sql)
            readerlogined=cursor.fetchall()
    
    
        #第二个界面
    
        def submit(self):
                    sql = 'update secreatry set selab="b8-123" where saname="张三"'
    
                    if sql:
                        res = cursor.execute(sql)
                    conn.commit()
                    QMessageBox.warning(self, "提示", "修改成功！", QMessageBox.Yes)
        #修改
        def ReturnBook(self):
            bookid = self.returnbookid.text()
            sql='SELECT * FROM secreatry'
            res=cursor.execute(sql)
            if res:
                sql = 'update secreatry set selab="b8-802" where sename="张三"'
                res = cursor.execute(sql)
                borrowinfo = cursor.fetchall()
                if res:
    
                        print(borrowinfo)
                        cursor.execute(sql)
                        conn.commit()
                        QMessageBox.warning(self, "提示", "修改成功！", QMessageBox.Yes)
    
            else:
                QMessageBox.warning(self, "警告", "修改信息有误 请重新输入！", QMessageBox.Yes)
        #第三个查询
    
        def selectallbook(self):
    
            sql='insert into secreatry values("汤德佑","33","男","b8-234")'
            cursor.execute(sql)
            if sql:
                QMessageBox.warning(self, "提示", "添加成功！", QMessageBox.Yes)
    
            books=cursor.fetchall()
            conn.commit()
    
    
    
        #查询书籍
        def selectbook(self):
    
            sql='SELECT * FROM secreatry'
    
            res=cursor.execute(sql)
            display = cursor.fetchall()
            print(display)
    
    
    
        #第四个修改
        def alterinfo(self):
            sql = 'delete from secreatry where sename="汤德佑"'
            if sql:
                cursor.execute(sql)
                result=cursor.fetchall()
    
                conn.commit()
                QMessageBox.warning(self, "警告", "删除成功", QMessageBox.Yes)
    
        #第五个支付
        def paymoney(self):
            money=0.00
            sql = 'select * from paper'
            cursor.execute(sql)
            res=cursor.fetchall()
            print(res)
            conn.commit()
            self.getreaderinfo()

4：主任模块 实现了登录后的主任界面及主任的各个功能

![884b9951e2d94f6582ccf122f67382b5.png][]

from PyQt5 import QtCore, QtGui, QtWidgets
    from connect import *
    from PyQt5.QtWidgets import QTableWidgetItem, QMessageBox
    import datetime
    import time
    
    cursor, conn = connect()
    
    
    class Ui_bookadmin(object):
    
        def __init__(self):
            self.dibeingtime = NotImplemented
            self.renqi=NotImplemented
            self.manangedlab=NotImplemented
    
        def setupUi(self, bookadmin):
            bookadmin.setObjectName("bookadmin")
            bookadmin.resize(846, 796)
            self.tabWidget = QtWidgets.QTabWidget(bookadmin)
            self.tabWidget.setGeometry(QtCore.QRect(20, 20, 811, 761))
            self.tabWidget.setObjectName("tabWidget")
            self.tab = QtWidgets.QWidget()
            self.tab.setObjectName("tab")
            self.verticalLayout_2 = QtWidgets.QVBoxLayout(self.tab)
            self.verticalLayout_2.setObjectName("verticalLayout_2")
            self.verticalLayout = QtWidgets.QVBoxLayout()
            self.verticalLayout.setObjectName("verticalLayout")
            self.horizontalLayout = QtWidgets.QHBoxLayout()
            self.horizontalLayout.setObjectName("horizontalLayout")
            self.label_2 = QtWidgets.QLabel(self.tab)
            self.label_2.setObjectName("label_2")
            self.horizontalLayout.addWidget(self.label_2)
            self.readerid = QtWidgets.QLineEdit(self.tab)
            self.readerid.setObjectName("dibeingtime")
            self.horizontalLayout.addWidget(self.readerid)
            self.label = QtWidgets.QLabel(self.tab)
            self.label.setObjectName("label")
            self.horizontalLayout.addWidget(self.label)
            self.readername = QtWidgets.QLineEdit(self.tab)
            self.readername.setObjectName("renqi")
            self.horizontalLayout.addWidget(self.readername)
            self.label_3 = QtWidgets.QLabel(self.tab)
            self.label_3.setObjectName("label_3")
            self.horizontalLayout.addWidget(self.label_3)
            self.unit = QtWidgets.QLineEdit(self.tab)
            self.unit.setObjectName("unit")
            self.horizontalLayout.addWidget(self.unit)
            self.verticalLayout.addLayout(self.horizontalLayout)
            self.horizontalLayout_2 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_2.setObjectName("horizontalLayout_2")
            self.select = QtWidgets.QPushButton(self.tab)
            sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Fixed, QtWidgets.QSizePolicy.Fixed)
            sizePolicy.setHorizontalStretch(0)
            sizePolicy.setVerticalStretch(0)
            sizePolicy.setHeightForWidth(self.select.sizePolicy().hasHeightForWidth())
            self.select.setSizePolicy(sizePolicy)
            self.select.setObjectName("select")
            self.horizontalLayout_2.addWidget(self.select)
            self.selectall = QtWidgets.QPushButton(self.tab)
            sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Fixed, QtWidgets.QSizePolicy.Fixed)
            sizePolicy.setHorizontalStretch(0)
            sizePolicy.setVerticalStretch(0)
            sizePolicy.setHeightForWidth(self.selectall.sizePolicy().hasHeightForWidth())
            self.selectall.setSizePolicy(sizePolicy)
            self.selectall.setObjectName("selectall")
            self.horizontalLayout_2.addWidget(self.selectall)
            self.verticalLayout.addLayout(self.horizontalLayout_2)
            self.readerinfors = QtWidgets.QTableWidget(self.tab)
            self.readerinfors.setObjectName("directorinfo")
            self.readerinfors.setColumnCount(8)
            self.readerinfors.setRowCount(0)
            item = QtWidgets.QTableWidgetItem()
            self.readerinfors.setHorizontalHeaderItem(0, item)
            item = QtWidgets.QTableWidgetItem()
            self.readerinfors.setHorizontalHeaderItem(1, item)
            item = QtWidgets.QTableWidgetItem()
            self.readerinfors.setHorizontalHeaderItem(2, item)
            item = QtWidgets.QTableWidgetItem()
            self.readerinfors.setHorizontalHeaderItem(3, item)
            item = QtWidgets.QTableWidgetItem()
            self.readerinfors.setHorizontalHeaderItem(4, item)
            item = QtWidgets.QTableWidgetItem()
            self.readerinfors.setHorizontalHeaderItem(5, item)
            item = QtWidgets.QTableWidgetItem()
            self.readerinfors.setHorizontalHeaderItem(6, item)
            item = QtWidgets.QTableWidgetItem()
            self.readerinfors.setHorizontalHeaderItem(7, item)
            self.verticalLayout.addWidget(self.readerinfors)
            self.verticalLayout_2.addLayout(self.verticalLayout)
            self.tabWidget.addTab(self.tab, "")
            self.tab_2 = QtWidgets.QWidget()
            self.tab_2.setObjectName("tab_2")
            self.verticalLayout_5 = QtWidgets.QVBoxLayout(self.tab_2)
            self.verticalLayout_5.setObjectName("verticalLayout_5")
            self.verticalLayout_3 = QtWidgets.QVBoxLayout()
            self.verticalLayout_3.setObjectName("verticalLayout_3")
            self.horizontalLayout_13 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_13.setObjectName("horizontalLayout_13")
            self.horizontalLayout_3 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_3.setObjectName("horizontalLayout_3")
            self.label_4 = QtWidgets.QLabel(self.tab_2)
            self.label_4.setObjectName("label_4")
            self.horizontalLayout_3.addWidget(self.label_4)
            self.bookid = QtWidgets.QLineEdit(self.tab_2)
            self.bookid.setObjectName("bookid")
            self.horizontalLayout_3.addWidget(self.bookid)

5：科研人员模块 实现了登录后的科研人员界面及科研的各个ca

![9b2e23459b3c411d97fa84dc46acb4a3.png][]

import pymysql
    from PyQt5 import QtCore, QtGui, QtWidgets
    from PyQt5.QtWidgets import QTableWidgetItem,QMessageBox
    from connect import *
    from PyQt5 import QtCore, QtGui, QtWidgets
    
    
    cursor,conn=connect()
    class Ui_systemadmin(object):
        def __init__(self):
            self.conn = None
    
        def setupUi(self, systemadmin):
            systemadmin.setObjectName("systemadmin")
            systemadmin.resize(738, 747)
            self.tabWidget = QtWidgets.QTabWidget(systemadmin)
            self.tabWidget.setGeometry(QtCore.QRect(9, 9, 721, 731))
            self.tabWidget.setObjectName("tabWidget")
            self.tab = QtWidgets.QWidget()
            self.tab.setObjectName("tab")
            self.widget = QtWidgets.QWidget(self.tab)
            self.widget.setGeometry(QtCore.QRect(10, 10, 701, 691))
            self.widget.setObjectName("widget")
            self.verticalLayout = QtWidgets.QVBoxLayout(self.widget)
            self.verticalLayout.setContentsMargins(0, 0, 0, 0)
            self.verticalLayout.setObjectName("verticalLayout")
            self.horizontalLayout_7 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_7.setObjectName("horizontalLayout_7")
            self.horizontalLayout = QtWidgets.QHBoxLayout()
            self.horizontalLayout.setObjectName("horizontalLayout")
            self.label = QtWidgets.QLabel(self.widget)
            self.label.setObjectName("label")
            self.horizontalLayout.addWidget(self.label)
            self.readerid = QtWidgets.QLineEdit(self.widget)
            sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Fixed)
            sizePolicy.setHorizontalStretch(0)
            sizePolicy.setVerticalStretch(0)
            sizePolicy.setHeightForWidth(self.readerid.sizePolicy().hasHeightForWidth())
            self.readerid.setSizePolicy(sizePolicy)
            self.readerid.setObjectName("readerid")
            self.horizontalLayout.addWidget(self.readerid)
            self.horizontalLayout_7.addLayout(self.horizontalLayout)
            self.horizontalLayout_2 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_2.setObjectName("horizontalLayout_2")
            self.label_2 = QtWidgets.QLabel(self.widget)
            self.label_2.setObjectName("label_2")
            self.horizontalLayout_2.addWidget(self.label_2)
            self.readname = QtWidgets.QLineEdit(self.widget)
            sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Fixed, QtWidgets.QSizePolicy.Fixed)
            sizePolicy.setHorizontalStretch(0)
            sizePolicy.setVerticalStretch(0)
            sizePolicy.setHeightForWidth(self.readname.sizePolicy().hasHeightForWidth())
            self.readname.setSizePolicy(sizePolicy)
            self.readname.setObjectName("readname")
            self.horizontalLayout_2.addWidget(self.readname)
            self.horizontalLayout_7.addLayout(self.horizontalLayout_2)
            self.horizontalLayout_5 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_5.setObjectName("horizontalLayout_5")
            self.label_4 = QtWidgets.QLabel(self.widget)
            self.label_4.setObjectName("label_4")
            self.horizontalLayout_5.addWidget(self.label_4)
            self.unit = QtWidgets.QComboBox(self.widget)
            self.unit.setObjectName("unit")
            self.unit.addItem("")
            self.unit.addItem("")
            self.unit.addItem("")
            self.unit.addItem("")
            self.horizontalLayout_5.addWidget(self.unit)
            self.horizontalLayout_7.addLayout(self.horizontalLayout_5)
            self.horizontalLayout_4 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_4.setObjectName("horizontalLayout_4")
            self.label_3 = QtWidgets.QLabel(self.widget)
            self.label_3.setObjectName("label_3")
            self.horizontalLayout_4.addWidget(self.label_3)
            self.sex = QtWidgets.QComboBox(self.widget)
            sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Fixed, QtWidgets.QSizePolicy.Fixed)
            sizePolicy.setHorizontalStretch(0)
            sizePolicy.setVerticalStretch(0)
            sizePolicy.setHeightForWidth(self.sex.sizePolicy().hasHeightForWidth())
            self.sex.setSizePolicy(sizePolicy)
            self.sex.setObjectName("sex")
            self.sex.addItem("")
            self.sex.addItem("")
            self.horizontalLayout_4.addWidget(self.sex)
            self.horizontalLayout_7.addLayout(self.horizontalLayout_4)
            self.verticalLayout.addLayout(self.horizontalLayout_7)
            self.horizontalLayout_13 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_13.setObjectName("horizontalLayout_13")
            self.horizontalLayout_9 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_9.setObjectName("horizontalLayout_9")
            self.label_6 = QtWidgets.QLabel(self.widget)
            self.label_6.setObjectName("label_6")
            self.horizontalLayout_9.addWidget(self.label_6)
            self.readtype = QtWidgets.QComboBox(self.widget)
            self.readtype.setObjectName("readtype")
            self.readtype.addItem("")
            self.readtype.addItem("")
            self.readtype.addItem("")
            self.horizontalLayout_9.addWidget(self.readtype)
            self.horizontalLayout_13.addLayout(self.horizontalLayout_9)
            self.horizontalLayout_10 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_10.setObjectName("horizontalLayout_10")
            self.label_7 = QtWidgets.QLabel(self.widget)
            self.label_7.setObjectName("label_7")
            self.horizontalLayout_10.addWidget(self.label_7)
            self.totalnumber = QtWidgets.QLineEdit(self.widget)
            self.totalnumber.setObjectName("totalnumber")
            self.horizontalLayout_10.addWidget(self.totalnumber)
            self.horizontalLayout_13.addLayout(self.horizontalLayout_10)
            self.horizontalLayout_11 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_11.setObjectName("horizontalLayout_11")
            self.label_8 = QtWidgets.QLabel(self.widget)
            self.label_8.setObjectName("label_8")
            self.horizontalLayout_11.addWidget(self.label_8)
            self.number = QtWidgets.QLineEdit(self.widget)
            self.number.setObjectName("number")
            self.horizontalLayout_11.addWidget(self.number)
            self.horizontalLayout_13.addLayout(self.horizontalLayout_11)
            self.horizontalLayout_12 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_12.setObjectName("horizontalLayout_12")
            self.label_9 = QtWidgets.QLabel(self.widget)
            self.label_9.setObjectName("label_9")
            self.horizontalLayout_12.addWidget(self.label_9)
            self.money = QtWidgets.QLineEdit(self.widget)
            self.money.setObjectName("money")
            self.horizontalLayout_12.addWidget(self.money)
            self.horizontalLayout_13.addLayout(self.horizontalLayout_12)
            self.verticalLayout.addLayout(self.horizontalLayout_13)
            self.horizontalLayout_8 = QtWidgets.QHBoxLayout()
            self.horizontalLayout_8.setObjectName("horizontalLayout_8")
            self.addr = QtWidgets.QPushButton(self.widget)
            sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Fixed, QtWidgets.QSizePolicy.Fixed)
            sizePolicy.setHorizontalStretch(0)
            sizePolicy.setVerticalStretch(0)
            sizePolicy.setHeightForWidth(self.addr.sizePolicy().hasHeightForWidth())
            self.addr.setSizePolicy(sizePolicy)
            self.addr.setObjectName("addr")
            self.horizontalLayout_8.addWidget(self.addr)
            self.alterr = QtWidgets.QPushButton(self.widget)
            sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Fixed, QtWidgets.QSizePolicy.Fixed)
            sizePolicy.setHorizontalStretch(0)
            sizePolicy.setVerticalStretch(0)
            sizePolicy.setHeightForWidth(self.alterr.sizePolicy().hasHeightForWidth())
            self.alterr.setSizePolicy(sizePolicy)
            self.alterr.setObjectName("alterr")
            self.horizontalLayout_8.addWidget(self.alterr)
            self.deleter = QtWidgets.QPushButton(self.widget)
            sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Fixed, QtWidgets.QSizePolicy.Fixed)
            sizePolicy.setHorizontalStretch(0)
            sizePolicy.setVerticalStretch(0)

6：主函数模块 最后执行的模块 调用其他模块

import sys
    import pymysql
    import time
    from PyQt5 import QtCore, QtGui, QtWidgets
    from PyQt5.QtWidgets import QApplication, QMainWindow,QMessageBox
    from login import Ui_Login
    from secreatry import Ui_Reader
    from connect import *
    from repeople import Ui_systemadmin
    from director import Ui_bookadmin
    
    cursor,conn=connect()
    
    
    class Readerui(QtWidgets.QMainWindow, Ui_Reader):
        def __init__(self, parent=None):
            super(Readerui,self).__init__(parent)
            self.setupUi(self)
    
    class bookadminui(QtWidgets.QMainWindow,Ui_bookadmin):
        def __init__(self, parent=None):
           super(bookadminui, self).__init__(parent)
           self.setupUi(self)
    class sysadminui(QtWidgets.QMainWindow,Ui_systemadmin):
        def __init__(self, parent=None):
            super(sysadminui, self).__init__(parent)
            self.setupUi(self)
    class MyMainForm(QMainWindow, Ui_Login):
        def __init__(self, parent=None):
            super(MyMainForm, self).__init__(parent)
            self.setupUi(self)
            self.exitbt.clicked.connect(self.exit)
            self.loginbt.clicked.connect(self.login)
        def exit(self):    #退出
            rec_code=QMessageBox.question(self, "确认", "好好想想真的要退出吗？？", QMessageBox.Yes | QMessageBox.No)
            if rec_code != 65536:
                self.close()
        def login(self):   #登陆
            ID=self.userline.text()
            PW=self.pwline.text()
            if ID=='' or PW=='':
                QMessageBox.warning(self, "警告", "用户名和密码都要输入噢！！！", QMessageBox.Yes)
            else:
                if self.idbox.currentText()=='秘书':
    
                    type='秘书'
                    sql = 'select * from secreatry where sename = "%s" and seworknum="%s" '%  (ID, PW)
                    res = cursor.execute(sql)
                    if res:
    
                        self.read = Readerui()
                        self.read.show()
    
    
                    else:
                        QMessageBox.warning(self, "警告", "密码错误，请重新输入！", QMessageBox.Yes)
                elif self.idbox.currentText()=='主任':
                    type='主任'

[ca58d5139e724c5caa1d94fabb11b86b.png]: https://img-blog.csdnimg.cn/ca58d5139e724c5caa1d94fabb11b86b.png
[884b9951e2d94f6582ccf122f67382b5.png]: https://img-blog.csdnimg.cn/884b9951e2d94f6582ccf122f67382b5.png
[9b2e23459b3c411d97fa84dc46acb4a3.png]: https://img-blog.csdnimg.cn/9b2e23459b3c411d97fa84dc46acb4a3.png