基于springboot+mybatis+mysql+html实现校园疫情防控管理系统
一、系统介绍
（1）管理员功能要求：首页、个人中心、用户管理（学生信息管理、教师信息管理）、通知公告管理、离校管理、健康打卡、核酸报告、疫情信息、系统管理、日志管理等功能模块。
（2）教师功能模块：个人信息、通知（通知公告、教职工通知、班级通知）、离校申请、核酸报告、疫情信息。
（3）学生功能模块：个人信息、通知（通知公告、班级通知）、离校申请、核酸报告、疫情信息。
二、采用技术及开发环境
1.开发技术
前端：HTML + CSS + JavaScript + Bootstrap + Jquery + Ajax
后端：springboot+mybatis-plus
2.开发环境
工具：IDEA
环境：JDK 1.8、Tomcat 8.0、Mysql 8.0
二、功能展示
1.登陆
2.首页（管理员）
3.个人信息
4.学生管理
5.教师管理
6.通知管理
7.离校管理
8.健康打卡
9.核酸报告管理
10.疫情信息
10.教师端
11.学生端
四、数据库
/*
Navicat MySQL Data Transfer
Source Server : test
Source Server Version : 80021
Source Host : localhost:3306
Source Database : campus_epidemic_management_system
Target Server Type : MYSQL
Target Server Version : 80021
File Encoding : 65001
Date: 2022-12-03 15:22:37
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `account`
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
`user_id` int NOT NULL AUTO_INCREMENT,
`user_pwd` varchar(250) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1017 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account
-- ----------------------------
INSERT INTO `account` VALUES ('1006', '$2a$10$g26ufe/FeoqRnq3Z4KisbuNmmqIi/VI28reVVcPp73LU3OwMoWbgi');
INSERT INTO `account` VALUES ('1009', '$2a$10$g5IY6BdDl/Swv3bpX/bey.EZvuN.XHl9IGFXIcjGUwcQTgHwxd6x2');
INSERT INTO `account` VALUES ('1012', '$2a$10$ZSFTMlk4fIj2vFyoufSlMOJX/ICyoXrqlqII4/hg5/GifXSjKjH76');
INSERT INTO `account` VALUES ('1013', '$2a$10$ZZ61fi7TvzNay01mwKdJceTvbwhYLmY14zxVKQpLj3sDEwyHZyCji');
INSERT INTO `account` VALUES ('1014', '$2a$10$TeFsgkmDr7vbM0GUz/Wi5e45Xr/G7gfmvRwZkBEFSmqwlzThVHrr2');
INSERT INTO `account` VALUES ('1016', '$2a$10$01EMTJw7StJYgIVMgIfmqOqH/VCX6GprqdY7fo1tiFQdZNMrA/J02');
-- ----------------------------
-- Table structure for `class_info`
-- ----------------------------
DROP TABLE IF EXISTS `class_info`;
CREATE TABLE `class_info` (
`class` varchar(20) NOT NULL,
`class_grade` varchar(20) NOT NULL,
`teacher_id` varchar(20) NOT NULL,
`class_major` varchar(20) NOT NULL,
`class_faculty` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of class_info
-- ----------------------------
INSERT INTO `class_info` VALUES ('软件1班', '2022级', '1009', '软件工程', '计算机科学与技术学院');
INSERT INTO `class_info` VALUES ('软件2班', '2022级', '1014', '软件工程', '计算机科学与技术学院');
-- ----------------------------
-- Table structure for `clock_state`
-- ----------------------------
DROP TABLE IF EXISTS `clock_state`;
CREATE TABLE `clock_state` (
`clock_id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
`user_name` varchar(20) NOT NULL,
`user_faculty` varchar(20) DEFAULT NULL,
`user_class` varchar(20) DEFAULT '无',
`clock_time` date NOT NULL,
`clock_time_type` varchar(20) NOT NULL,
`clock_area` varchar(20) NOT NULL,
`temperature` varchar(20) NOT NULL,
`cough` varchar(20) NOT NULL,
`fever` varchar(20) NOT NULL,
PRIMARY KEY (`clock_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clock_state
-- ----------------------------
INSERT INTO `clock_state` VALUES ('31', '1012', '张小明', '计算机科学与技术学院', '软件1班', '2022-11-27', '早上', '学校', '36.7', '无', '无');
INSERT INTO `clock_state` VALUES ('32', '1009', '王老师', '计算机科学与技术学院', '无', '2022-11-27', '早上', '学校', '36.7', '有', '无');
INSERT INTO `clock_state` VALUES ('33', '1012', '张小明', '计算机科学与技术学院', '软件1班', '2022-12-03', '中午', '学校', '36.7', '无', '无');
INSERT INTO `clock_state` VALUES ('34', '1014', '张老师', '计算机科学与技术学院', '无', '2022-12-03', '晚上', '学校', '36.7', '无', '无');
-- ----------------------------
-- Table structure for `c_data`
-- ----------------------------
DROP TABLE IF EXISTS `c_data`;
CREATE TABLE `c_data` (
`p_name` varchar(20) NOT NULL,
`c_name` varchar(20) NOT NULL,
`c_total_nowConfirm` varchar(20) NOT NULL,
`c_total_wzz` varchar(20) NOT NULL,
`c_total_confirm` varchar(20) NOT NULL,
`c_total_dead` varchar(20) NOT NULL,
`c_total_heal` varchar(20) NOT NULL,
`c_today_confirm` varchar(20) NOT NULL,
PRIMARY KEY (`c_name`,`p_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of c_data
-- ----------------------------
INSERT INTO `c_data` VALUES ('广东', '广州', '1000', '10000', '1000', '10000', '1000', '1000');
INSERT INTO `c_data` VALUES ('广东', '湛江', '100', '100', '100', '100', '100', '100');
-- ----------------------------
-- Table structure for `g_data`
-- ----------------------------
DROP TABLE IF EXISTS `g_data`;
CREATE TABLE `g_data` (
`g_id` varchar(20) NOT NULL,
`g_localConfirm` varchar(20) NOT NULL,
`g_nowConfirm` varchar(20) NOT NULL,
`g_confirm` varchar(20) NOT NULL,
`g_wzz` varchar(20) NOT NULL,
`g_importedCase` varchar(20) NOT NULL,
`g_dead` varchar(20) NOT NULL,
`g_localConfirm_add` varchar(20) NOT NULL,
`g_nowConfirm_add` varchar(20) NOT NULL,
`g_confirm_add` varchar(20) NOT NULL,
`g_wzz_add` varchar(20) NOT NULL,
`g_importedCase_add` varchar(20) NOT NULL,
`g_dead_add` varchar(20) NOT NULL,
PRIMARY KEY (`g_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of g_data
-- ----------------------------
INSERT INTO `g_data` VALUES ('1', '10000', '1000', '1000', '100', '1000', '1000', '1000', '100', '1000', '1000', '1000', '1000');
-- ----------------------------
-- Table structure for `leave_apply`
-- ----------------------------
DROP TABLE IF EXISTS `leave_apply`;
CREATE TABLE `leave_apply` (
`apply_id` int NOT NULL AUTO_INCREMENT,
`stu_id` int NOT NULL,
`stu_name` varchar(20) NOT NULL,
`stu_faculty` varchar(20) NOT NULL,
`stu_class` varchar(20) NOT NULL,
`reason` varchar(200) NOT NULL,
`travel` varchar(20) NOT NULL,
`leave_time` date NOT NULL,
`back_time` date NOT NULL,
`apply_state` varchar(20) NOT NULL DEFAULT '待审批',
PRIMARY KEY (`apply_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of leave_apply
-- ----------------------------
INSERT INTO `leave_apply` VALUES ('5', '1012', '张小明', '计算机科学与技术学院', '软件1班', '因个人原因', '深圳 ', '2022-11-27', '2022-11-30', '通过');
INSERT INTO `leave_apply` VALUES ('6', '1013', '李四', '计算机科学与技术学院', '软件1班', '回家一下', '深圳 ', '2022-12-03', '2022-12-29', '通过');
INSERT INTO `leave_apply` VALUES ('7', '1016', '王五', '计算机科学与技术学院', '软件1班', '外出买生活用品', '深圳 ', '2022-12-03', '2022-12-04', '通过');
INSERT INTO `leave_apply` VALUES ('8', '1012', '张小明', '计算机科学与技术学院', '软件1班', '出去走走', '深圳 ', '2022-12-03', '2022-12-10', '待审批');
-- ----------------------------
-- Table structure for `log`
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
`log_id` int NOT NULL AUTO_INCREMENT,
`log_operation` varchar(200) DEFAULT NULL,
`log_access_addr` varchar(200) DEFAULT NULL,
`log_access_path` varchar(200) DEFAULT NULL,
`log_ip` varchar(200) DEFAULT NULL,
`log_access_method` varchar(200) DEFAULT NULL,
`log_access_controller` varchar(200) DEFAULT NULL,
`log_access_time` datetime DEFAULT NULL,
`log_time_use` varchar(200) DEFAULT NULL,
`log_parameter` varchar(255) DEFAULT NULL,
PRIMARY KEY (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5268 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of log
-- ----------------------------
INSERT INTO `log` VALUES ('5260', 'selectPEpmcInfo', 'http://localhost:8080/epmc/select/c', '/epmc/select/c', '0:0:0:0:0:0:0:1', 'BaseResponse com.example.campus_system.controller.EpidemicInfoController.selectPEpmcInfo(String)', 'class com.example.campus_system.controller.EpidemicInfoController', '2022-12-03 15:19:16', '2', 'page=1&limit=10&p_name=广东');
INSERT INTO `log` VALUES ('5261', 'login', 'http://localhost:8080/login', '/login', '0:0:0:0:0:0:0:1', 'String com.example.campus_system.controller.LoginController.login()', 'class com.example.campus_system.controller.LoginController', '2022-12-03 15:20:10', '0', 'null');
INSERT INTO `log` VALUES ('5262', 'selectTeacherInfo', 'http://localhost:8080/psinfo/select/teacher', '/psinfo/select/teacher', '0:0:0:0:0:0:0:1', 'BaseResponse com.example.campus_system.controller.PersonalInfoController.selectTeacherInfo(Authentication)', 'class com.example.campus_system.controller.PersonalInfoController', '2022-12-03 15:20:30', '3', 'null');
INSERT INTO `log` VALUES ('5263', 'selectGuoEpmcInfo', 'http://localhost:8080/epmc/select/g', '/epmc/select/g', '0:0:0:0:0:0:0:1', 'BaseResponse com.example.campus_system.controller.EpidemicInfoController.selectGuoEpmcInfo()', 'class com.example.campus_system.controller.EpidemicInfoController', '2022-12-03 15:20:34', '3', 'null');
INSERT INTO `log` VALUES ('5264', 'selectPEpmcInfo', 'http://localhost:8080/epmc/select/p', '/epmc/select/p', '0:0:0:0:0:0:0:1', 'BaseResponse com.example.campus_system.controller.EpidemicInfoController.selectPEpmcInfo()', 'class com.example.campus_system.controller.EpidemicInfoController', '2022-12-03 15:20:34', '2', 'page=1&limit=10');
INSERT INTO `log` VALUES ('5265', 'login', 'http://localhost:8080/login', '/login', '0:0:0:0:0:0:0:1', 'String com.example.campus_system.controller.LoginController.login()', 'class com.example.campus_system.controller.LoginController', '2022-12-03 15:21:51', '0', 'null');
INSERT INTO `log` VALUES ('5266', 'selectGuoEpmcInfo', 'http://localhost:8080/epmc/select/g', '/epmc/select/g', '0:0:0:0:0:0:0:1', 'BaseResponse com.example.campus_system.controller.EpidemicInfoController.selectGuoEpmcInfo()', 'class com.example.campus_system.controller.EpidemicInfoController', '2022-12-03 15:22:08', '1', 'null');
INSERT INTO `log` VALUES ('5267', 'selectPEpmcInfo', 'http://localhost:8080/epmc/select/p', '/epmc/select/p', '0:0:0:0:0:0:0:1', 'BaseResponse com.example.campus_system.controller.EpidemicInfoController.selectPEpmcInfo()', 'class com.example.campus_system.controller.EpidemicInfoController', '2022-12-03 15:22:08', '3', 'page=1&limit=10');
-- ----------------------------
-- Table structure for `notice`
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
`notice_id` int NOT NULL AUTO_INCREMENT,
`notice_title` varchar(200) NOT NULL,
`notice_content` varchar(200) NOT NULL,
`notice_user` varchar(20) NOT NULL,
`notice_type` varchar(20) NOT NULL,
`notice_state` varchar(20) NOT NULL DEFAULT '待审批',
`notice_time` date NOT NULL,
`notice_class` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`notice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES ('27', '疫情防控，人人有责任', '疫情区间，大家在宿舍，不要外出。', 'master', '通知公告', '通过', '2022-11-26', '疫情区间，大家在宿舍，不要外出。');
INSERT INTO `notice` VALUES ('28', '因疫情原因，改为线上上课', '因疫情原因，改为线上上课', 'master', '班级通知', '通过', '2022-11-27', '软件1班');
INSERT INTO `notice` VALUES ('29', '因疫情原因，改为线上上课', '因疫情原因，改为线上上课', 'master', '通知公告', '通过', '2022-12-03', '因疫情原因，改为线上上课');
INSERT INTO `notice` VALUES ('30', '假期疫情防控通知', '假期疫情防控通知，请大家尽量呆家中，不要外出。', 'master', '通知公告', '通过', '2022-12-03', '假期疫情防控通知，请大家尽量呆家中，不要外出。');
-- ----------------------------
-- Table structure for `p_data`
-- ----------------------------
DROP TABLE IF EXISTS `p_data`;
CREATE TABLE `p_data` (
`p_name` varchar(20) NOT NULL,
`p_total_nowConfirm` varchar(20) NOT NULL,
`p_total_wzz` varchar(20) NOT NULL,
`p_total_confirm` varchar(20) NOT NULL,
`p_total_dead` varchar(20) NOT NULL,
`p_total_heal` varchar(20) NOT NULL,
`p_today_confirm` varchar(20) NOT NULL,
`p_today_wzz_add` varchar(20) NOT NULL,
PRIMARY KEY (`p_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of p_data
-- ----------------------------
INSERT INTO `p_data` VALUES ('广东', '1000', '100', '200000', '100', '100', '8702', '1000000');
-- ----------------------------
-- Table structure for `report`
-- ----------------------------
DROP TABLE IF EXISTS `report`;
CREATE TABLE `report` (
`stu_id` int NOT NULL,
`stu_name` varchar(20) NOT NULL,
`stu_faculty` varchar(20) NOT NULL,
`stu_class` varchar(20) NOT NULL,
`test_report` varchar(200) DEFAULT NULL,
`report_time` date DEFAULT NULL,
PRIMARY KEY (`stu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of report
-- ----------------------------
INSERT INTO `report` VALUES ('1012', '张小明', '计算机科学与技术学院', '软件1班', 'http://localhost:8080/campus_system/file/report/1669515145552cat.jpg', '2022-11-27');
INSERT INTO `report` VALUES ('1013', '李四', '计算机科学与技术学院', '软件1班', 'http://localhost:8080/campus_system/file/report/1670044248618.png', '2022-12-03');
INSERT INTO `report` VALUES ('1016', '王五', '计算机科学与技术学院', '软件1班', null, null);
-- ----------------------------
-- Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`role_id` int NOT NULL,
`role_name` varchar(20) NOT NULL,
`role_cname` varchar(20) NOT NULL,
`role_describe` varchar(20) NOT NULL,
PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', 'admin', '管理员', 'admin');
INSERT INTO `role` VALUES ('2', 'teacher', '教师', 'teacher');
INSERT INTO `role` VALUES ('3', 'student', '学生', 'student');
-- ----------------------------
-- Table structure for `stu_info`
-- ----------------------------
DROP TABLE IF EXISTS `stu_info`;
CREATE TABLE `stu_info` (
`stu_id` int NOT NULL,
`stu_name` varchar(20) NOT NULL,
`stu_photo` varchar(200) DEFAULT NULL,
`stu_sex` varchar(2) NOT NULL,
`stu_age` varchar(20) NOT NULL,
`stu_address` varchar(20) NOT NULL,
`stu_birth` date NOT NULL,
`stu_phone` varchar(20) NOT NULL,
`stu_email` varchar(20) NOT NULL,
`stu_faculty` varchar(20) NOT NULL,
`stu_major` varchar(20) NOT NULL,
`stu_class` varchar(20) NOT NULL,
`stu_time` date NOT NULL,
`stu_password` varchar(20) NOT NULL DEFAULT '888',
PRIMARY KEY (`stu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of stu_info
-- ----------------------------
INSERT INTO `stu_info` VALUES ('1012', '张小明', 'http://localhost:8080/campus_system/file/student/1669515087941dog2.jpg', '女', '20', '广东深圳', '2022-11-27', '13726892226', '123@qq.com', '计算机科学与技术学院', '软件工程', '软件1班', '2022-11-27', '888');
INSERT INTO `stu_info` VALUES ('1013', '李四', null, '男', '20', '广东深圳', '2022-11-27', '10086', '', '计算机科学与技术学院', '软件工程', '软件1班', '2022-11-27', '888');
INSERT INTO `stu_info` VALUES ('1016', '王五', null, '男', '20', '广东深圳', '2000-12-03', '10086', '123@qq.com', '计算机科学与技术学院', '软件工程', '软件1班', '2022-12-03', '888');
-- ----------------------------
-- Table structure for `teacher`
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
`teacher_id` int NOT NULL AUTO_INCREMENT,
`teacher_name` varchar(20) NOT NULL,
`teacher_age` varchar(20) NOT NULL,
`teacher_photo` varchar(200) DEFAULT NULL,
`teacher_address` varchar(200) NOT NULL,
`teacher_birth` date NOT NULL,
`teacher_sex` varchar(2) NOT NULL,
`teacher_phone` varchar(20) NOT NULL,
`teacher_email` varchar(20) NOT NULL,
`teacher_faculty` varchar(20) NOT NULL,
`teacher_password` varchar(20) NOT NULL DEFAULT '888',
PRIMARY KEY (`teacher_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1015 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES ('1006', '张三', '50', null, '深圳大学', '2022-11-27', '男', '13726892228', '', '计算机科学与技术学院', '888');
INSERT INTO `teacher` VALUES ('1009', '王老师', '40', null, '深圳大学', '2022-11-27', '女', '13726892229', '', '计算机科学与技术学院', '888');
INSERT INTO `teacher` VALUES ('1014', '张老师', '40', null, '深圳大学', '2022-11-27', '女', '13726892229', '', '计算机科学与技术学院', '888');
-- ----------------------------
-- Table structure for `user_role`
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
`user_id` int NOT NULL,
`role_id` int NOT NULL,
KEY `role_id` (`role_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `role_id` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`),
CONSTRAINT `user_id` FOREIGN KEY (`user_id`) REFERENCES `account` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user_role
-- ----------------------------
INSERT INTO `user_role` VALUES ('1006', '1');
INSERT INTO `user_role` VALUES ('1009', '2');
INSERT INTO `user_role` VALUES ('1012', '3');
INSERT INTO `user_role` VALUES ('1013', '3');
INSERT INTO `user_role` VALUES ('1014', '2');
INSERT INTO `user_role` VALUES ('1016', '3');
1769
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
