1500字范文 > JAVA基于JSP的疫情学生宿舍管理系统【数据库设计论文源码开题报告】

JAVA基于JSP的疫情学生宿舍管理系统【数据库设计论文源码开题报告】

时间：2022-12-15 10:16:56

主要使用技术

Servlet+layui+JSP+CSS+JS+Mysql

数据库脚本

/*SQLyog Ultimate v13.1.1 (64 bit)MySQL - 5.5.40 : Database - sdms**********************************************************************//*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE=''*/;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;CREATE DATABASE /*!32312 IF NOT EXISTS*/`sdms` /*!40100 DEFAULT CHARACTER SET utf8 */;USE `sdms`;/*Table structure for table `bulletin` */DROP TABLE IF EXISTS `bulletin`;CREATE TABLE `bulletin` (`bulletin_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '通告ID',`bulletin_title` varchar(255) DEFAULT NULL COMMENT '通告标题',`bulletin_img` varchar(255) DEFAULT NULL COMMENT '通告配图',`bulletin_content` varchar(4000) DEFAULT NULL COMMENT '通告内容',`read_count` int(11) DEFAULT NULL COMMENT '阅读数',`publisher` int(11) DEFAULT NULL COMMENT '发布者（对应用户表）',`gmt_create` bigint(20) DEFAULT NULL COMMENT '创建时间',`gmt_modify` bigint(20) DEFAULT NULL COMMENT '修修改时间',PRIMARY KEY (`bulletin_id`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='通告表';/*Data for the table `bulletin` */insert into `bulletin`(`bulletin_id`,`bulletin_title`,`bulletin_img`,`bulletin_content`,`read_count`,`publisher`,`gmt_create`,`gmt_modify`) values (1,'新冠疫情最新疫情简报','/upload/313162.jpg','请填写 公告 内容....<pre>var editor; window.onload = function () { const E = window.wangEditor; editor = new E(\'#bulletinContent\'); editor.config.placeholder = \'请填写公告内容...\'; // 设置编辑器高度 editor.config.height = 480; editor.create() } layui.use([\'layer\', \'upload\'], function () { var $ = layui.jquery; var layer = layui.layer, upload = layui.upload; //普通图片上传开始 var uploadInst = upload.render({ elem: \'#id_upload_img\', url: \'/bulletin/upload\', size: 1024, //限制文件大小，单位 KB before: function (obj) { //预读本地文件示例，不支持ie8 obj.preview(function (index, file, result) { $(\'#id_upload_img\').attr(\'style\', \'width: auto;height: auto;max-width: 20%;max-height: 20%; border-radius: 15px;\'); $(\'#id_upload_img\').attr(\'src\', result); //图片链接（base64） }); }, done: function (res) { //如果上传失败 if (res.code != 200) { return layer.msg(\'上传失败\'); } //上传成功 var path = res.data; $(\'#bulletinImgPath\').val(path); }, error: function () { //演示失败状态，并实现重传 var demoText = $(\'#demoText\'); demoText.html(\'上传失败 <a class=\"layui-btn layui-btn-xs demo-reload\">重试</a>\'); demoText.find(\'.demo-reload\').on(\'click\', function () { uploadInst.upload(); }); } }); }); function pushBulletin() { // 获取表单参数 var bulletinTitle = $(\"#bulletinTitle\").val(); // 标题 var bulletinImgPath = $(\"#bulletinImgPath\").val(); // 配图 const E = window.wangEditor; //var bulletinContent = editor.txt.text(); // 内容 var bulletinContent = editor.txt.html(); // 内容 // debugger; // alert(bulletinContent); var param = { bulletinTitle: bulletinTitle, bulletinImg: bulletinImgPath, bulletinContent: bulletinContent } // 检验表单参数 var verifyResult = verify(param); if (verifyResult) { // 校验成功，执行添加请求 $.ajax({ type: \"POST\", url: \"/bulletin/pushBulletin\", contentType: \"application/json\", sync: true, data: JSON.stringify(param), dataType: \"json\", success: function (result) { if (result.code == 200) { layer.msg(\'添加公告成功！\', {icon: 1, offset: \'100px\', time: 2000}); setTimeout(() => { window.location.href = \"index\"; }, 2000); } else { layer.msg(result.msg, {icon: 2, offset: \'100px\', time: 2000}); } } }); } } function verify(param) { var bulletinTitle = param.bulletinTitle; var bulletinContent = param.bulletinContent; if ($.isEmptyObject(bulletinTitle)) { layer.msg(\'请填写公告标题！\', {icon: 2, offset: \'100px\', time: 2000}); return false; } else if ($.isEmptyObject(bulletinContent)) { layer.msg(\'请填写公告内容！\', {icon: 2, offset: \'100px\', time: 2000}); return false; } return true; }</pre>',2,24,1618235472360,1618235472360),(4,'新冠病毒疫苗是一种什么药？','/upload/vaccine.png','新冠病毒疫苗（COVID-19 Vaccine，SARS-COV-2 Vaccine）是具有新型冠状病毒抗原特性的各种疫苗的总称，简称「新冠疫苗」，或称「新冠肺炎疫苗」。根据研发原理和生产工艺的不同，WHO 的疫苗分类一共是 10 类，但是为了便于说明，下面将新冠病毒疫苗分为 6 类：<ul><li>全病毒灭活疫苗</li><li>病毒载体疫苗（复制 / 非复制）</li><li>蛋白亚单位疫苗</li><li>核酸类疫苗（DNA、mRNA）</li><li>病毒样颗粒疫苗</li><li>减毒活疫苗</li></ul> 接种后可刺激人体产生针对新型冠状病毒（~nCoV）的抗体，从而为受种者提供免疫保护，抵御新型冠状病毒感染人体或导致发病。<h2>新冠病毒疫苗是用来治什么的？</h2>新型冠状病毒感染人体后，可能对肺脏、肝脏、肾脏，甚至心脏等人体重要组织器官造成直接损害，从而导致呼吸系统、心血管系统等各种疾病，其中最常见的就是新型冠状病毒肺炎。因此，研发和制备新型冠状病毒疫苗的目的就是用于预防新型冠状病毒感染后导致疾病或减轻感染后症状的严重性。<h2>全球是否有新冠病毒疫苗？</h2>全球已经有多个新冠病毒疫苗进入不同时期的临床研究阶段，其中获批上市的有英国、中国研究的疫苗。 年 12 月 31 日，阿联酋和巴林已分别批准国药集团新冠病毒疫苗正式注册上市，国药集团中国生物新冠灭活疫苗已获得国家药监局批准附条件上市。已有数据显示，保护率为 79.34%，实现安全性、有效性、可及性、可负担性的统一，达到世界卫生组织及国家药监局相关标准要求。后续，疫苗免疫的持久性和保护效果还需持续观察。在 12 月 31 日举行的国务院联防联控机制新闻发布会上，科技部副部长徐南平说，到目前为止，我国 5 条技术路线 14 个疫苗进入临床试验，其中 3 条技术路线 5 个疫苗进入 Ⅲ 期临床试验。（来源：新华视点@微博）更多信息可以跳转见「<a href=\"/index#/ncov-vaccine?hasTriggerLogin=true\" target=\"_blank\">疫苗动态</a>」。现在有批准用于「紧急接种」的新型冠状病毒疫苗，仅供 18 岁～59 岁具有较高职业暴露风险的医务人员、海关边检人员、出国务工人员、留学生及社会保障人员等特定人群自愿接种。<img src=\"//1015/322/4119527946146481443-22.png\" alt=\"image\"/>图片来源：终审专家提供<img src=\"//1015/770/9273688064356481443-22.png\" alt=\"image\"/>图片来源：终审专家提供 审核专家：田伟王素娜内容策划：范运柱',1,24,1618371166017,1618371166017),(5,'体育新闻','/upload/ed7b4883-32f8-46a8-828c-22335d3b201f.jpeg','度新闻是包含海量资讯的新闻服务平台,真实反映每时每刻的新闻热点。您可以搜索新闻事件、热点话题、人物动态、产品资讯等,快速了解它们的最新进展。度新闻是包含海量资讯的新闻服务平台,真实反映每时每刻的新闻热点。您可以搜索新闻事件、热点话题、人物动态、产品资讯等,快速了解它们的最新进展。度新闻是包含海量资讯的新闻服务平台,真实反映每时每刻的新闻热点。您可以搜索新闻事件、热点话题、人物动态、产品资讯等,快速了解它们的最新进展。度新闻是包含海量资讯的新闻服务平台,真实反映每时每刻的新闻热点。您可以搜索新闻事件、热点话题、人物动态、产品资讯等,快速了解它们的最新进展。度新闻是包含海量资讯的新闻服务平台,真实反映每时每刻的新闻热点。您可以搜索新闻事件、热点话题、人物动态、产品资讯等,快速了解它们的最新进展。度新闻是包含海量资讯的新闻服务平台,真实反映每时每刻的新闻热点。您可以搜索新闻事件、热点话题、人物动态、产品资讯等,快速了解它们的最新进展。',1,24,1618403259441,1632711806221),(6,'新冠病毒疫苗','/upload/159692-106.jpg','新冠病毒疫苗新冠病毒疫苗（COVID-19 Vaccine，SARS-COV-2 Vaccine）是具有新型冠状病毒抗原特性的各种疫苗的总称，简称「新冠疫苗」，或称「新冠肺炎疫苗」。根据研发原理和生产工艺的不同，WHO 的疫苗分类一共是 10 类，但是为了便于说明，下面将新冠病毒疫苗分为 6 类：<ul><li>全病毒灭活疫苗</li><li>病毒载体疫苗（复制 / 非复制）</li><li>蛋白亚单位疫苗</li><li>核酸类疫苗（DNA、mRNA）</li><li>病毒样颗粒疫苗</li><li>减毒活疫苗</li></ul> 接种后可刺激人体产生针对新型冠状病毒（~nCoV）的抗体，从而为受种者提供免疫保护，抵御新型冠状病毒感染人体或导致发病。<h2 style=\"text-align:center;\">新冠病毒疫苗是用来治什么的？</h2>新型冠状病毒感染人体后，可能对肺脏、肝脏、肾脏，甚至心脏等人体重要组织器官造成直接损害，从而导致呼吸系统、心血管系统等各种疾病，其中最常见的就是新型冠状病毒肺炎。因此，研发和制备新型冠状病毒疫苗的目的就是用于预防新型冠状病毒感染后导致疾病或减轻感染后症状的严重性。<h2 style=\"text-align:center;\">全球是否有新冠病毒疫苗？</h2>全球已经有多个新冠病毒疫苗进入不同时期的临床研究阶段，其中获批上市的有英国、中国研究的疫苗。 年 12 月 31 日，阿联酋和巴林已分别批准国药集团新冠病毒疫苗正式注册上市，国药集团中国生物新冠灭活疫苗已获得国家药监局批准附条件上市。已有数据显示，保护率为 79.34%，实现安全性、有效性、可及性、可负担性的统一，达到世界卫生组织及国家药监局相关标准要求。后续，疫苗免疫的持久性和保护效果还需持续观察。在 12 月 31 日举行的国务院联防联控机制新闻发布会上，科技部副部长徐南平说，到目前为止，我国 5 条技术路线 14 个疫苗进入临床试验，其中 3 条技术路线 5 个疫苗进入 Ⅲ 期临床试验。（来源：新华视点@微博）更多信息可以跳转见「<a href=\"/index#/ncov-vaccine?hasTriggerLogin=true\" target=\"_blank\">疫苗动态</a>」。现在有批准用于「紧急接种」的新型冠状病毒疫苗，仅供 18 岁～59 岁具有较高职业暴露风险的医务人员、海关边检人员、出国务工人员、留学生及社会保障人员等特定人群自愿接种。<img src=\"//1015/322/4119527946146481443-22.png\" alt=\"image\"/>图片来源：终审专家提供<img src=\"//1015/770/9273688064356481443-22.png\" alt=\"image\"/>图片来源：终审专家提供 审核专家：田伟王素娜 内容策划：范运柱',0,24,1618403259441,1618403259441),(13,'今天是个好日子','/upload/181a3d8f-6479-441f-9452-1dfa0c9eda66.jpg','今天是个好日子今天是个好日子今天是个好日子今天是个好日子今天是个好日子今天是个好日子今天是个好日子今天是个好日子今天是个好日子今天是个好日子今天是个好日子',0,24,1632469037737,1632469037737),(14,'明天每个人发一辆车模型','/upload/2af5e932-0d24-451c-98aa-a40d9c8c1b2b.jpg','明天每个人发一辆车模型明天每个人发一辆车模型明天每个人发一辆车模型',2,24,1632648090500,1632648090500),(15,'34534543','/upload/88159ddc-6ee2-4e30-afa1-3d03d4112631.jpg','435345435',0,24,1632650480693,1632650480693),(16,'45645645','/upload/5584e1ba-8a13-45c7-8167-d1b33f63899a.jpg','请填写 公告 内容....546546456',0,24,1632650508597,1632650508597);/*Table structure for table `clazz` */DROP TABLE IF EXISTS `clazz`;CREATE TABLE `clazz` (`clazz_id` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '班级编号',`major_id` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '专业编号',`clazz_name` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '班级名称',`remark` varchar(500) CHARACTER SET utf8 DEFAULT NULL COMMENT '班级备注',PRIMARY KEY (`clazz_id`) USING BTREE,KEY `FK_major_classes` (`major_id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='班级实体';/*Data for the table `clazz` */insert into `clazz`(`clazz_id`,`major_id`,`clazz_name`,`remark`) values ('1520521','52','15数媒一班','男女比例还算正常的一个班'),('1520522','52','15数媒二班','这个班的都是学霸，特别爱学习'),('1520531','53','15物工一班','积极向上，热爱学习'),('1520541','54','15计科一班','都是学霸~'),('1520542','54','15计科二班','班里的学习分为也不是i很好，不如一班 '),('1520551','55','15网工一班','他们会接网线'),('1520552','55','15网工二班','毫无存在感的一个班'),('1520561','56','15软件一班','大家上课一点也不积极'),('1520562','56','15软件二班','作者所在的班级'),('1521011','101','15对外贸易一班','都过了英语四级'),('161','22','16通信一班','热该学习，热爱劳动！'),('1620521','52','16数媒一班','男女比例还算正常的一个班'),('1620522','52','16数媒二班','这个班的都是学霸，特别爱学习'),('1620531','53','16物工一班','积极向上，热爱学习'),('1620532','53','16物工二班','积极向上，热爱学习'),('1620542','54','16计科二班','班里的学习分为也不是i很好，不如一班 '),('1620551','55','16网工一班','他们会接网线'),('1620552','55','16网工二班','毫无存在感的一个班'),('1620561','56','16软件一班','大家上课一点也不积极'),('1620562','56','16软件二班','作者所在的班级'),('1720521','52','17数媒一班','男女比例还算正常的一个班'),('1720522','52','17数媒二班','这个班的都是学霸，特别爱学习'),('1720531','53','17物工一班','积极向上，热爱学习'),('1720532','53','17物工二班','积极向上，热爱学习'),('1720541','54','17计科一班','都是学霸~'),('1720542','54','17计科二班','班里的学习分为也不是i很好，不如一班 '),('1720551','55','17网工一班','他们会接网线'),('1720552','55','17网工二班','毫无存在感的一个班'),('1720561','56','17软件一班','大家上课一点也不积极'),('1720562','56','17软件二班','作者所在的班级'),('1820521','52','18数媒一班','男女比例还算正常的一个班'),('1820522','52','18数媒二班','这个班的都是学霸，特别爱学习'),('1820531','53','18物工一班','积极向上，热爱学习'),('1820532','53','18物工二班','积极向上，热爱学习'),('1820541','54','18计科一班','都是学霸~'),('1820542','54','18计科二班','班里的学习分为也不是i很好，不如一班 '),('1820551','55','18网工一班','他们会接网线'),('1820552','55','18网工二班','毫无存在感的一个班'),('1820561','56','18软件一班','大家上课一点也不积极'),('1820562','56','18软件二班','作者所在的班级'),('1920521','52','19数媒一班','男女比例还算正常的一个班'),('1920522','52','19数媒二班','这个班的都是学霸，特别爱学习'),('1920531','53','19物工一班','积极向上，热爱学习'),('1920532','53','19物工二班','积极向上，热爱学习'),('1920541','54','19计科一班','都是学霸~'),('1920542','54','19计科二班','班里的学习分为也不是i很好，不如一班 '),('1920551','55','19网工一班','他们会接网线'),('1920552','55','19网工二班','毫无存在感的一个班'),('1920561','56','19软件一班','大家上课一点也不积极'),('1920562','56','19软件二班','作者所在的班级'),('1920563','14','挖掘机2班','挖掘机1班挖掘机2班');/*Table structure for table `department` */DROP TABLE IF EXISTS `department`;CREATE TABLE `department` (`dept_id` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '院系编号',`dept_name` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '院系名称',`remark` varchar(500) CHARACTER SET utf8 DEFAULT NULL COMMENT '院系备注',PRIMARY KEY (`dept_id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='院系实体';/*Data for the table `department` */insert into `department`(`dept_id`,`dept_name`,`remark`) values ('1','机械工程系','学校的重点专业所在系'),('10','外语系',NULL),('11','设计与艺术系',NULL),('14','考古系','考古系考古系'),('15','法律系','法律系法律系'),('16','医学系','医学系医学系'),('2','电子工程系',NULL),('4','化学与化工系',NULL),('5','计算机工程系',NULL),('6','环境与安全工程系',NULL),('7','材料工程系',NULL),('8','理学系',NULL),('9','经济与管理系',NULL);/*Table structure for table `dormitory` */DROP TABLE IF EXISTS `dormitory`;CREATE TABLE `dormitory` (`dormitory_id` varchar(10) NOT NULL,`dormitory_name` varchar(255) DEFAULT NULL,`remark` varchar(255) DEFAULT NULL,PRIMARY KEY (`dormitory_id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;/*Data for the table `dormitory` */insert into `dormitory`(`dormitory_id`,`dormitory_name`,`remark`) values ('1','美女001','美女宿舍'),('2','A栋002','男生宿舍');/*Table structure for table `major` */DROP TABLE IF EXISTS `major`;CREATE TABLE `major` (`major_id` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '专业编号',`dept_id` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '院系编号',`major_name` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '专业名称',`remark` varchar(500) CHARACTER SET utf8 DEFAULT NULL COMMENT '专业备注',PRIMARY KEY (`major_id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='专业实体';/*Data for the table `major` */insert into `major`(`major_id`,`dept_id`,`major_name`,`remark`) values ('101','10','对外进口贸易','男女比例1：9这个专业可以'),('11','1','机械设计制造及其自动化','lalalala'),('12','1','机械电子工程',NULL),('13','1','材料成型及控制工程',NULL),('14','1','汽车服务工程',NULL),('15','5','计算机科学与技术','计算机科学与技术计算机科学与技术'),('16','1','挖掘机修理','挖掘机修理挖掘机修理'),('22','2','通信工程',NULL),('23','2','电子信息工程',NULL),('41','4','制药工程','考研率高'),('52','5','数字媒体技术',NULL),('53','5','物联网工程',''),('54','5','计算机科学与技术',NULL),('55','5','网络工程',NULL),('56','5','软件工程','');/*Table structure for table `student` */DROP TABLE IF EXISTS `student`;CREATE TABLE `student` (`stu_id` varchar(20) NOT NULL COMMENT '学号',`stu_name` varchar(50) DEFAULT NULL COMMENT '姓名',`sex` varchar(10) DEFAULT NULL COMMENT '性别',`birthplace` varchar(255) DEFAULT NULL COMMENT '籍贯',`birthday` date DEFAULT NULL COMMENT '出生年月',`phone_number` varchar(11) DEFAULT NULL COMMENT '联系方式',`kinsfolk_name` varchar(255) DEFAULT NULL COMMENT '家属姓名',`kinsfolk_phone_number` varchar(11) DEFAULT NULL COMMENT '家属联系方式',`dormitory_id` varchar(20) DEFAULT NULL COMMENT '宿舍编号',`clazz_id` varchar(20) DEFAULT NULL COMMENT '班级编号',`grade` varchar(255) DEFAULT NULL COMMENT '年级',`remark` varchar(4000) DEFAULT NULL COMMENT '备注',`gmt_create` bigint(20) DEFAULT NULL COMMENT '添加时间',`gmt_modify` bigint(20) DEFAULT NULL COMMENT '修改时间',PRIMARY KEY (`stu_id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;/*Data for the table `student` */insert into `student`(`stu_id`,`stu_name`,`sex`,`birthplace`,`birthday`,`phone_number`,`kinsfolk_name`,`kinsfolk_phone_number`,`dormitory_id`,`clazz_id`,`grade`,`remark`,`gmt_create`,`gmt_modify`) values ('123456','小A','男','湖北','-09-07','13345678901','大A','13345678902','2','1521011','','测试',1632973494812,1632973494812),('162054124','李四','男','北京','-04-08','15395483645','张三丰','12536489654','1','1620561','','lalal',1618496021016,1618835013546),('162054126','马六','男','上海','-12-05','15364925795','hao liu','15364925795','1','1620542','','666',1618708617457,1618708617457),('162056201','张三','女','北京','-04-08','15395483645','张三丰','12536489654','2','1620562','','123',1618708617457,1618500077393),('162056202','李四','男','北京','-04-08','15395483645','张三丰','12536489654','1','1620562','','lalal',1618496021016,1618496021016),('162056203','李四','男','北京','-04-08','15395483645','张三丰','12536489654','1','1620562','','lalal',1618496021016,1618496021016),('162056204','李四','男','北京','-04-08','15395483645','张三丰','12536489654','2','1620562','','lalal',1618496021016,1618496021016),('162056206','李四','男','北京','-04-08','15395483645','张三丰','12536489654','1','1620562','','lalal',1618496021016,1618496021016),('162056207','李四','男','北京','-04-08','15395483645','张三丰','12536489654','1','1620562','','lalal',1618496021016,1618496021016),('162056209','李四','男','北京','-04-08','15395483645','张三丰','12536489654','1','1620562','','lalal',1618496021016,1618496021016),('162056224','王五','男','北京朝阳','-12-01','15336425795','hao liu','15698736542','1','1720561','','123',1618496021016,1618496021016);/*Table structure for table `temp_record` */DROP TABLE IF EXISTS `temp_record`;CREATE TABLE `temp_record` (`stu_id` varchar(20) NOT NULL COMMENT '学号',`record_date` date NOT NULL COMMENT '填写日期',`stu_temp` varchar(10) DEFAULT NULL COMMENT '当前体温',`symptom1` varchar(255) DEFAULT NULL COMMENT '是否出现咳嗽等症状？',`symptom2` varchar(255) DEFAULT NULL COMMENT '是否出现气促等症状？',`gmt_create` bigint(20) DEFAULT NULL COMMENT '填写时间',`gmt_modify` bigint(20) DEFAULT NULL COMMENT '修改时间',PRIMARY KEY (`stu_id`,`record_date`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;/*Data for the table `temp_record` */insert into `temp_record`(`stu_id`,`record_date`,`stu_temp`,`symptom1`,`symptom2`,`gmt_create`,`gmt_modify`) values ('162054124','-07-15','111','1','1',1616925822678,1616943296267),('162054124','-07-28','35.5','0','0',1616925822678,1616925822678),('162054124','-01-15','111','1','1',1616925822678,1616943296267),('162054124','-01-28','35.5','0','0',1616925822678,1616925822678),('162054124','-02-15','111','1','1',1616925822678,1616943296267),('162054124','-02-28','35.5','0','0',1616925822678,1616925822678),('162054124','-03-15','111','1','1',1616925822678,1616943296267),('162054124','-03-28','35.5','0','0',1616925822678,1616925822678),('162054124','-04-15','111','1','1',1616925822678,1616943296267),('162054124','-04-28','35.5','0','0',1616925822678,1616925822678),('162054124','-05-15','111','1','1',1616925822678,1616943296267),('162054124','-05-28','35.5','0','0',1616925822678,1616925822678),('162054124','-06-15','111','1','1',1616925822678,1616943296267),('162054124','-06-28','35.5','0','0',1616925822678,1616925822678),('162054124','-07-15','111','1','1',1616925822678,1616943296267),('162054124','-07-28','35.5','0','0',1616925822678,1616925822678),('162054124','-08-15','111','1','1',1616925822678,1616943296267),('162054124','-08-28','35.5','0','0',1616925822678,1616925822678),('162054124','-09-15','111','1','1',1616925822678,1616943296267),('162054124','-09-28','35.5','0','0',1616925822678,1616925822678),('162054124','-09-15','111','1','1',1616925822678,1616943296267),('162054124','-09-28','35.5','0','0',1616925822678,1616925822678),('162054124','-10-15','111','1','1',1616925822678,1616943296267),('162054124','-10-28','35.5','0','0',1616925822678,1616925822678),('162054124','-11-15','111','1','1',1616925822678,1616943296267),('162054124','-11-28','35.5','0','0',1616925822678,1616925822678),('162054124','-12-15','111','1','1',1616925822678,1616943296267),('162054124','-12-28','35.5','0','0',1616925822678,1616925822678),('162054124','-12-15','111','1','1',1616925822678,1616943296267),('162054124','-12-28','35.5','0','0',1616925822678,1616925822678),('162056224','-07-21','36.5','1','1',1632294446514,1632294446514),('162056224','-07-22','36.5','1','1',1632294041383,1632294041383),('162056224','-07-26','35.5','1','0',1616925822678,1616946795995),('162056224','-07-27','35.5','1','0',1616925822678,1616946795995),('162056224','-07-28','36.5','1','1',1616925822678,1616925822678),('162056224','-07-29','111','1','1',1616925822678,1616946939230),('162056224','-01-21','36.5','1','1',1632294446514,1632294446514),('162056224','-01-22','36.5','1','1',1632294041383,1632294041383),('162056224','-01-26','35.5','1','0',1616925822678,1616946795995),('162056224','-01-27','35.5','1','0',1616925822678,1616946795995),('162056224','-01-28','36.5','1','1',1616925822678,1616925822678),('162056224','-01-29','111','1','1',1616925822678,1616946939230),('162056224','-02-26','35.5','1','0',1616925822678,1616946795995),('162056224','-02-27','35.5','1','0',1616925822678,1616946795995),('162056224','-02-28','36.5','1','1',1616925822678,1616925822678),('162056224','-03-26','35.5','1','0',1616925822678,1616946795995),('162056224','-03-27','35.5','1','0',1616925822678,1616946795995),('162056224','-03-28','36.5','1','1',1616925822678,1616925822678),('162056224','-03-29','111','1','1',1616925822678,1616946939230),('162056224','-04-21','36.5','1','1',1632294446514,1632294446514),('162056224','-04-22','36.5','1','1',1632294041383,1632294041383),('162056224','-04-26','35.5','1','0',1616925822678,1616946795995),('162056224','-04-27','35.5','1','0',1616925822678,1616946795995),('162056224','-04-28','36.5','1','1',1616925822678,1616925822678),('162056224','-04-29','111','1','1',1616925822678,1616946939230),('162056224','-05-21','36.5','1','1',1632294446514,1632294446514),('162056224','-05-22','36.5','1','1',1632294041383,1632294041383),('162056224','-05-26','35.5','1','0',1616925822678,1616946795995),('162056224','-05-27','35.5','1','0',1616925822678,1616946795995),('162056224','-05-28','36.5','1','1',1616925822678,1616925822678),('162056224','-05-29','111','1','1',1616925822678,1616946939230),('162056224','-06-21','36.5','1','1',1632294446514,1632294446514),('162056224','-06-22','36.5','1','1',1632294041383,1632294041383),('162056224','-06-26','35.5','1','0',1616925822678,1616946795995),('162056224','-06-27','35.5','1','0',1616925822678,1616946795995),('162056224','-06-28','36.5','1','1',1616925822678,1616925822678),('162056224','-06-29','111','1','1',1616925822678,1616946939230),('162056224','-07-21','36.5','1','1',1632294446514,1632294446514),('162056224','-07-22','36.5','1','1',1632294041383,1632294041383),('162056224','-07-26','35.5','1','0',1616925822678,1616946795995),('162056224','-07-27','35.5','1','0',1616925822678,1616946795995),('162056224','-07-28','36.5','1','1',1616925822678,1616925822678),('162056224','-07-29','111','1','1',1616925822678,1616946939230),('162056224','-08-21','36.5','1','1',1632294446514,1632294446514),('162056224','-08-22','36.5','1','1',1632294041383,1632294041383),('162056224','-08-26','35.5','1','0',1616925822678,1616946795995),('162056224','-08-27','35.5','1','0',1616925822678,1616946795995),('162056224','-08-28','36.5','1','1',1616925822678,1616925822678),('162056224','-08-29','111','1','1',1616925822678,1616946939230),('162056224','-09-21','36.5','1','1',1632294446514,1632294446514),('162056224','-09-22','36.5','1','1',1632294041383,1632294041383),('162056224','-09-26','35.5','1','0',1616925822678,1616946795995),('162056224','-09-27','35.5','1','0',1616925822678,1616946795995),('162056224','-09-28','36.5','1','1',1616925822678,1616925822678),('162056224','-09-29','111','1','1',1616925822678,1616946939230),('162056224','-09-21','36.5','1','1',1632294446514,1632294446514),('162056224','-09-26','35.5','1','0',1616925822678,1616946795995),('162056224','-09-27','35.5','1','0',1616925822678,1616946795995),('162056224','-09-28','36.5','1','1',1616925822678,1616925822678),('162056224','-09-29','111','1','1',1616925822678,1616946939230),('162056224','-10-21','36.5','1','1',1632294446514,1632294446514),('162056224','-10-26','35.5','1','0',1616925822678,1616946795995),('162056224','-10-27','35.5','1','0',1616925822678,1616946795995),('162056224','-10-28','36.5','1','1',1616925822678,1616925822678),('162056224','-10-29','111','1','1',1616925822678,1616946939230),('162056224','-11-21','36.5','1','1',1632294446514,1632294446514),('162056224','-11-26','35.5','1','0',1616925822678,1616946795995),('162056224','-11-27','35.5','1','0',1616925822678,1616946795995),('162056224','-11-28','36.5','1','1',1616925822678,1616925822678),('162056224','-11-29','111','1','1',1616925822678,1616946939230),('162056224','-12-21','36.5','1','1',1632294446514,1632294446514),('162056224','-12-26','35.5','1','0',1616925822678,1616946795995),('162056224','-12-27','35.5','1','0',1616925822678,1616946795995),('162056224','-12-28','36.5','1','1',1616925822678,1616925822678),('162056224','-12-29','111','1','1',1616925822678,1616946939230),('162056224','-12-21','36.5','1','1',1632294446514,1632294446514),('162056224','-12-26','35.5','1','0',1616925822678,1616946795995),('162056224','-12-27','35.5','1','0',1616925822678,1616946795995),('162056224','-12-28','36.5','1','1',1616925822678,1616925822678),('162056224','-12-29','111','1','1',1616925822678,1616946939230);/*Table structure for table `user` */DROP TABLE IF EXISTS `user`;CREATE TABLE `user` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',`token` varchar(255) DEFAULT NULL COMMENT '登录令牌',`user_name` varchar(255) NOT NULL COMMENT '用户名',`password` varchar(255) NOT NULL COMMENT '用户密码',`real_name` varchar(255) NOT NULL COMMENT '用户真实姓名',`phone` varchar(255) DEFAULT '12345678910' COMMENT '用户联系方式',`role` varchar(255) NOT NULL DEFAULT 'normal' COMMENT '用户身份/角色（1-超级管理员 2-宿舍管理员 3-学生）',`avatar_url` varchar(255) DEFAULT 'default.jpg' COMMENT '用户头像',`remark` varchar(4000) DEFAULT NULL COMMENT '备注',`gmt_create` bigint(20) DEFAULT NULL COMMENT '创建时间',`gmt_modify` bigint(20) DEFAULT NULL COMMENT '修改时间',PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;/*Data for the table `user` */insert into `user`(`id`,`token`,`user_name`,`password`,`real_name`,`phone`,`role`,`avatar_url`,`remark`,`gmt_create`,`gmt_modify`) values (23,NULL,'bruce','123456','老刘','15364925796','2',NULL,'测试',1618721144407,1632969847618),(24,NULL,'admin','123456','超级管理员','15364925795','1',NULL,'是超级管理员啦~',1618721144407,1632970877791),(25,NULL,'zhangsan','123456','张老师','15364925795','2',NULL,'我是张三',1618721144407,1618721144407),(28,NULL,'小王','admin123','小王','13367891010','3',NULL,'小王小王',1632973261090,1632973261090),(29,NULL,'2011','123456','小A','13345678901','3',NULL,'测试',1632973494831,1632973494831);/*Table structure for table `visit_record` */DROP TABLE IF EXISTS `visit_record`;CREATE TABLE `visit_record` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '访问记录ID',`stu_id` varchar(20) DEFAULT NULL COMMENT '访问学生学号',`stu_temp` varchar(10) DEFAULT NULL COMMENT '访问者体温',`dormitory_id` int(11) DEFAULT NULL COMMENT '访问宿舍ID',`record_date` date DEFAULT NULL COMMENT '访问日期',PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;/*Data for the table `visit_record` */insert into `visit_record`(`id`,`stu_id`,`stu_temp`,`dormitory_id`,`record_date`) values (1,'162056201','36.5',1,'-04-14'),(2,'162056224','36.5',1,'-04-14'),(3,'162056201','36.5',1,'-04-14'),(4,'162056224','36.5',1,'-04-14'),(5,'162056201','36.5',1,'-04-14'),(6,'162054124','36.5',1,'-04-14'),(7,'162054124','36.5',2,'-09-21'),(8,'162056201','56',2,'-09-25');/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;