开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库脚本：
DROP TABLE IF EXISTS `binglijilu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `binglijilu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`binglibianhao` varchar(200) DEFAULT NULL COMMENT ‘病历编号’,
`xuehao` varchar(200) DEFAULT NULL COMMENT ‘学号’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`jiaose` varchar(200) DEFAULT NULL COMMENT ‘角色’,
`zhusu` varchar(200) DEFAULT NULL COMMENT ‘主诉’,
`xianbingshi` varchar(200) DEFAULT NULL COMMENT ‘现病史’,
`jiwangshi` varchar(200) DEFAULT NULL COMMENT ‘既往史’,
`yaominshi` varchar(200) DEFAULT NULL COMMENT ‘药敏史’,
`zhenduan` varchar(200) DEFAULT NULL COMMENT ‘诊断’,
`zhiliaofangan` longtext COMMENT ‘治疗方案’,
`xiaoyigonghao` varchar(200) DEFAULT NULL COMMENT ‘校医工号’,
`xiaoyixingming` varchar(200) DEFAULT NULL COMMENT ‘校医姓名’,
`dengjishijian` datetime DEFAULT NULL COMMENT ‘登记时间’,
PRIMARY KEY (`id`),
UNIQUE KEY `binglibianhao` (`binglibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT=’病例记录’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `binglijilu`
—
LOCK TABLES `binglijilu` WRITE;
/*!40000 ALTER TABLE `binglijilu` DISABLE KEYS */;
INSERT INTO `binglijilu` VALUES (81,’2022-04-14 03:18:54′,’1111111111′,’学号1′,’姓名1′,’角色1′,’主诉1′,’现病史1′,’既往史1′,’药敏史1′,’诊断1′,’治疗方案1′,’校医工号1′,’校医姓名1′,’2022-04-14 11:18:54′),(82,’2022-04-14 03:18:54′,’2222222222′,’学号2′,’姓名2′,’角色2′,’主诉2′,’现病史2′,’既往史2′,’药敏史2′,’诊断2′,’治疗方案2′,’校医工号2′,’校医姓名2′,’2022-04-14 11:18:54′),(83,’2022-04-14 03:18:54′,’3333333333′,’学号3′,’姓名3′,’角色3′,’主诉3′,’现病史3′,’既往史3′,’药敏史3′,’诊断3′,’治疗方案3′,’校医工号3′,’校医姓名3′,’2022-04-14 11:18:54′),(84,’2022-04-14 03:18:54′,’4444444444′,’学号4′,’姓名4′,’角色4′,’主诉4′,’现病史4′,’既往史4′,’药敏史4′,’诊断4′,’治疗方案4′,’校医工号4′,’校医姓名4′,’2022-04-14 11:18:54′),(85,’2022-04-14 03:18:54′,’5555555555′,’学号5′,’姓名5′,’角色5′,’主诉5′,’现病史5′,’既往史5′,’药敏史5′,’诊断5′,’治疗方案5′,’校医工号5′,’校医姓名5′,’2022-04-14 11:18:54′),(86,’2022-04-14 03:18:54′,’6666666666′,’学号6′,’姓名6′,’角色6′,’主诉6′,’现病史6′,’既往史6′,’药敏史6′,’诊断6′,’治疗方案6′,’校医工号6′,’校医姓名6′,’2022-04-14 11:18:54′);
/*!40000 ALTER TABLE `binglijilu` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `config`
—
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`name` varchar(100) NOT NULL COMMENT ‘配置参数名称’,
`value` varchar(100) DEFAULT NULL COMMENT ‘配置参数值’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT=’配置文件’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `config`
—
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,’picture1′,’upload/picture1.jpg’),(2,’picture2′,’upload/picture2.jpg’),(3,’picture3′,’upload/picture3.jpg’);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `discussxiaoyi`
—
DROP TABLE IF EXISTS `discussxiaoyi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussxiaoyi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`refid` bigint(20) NOT NULL COMMENT ‘关联表id’,
`userid` bigint(20) NOT NULL COMMENT ‘用户id’,
`nickname` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`content` longtext NOT NULL COMMENT ‘评论内容’,
`reply` longtext COMMENT ‘回复内容’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8 COMMENT=’校医评论表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `discussxiaoyi`
—
LOCK TABLES `discussxiaoyi` WRITE;
/*!40000 ALTER TABLE `discussxiaoyi` DISABLE KEYS */;
INSERT INTO `discussxiaoyi` VALUES (191,’2022-04-14 03:18:54′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(192,’2022-04-14 03:18:54′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(193,’2022-04-14 03:18:54′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(194,’2022-04-14 03:18:54′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(195,’2022-04-14 03:18:54′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(196,’2022-04-14 03:18:54′,6,6,’用户名6′,’评论内容6′,’回复内容6′);
/*!40000 ALTER TABLE `discussxiaoyi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `discussyaopinxinxi`
—
DROP TABLE IF EXISTS `discussyaopinxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussyaopinxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`refid` bigint(20) NOT NULL COMMENT ‘关联表id’,
`userid` bigint(20) NOT NULL COMMENT ‘用户id’,
`nickname` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`content` longtext NOT NULL COMMENT ‘评论内容’,
`reply` longtext COMMENT ‘回复内容’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8 COMMENT=’药品信息评论表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `discussyaopinxinxi`
—
LOCK TABLES `discussyaopinxinxi` WRITE;
/*!40000 ALTER TABLE `discussyaopinxinxi` DISABLE KEYS */;
INSERT INTO `discussyaopinxinxi` VALUES (201,’2022-04-14 03:18:55′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(202,’2022-04-14 03:18:55′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(203,’2022-04-14 03:18:55′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(204,’2022-04-14 03:18:55′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(205,’2022-04-14 03:18:55′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(206,’2022-04-14 03:18:55′,6,6,’用户名6′,’评论内容6′,’回复内容6′);
/*!40000 ALTER TABLE `discussyaopinxinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `fanxiaoshenqing`
—
DROP TABLE IF EXISTS `fanxiaoshenqing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fanxiaoshenqing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`xuehao` varchar(200) DEFAULT NULL COMMENT ‘学号’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`jiaose` varchar(200) DEFAULT NULL COMMENT ‘角色’,
`xueyuan` varchar(200) DEFAULT NULL COMMENT ‘学院’,
`ruxiaoshijian` datetime DEFAULT NULL COMMENT ‘入校时间’,
`tiwen` varchar(200) DEFAULT NULL COMMENT ‘体温’,
`yuekangma` varchar(200) DEFAULT NULL COMMENT ‘粤康码’,
`xingchengma` varchar(200) DEFAULT NULL COMMENT ‘行程码’,
`hesuanma` varchar(200) DEFAULT NULL COMMENT ‘核酸码’,
`sfsh` varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
`shhf` longtext COMMENT ‘审核回复’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT=’返校申请’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `fanxiaoshenqing`
—
LOCK TABLES `fanxiaoshenqing` WRITE;
/*!40000 ALTER TABLE `fanxiaoshenqing` DISABLE KEYS */;
INSERT INTO `fanxiaoshenqing` VALUES (111,’2022-04-14 03:18:54′,’学号1′,’姓名1′,’角色1′,’学院1′,’2022-04-14 11:18:54′,’体温1′,’upload/fanxiaoshenqing_yuekangma1.jpg’,’upload/fanxiaoshenqing_xingchengma1.jpg’,’upload/fanxiaoshenqing_hesuanma1.jpg’,’是’,”),(112,’2022-04-14 03:18:54′,’学号2′,’姓名2′,’角色2′,’学院2′,’2022-04-14 11:18:54′,’体温2′,’upload/fanxiaoshenqing_yuekangma2.jpg’,’upload/fanxiaoshenqing_xingchengma2.jpg’,’upload/fanxiaoshenqing_hesuanma2.jpg’,’是’,”),(113,’2022-04-14 03:18:54′,’学号3′,’姓名3′,’角色3′,’学院3′,’2022-04-14 11:18:54′,’体温3′,’upload/fanxiaoshenqing_yuekangma3.jpg’,’upload/fanxiaoshenqing_xingchengma3.jpg’,’upload/fanxiaoshenqing_hesuanma3.jpg’,’是’,”),(114,’2022-04-14 03:18:54′,’学号4′,’姓名4′,’角色4′,’学院4′,’2022-04-14 11:18:54′,’体温4′,’upload/fanxiaoshenqing_yuekangma4.jpg’,’upload/fanxiaoshenqing_xingchengma4.jpg’,’upload/fanxiaoshenqing_hesuanma4.jpg’,’是’,”),(115,’2022-04-14 03:18:54′,’学号5′,’姓名5′,’角色5′,’学院5′,’2022-04-14 11:18:54′,’体温5′,’upload/fanxiaoshenqing_yuekangma5.jpg’,’upload/fanxiaoshenqing_xingchengma5.jpg’,’upload/fanxiaoshenqing_hesuanma5.jpg’,’是’,”),(116,’2022-04-14 03:18:54′,’学号6′,’姓名6′,’角色6′,’学院6′,’2022-04-14 11:18:54′,’体温6′,’upload/fanxiaoshenqing_yuekangma6.jpg’,’upload/fanxiaoshenqing_xingchengma6.jpg’,’upload/fanxiaoshenqing_hesuanma6.jpg’,’是’,”);
/*!40000 ALTER TABLE `fanxiaoshenqing` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `jiankangshangbao`
—
DROP TABLE IF EXISTS `jiankangshangbao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiankangshangbao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`xuehao` varchar(200) DEFAULT NULL COMMENT ‘学号’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`xingbie` varchar(200) DEFAULT NULL COMMENT ‘性别’,
`shoujihao` varchar(200) DEFAULT NULL COMMENT ‘手机号’,
`jiaose` varchar(200) DEFAULT NULL COMMENT ‘角色’,
`jiankangma` varchar(200) DEFAULT NULL COMMENT ‘健康码’,
`xingchengma` varchar(200) DEFAULT NULL COMMENT ‘行程码’,
`hesuanbaogao` varchar(200) DEFAULT NULL COMMENT ‘核酸报告’,
`tiwen` varchar(200) DEFAULT NULL COMMENT ‘体温’,
`beizhu` longtext COMMENT ‘备注’,
`shangbaoshijian` date DEFAULT NULL COMMENT ‘上报时间’,
`longitude` float DEFAULT NULL COMMENT ‘经度’,
`latitude` float DEFAULT NULL COMMENT ‘纬度’,
`fulladdress` varchar(200) DEFAULT NULL COMMENT ‘地址’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT=’健康上报’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `jiankangshangbao`
—
LOCK TABLES `jiankangshangbao` WRITE;
/*!40000 ALTER TABLE `jiankangshangbao` DISABLE KEYS */;
INSERT INTO `jiankangshangbao` VALUES (91,’2022-04-14 03:18:54′,’学号1′,’姓名1′,’男’,’13823888881′,’角色1′,’upload/jiankangshangbao_jiankangma1.jpg’,’upload/jiankangshangbao_xingchengma1.jpg’,’upload/jiankangshangbao_hesuanbaogao1.jpg’,’体温1′,’备注1′,’2022-04-14′,1,1,’宇宙银河系地球1号’),(92,’2022-04-14 03:18:54′,’学号2′,’姓名2′,’男’,’13823888882′,’角色2′,’upload/jiankangshangbao_jiankangma2.jpg’,’upload/jiankangshangbao_xingchengma2.jpg’,’upload/jiankangshangbao_hesuanbaogao2.jpg’,’体温2′,’备注2′,’2022-04-14′,2,2,’宇宙银河系地球2号’),(93,’2022-04-14 03:18:54′,’学号3′,’姓名3′,’男’,’13823888883′,’角色3′,’upload/jiankangshangbao_jiankangma3.jpg’,’upload/jiankangshangbao_xingchengma3.jpg’,’upload/jiankangshangbao_hesuanbaogao3.jpg’,’体温3′,’备注3′,’2022-04-14′,3,3,’宇宙银河系地球3号’),(94,’2022-04-14 03:18:54′,’学号4′,’姓名4′,’男’,’13823888884′,’角色4′,’upload/jiankangshangbao_jiankangma4.jpg’,’upload/jiankangshangbao_xingchengma4.jpg’,’upload/jiankangshangbao_hesuanbaogao4.jpg’,’体温4′,’备注4′,’2022-04-14′,4,4,’宇宙银河系地球4号’),(95,’2022-04-14 03:18:54′,’学号5′,’姓名5′,’男’,’13823888885′,’角色5′,’upload/jiankangshangbao_jiankangma5.jpg’,’upload/jiankangshangbao_xingchengma5.jpg’,’upload/jiankangshangbao_hesuanbaogao5.jpg’,’体温5′,’备注5′,’2022-04-14′,5,5,’宇宙银河系地球5号’),(96,’2022-04-14 03:18:54′,’学号6′,’姓名6′,’男’,’13823888886′,’角色6′,’upload/jiankangshangbao_jiankangma6.jpg’,’upload/jiankangshangbao_xingchengma6.jpg’,’upload/jiankangshangbao_hesuanbaogao6.jpg’,’体温6′,’备注6′,’2022-04-14′,6,6,’宇宙银河系地球6号’);
/*!40000 ALTER TABLE `jiankangshangbao` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `keshi`
—
DROP TABLE IF EXISTS `keshi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `keshi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`keshi` varchar(200) NOT NULL COMMENT ‘科室’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT=’科室’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `keshi`
—
LOCK TABLES `keshi` WRITE;
/*!40000 ALTER TABLE `keshi` DISABLE KEYS */;
INSERT INTO `keshi` VALUES (21,’2022-04-14 03:18:54′,’科室1′),(22,’2022-04-14 03:18:54′,’科室2′),(23,’2022-04-14 03:18:54′,’科室3′),(24,’2022-04-14 03:18:54′,’科室4′),(25,’2022-04-14 03:18:54′,’科室5′),(26,’2022-04-14 03:18:54′,’科室6′);