用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, conn2：登录模块 实现登录界面并且有三种身份，根据数据库里账号密码来判断登录是否正确
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><p><span style=\" font-size:15pt;\">SCUT</span></p></body></html>"))
self.user.setText(_translate("Login", "<html><head/><body><p><span style=\" font-size:10pt;\">用户</span></p></body></html>"))
self.password.setText(_translate("Login", "<html><head/><body><p><span style=\" font-size:12pt;\">密码</span></p></body></html>"))
self.identify.setText(_translate("Login", "<html><head/><body><p><span style=\" font-size:12pt;\">身份类型</span></p></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：秘书模块 实现了登录成功后秘书的界面及秘书所能执行的操作
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：主任模块 实现了登录后的主任界面及主任的各个功能
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
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='主任'本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
