毕业设计基于JavaWeb的医院预约挂号系统

柔情只为你懂 2024-02-25 03:27 21阅读 0赞

> 项目介绍：后端采用Jsp+Servlet。前端使用的是Layui的一个网站模板。开发一个在线的医院预约挂号系统。从角色的划分，包括用户、医生、管理员。功能模块上包括了公告发布、医院信息查看、医院医生信息查看、预约医生、病例记录、挂号审核、图表统计等模块。

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

**摘要**

*随着医疗水平的提高，以及人们对于健康的观念越来越重视，出入医院成了一种常见的现象。而随着看病人数增多，经常出现挂号难的现象。一部分原因时号源有限，挂号人数多；另一方面是绝大多数人都选择线下取号。这就导致了医院当中排队的人数过多。本系统则是基于JavaWeb技术开发的Web应用程序。通过Eclipse进行编程开发。之后通过MySQL构建数据库表。由Tomcat运行访问。人们只需要在网上自行预约，在规定的时间内前往医院就诊，即可实现和线下医院预约取号一样的操作。而系统中的医生角色，则可以直接接受预约就诊的请求。之后在接诊的时候，为患者填写相关的病历单。传统的就诊方式则是纸质病历单，这难以保存，且文字显示不方便。而线上的病历单则可以快速查看数据，且永久保存在MySQL。线上预约就诊在很大程度上方便了人们看病。*

**系统功能结构图**

![49a6823e31e74921b422e50be19f078c.png][]

**目录**

00完整的程序目录

01管理员端功能介绍

1.0用户登录

1.1用户注册

1.2患者管理

1.3科室管理

1.4医生信息管理

1.5公告管理

1.6医院新闻发布

1.7医生挂号情况统计

02用户功能介绍

2.1 系统首页

2.2在线预约挂号

2.3医院信息介绍

2.4公告动态查看

2.5新闻通知

2.6预约记录管理

2.7个人资料修改

03医生端功能介绍

3.1门诊预约审核

3.2病例录入

3.3病例信息管理

04项目结构

Eclipse版本目录

Idea版本目录

05数据库设计

06系统演示

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

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

![0e0600ef92acda6be459bd2196def3e2.png][]

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

### **1.0用户登录** ###

![13cfdc73006d06276d055c2922bea3da.png][]

### 1.1用户注册 ###

![bd6bac28817022ee5eebc36809a0d227.png][]

### **1.2患者管理** ###

![1d89d961d0fc58e81a6205e2d3720253.png][]

### **1.3科室管理** ###

![190f08d0286ca44e686a174673bf0952.png][]

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

![ba834456acc3bc4a30355ac64bfcd452.png][]

### **1.5公告管理** ###

![7bef639e38a1418f7623020181222633.png][]

### **1.6医院新闻发布** ###

![e468776291b3e4859536f8acf25b2f02.png][]

### **1.7医生挂号情况统计** ###

![9bb9df402f9b0c6fed823a0a6584599b.png][]

## 02 **用户功能介绍** ##

### **2.1 系统首页** ###

![ff8d4e6577584a5f5c190231b1989ef9.png][]

### **2.2在线预约挂号** ###

![86a6caad68221fb8e8eaf591f8419b49.png][]

![ece89c847eabb7fcb9966507df02fd2e.png][]

### **2.3医院信息介绍** ###

![42deb6f33d15b281c9eb9b9d80f55b43.png][]

### **2.4公告动态查看** ###

![595cbf7e610f17aee5975d11d91c6043.png][]

### **2.5新闻通知** ###

![e55c037f21c47a762298c8ddcd63586f.png][]

### **2.6预约记录管理** ###

![1058569ad07c01e335b9495d5c992501.png][]

### 2.7个人资料修改 ###

![6ce3640a5d7506727ff662123de7ec95.png][]

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

### **3.1门诊预约审核** ###

![3193616612b5f4a4fb791de2b6589285.png][]

### **3.2病例录入** ###

![bbdb69b001cd8116b12611c7a42c8d7b.png][]

### **3.3病例信息管理** ###

![67264d06e3f10490e66a97a320da842c.png][]

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

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

![fb53733ce9c6d50ba86cee34a9cdfff5.png][]

### **Idea版本目录** ###

![3e08e237f761436f8787c9cd1a558375.png][]

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

![dc869bdac9d2bf015b7909acc543e859.png][]

## 06系统演示 ##

javaweb医院挂号系统（医院预约挂号系统毕业设计）

