牙科诊所接诊与治疗管理系统（代码界面跳转、登录界面）

Back～～

已于 2024-07-13 21:01:03 修改

阅读量93

点赞数 1

分类专栏： Python学习文章标签：学习

于 2024-07-13 20:52:55 首次发布

本文链接：https://blog.csdn.net/m0_72827793/article/details/140406193

版权

Python学习专栏收录该内容

32 篇文章 0 订阅

订阅专栏

该系统采Python+PyQt5技术进行开发，使用MySQL数据库，具备直接通过cmd终端对数据库进行构建、编写，并且允许管理员对数据库用户进行授权操作，同时与其他编程语言具有很强的可集成性。
本文先对需求进行分析，详细介绍了数据库实现所进行的系统规划，系统分析流程，需求分析流程，系统概要设计，并介绍了系统的设计与实现。最后对系统进行总结。

控制界面跳转
import hashlib
import os
import sys

import pymysql
from PyQt5.QtWidgets import QApplication, QMainWindow

from Admin import *
from Doctor import *
from Login import *
from Servant import *

DATABASE = 'dentistry_db'
HOST = '127.0.0.1'




# 资源文件目录访问
def source_path(relative_path):
    # 是否Bundle Resource
    if getattr(sys, 'frozen', False):
        base_path = sys._MEIPASS
    else:
        base_path = os.path.abspath(".")
    return os.path.join(base_path, relative_path)
# 修改当前工作目录，使得资源文件可以被正确访问
cd = source_path('')
os.chdir(cd)





class LoginWindow(QMainWindow):
    def __init__(self):
        super().__init__()
        self.ui = Ui_LoginWindow()
        self.ui.setupUi(self)
        #界面优化设置
        self.setWindowFlag(QtCore.Qt.FramelessWindowHint)
        self.setAttribute(QtCore.Qt.WA_TranslucentBackground)
        self.shadow = QtWidgets.QGraphicsDropShadowEffect(self)
        self.shadow.setOffset(0, 0)
        self.shadow.setBlurRadius(10)
        self.shadow.setColor(QtCore.Qt.black)
        self.shadow.setBlurRadius(10)
        self.ui.frame.setGraphicsEffect(self.shadow)
        # 登录
        self.ui.pushButton_L_sure.clicked.connect(self.login)
        # 数据库连接
        # self.mysql = self.mysql_connection()
        # self.cursor = self.mysql.cursor()
        self.show()

    def mysql_connection(self, USER, PASSWORD):
        conn = pymysql.connect(
            host=HOST,  # 连接地址
            user=USER,  # 用户
            password=PASSWORD,  # 数据库密码,记得修改为自己本机的密码
            port=3306,  # 端口,默认为3306
            charset='utf8',  # 编码
            database=DATABASE,  # 选择数据库
            autocommit=True
        )
        return conn

    def login(self):
        password = self.ui.lineEdit_L_password.text()
        md5 = hashlib.md5()
        md5.update(password.encode('utf-8'))
        result = md5.hexdigest()
        print(result)
        acaccount_papassword_tuple = (self.ui.lineEdit_L_account.text(), result)
        print(acaccount_papassword_tuple)
        user_power = self.ui.comboBox.currentIndex()

        if user_power == 0:
            mysql = self.mysql_connection('servant', 'servant123456')
            cursor = mysql.cursor()
            cursor.execute('select * from user_s where account = %s and password = %s',(acaccount_papassword_tuple[0], acaccount_papassword_tuple[1]))
            result = cursor.fetchall()
            for row in result:
                if acaccount_papassword_tuple == (row[0], row[1]):
                    self.win = ServantWindow()
                    self.close()
        elif user_power == 1:
            mysql = self.mysql_connection('doctor', 'doctor123456')
            cursor = mysql.cursor()
            cursor.execute('select * from user_d where account = %s and password = %s',(acaccount_papassword_tuple[0], acaccount_papassword_tuple[1]))
            result = cursor.fetchall()
            for row in result:
                if acaccount_papassword_tuple == (row[0], row[1]):
                    self.win = DoctorWindow()
                    self.close()
        elif user_power == 2:
            mysql = self.mysql_connection('admin', 'admin123456')
            cursor = mysql.cursor()
            cursor.execute('select * from user_a where account = %s and password = %s',
                           (acaccount_papassword_tuple[0], acaccount_papassword_tuple[1]))
            result = cursor.fetchall()
            for row in result:
                if acaccount_papassword_tuple == (row[0], row[1]):
                    self.win = AdminWindow()
                    self.close()


class AdminWindow(QMainWindow):
    def __init__(self):
        super().__init__()
        self.ui = Ui_AdminWindow()
        self.ui.setupUi(self)
        # 界面优化设置
        self.setWindowFlag(QtCore.Qt.FramelessWindowHint)
        self.setAttribute(QtCore.Qt.WA_TranslucentBackground)
        # 功能跳转
        self.ui.pushButton_home.clicked.connect(lambda: self.ui.stackedWidget.setCurrentIndex(0))
        self.ui.pushButton_work.clicked.connect(self.go_work)
        self.ui.pushButton_enroll.clicked.connect(self.go_enroll)
        self.ui.pushButton_medicine.clicked.connect(self.go_medicine)
        self.ui.pushButton_pathient.clicked.connect(self.go_patient)
        self.ui.pushButton_servant.clicked.connect(self.go_servant)
        self.ui.pushButton_room.clicked.connect(self.go_room)
        self.ui.pushButton_cure.clicked.connect(self.go_cure)
        self.ui.pushButton_doctor.clicked.connect(self.go_doctor)
        self.ui.pushButton_information.clicked.connect(self.go_information)
        # 登出
        self.ui.pushButton_logout.clicked.connect(self.logout)
        self.show()

    def go_work(self):
        self.ui.stackedWidget.setCurrentIndex(1)

    def go_enroll(self):
           self.ui.stackedWidget.setCurrentIndex(9)

    def go_medicine(self):
        self.ui.stackedWidget.setCurrentIndex(2)

    def go_patient(self):
        self.ui.stackedWidget.setCurrentIndex(6)

    def go_servant(self):
        self.ui.stackedWidget.setCurrentIndex(5)

    def go_room(self):
        self.ui.stackedWidget.setCurrentIndex(3)

    def go_cure(self):
        self.ui.stackedWidget.setCurrentIndex(7)

    def go_doctor(self):
        self.ui.stackedWidget.setCurrentIndex(4)

    def go_information(self):
        self.ui.stackedWidget.setCurrentIndex(8)

    def logout(self):
        self.close()
        self.login = LoginWindow()


class DoctorWindow(QMainWindow):
    def __init__(self):
        super().__init__()
        self.ui = Ui_DoctorWindow()
        self.ui.setupUi(self)
        # 界面优化设置
        self.setWindowFlag(QtCore.Qt.FramelessWindowHint)
        self.setAttribute(QtCore.Qt.WA_TranslucentBackground)
        # 功能跳转
        self.ui.pushButton_D_home.clicked.connect(lambda: self.ui.stackedWidget.setCurrentIndex(0))
        self.ui.pushButton_D_work.clicked.connect(self.go_work)
        self.ui.pushButton_D_enroll.clicked.connect(self.go_enroll)
        self.ui.pushButton_D_cure.clicked.connect(self.go_cure)
        self.ui.pushButton_D_medicine.clicked.connect(self.go_medicine)
        self.ui.pushButton_D_patient.clicked.connect(self.go_patient)
        # 登出
        self.ui.pushButton_logout.clicked.connect(self.logout)
        self.show()

    def go_work(self):
        self.ui.stackedWidget.setCurrentIndex(1)

    def go_enroll(self):
        self.ui.stackedWidget.setCurrentIndex(5)

    def go_cure(self):
        self.ui.stackedWidget.setCurrentIndex(3)

    def go_medicine(self):
        self.ui.stackedWidget.setCurrentIndex(4)

    def go_patient(self):
        self.ui.stackedWidget.setCurrentIndex(2)

    def logout(self):
        self.close()
        self.login = LoginWindow()


class ServantWindow(QMainWindow):
    def __init__(self):
        super().__init__()
        self.ui = Ui_ServantWindow()
        self.ui.setupUi(self)
        # 界面优化设置
        self.setWindowFlag(QtCore.Qt.FramelessWindowHint)
        self.setAttribute(QtCore.Qt.WA_TranslucentBackground)
        #功能跳转
        self.ui.pushButton_S_home.clicked.connect(lambda :self.ui.stackedWidget.setCurrentIndex(0))
        self.ui.pushButton_S_work.clicked.connect(self.go_work)
        self.ui.pushButton_S_enroll.clicked.connect(self.go_enroll)
        # 登出
        self.ui.pushButton_logout.clicked.connect(self.logout)
        self.show()

    def go_work(self):
        self.ui.stackedWidget.setCurrentIndex(1)

    def go_enroll(self):
        self.ui.stackedWidget.setCurrentIndex(2)

    def logout(self):
        self.close()
        self.login = LoginWindow()


if __name__ == '__main__':
    app = QApplication(sys.argv)
    window = LoginWindow()
    sys.exit(app.exec_())

登录界面

# -*- coding: utf-8 -*-

# Form implementation generated from reading ui file 'f:\datasheji\牙科UI\牙科2\Login.ui'
#
# Created by: PyQt5 UI code generator 5.15.10
#
# 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.


