基于springboot医院碳排放管理平台设计与实现-计算机毕业设计源码+LW文档

系统功能模块设计:

1登录功能,碳排放管理计算功能,后台用户管理功能

登录模块实现:登录页面

主页面模块实现

1用户信息页面,国内国外新闻页面,医院碳排放页面

碳排放计算模块实现

1患者碳排放计算页面

2医护人员碳排放计算页面

3医护车辆碳排放计算页面

4碳排放报表页面

5医院碳排放数据页面

低碳智慧园模块实现

1践行低碳生活页面

2共建低碳校园页面

3碳达峰碳中和页面

系统管理模块实现

1用户管理

2登录日志

3分组管理

开发语言:Java

框架:springboot

JDK版本:JDK1.8

服务器:tomcat7

数据库:mysql 5.7(一定要5.7版本)

数据库工具:Navicat11

开发软件:eclipse/myeclipse/idea

Maven包:Maven3.3.9

浏览器:谷歌浏览器

数据库脚本:

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/1650945028295.png’),(2,’picture2′,’upload/picture2.jpg’),(3,’picture3′,’upload/picture3.jpg’);

/*!40000 ALTER TABLE `config` ENABLE KEYS */;

UNLOCK TABLES;

— Table structure for table `discussditanzhihuiyuan`

DROP TABLE IF EXISTS `discussditanzhihuiyuan`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `discussditanzhihuiyuan` (

  `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=1650944715521 DEFAULT CHARSET=utf8 COMMENT=’低碳智慧园评论表’;

/*!40101 SET character_set_client = @saved_cs_client */;

— Dumping data for table `discussditanzhihuiyuan`

LOCK TABLES `discussditanzhihuiyuan` WRITE;

/*!40000 ALTER TABLE `discussditanzhihuiyuan` DISABLE KEYS */;

INSERT INTO `discussditanzhihuiyuan` VALUES (81,’2022-04-26 03:43:08′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(82,’2022-04-26 03:43:08′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(83,’2022-04-26 03:43:08′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(84,’2022-04-26 03:43:08′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(85,’2022-04-26 03:43:08′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(86,’2022-04-26 03:43:08′,6,6,’用户名6′,’评论内容6′,’回复内容6′),(1650944715520,’2022-04-26 03:45:15′,36,1650944681748,’11’,’这里是评论的地方’,’这里是回复用户评论的地方’);

/*!40000 ALTER TABLE `discussditanzhihuiyuan` ENABLE KEYS */;

UNLOCK TABLES;

— Table structure for table `discussyiyuantanpaifang`

DROP TABLE IF EXISTS `discussyiyuantanpaifang`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `discussyiyuantanpaifang` (

  `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=77 DEFAULT CHARSET=utf8 COMMENT=’医院碳排放评论表’;

/*!40101 SET character_set_client = @saved_cs_client */;

— Dumping data for table `discussyiyuantanpaifang`

LOCK TABLES `discussyiyuantanpaifang` WRITE;

/*!40000 ALTER TABLE `discussyiyuantanpaifang` DISABLE KEYS */;

INSERT INTO `discussyiyuantanpaifang` VALUES (71,’2022-04-26 03:43:08′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(72,’2022-04-26 03:43:08′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(73,’2022-04-26 03:43:08′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(74,’2022-04-26 03:43:08′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(75,’2022-04-26 03:43:08′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(76,’2022-04-26 03:43:08′,6,6,’用户名6′,’评论内容6′,’回复内容6′);

/*!40000 ALTER TABLE `discussyiyuantanpaifang` ENABLE KEYS */;

UNLOCK TABLES;

— Table structure for table `ditanzhihuiyuan`

DROP TABLE IF EXISTS `ditanzhihuiyuan`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ditanzhihuiyuan` (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,

  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,

  `biaoti` varchar(200) NOT NULL COMMENT ‘标题’,

  `fengmian` varchar(200) DEFAULT NULL COMMENT ‘封面’,

  `leixing` varchar(200) NOT NULL COMMENT ‘类型’,

  `tuijianjianyi` varchar(200) DEFAULT NULL COMMENT ‘推荐建议’,

  `zhuyishixiang` varchar(200) DEFAULT NULL COMMENT ‘注意事项’,

  `tanpailiang` float DEFAULT NULL COMMENT ‘碳排量’,

  `jianjie` longtext COMMENT ‘简介’,

  `xiangqing` longtext COMMENT ‘详情’,

  `faburiqi` date DEFAULT NULL COMMENT ‘发布日期’,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1650944923650 DEFAULT CHARSET=utf8 COMMENT=’低碳智慧园’;

/*!40101 SET character_set_client = @saved_cs_client */;

— Dumping data for table `ditanzhihuiyuan`

LOCK TABLES `ditanzhihuiyuan` WRITE;

/*!40000 ALTER TABLE `ditanzhihuiyuan` DISABLE KEYS */;

INSERT INTO `ditanzhihuiyuan` VALUES (31,’2022-04-26 03:43:08′,’标题1′,’upload/ditanzhihuiyuan_fengmian1.jpg’,’践行低碳生活’,’推荐建议1′,’注意事项1′,1,’简介1′,’详情1′,’2022-04-26′),(32,’2022-04-26 03:43:08′,’标题2′,’upload/ditanzhihuiyuan_fengmian2.jpg’,’践行低碳生活’,’推荐建议2′,’注意事项2′,2,’简介2′,’详情2′,’2022-04-26′),(33,’2022-04-26 03:43:08′,’标题3′,’upload/ditanzhihuiyuan_fengmian3.jpg’,’践行低碳生活’,’推荐建议3′,’注意事项3′,3,’简介3′,’详情3′,’2022-04-26′),(34,’2022-04-26 03:43:08′,’标题4′,’upload/ditanzhihuiyuan_fengmian4.jpg’,’践行低碳生活’,’推荐建议4′,’注意事项4′,4,’简介4′,’详情4′,’2022-04-26′),(35,’2022-04-26 03:43:08′,’标题5′,’upload/ditanzhihuiyuan_fengmian5.jpg’,’践行低碳生活’,’推荐建议5′,’注意事项5′,5,’简介5′,’详情5′,’2022-04-26′),(36,’2022-04-26 03:43:08′,’标题6′,’upload/ditanzhihuiyuan_fengmian6.jpg’,’践行低碳生活’,’推荐建议6′,’注意事项6′,6,’简介6′,’详情6′,’2022-04-26′),(1650944923649,’2022-04-26 03:48:43′,’某某低碳信息’,’upload/1650944888719.jpg’,’共建低碳校园’,’这里输入推荐建议’,’这里输入注意事项’,15,’这里输入基本的简介’,'<p>这里输入具体的详情</p><p><img src=\”http://localhost:8080/springbootr392w/upload/1650944921785.jpg\”></p>’,’2022-04-26′);

资源下载: