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

矫情吗；* 2024-02-05 17:02 44阅读 0赞

> 项目类型：SSM源码
> 
> 用户类型：3个角色（管理员+普通用户+医生）
> 
> 主要技术：SSM+MySQL+Bootstrap
> 
> 开发工具：Eclipse/Idea均可使用，有两个不同的版本
> 
> 数据库：MySQL
> 
> 数据库表：7张
> 
> 项目介绍：后端采用SSM。前端使用的是Bootstrap的一个网站模板。通过3种角色使用。包括了核酸检测预约、普通门诊预约、挂号、接诊等多个不同的模块。

**目录**

00完整的程序目录

01管理员端功能介绍

1.0用户注册

1.1登录页面

1.2后台首页(展示预约信息和公告通知)

1.3患者信息管理

1.4科室信息管理

1.5医生信息管理

1.6核酸检测预约管理（需要填写行程信息）

1.7 公告通知

1.8 数据统计

02普通用户端功能介绍

2.1 个人信息维护

2.2个核酸检测预约

2.3在线门诊预约

2.4门诊预约记录（需要支付门诊费用）

03医生端功能介绍

3.1 在线审核接诊

3.2 个人中心

04项目结构

Eclipse版本目录

Idea版本目录

05数据库设计

演示视频

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

![f3b852ff1bc4292e9659163da821538d.jpeg][]

## 01 **管理员端功能介绍** ##

### **1.0用户注册** ###

![a2f87bf06cf6eda6ab952e8420ef8a4a.png][]

### **1.1登录页面** ###

![0284a4e60d182a944cccd3ffeb943567.png][]

### **1.2后台首页(展示预约信息和公告通知)** ###

![85d61fc579f58f8c38702c3a16451e3a.png][]

### **1.3患者信息管理** ###

![003052a2f6361edf44fcc415615c0314.png][]

### **1.4科室信息管理** ###

![5f30f5dab2c73f086ea268fec574b219.png][]

### **1.5医生信息管理** ###

![ca166df9de705c637c3bd6cb97aec1e3.png][]

### **1.6核酸检测预约管理（需要填写行程信息）** ###

![9bd756cd97b56e62f48284b0a35be167.png][]

### **1.7 公告通知** ###

![6acf9abee2a707ee72df07d3b7ed3ed3.png][]

### 1.8 数据统计 ###

![ba55aee6909b79dfa0ace52043ffa2f0.png][]

![595a3b18ecaaa445a0593b670a88491c.png][]

## 02 **普通用户端功能介绍** ##

### **2.1 个人信息维护** ###

![439861e5d1805376e60639e76fced6be.png][]

### **2.2个核酸检测预约** ###

![05562f14f86ce5c160fbea5bdfbcba39.png][]

### **2.3在线门诊预约** ###

![5cbf6760580671edbe728856c1a5034c.png][]

### **2.4门诊预约记录（需要支付门诊费用）** ###

![31c639043e08c7caeedb8162f67dd7d2.png][]

## 03 **医生端功能介绍** ##

### **3.1 在线审核接诊** ###

![dd90c828e0019f53897de11f1a5cbd1c.png][]

### **3.2 个人中心** ###

![d33c39822735cf1f4e1360a958d409c9.png][]

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

### **Eclipse版本目录** ###

![a2bd715529f125b772ce62a847e13f8d.png][]

### Idea版本目录 ###

![def80c6b953ae21aa896423c0518819b.png][]

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

![38230f7accb77cf7d82ad1e2da1eb833.png][]

## 演示视频 ##

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

