开发语言: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');