基于ssm的大學(xué)校醫(yī)院信息管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開(kāi)發(fā)語(yǔ)言：Java
框架：ssm
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫(kù)：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫(kù)工具：Navicat11
開(kāi)發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫(kù)腳本：
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 '創(chuàng)建時(shí)間',
? `binglibianhao` varchar(200) DEFAULT NULL COMMENT '病歷編號(hào)',
? `xuehao` varchar(200) DEFAULT NULL COMMENT '學(xué)號(hào)',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `jiaose` varchar(200) DEFAULT NULL COMMENT '角色',
? `zhusu` varchar(200) DEFAULT NULL COMMENT '主訴',
? `xianbingshi` varchar(200) DEFAULT NULL COMMENT '現(xiàn)病史',
? `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 '校醫(yī)工號(hào)',
? `xiaoyixingming` varchar(200) DEFAULT NULL COMMENT '校醫(yī)姓名',
? `dengjishijian` datetime DEFAULT NULL COMMENT '登記時(shí)間',
? 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','學(xué)號(hào)1','姓名1','角色1','主訴1','現(xiàn)病史1','既往史1','藥敏史1','診斷1','治療方案1','校醫(yī)工號(hào)1','校醫(yī)姓名1','2022-04-14 11:18:54'),(82,'2022-04-14 03:18:54','2222222222','學(xué)號(hào)2','姓名2','角色2','主訴2','現(xiàn)病史2','既往史2','藥敏史2','診斷2','治療方案2','校醫(yī)工號(hào)2','校醫(yī)姓名2','2022-04-14 11:18:54'),(83,'2022-04-14 03:18:54','3333333333','學(xué)號(hào)3','姓名3','角色3','主訴3','現(xiàn)病史3','既往史3','藥敏史3','診斷3','治療方案3','校醫(yī)工號(hào)3','校醫(yī)姓名3','2022-04-14 11:18:54'),(84,'2022-04-14 03:18:54','4444444444','學(xué)號(hào)4','姓名4','角色4','主訴4','現(xiàn)病史4','既往史4','藥敏史4','診斷4','治療方案4','校醫(yī)工號(hào)4','校醫(yī)姓名4','2022-04-14 11:18:54'),(85,'2022-04-14 03:18:54','5555555555','學(xué)號(hào)5','姓名5','角色5','主訴5','現(xiàn)病史5','既往史5','藥敏史5','診斷5','治療方案5','校醫(yī)工號(hào)5','校醫(yī)姓名5','2022-04-14 11:18:54'),(86,'2022-04-14 03:18:54','6666666666','學(xué)號(hào)6','姓名6','角色6','主訴6','現(xiàn)病史6','既往史6','藥敏史6','診斷6','治療方案6','校醫(yī)工號(hào)6','校醫(yī)姓名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 '配置參數(shù)名稱(chēng)',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評(píng)論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8 COMMENT='校醫(yī)評(píng)論表';
/*!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','評(píng)論內(nèi)容1','回復(fù)內(nèi)容1'),(192,'2022-04-14 03:18:54',2,2,'用戶名2','評(píng)論內(nèi)容2','回復(fù)內(nèi)容2'),(193,'2022-04-14 03:18:54',3,3,'用戶名3','評(píng)論內(nèi)容3','回復(fù)內(nèi)容3'),(194,'2022-04-14 03:18:54',4,4,'用戶名4','評(píng)論內(nèi)容4','回復(fù)內(nèi)容4'),(195,'2022-04-14 03:18:54',5,5,'用戶名5','評(píng)論內(nèi)容5','回復(fù)內(nèi)容5'),(196,'2022-04-14 03:18:54',6,6,'用戶名6','評(píng)論內(nèi)容6','回復(fù)內(nèi)容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 '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評(píng)論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8 COMMENT='藥品信息評(píng)論表';
/*!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','評(píng)論內(nèi)容1','回復(fù)內(nèi)容1'),(202,'2022-04-14 03:18:55',2,2,'用戶名2','評(píng)論內(nèi)容2','回復(fù)內(nèi)容2'),(203,'2022-04-14 03:18:55',3,3,'用戶名3','評(píng)論內(nèi)容3','回復(fù)內(nèi)容3'),(204,'2022-04-14 03:18:55',4,4,'用戶名4','評(píng)論內(nèi)容4','回復(fù)內(nèi)容4'),(205,'2022-04-14 03:18:55',5,5,'用戶名5','評(píng)論內(nèi)容5','回復(fù)內(nèi)容5'),(206,'2022-04-14 03:18:55',6,6,'用戶名6','評(píng)論內(nèi)容6','回復(fù)內(nèi)容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 '創(chuàng)建時(shí)間',
? `xuehao` varchar(200) DEFAULT NULL COMMENT '學(xué)號(hào)',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `jiaose` varchar(200) DEFAULT NULL COMMENT '角色',
? `xueyuan` varchar(200) DEFAULT NULL COMMENT '學(xué)院',
? `ruxiaoshijian` datetime DEFAULT NULL COMMENT '入校時(shí)間',
? `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 '審核回復(fù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='返校申請(qǐng)';
/*!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','學(xué)號(hào)1','姓名1','角色1','學(xué)院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','學(xué)號(hào)2','姓名2','角色2','學(xué)院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','學(xué)號(hào)3','姓名3','角色3','學(xué)院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','學(xué)號(hào)4','姓名4','角色4','學(xué)院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','學(xué)號(hào)5','姓名5','角色5','學(xué)院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','學(xué)號(hào)6','姓名6','角色6','學(xué)院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 '創(chuàng)建時(shí)間',
? `xuehao` varchar(200) DEFAULT NULL COMMENT '學(xué)號(hào)',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `shoujihao` varchar(200) DEFAULT NULL COMMENT '手機(jī)號(hào)',
? `jiaose` varchar(200) DEFAULT NULL COMMENT '角色',
? `jiankangma` varchar(200) DEFAULT NULL COMMENT '健康碼',
? `xingchengma` varchar(200) DEFAULT NULL COMMENT '行程碼',
? `hesuanbaogao` varchar(200) DEFAULT NULL COMMENT '核酸報(bào)告',
? `tiwen` varchar(200) DEFAULT NULL COMMENT '體溫',
? `beizhu` longtext COMMENT '備注',
? `shangbaoshijian` date DEFAULT NULL COMMENT '上報(bào)時(shí)間',
? `longitude` float DEFAULT NULL COMMENT '經(jīng)度',
? `latitude` float DEFAULT NULL COMMENT '緯度',
? `fulladdress` varchar(200) DEFAULT NULL COMMENT '地址',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='健康上報(bào)';
/*!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','學(xué)號(hào)1','姓名1','男','13823888881','角色1','upload/jiankangshangbao_jiankangma1.jpg','upload/jiankangshangbao_xingchengma1.jpg','upload/jiankangshangbao_hesuanbaogao1.jpg','體溫1','備注1','2022-04-14',1,1,'宇宙銀河系地球1號(hào)'),(92,'2022-04-14 03:18:54','學(xué)號(hào)2','姓名2','男','13823888882','角色2','upload/jiankangshangbao_jiankangma2.jpg','upload/jiankangshangbao_xingchengma2.jpg','upload/jiankangshangbao_hesuanbaogao2.jpg','體溫2','備注2','2022-04-14',2,2,'宇宙銀河系地球2號(hào)'),(93,'2022-04-14 03:18:54','學(xué)號(hào)3','姓名3','男','13823888883','角色3','upload/jiankangshangbao_jiankangma3.jpg','upload/jiankangshangbao_xingchengma3.jpg','upload/jiankangshangbao_hesuanbaogao3.jpg','體溫3','備注3','2022-04-14',3,3,'宇宙銀河系地球3號(hào)'),(94,'2022-04-14 03:18:54','學(xué)號(hào)4','姓名4','男','13823888884','角色4','upload/jiankangshangbao_jiankangma4.jpg','upload/jiankangshangbao_xingchengma4.jpg','upload/jiankangshangbao_hesuanbaogao4.jpg','體溫4','備注4','2022-04-14',4,4,'宇宙銀河系地球4號(hào)'),(95,'2022-04-14 03:18:54','學(xué)號(hào)5','姓名5','男','13823888885','角色5','upload/jiankangshangbao_jiankangma5.jpg','upload/jiankangshangbao_xingchengma5.jpg','upload/jiankangshangbao_hesuanbaogao5.jpg','體溫5','備注5','2022-04-14',5,5,'宇宙銀河系地球5號(hào)'),(96,'2022-04-14 03:18:54','學(xué)號(hào)6','姓名6','男','13823888886','角色6','upload/jiankangshangbao_jiankangma6.jpg','upload/jiankangshangbao_xingchengma6.jpg','upload/jiankangshangbao_hesuanbaogao6.jpg','體溫6','備注6','2022-04-14',6,6,'宇宙銀河系地球6號(hào)');
/*!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 '創(chuàng)建時(shí)間',
? `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');
