基于ssm的大学校医院信息管理系统设计与实现-计算机毕业设计源码+LW文档

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