计算机java项目推荐基于SSM的医院预约挂号系统_2

秒速五厘米 2024-02-05 17:03 18阅读 0赞

> **项目介绍**  
> ：系统设计3个使用角色：管理员、用户、医生。基础的功能模块包括医生排班、在线预约挂号、缴费、病历查询、配药查看等。与其他的信息管理系统相比，该系统拥有更多的特别功能，比如科室筛选医生、病历查询等，用户在线上预约，不需要现场排队挂号等待，这样可以使病人合理安排来医院检查的时间。并且病人可以在线上直接查到自己的检查报告等信息。

> 项目类型：SSM源码
> 
> 用户类型：3个角色（管理员+医生+用户）
> 
> 主要技术：SSM+MySQL+Jquery
> 
> 开发工具：Eclipse/Idea均可使用，有两个不同的版本
> 
> 数据库：MySQL
> 
> 数据库表：12张

**目录**

00完整的程序目录

01管理员端

1.0系统登录

1.1后台首页

1.2数据统计模块

1.3用户管理模块

1.4医生管理模块

1.5科室管理模块

1.6通知管理模块

1.7排班管理模块

1.8添加医生排班

1.9药品管理模块

1.10医生请假管理模块

02用户端

2.1 挂号查询

2.2挂号管理

2.3病历管理

2.4配药查询

03医生端

3.1挂号受理

3.2 病历录入

3.3病历管理

3.4药品分配

3.5请假申请

04项目结构

05数据库设计

06演示视频

--------------------

## 00 **完整的程序目录** ##

![8228786ed892ad9fb12d12dd91830b27.png][]

## 01 **管理员端** ##

### **1.0系统登录** ###

![552842744185a7da142af9ddfe2401f8.png][]

### 1.1后台首页 ###

![dfe9792f5519e28c6fa98a9994a103fc.png][]

### **1.2数据统计模块** ###

![3a0e7c0cdc684e0fd03e770963b207ea.png][]

### **1.3用户管理模块** ###

![cffd40ca213a5b5dbf61eae5aef8fdcd.png][]

### **1.4医生管理模块** ###

![e0a017d5e1a3c8f94c5e29c87e174d68.png][]

### **1.5科室管理模块** ###

![5cd430c22c987b1bedffb1295b953b1c.png][]

### **1.6通知管理模块** ###

![c02cd585c3818feba796dbdce75c98fa.png][]

### **1.7排班管理模块** ###

![bcaf6511cdd00b8c5de3b22936051ebb.png][]

### **1.8添加医生排班** ###

![4d9b3eba2ae42a36d4b2fad1726a1306.png][]

### **1.9药品管理模块** ###

![03b65d41ce4232cc21860fc427d784b9.png][]

### **1.10医生请假管理模块** ###

![71369252a0243b13517952815cbb02a6.png][]

## 02 **用户端** ##

### **2.1 挂号查询** ###

![637ca7893d0b3a2320fd1af571390eed.png][]

### **2.2挂号管理** ###

![debce24d37d3acfe0287fb0fd50ae484.png][]

### **2.3病历管理** ###

![b01286f8b4cdfafed4e9e8d9c58a206c.png][]

### **2.4配药查询** ###

![549cc4ad94fbaf64cf6a7b392461f380.png][]

## 03 **医生端** ##

### **3.1挂号受理** ###

![bd19047ec52d1e8ab186157840ceff70.png][]

### **3.2 病历录入** ###

![bb67674c62b00ae2122e7ad232d7183c.png][]

### **3.3病历管理** ###

![27f1551d8cfa1481a86f80e39e3d7b4b.png][]

### **3.4药品分配** ###

![8f75deee6934c34fe41a970a688089bb.png][]

### **3.5请假申请** ###

![940aa183adb9b4871f71cddf31cd0ce4.png][]

## 04 **项目结构** ##

![850a5256dfc1e120cb0dcdb2e3da4233.png][]

## 05 **数据库设计** ##

![f5c6f8029a0bc35ec6ce063d0a91f5c0.png][]

## 06演示视频 ##

【原创】ssm医院预约挂号系统（毕设源代码）

SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for admin
    -- ----------------------------
    DROP TABLE IF EXISTS `admin`;
    CREATE TABLE `admin`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for bingli
    -- ----------------------------
    DROP TABLE IF EXISTS `bingli`;
    CREATE TABLE `bingli`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '病历id',
      `uid` int(11) DEFAULT NULL COMMENT '用户id',
      `did` int(11) DEFAULT NULL COMMENT '医生id',
      `ctime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',
      `describes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '病情描述',
      `result` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '诊断结果',
      `treat` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '治疗意见',
      `rid` int(11) DEFAULT NULL COMMENT '门诊预约id',
      `rno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '病历单号',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for classes
    -- ----------------------------
    DROP TABLE IF EXISTS `classes`;
    CREATE TABLE `classes`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `collegeid` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for college
    -- ----------------------------
    DROP TABLE IF EXISTS `college`;
    CREATE TABLE `college`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for doctor
    -- ----------------------------
    DROP TABLE IF EXISTS `doctor`;
    CREATE TABLE `doctor`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '医生id',
      `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
      `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
      `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
      `times` varchar(33) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',
      `job` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '职位',
      `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
      `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机',
      `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
      `cid` int(11) DEFAULT NULL COMMENT '主科室',
      `userno` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '编号',
      `classesid` int(11) DEFAULT NULL COMMENT '子

## 项目获取: ##

[https://gitee.com/sinonfin/L-javaWebSha/tree/master][https_gitee.com_sinonfin_L-javaWebSha_tree_master]

[8228786ed892ad9fb12d12dd91830b27.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/64256a944aae4b0bb6b11fbde86b159f.png
[552842744185a7da142af9ddfe2401f8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/b82a1dcce05243c3b56b965780ca0073.png
[dfe9792f5519e28c6fa98a9994a103fc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/655385b3aac746b4be384c428737e294.png
[3a0e7c0cdc684e0fd03e770963b207ea.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/764d60d0e52242358cdeae13a9efb052.png
[cffd40ca213a5b5dbf61eae5aef8fdcd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/224ddab65859488f94c6af3ee5e65751.png
[e0a017d5e1a3c8f94c5e29c87e174d68.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/fc1cc3c10bcf4ea3b91d97e5472c0f2c.png
[5cd430c22c987b1bedffb1295b953b1c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/7aa273936f92494dbd8a46db4af179dd.png
[c02cd585c3818feba796dbdce75c98fa.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/23e7c6699a0b40f997aa7ff71391a28c.png
[bcaf6511cdd00b8c5de3b22936051ebb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/983b651440414fabadbe8b7e1c916975.png
[4d9b3eba2ae42a36d4b2fad1726a1306.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/92e3357dcfee4558b51546ab68da1254.png
[03b65d41ce4232cc21860fc427d784b9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/81f428e03d974b2fa8cd3eb44ccae6d8.png
[71369252a0243b13517952815cbb02a6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/ac0c78d1602b4ab5afbd3fa83706a91a.png
[637ca7893d0b3a2320fd1af571390eed.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/c68093f1132747febb848435460f2dfc.png
[debce24d37d3acfe0287fb0fd50ae484.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/93724af61693447490f6baa088bbd2bb.png
[b01286f8b4cdfafed4e9e8d9c58a206c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/cd21c56105d943cf94ae5f1f0ecc538c.png
[549cc4ad94fbaf64cf6a7b392461f380.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/f15d0b910b574fada530e658a4f784be.png
[bd19047ec52d1e8ab186157840ceff70.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/8b1bf9be740a4f76a189a9c7c675f32f.png
[bb67674c62b00ae2122e7ad232d7183c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/bde20cc88a5c43cc900540e48d09af77.png
[27f1551d8cfa1481a86f80e39e3d7b4b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/ebfa785d290443ae8142ca4afe4ba5ea.png
[8f75deee6934c34fe41a970a688089bb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/2aae19a60b3c492284f954c909f3ef4d.png
[940aa183adb9b4871f71cddf31cd0ce4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/88988fd1a3764a11a63bd9290f9df569.png
[850a5256dfc1e120cb0dcdb2e3da4233.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/3e94f001a57843bf8c786aad3e49dcb4.png
[f5c6f8029a0bc35ec6ce063d0a91f5c0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/739e28f7d837499d98af7c9bf26d0af4.png
[https_gitee.com_sinonfin_L-javaWebSha_tree_master]: https://gitee.com/sinonfin/L-javaWebSha/tree/master