项目介绍：后端采用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完整的程序目录

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演示视频

-- ----------------------------
-- 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;