from PyQt5 import QtCore, QtWidgets


class Ui_LoginWindow(object):
    def setupUi(self, LoginWindow):
        LoginWindow.setObjectName("LoginWindow")
        LoginWindow.resize(868, 645)
        self.centralwidget = QtWidgets.QWidget(LoginWindow)
        self.centralwidget.setObjectName("centralwidget")
        self.frame = QtWidgets.QFrame(self.centralwidget)
        self.frame.setGeometry(QtCore.QRect(0, 0, 401, 601))
        self.frame.setStyleSheet("#frame{\n"
"background-color: qlineargradient(spread:pad, x1:0.681592, y1:0.29, x2:1, y2:1, stop:0 rgba(0, 0, 255, 255), stop:1 rgba(0, 255, 87, 255));\n"
"border-radius:20px;\n"
"}")
        self.frame.setFrameShape(QtWidgets.QFrame.StyledPanel)
        self.frame.setFrameShadow(QtWidgets.QFrame.Raised)
        self.frame.setObjectName("frame")
        self.label = QtWidgets.QLabel(self.frame)
        self.label.setGeometry(QtCore.QRect(60, 70, 281, 111))
        self.label.setStyleSheet("color: rgb(255, 255, 255);\n"
"font: 20pt \"黑体\";")
        self.label.setObjectName("label")
        self.label_2 = QtWidgets.QLabel(self.frame)
        self.label_2.setGeometry(QtCore.QRect(130, 160, 141, 61))
        self.label_2.setStyleSheet("color: rgb(255, 255, 255);\n"
"font: 20pt \"黑体\";")
        self.label_2.setObjectName("label_2")
        self.frame_2 = QtWidgets.QFrame(self.centralwidget)
        self.frame_2.setGeometry(QtCore.QRect(400, 10, 401, 581))
        self.frame_2.setStyleSheet("#frame_2{\n"
"    background-color: rgb(255, 255, 255);\n"
"    border-top-right-radius:20px;\n"
"    border-bottom-right-radius:20px;\n"
"}")
        self.frame_2.setFrameShape(QtWidgets.QFrame.StyledPanel)
        self.frame_2.setFrameShadow(QtWidgets.QFrame.Raised)
        self.frame_2.setObjectName("frame_2")
        self.pushButton_L_exit = QtWidgets.QPushButton(self.frame_2)
        self.pushButton_L_exit.setGeometry(QtCore.QRect(350, 0, 61, 41))
        self.pushButton_L_exit.setStyleSheet("QPushButton{\n"
"    \n"
"    \n"
"    font: 75 10pt \"Arial\";\n"
"    border:none\n"
"}\n"
"QPushButton:hover{\n"
"    padding-bottom:5px;\n"
"    \n"
"}")
        self.pushButton_L_exit.setObjectName("pushButton_L_exit")
        self.frame_3 = QtWidgets.QFrame(self.frame_2)
        self.frame_3.setGeometry(QtCore.QRect(0, 40, 401, 531))
        self.frame_3.setMinimumSize(QtCore.QSize(401, 531))
        self.frame_3.setFrameShape(QtWidgets.QFrame.StyledPanel)
        self.frame_3.setFrameShadow(QtWidgets.QFrame.Raised)
        self.frame_3.setObjectName("frame_3")
        self.verticalLayout = QtWidgets.QVBoxLayout(self.frame_3)
        self.verticalLayout.setContentsMargins(0, 0, 0, 0)
        self.verticalLayout.setSpacing(0)
        self.verticalLayout.setObjectName("verticalLayout")
        self.frame_4 = QtWidgets.QFrame(self.frame_3)
        sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Expanding)
        sizePolicy.setHorizontalStretch(0)
        sizePolicy.setVerticalStretch(5)
        sizePolicy.setHeightForWidth(self.frame_4.sizePolicy().hasHeightForWidth())
        self.frame_4.setSizePolicy(sizePolicy)
        self.frame_4.setStyleSheet("QLineEdit{\n"
"    background-color: rgba(255, 255, 255, 0);\n"
"border:none;\n"
"border-bottom:1px solid black;\n"
"}\n"
"")
        self.frame_4.setFrameShape(QtWidgets.QFrame.StyledPanel)
        self.frame_4.setFrameShadow(QtWidgets.QFrame.Raised)
        self.frame_4.setObjectName("frame_4")
        self.verticalLayout_2 = QtWidgets.QVBoxLayout(self.frame_4)
        self.verticalLayout_2.setObjectName("verticalLayout_2")
        self.lineEdit_L_account = QtWidgets.QLineEdit(self.frame_4)
        self.lineEdit_L_account.setMinimumSize(QtCore.QSize(375, 24))
        self.lineEdit_L_account.setObjectName("lineEdit_L_account")
        self.verticalLayout_2.addWidget(self.lineEdit_L_account)
        self.lineEdit_L_password = QtWidgets.QLineEdit(self.frame_4)
        self.lineEdit_L_password.setMinimumSize(QtCore.QSize(375, 24))
        self.lineEdit_L_password.setEchoMode(QtWidgets.QLineEdit.Password)
        self.lineEdit_L_password.setObjectName("lineEdit_L_password")
        self.verticalLayout_2.addWidget(self.lineEdit_L_password)
        self.comboBox = QtWidgets.QComboBox(self.frame_4)
        self.comboBox.setObjectName("comboBox")
        self.comboBox.addItem("")
        self.comboBox.addItem("")
        self.comboBox.addItem("")
        self.verticalLayout_2.addWidget(self.comboBox)
        self.verticalLayout.addWidget(self.frame_4)
        self.frame_5 = QtWidgets.QFrame(self.frame_3)
        sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Expanding)
        sizePolicy.setHorizontalStretch(0)
        sizePolicy.setVerticalStretch(1)
        sizePolicy.setHeightForWidth(self.frame_5.sizePolicy().hasHeightForWidth())
        self.frame_5.setSizePolicy(sizePolicy)
        self.frame_5.setStyleSheet("QPushButton{\n"
"    border:none;\n"
"}\n"
"QPushButton:pressed{\n"
"    padding-top:5px;\n"
"    padding-left:5px;\n"
"}")
        self.frame_5.setFrameShape(QtWidgets.QFrame.StyledPanel)
        self.frame_5.setFrameShadow(QtWidgets.QFrame.Raised)
        self.frame_5.setObjectName("frame_5")
        self.horizontalLayout = QtWidgets.QHBoxLayout(self.frame_5)
        self.horizontalLayout.setObjectName("horizontalLayout")
        self.pushButton_L_sure = QtWidgets.QPushButton(self.frame_5)
        sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Minimum, QtWidgets.QSizePolicy.Expanding)
        sizePolicy.setHorizontalStretch(0)
        sizePolicy.setVerticalStretch(0)
        sizePolicy.setHeightForWidth(self.pushButton_L_sure.sizePolicy().hasHeightForWidth())
        self.pushButton_L_sure.setSizePolicy(sizePolicy)
        self.pushButton_L_sure.setStyleSheet("font: 15pt \"黑体\";\n"
"background-color: rgb(0, 0, 0);\n"
"color: rgb(255, 255, 255);\n"
"border-radius:7px")
        self.pushButton_L_sure.setObjectName("pushButton_L_sure")
        self.horizontalLayout.addWidget(self.pushButton_L_sure)
        self.verticalLayout.addWidget(self.frame_5)
        self.frame_2.raise_()
        self.frame.raise_()
        LoginWindow.setCentralWidget(self.centralwidget)

        self.retranslateUi(LoginWindow)
        self.pushButton_L_exit.clicked.connect(LoginWindow.close) # type: ignore
        QtCore.QMetaObject.connectSlotsByName(LoginWindow)

    def retranslateUi(self, LoginWindow):
        _translate = QtCore.QCoreApplication.translate
        LoginWindow.setWindowTitle(_translate("LoginWindow", "MainWindow"))
        self.label.setText(_translate("LoginWindow", "牙科诊所管理系统"))
        self.label_2.setText(_translate("LoginWindow", "登录界面"))
        self.pushButton_L_exit.setText(_translate("LoginWindow", "X"))
        self.lineEdit_L_account.setPlaceholderText(_translate("LoginWindow", "账号："))
        self.lineEdit_L_password.setPlaceholderText(_translate("LoginWindow", "密码："))
        self.comboBox.setItemText(0, _translate("LoginWindow", "导诊台"))
        self.comboBox.setItemText(1, _translate("LoginWindow", "医生"))
        self.comboBox.setItemText(2, _translate("LoginWindow", "管理员"))
        self.pushButton_L_sure.setText(_translate("LoginWindow", "登录"))

更多内容，我已经上传到我的资源那里了

Back～～

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
牙科诊所接诊与治疗管理系统（代码界面跳转、登录界面）

该系统采Python+PyQt5技术进行开发，使用MySQL数据库，具备直接通过cmd终端对数据库进行构建、编写，并且允许管理员对数据库用户进行授权操作，同时与其他编程语言具有很强的可集成性。本文先对需求进行分析，详细介绍了数据库实现所进行的系统规划，系统分析流程，需求分析流程，系统概要设计，并介绍了系统的设计与实现。最后对系统进行总结。
复制链接

扫一扫