java毕业设计springboot+vue社区疫情管控管理系统+开发讲解文档

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: 社区疫情管控系统 -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `社区疫情管控系统` -- /*!40000 DROP DATABASE IF EXISTS `社区疫情管控系统`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `社区疫情管控系统` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `社区疫情管控系统`; -- -- Table structure for table `aboutus` -- DROP TABLE IF EXISTS `aboutus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `aboutus` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `title` varchar(200) NOT NULL COMMENT '标题', `subtitle` varchar(200) DEFAULT NULL COMMENT '副标题', `content` longtext NOT NULL COMMENT '内容', `picture1` longtext COMMENT '图片1', `picture2` longtext COMMENT '图片2', `picture3` longtext COMMENT '图片3', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='关于我们'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `aboutus` -- LOCK TABLES `aboutus` WRITE; /*!40000 ALTER TABLE `aboutus` DISABLE KEYS */; INSERT INTO `aboutus` VALUES (1,'2023-03-14 12:54:59','关于我们','ABOUT US','不管你想要怎样的生活，你都要去努力争取，不多尝试一些事情怎么知道自己适合什么、不适合什么呢?\n你说你喜欢读书，让我给你列书单，你还问我哪里有那么多时间看书;你说自己梦想的职业是广告文案，问我如何成为一个文案，应该具备哪些素质;你说你计划晨跑，但总是因为学习、工作辛苦或者身体不舒服第二天起不了床;你说你一直梦想一个人去长途旅行，但是没钱，父母觉得危险。其实，我已经厌倦了你这样说说而已的把戏，我觉得就算我告诉你如何去做，你也不会照做，因为你根本什么都不做。','upload/aboutus_picture1.jpg','upload/aboutus_picture2.jpg','upload/aboutus_picture3.jpg'); /*!40000 ALTER TABLE `aboutus` 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 `discussyiqingdongtai` -- DROP TABLE IF EXISTS `discussyiqingdongtai`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discussyiqingdongtai` ( `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', `avatarurl` longtext COMMENT '头像', `nickname` varchar(200) DEFAULT NULL COMMENT '用户名', `content` longtext NOT NULL COMMENT '评论内容', `reply` longtext COMMENT '回复内容', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1678799262715 DEFAULT CHARSET=utf8 COMMENT='疫情动态评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discussyiqingdongtai` -- LOCK TABLES `discussyiqingdongtai` WRITE; /*!40000 ALTER TABLE `discussyiqingdongtai` DISABLE KEYS */; INSERT INTO `discussyiqingdongtai` VALUES (1678799262714,'2023-03-14 13:07:42',1678799097421,1678798629329,'upload/1678798619946.png','111','2111',NULL); /*!40000 ALTER TABLE `discussyiqingdongtai` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discussyiqingxinxi` -- DROP TABLE IF EXISTS `discussyiqingxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discussyiqingxinxi` ( `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', `avatarurl` longtext COMMENT '头像', `nickname` varchar(200) DEFAULT NULL COMMENT '用户名', `content` longtext NOT NULL COMMENT '评论内容', `reply` longtext COMMENT '回复内容', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='疫情信息评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discussyiqingxinxi` -- LOCK TABLES `discussyiqingxinxi` WRITE; /*!40000 ALTER TABLE `discussyiqingxinxi` DISABLE KEYS */; /*!40000 ALTER TABLE `discussyiqingxinxi` 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 '创建时间', `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号', `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名', `shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码', `menpaihao` varchar(200) DEFAULT NULL COMMENT '门牌号', `tianbaoriqi` date DEFAULT NULL COMMENT '填报日期', `shifoufare` varchar(200) DEFAULT NULL COMMENT '是否发热', `shifoukesou` varchar(200) DEFAULT NULL COMMENT '是否咳嗽', `shifouxiongmen` varchar(200) DEFAULT NULL COMMENT '是否胸闷', `shifouquezhen` varchar(200) DEFAULT NULL COMMENT '是否确诊', `jichubing` varchar(200) DEFAULT NULL COMMENT '基础病', `shifouganran` varchar(200) DEFAULT NULL COMMENT '是否感染', `tiwen` varchar(200) DEFAULT NULL COMMENT '体温', `jiankangma` longtext COMMENT '健康码', `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核', `shhf` longtext COMMENT '审核回复', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1678798747386 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 (31,'2023-03-14 12:54:59','用户账号1','用户姓名1','手机号码1','门牌号1','2023-03-14','否','否','否','否','否','否','体温1','upload/jiankangshangbao_jiankangma1.jpg,upload/jiankangshangbao_jiankangma2.jpg,upload/jiankangshangbao_jiankangma3.jpg','