毕业设计基于JavaWeb的社区疫情防控管理系统

小鱼儿 2024-02-23 07:14 9阅读 0赞

> 项目介绍：后端采用Jsp+Servlet。前端使用的是Bootstrap的一个网站模板。开发一个在线的社区疫情防控管理系统。从角色的划分，包括用户、社管员、管理员。功能模块上包括了社区公告发布、高风险地区记录、地区感染信息管理、社区出入登记管理、行程信息管理、疫情隔离管理。等模块

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

**目录**

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个人资料修改

03用户端功能介绍

3.1行程信息填写

3.2高风险地区查看

3.3地区感染信息查询

04项目结构

Eclipse版本目录

Idea版本目录

05数据库设计

06演示视频

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

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

![5d043af825b48fee389acd7b7d3069b9.png][]

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

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

![4b075496db01d40ecafec98d59281a72.png][]

### 1.1用户注册 ###

![3d37bbeda2ddb1f7b73ecdc52816fe9f.png][]

### **1.2系统首页（包括每天进出社区的次数统计、隔离人员情况）** ###

![83571509609c2c82bae665c2044a5d30.png][]

### **1.3用户管理** ###

![52bc500fb75436e708f72ef05abfb17b.png][]

### **1.4社管员管理** ###

![9b800d4755f321c0d79ab8f30c8e5b6e.png][]

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

![f1343a5233a17ce363cbfee8eb49f40b.png][]

### **1.6地区疫情情况管理** ###

![db5734291366d756c9075862875873ed.png][]

![6e01fad814f301598096c7ae9c5c3518.png][]

### **1.7隔离情况管理** ###

![b10dd56c9876c7f908f1874a4d02e343.png][]

### **1.8隔离人员管理** ###

![5597a3714bce6be1f4b6c817e0a854dc.png][]

## 02 **社管端功能介绍** ##

### **2.1 风险地区录入** ###

![b5e1708a2ecbba35e49d96c8857609c0.png][]

### **2.2出入登记** ###

![6cdb4867988518551224f1b9ac551f7b.png][]

### **2.3个人资料修改** ###

![e50e743a4229d6154bef2c3ae00dbc8d.png][]

## 03 **用户端功能介绍** ##

### **3.1行程信息填写** ###

![fbab25667a01bea0071760fd55bcc2fb.png][]

### **3.2高风险地区查看** ###

![7776f623b82a7110326957383df90782.png][]

### **3.3地区感染信息查询** ###

![6d014c9f39c1a3f0f5dfc3e30d21d1f5.png][]

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

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

![3c3b5e141ffbc01be6723f2862ababa0.png][]

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

![6911433a937040259bb440d251c3876d.png][]

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

![cc66548622ba6e602934f2689cdf20a1.png][]

## 06演示视频 ##

javaweb疫情防控系统（毕业设计）

-- ----------------------------
    -- Table structure for admin
    -- ----------------------------
    DROP TABLE IF EXISTS `admin`;
    CREATE TABLE `admin`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
      `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
      `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '账号',
      `pwd` 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 area
    -- ----------------------------
    DROP TABLE IF EXISTS `area`;
    CREATE TABLE `area`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `level` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `ctime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for crdj
    -- ----------------------------
    DROP TABLE IF EXISTS `crdj`;
    CREATE TABLE `crdj`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `mname` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `dno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `ctime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `tiwen` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for glry
    -- ----------------------------
    DROP TABLE IF EXISTS `glry`;
    CREATE TABLE `glry`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `cno` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `tx` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `status` int(255) DEFAULT NULL COMMENT '0阳性 1阴性',
      `condation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `spot` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `days` int(255) DEFAULT NULL,
      `ctime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `uid` int(11) DEFAULT NULL,
      `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `userstatus` int(255) DEFAULT NULL COMMENT '隔离状态，0已经隔离，1未隔离',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for gonggao
    -- ----------------------------
    DROP TABLE IF EXISTS `gonggao`;
    CREATE TABLE `gonggao`  (
      `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,
      `ctime` 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 grab
    -- ----------------------------
    DROP TABLE IF EXISTS `grab`;
    CREATE TABLE `grab`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `a_id` int(11) DEFAULT NULL,
      `amount` int(255) DEFAULT NULL,
      `die_amount` int(255) DEFAULT NULL,
      `zy_amount` int(255) DEFAULT NULL,
      `ctime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `aname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `address` varchar(255) 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;
    
    -- ----------------------------
    -- Table structure for manager
    -- ----------------------------
    DROP TABLE IF EXISTS `manager`;
    CREATE TABLE `manager`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `eno` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
      `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `tx` 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 trip
    -- ----------------------------
    DROP TABLE IF EXISTS `trip`;
    CREATE TABLE `trip`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `u_id` int(11) NOT NULL,
      `uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `city1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `city2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `state1` int(255) DEFAULT NULL,
      `state2` int(255) DEFAULT NULL,
      `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `ctime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `userstatus` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '1未隔离，0是已隔离',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 32 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',
      `realname` 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 '手机号',
      `tx` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
      `register_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `cno` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `status` int(255) DEFAULT NULL COMMENT '1红码',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 10 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]

[5d043af825b48fee389acd7b7d3069b9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/e43393dac7dd4a3fbe6f21307cab8bf8.png
[4b075496db01d40ecafec98d59281a72.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/f1f7fb8b8a79429c91f4c9bed1e15a5b.png
[3d37bbeda2ddb1f7b73ecdc52816fe9f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/2f9062dfa07244fe81b8641b06c24df1.png
[83571509609c2c82bae665c2044a5d30.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/954fde27520743449046cf16df582960.png
[52bc500fb75436e708f72ef05abfb17b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/2ff6e654a99848c291c098ba833f0625.png
[9b800d4755f321c0d79ab8f30c8e5b6e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/d8e747d89640428da08da8ef9f96cf23.png
[f1343a5233a17ce363cbfee8eb49f40b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/904af120c1704639ac6a8ca4954c964f.png
[db5734291366d756c9075862875873ed.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/91bba76300a54d3b838942da4aba7112.png
[6e01fad814f301598096c7ae9c5c3518.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/dc1614df222e41a99103d14686f68afb.png
[b10dd56c9876c7f908f1874a4d02e343.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/df6245fb2492412081d449adb359c6e3.png
[5597a3714bce6be1f4b6c817e0a854dc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/882461aa80f7418e9a4e35e0c75503ac.png
[b5e1708a2ecbba35e49d96c8857609c0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/c5e925400510441dad3b412c8e84e6cf.png
[6cdb4867988518551224f1b9ac551f7b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/ad3725afda614de0abfb11fb49dc5941.png
[e50e743a4229d6154bef2c3ae00dbc8d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/98ecf2609f33483e8e3d90e3a3f2b194.png
[fbab25667a01bea0071760fd55bcc2fb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/7eb3015522df47c281870b1e1a77b7de.png
[7776f623b82a7110326957383df90782.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/e359c2ce73564004b1c638b70a7d2c79.png
[6d014c9f39c1a3f0f5dfc3e30d21d1f5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/1425416ca0894b97bb25be7e3b317246.png
[3c3b5e141ffbc01be6723f2862ababa0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/9e1cd3a7a5c84db3b2bf364675035a7a.png
[6911433a937040259bb440d251c3876d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/830daa7841064f01bd4f807120d7dd68.png
[cc66548622ba6e602934f2689cdf20a1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/23/279fecc7edd949d4abe1c4303aa8f67c.png
[https_gitee.com_sinonfin_L-javaWebSha_tree_master]: https://gitee.com/sinonfin/L-javaWebSha/tree/master