python学生管理系统源码

# -*- coding: utf-8 -*- # Form implementation generated from reading ui file 'student_manage.ui' # # Created by: PyQt5 UI code generator 5.15.4 # # WARNING: Any manual changes made to this file will be lost when pyuic5 is # run again. Do not edit this file unless you know what you are doing. import sys from PyQt5 import QtCore, QtGui, QtWidgets from PyQt5.QtWidgets import * sys.path.append('../service/') import service from service.service import query, exec class Ui_Student_Manage_MainWindow(QMainWindow): # 构造方法 def __init__(self): super(Ui_Student_Manage_MainWindow, self).__init__() #self.setWindowFlags(QtCore.Qt.MSWindowsFixedSizeDialogHint) # 只显示最小化和关闭按钮 self.setupUi(self) # 初始化窗体设置 def setupUi(self, Student_Manage_MainWindow): Student_Manage_MainWindow.setObjectName("Student_Manage_MainWindow") Student_Manage_MainWindow.resize(800, 600) self.centralwidget = QtWidgets.QWidget(Student_Manage_MainWindow) self.centralwidget.setObjectName("centralwidget") self.label = QtWidgets.QLabel(self.centralwidget) self.label.setGeometry(QtCore.QRect(20, 20, 31, 21)) self.label.setObjectName("label") self.comboBoxNJ = QtWidgets.QComboBox(self.centralwidget) self.comboBoxNJ.setGeometry(QtCore.QRect(60, 20, 81, 21)) self.comboBoxNJ.setObjectName("comboBoxNJ") self.label_2 = QtWidgets.QLabel(self.centralwidget) self.label_2.setGeometry(QtCore.QRect(170, 20, 31, 21)) self.label_2.setObjectName("label_2") self.comboBoxBJ = QtWidgets.QComboBox(self.centralwidget) self.comboBoxBJ.setGeometry(QtCore.QRect(210, 20, 81, 21)) self.comboBoxBJ.setObjectName("comboBoxBJ") self.refreshBtn = QtWidgets.QPushButton(self.centralwidget) self.refreshBtn.setGeometry(QtCore.QRect(310, 20, 75, 23)) self.refreshBtn.setObjectName("refreshBtn") self.addBtn = QtWidgets.QPushButton(self.centralwidget) self.addBtn.setGeometry(QtCore.QRect(400, 20, 75, 23)) self.addBtn.setObjectName("addBtn") self.modifyBtn = QtWidgets.QPushButton(self.centralwidget) self.modifyBtn.setGeometry(QtCore.QRect(490, 20, 75, 23)) self.modifyBtn.setObjectName("modifyBtn") self.delBtn = QtWidgets.QPushButton(self.centralwidget) self.delBtn.setGeometry(QtCore.QRect(580, 20, 75, 23)) self.delBtn.setObjectName("delBtn") self.exitBtn = QtWidgets.QPushButton(self.centralwidget) self.exitBtn.setGeometry(QtCore.QRect(670, 20, 75, 23)) self.exitBtn.setObjectName("exitBtn") self.label_3 = QtWidgets.QLabel(self.centralwidget) self.label_3.setGeometry(QtCore.QRect(30, 460, 61, 21)) self.label_3.setObjectName("label_3") self.editNum = QtWidgets.QLineEdit(self.centralwidget) self.editNum.setGeometry(QtCore.QRect(90, 460, 131, 20)) self.editNum.setObjectName("editNum") self.label_4 = QtWidgets.QLabel(self.centralwidget) self.label_4.setGeometry(QtCore.QRect(260, 460, 31, 21)) self.label_4.setObjectName("label_4") self.editName = QtWidgets.QLineEdit(self.centralwidget) self.editName.setGeometry(QtCore.QRect(300, 460, 121, 20)) self.editName.setText("") self.editName.setObjectName("editName") self.label_5 = QtWidgets.QLabel(self.centralwidget) self.label_5.setGeometry(QtCore.QRect(450, 460, 31, 21)) self.label_5.setObjectName("label_5") self.editAge = QtWidgets.QLineEdit(self.centralwidget) self.editAge.setGeometry(QtCore.QRect(490, 460, 91, 20)) self.editAge.setObjectName("editAge") self.label_6 = QtWidgets.QLabel(self.centralwidget) self.label_6.setGeometry(QtCore.QRect(610, 460, 31, 21)) self.label_6.setObjectName("label_6") self.comboBoxXB = QtWidgets.QComboBox(self.centralwidget) self.comboBoxXB.setGeometry(QtCore.QRect(650, 460, 81, 21)) self.comboBoxXB.setObjectName("comboBoxXB") self.comboBoxXB.addItem("") self.comboBoxXB.addItem("") self.label_7 = QtWidgets.QLabel(self.centralwidget) self.label_7.setGeometry(QtCore.QRect(30, 500, 61, 21)) self.label_7.setObjectName("label_7") self.editPhone = QtWidgets.QLineEdit(self.centralwidget) self.editPhone.setGeometry(QtCore.QRect(90, 500, 131, 20)) self.editPhone.setObjectName("editPhone") self.label_8 = QtWidgets.QLabel(self.centralwidget) self.label_8.setGeometry(QtCore.QRect(240, 500, 61, 21)) self.label_8.setObjectName("label_8") self.editAddress = QtWidgets.QLineEdit(self.centralwidget) self.editAddress.setGeometry(QtCore.QRect(300, 500, 431, 20)) self.editAddress.setText("") self.editAddress.setObjectName("editAddress") self.tbStudent = QtWidgets.QTableWidget(self.centralwidget) self.tbStudent.setGeometry(QtCore.QRect(25, 61, 731, 381)) self.tbStudent.setColumnCount(8) self.tbStudent.setObjectName("tbStudent") self.tbStudent.setRowCount(0) item = QtWidgets.QTableWidgetItem() self.tbStudent.setHorizontalHeaderItem(0, item) item = QtWidgets.QTableWidgetItem() self.tbStudent.setHorizontalHeaderItem(1, item) item = QtWidgets.QTableWidgetItem() self.tbStudent.setHorizontalHeaderItem(2, item) item = QtWidgets.QTableWidgetItem() self.tbStudent.setHorizontalHeaderItem(3, item) item = QtWidgets.QTableWidgetItem() self.tbStudent.setHorizontalHeaderItem(4, item) item = QtWidgets.QTableWidgetItem() self.tbStudent.setHorizontalHeaderItem(5, item) item = QtWidgets.QTableWidgetItem() self.tbStudent.setHorizontalHeaderItem(6, item) item = QtWidgets.QTableWidgetItem() self.tbStudent.setHorizontalHeaderItem(7, item) Student_Manage_MainWindow.setCentralWidget(self.centralwidget) self.menubar = QtWidgets.QMenuBar(Student_Manage_MainWindow) self.menubar.setGeometry(QtCore.QRect(0, 0, 800, 23)) self.menubar.setObjectName("menubar") Student_Manage_MainWindow.setMenuBar(self.menubar) self.statusbar = QtWidgets.QStatusBar(Student_Manage_MainWindow) self.statusbar.setObjectName("statusbar") Student_Manage_MainWindow.setStatusBar(self.statusbar) self.retranslateUi(Student_Manage_MainWindow) QtCore.QMetaObject.connectSlotsByName(Student_Manage_MainWindow) self.comboBoxNJ.addItem("全年级") self.comboBoxBJ.addItem("所有班级") # 绑定年级下拉列表 self.bindnj() # 根据年级绑定班级列表 self.comboBoxNJ.currentIndexChanged.connect(self.bindbj) self.tbStudent.setAlternatingRowColors(True) # 使表格颜色交错显示 self.tbStudent.verticalHeader().setVisible(False) # 隐藏垂直标题 #显示TableWidget self.showTableWidget() #为增加按钮addBtn添加处理函数 self.addBtn.clicked.connect(self.addData) self.refreshBtn.clicked.connect(self.showTableWidget) self.modifyBtn.clicked.connect(self.modifyData) self.delBtn.clicked.connect(self.delData) self.exitBtn.clicked.connect(Student_Manage_MainWindow.close) # 获取选中的单元格数据 self.tbStudent.itemClicked.connect(self.getItem) # 获取选中的表格内容 def getItem(self, item): if item.column() == 0: # 如果单击的是第一列 self.select = item.text() # 获取单击的单元格文本 #self.editNum.setText(self.select) # 显示在学生编号文本框中 # 根据学生编号查询