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

  • 开发
  • 20

该系统采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", "登录"))

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

阅读全部

相关推荐

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

    2024-07-14 06:38:02       21 阅读

  6. android跳转到系统设置wifi界面

    2024-07-14 06:38:02       31 阅读

最近更新

  3. docker php8.1+nginx base 镜像 dockerfile 配置

    2024-07-14 06:38:02       67 阅读

  4. Could not load dynamic library ‘cudart64_100.dll‘

    2024-07-14 06:38:02       72 阅读

  9. 在Django里面运行非项目文件

    2024-07-14 06:38:02       58 阅读

  19. Python语言-面向对象

    2024-07-14 06:38:02       69 阅读

  20. 如何分清楚常见的 Git 分支管理策略Git Flow、GitHub Flow 和 GitLab Flow

    2024-07-14 06:38:02       64 阅读

热门阅读

  1. git 创建分支--命令行

    2024-07-14 06:38:02       22 阅读

  7. k8s中kubesphere开启devops总是报错解决

    2024-07-14 06:38:02       24 阅读

  10. 酒店房间登记与计费管理系统（c++）

    2024-07-14 06:38:02       20 阅读

  11. golang监控公网IP变化自动同步dns解析

    2024-07-14 06:38:02       28 阅读

  15. Unity脚步.txt

    2024-07-14 06:38:02       25 阅读

  16. React Native Android 应用开发、调试与发布深度指南

    2024-07-14 06:38:02       28 阅读

  18. 方差是什么？

    2024-07-14 06:38:02       20 阅读

  19. 【jvm】字符串常量池问题

    2024-07-14 06:38:02       25 阅读

  20. 基于STM32的无人机控制系统：硬件选择与软件实现

    2024-07-14 06:38:02       22 阅读

  24. 金融业务系统云原生技术转型：从传统架构到云原生的跨越

    2024-07-14 06:38:02       25 阅读

  25. VECTOR,ARRAYLIST, LINKEDLIST的区别是什么？

    2024-07-14 06:38:02       27 阅读

  26. 在 MATLAB 中，如何高效地处理大规模矩阵运算以提高程序的运行速度？

    2024-07-14 06:38:02       24 阅读