-- ----------------------------
        -- Table structure for admin
        -- ----------------------------
        DROP TABLE IF EXISTS `admin`;
        CREATE TABLE `admin`  (
          `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 '密码',
          PRIMARY KEY (`id`) USING BTREE
        ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    
        
        
    
        -- ----------------------------
        -- Table structure for department
        -- ----------------------------
        DROP TABLE IF EXISTS `department`;
        CREATE TABLE `department`  (
          `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部门id',
          `dname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '部门名',
          `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '部门描述',
          PRIMARY KEY (`id`) USING BTREE
        ) ENGINE = InnoDB AUTO_INCREMENT = 6 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',
          `names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '医生姓名',
          `age` int(11) 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 '手机',
          `detail` 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 '图片',
          `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '添加时间',
          `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
          `dname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所在科室',
          `price` double(10, 2) DEFAULT 0.00 COMMENT '门诊费用',
          PRIMARY KEY (`id`) USING BTREE
        ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    
        
        
    
        -- ----------------------------
        -- Table structure for hsjc
        -- ----------------------------
        DROP TABLE IF EXISTS `hsjc`;
        CREATE TABLE `hsjc`  (
          `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '记录id',
          `uid` int(11) DEFAULT NULL COMMENT '患者id',
          `uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '患者姓名',
          `ismj` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否有密切接触行为',
          `isfr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否发热咳嗽',
          `isjzs` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否在风险地区停留',
          `from_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '来自哪里',
          `now_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '现居住地',
          `start_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '预约开始时间',
          `end_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '预约结束时间',
          `createtime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',
          `xcm` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行程码',
          `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '0预约成功待管理员审核  1 审核通过 2审核不通过',
          PRIMARY KEY (`id`) USING BTREE
        ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    
        
        
    
        -- ----------------------------
        -- Table structure for message
        -- ----------------------------
        DROP TABLE IF EXISTS `message`;
        CREATE TABLE `message`  (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
          `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
          `createtime` varchar(50) 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 records
        -- ----------------------------
        DROP TABLE IF EXISTS `records`;
        CREATE TABLE `records`  (
          `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '门诊记录id',
          `did` int(11) DEFAULT NULL,
          `uid` int(11) DEFAULT NULL,
          `uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
          `dname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
          `starttime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
          `endtime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
          `createtime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
          `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '0预约中待审批 1审批通过 2审批未通过',
          `iszf` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '0未支付 1已支付',
          PRIMARY KEY (`id`) USING BTREE
        ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    
        
    
        -- ----------------------------
        -- Table structure for user
        -- ----------------------------
        DROP TABLE IF EXISTS `user`;
        CREATE TABLE `user`  (
          `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 '密码',
          `realName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
          `idCard` 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 '手机号',
          `times` varchar(33) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '注册时间',
          `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
          `money` double(11, 2) DEFAULT 0.00 COMMENT '账户余额',
          PRIMARY KEY (`id`) USING BTREE
        ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

## 项目获取: ##

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

[f3b852ff1bc4292e9659163da821538d.jpeg]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/9812f0f582de4557a84f5dabcf5c6397.png
[a2f87bf06cf6eda6ab952e8420ef8a4a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/ac71909a3a6b4b449c7b4c6fbcd1a5cc.png
[0284a4e60d182a944cccd3ffeb943567.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/c03467ce4c2c43d4a6d33f7fdf70c7eb.png
[85d61fc579f58f8c38702c3a16451e3a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/8d532bf4375e4cef9abe38b6c843080a.png
[003052a2f6361edf44fcc415615c0314.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/db6f6da609774a0a83de2f1d1ce8b9e0.png
[5f30f5dab2c73f086ea268fec574b219.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/140fed029fa14e9b8351f207d10f23c2.png
[ca166df9de705c637c3bd6cb97aec1e3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/5f0903dd66be41fbab0a35eb3f1a2d73.png
[9bd756cd97b56e62f48284b0a35be167.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/ec7bf66247c644408dadc0d10f5abce5.png
[6acf9abee2a707ee72df07d3b7ed3ed3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/f3f49e6466cf47dd858d85c4a35f4afc.png
[ba55aee6909b79dfa0ace52043ffa2f0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/dae66697701c4c66a27847cb64d6f756.png
[595a3b18ecaaa445a0593b670a88491c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/42ede3a9d3e7421db4a0ca2f7e0729e5.png
[439861e5d1805376e60639e76fced6be.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/78be451f8edd4d45a6c52558e0850e0d.png
[05562f14f86ce5c160fbea5bdfbcba39.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/32bea1eb8d4742f286100ba32494965c.png
[5cbf6760580671edbe728856c1a5034c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/f6aec1997c7c4705a7a37e575afe3c91.png
[31c639043e08c7caeedb8162f67dd7d2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/1aaeb45340484e1bb68d0efb8192b68f.png
[dd90c828e0019f53897de11f1a5cbd1c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/4fad42809dec425092c2d87b9ee5bdd8.png
[d33c39822735cf1f4e1360a958d409c9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/bd433164e8d548dda83ae30ff1407088.png
[a2bd715529f125b772ce62a847e13f8d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/63ef19406c4f4690b85c4d909d1cafd4.png
[def80c6b953ae21aa896423c0518819b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/1428a34585ad4eeb9ba15fa31472352c.png
[38230f7accb77cf7d82ad1e2da1eb833.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/30/46bffd9d317a42eba5eb68020c9946c6.png
[https_gitee.com_sinonfin_L-javaWebSha_tree_master]: https://gitee.com/sinonfin/L-javaWebSha/tree/master