-- ----------------------------
    -- 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 board
    -- ----------------------------
    DROP TABLE IF EXISTS `board`;
    CREATE TABLE `board`  (
      `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,
      `fbrq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `fbr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `see_count` int(11) DEFAULT 0,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for dept
    -- ----------------------------
    DROP TABLE IF EXISTS `dept`;
    CREATE TABLE `dept`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `k_no` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `tp` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 3 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,
      `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `d_id` int(11) DEFAULT NULL,
      `job` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `tx` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `create_date` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for mzgh
    -- ----------------------------
    DROP TABLE IF EXISTS `mzgh`;
    CREATE TABLE `mzgh`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `u_id` int(11) DEFAULT NULL,
      `doctor_id` int(11) DEFAULT NULL,
      `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `yyrq` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `detail` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `create_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 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,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for news
    -- ----------------------------
    DROP TABLE IF EXISTS `news`;
    CREATE TABLE `news`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `content` text CHARACTER SET utf8 COLLATE utf8_general_ci,
      `fbsj` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `see_count` int(11) DEFAULT 0,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for record
    -- ----------------------------
    DROP TABLE IF EXISTS `record`;
    CREATE TABLE `record`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `cno` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `dname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `zdrq` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 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 user
    -- ----------------------------
    DROP TABLE IF EXISTS `user`;
    CREATE TABLE `user`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `phone` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `pwd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `birthady` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `cno` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `tx` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `create_date` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    SET FOREIGN_KEY_CHECKS = 1;

## 项目获取: ##

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

[49a6823e31e74921b422e50be19f078c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/c1b6910a30c94b5fa5cec9675ee3d246.png
[0e0600ef92acda6be459bd2196def3e2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/0fde6c6f3ac74e70ba87d818ab00b5eb.png
[13cfdc73006d06276d055c2922bea3da.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/34c45da0b4de427f8eca42ba39bad10c.png
[bd6bac28817022ee5eebc36809a0d227.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/6ea23e877bc143cb837423994bcf87d0.png
[1d89d961d0fc58e81a6205e2d3720253.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/47c63dbee8b044489bf1ece9adb87955.png
[190f08d0286ca44e686a174673bf0952.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/1547abaabfc34157935c24f566aec072.png
[ba834456acc3bc4a30355ac64bfcd452.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/56af0c481e8946d4b36b23c2ed6f7e69.png
[7bef639e38a1418f7623020181222633.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/344fe8d6a6f34448b46f3290b5740850.png
[e468776291b3e4859536f8acf25b2f02.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/bff964255f4944979787527d918f2542.png
[9bb9df402f9b0c6fed823a0a6584599b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/4a8fd1f6d18e4e25983d634408a44d08.png
[ff8d4e6577584a5f5c190231b1989ef9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/c7ccc15540884bc5848ab6cf82ce4128.png
[86a6caad68221fb8e8eaf591f8419b49.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/5280cb10b2534a1ca4ae06e6a42897ed.png
[ece89c847eabb7fcb9966507df02fd2e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/89a057e0188d40789cf1e97f21a34846.png
[42deb6f33d15b281c9eb9b9d80f55b43.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/dbaffbcd760e4aa8b549e4b6566f7d34.png
[595cbf7e610f17aee5975d11d91c6043.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/02bc637ce7014a5886691e10ffbbc6c3.png
[e55c037f21c47a762298c8ddcd63586f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/2053e09a8dba40708c26a540d0dcd93d.png
[1058569ad07c01e335b9495d5c992501.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/18be422a6a9f4772964ce6a5499c0d37.png
[6ce3640a5d7506727ff662123de7ec95.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/82d35cc698444323b8d06aa3f6953e30.png
[3193616612b5f4a4fb791de2b6589285.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/de56e5196a6d4f71a3c30e96a20d9f59.png
[bbdb69b001cd8116b12611c7a42c8d7b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/cd3c1167aaf340eeb0c09a2ddbb3fcd8.png
[67264d06e3f10490e66a97a320da842c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/241c1459b9174a7ba799c966d9cdb4b2.png
[fb53733ce9c6d50ba86cee34a9cdfff5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/59ee130afcd042b6a7c8d23fb2aaea25.png
[3e08e237f761436f8787c9cd1a558375.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/ac7189790dc74cbd99b94aa6b7b4f912.png
[dc869bdac9d2bf015b7909acc543e859.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/25/8d2ae548bf71418caec7bd4af1a86d7a.png
[https_gitee.com_sinonfin_L-javaWebSha_tree_master]: https://gitee.com/sinonfin/L-javaWebSha/tree/master