基于springboot园区管理系统的设计与实现-计算机毕业设计源码+LW文档
开发语言：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/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fuwuxinxi`
--
DROP TABLE IF EXISTS `fuwuxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuwuxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`fuwubianhao` varchar(200) DEFAULT NULL COMMENT '服务编号',
`fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服务类型',
`fuwushijian` datetime DEFAULT NULL COMMENT '服务时间',
`fuwurenyuan` varchar(200) DEFAULT NULL COMMENT '服务人员',
`fuwufeiyong` float DEFAULT NULL COMMENT '服务费用',
`fuwuzhangdan` longtext COMMENT '服务账单',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`dingdanzhuangtai` varchar(200) DEFAULT NULL COMMENT '订单状态',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`),
UNIQUE KEY `fuwubianhao` (`fuwubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='服务信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fuwuxinxi`
--
LOCK TABLES `fuwuxinxi` WRITE;
/*!40000 ALTER TABLE `fuwuxinxi` DISABLE KEYS */;
INSERT INTO `fuwuxinxi` VALUES (81,'2022-05-14 08:33:13','1111111111','服务类型1','2022-05-14 16:33:13','服务人员1',1,'服务账单1','用户账号1','用户姓名1','进行中','未支付'),(82,'2022-05-14 08:33:13','2222222222','服务类型2','2022-05-14 16:33:13','服务人员2',2,'服务账单2','用户账号2','用户姓名2','进行中','未支付'),(83,'2022-05-14 08:33:13','3333333333','服务类型3','2022-05-14 16:33:13','服务人员3',3,'服务账单3','用户账号3','用户姓名3','进行中','未支付'),(84,'2022-05-14 08:33:13','4444444444','服务类型4','2022-05-14 16:33:13','服务人员4',4,'服务账单4','用户账号4','用户姓名4','进行中','未支付'),(85,'2022-05-14 08:33:13','5555555555','服务类型5','2022-05-14 16:33:13','服务人员5',5,'服务账单5','用户账号5','用户姓名5','进行中','未支付'),(86,'2022-05-14 08:33:13','6666666666','服务类型6','2022-05-14 16:33:13','服务人员6',6,'服务账单6','用户账号6','用户姓名6','进行中','未支付');
/*!40000 ALTER TABLE `fuwuxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fuwuyuyue`
--
DROP TABLE IF EXISTS `fuwuyuyue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuwuyuyue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yuyuebianhao` varchar(200) DEFAULT NULL COMMENT '预约编号',
`fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服务类型',
`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`yuyueshijian` datetime DEFAULT NULL COMMENT '预约时间',
`dizhi` varchar(200) DEFAULT NULL COMMENT '地址',
`yuyuexiangqing` longtext COMMENT '预约详情',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`zhuangtai` varchar(200) DEFAULT NULL COMMENT '状态',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`),
UNIQUE KEY `yuyuebianhao` (`yuyuebianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='服务预约';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fuwuyuyue`
--
LOCK TABLES `fuwuyuyue` WRITE;
/*!40000 ALTER TABLE `fuwuyuyue` DISABLE KEYS */;
INSERT INTO `fuwuyuyue` VALUES (71,'2022-05-14 08:33:13','1111111111','保洁','备注1','upload/fuwuyuyue_tupian1.jpg','2022-05-14 16:33:13','地址1','预约详情1','用户账号1','用户姓名1','已接单','是',''),(72,'2022-05-14 08:33:13','2222222222','保洁','备注2','upload/fuwuyuyue_tupian2.jpg','2022-05-14 16:33:13','地址2','预约详情2','用户账号2','用户姓名2','已接单','是',''),(73,'2022-05-14 08:33:13','3333333333','保洁','备注3','upload/fuwuyuyue_tupian3.jpg','2022-05-14 16:33:13','地址3','预约详情3','用户账号3','用户姓名3','已接单','是',''),(74,'2022-05-14 08:33:13','4444444444','保洁','备注4','upload/fuwuyuyue_tupian4.jpg','2022-05-14 16:33:13','地址4','预约详情4','用户账号4','用户姓名4','已接单','是',''),(75,'2022-05-14 08:33:13','5555555555','保洁','备注5','upload/fuwuyuyue_tupian5.jpg','2022-05-14 16:33:13','地址5','预约详情5','用户账号5','用户姓名5','已接单','是',''),(76,'2022-05-14 08:33:13','6666666666','保洁','备注6','upload/fuwuyuyue_tupian6.jpg','2022-05-14 16:33:13','地址6','预约详情6','用户账号6','用户姓名6','已接单','是','');
/*!40000 ALTER TABLE `fuwuyuyue` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiaofeixinxi`
--
DROP TABLE IF EXISTS `jiaofeixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaofeixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhangdanbianhao` varchar(200) DEFAULT NULL COMMENT '账单编号',
`jiaofeibiaoti` varchar(200) DEFAULT NULL COMMENT '缴费标题',
`shoufeileibie` varchar(200) DEFAULT NULL COMMENT '收费类别',
`meidujiage` float DEFAULT NULL COMMENT '每度价格',
`shuliang` int(11) DEFAULT NULL COMMENT '数量',
`feiyong` float DEFAULT NULL COMMENT '费用',
`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
`zhangdanxiangqing` longtext COMMENT '账单详情',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`),
UNIQUE KEY `zhangdanbianhao` (`zhangdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='缴费信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiaofeixinxi`
--
LOCK TABLES `jiaofeixinxi` WRITE;
/*!40000 ALTER TABLE `jiaofeixinxi` DISABLE KEYS */;
INSERT INTO `jiaofeixinxi` VALUES (91,'2022-05-14 08:33:13','1111111111','缴费标题1','收费类别1',1,1,1,'备注1','账单详情1','用户账号1','用户姓名1','未支付'),(92,'2022-05-14 08:33:13','2222222222','缴费标题2','收费类别2',2,2,2,'备注2','账单详情2','用户账号2','用户姓名2','未支付'),(93,'2022-05-14 08:33:13','3333333333','缴费标题3','收费类别3',3,3,3,'备注3','账单详情3','用户账号3','用户姓名3','未支付'),(94,'2022-05-14 08:33:13','4444444444','缴费标题4','收费类别4',4,4,4,'备注4','账单详情4','用户账号4','用户姓名4','未支付'),(95,'2022-05-14 08:33:13','5555555555','缴费标题5','收费类别5',5,5,5,'备注5','账单详情5','用户账号5','用户姓名5','未支付'),(96,'2022-05-14 08:33:13','6666666666','缴费标题6','收费类别6',6,6,6,'备注6','账单详情6','用户账号6','用户姓名6','未支付');
/*!40000 ALTER TABLE `jiaofeixinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`introduction` longtext COMMENT '简介',
`picture` varchar(200) NOT NULL COMMENT '图片',
`content` longtext NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='园区新闻';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `shenqingchewei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shenqingchewei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shenqingbianhao` varchar(200) DEFAULT NULL COMMENT '申请编号',
`tingchechangmingcheng` varchar(200) DEFAULT NULL COMMENT '停车场名称',
`feiyong` float DEFAULT NULL COMMENT '费用',
`shenqingshijian` datetime DEFAULT NULL COMMENT '申请时间',
`shenqingbeizhu` longtext COMMENT '申请备注',
`shenqingfujian` varchar(200) DEFAULT NULL COMMENT '申请附件',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`),
UNIQUE KEY `shenqingbianhao` (`shenqingbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='申请车位';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shenqingchewei`
--
LOCK TABLES `shenqingchewei` WRITE;
/*!40000 ALTER TABLE `shenqingchewei` DISABLE KEYS */;
INSERT INTO `shenqingchewei` VALUES (61,'2022-05-14 08:33:13','1111111111','停车场名称1',1,'2022-05-14 16:33:13','申请备注1','','用户账号1','用户姓名1','是','','未支付'),(62,'2022-05-14 08:33:13','2222222222','停车场名称2',2,'2022-05-14 16:33:13','申请备注2','','用户账号2','用户姓名2','是','','未支付'),(63,'2022-05-14 08:33:13','3333333333','停车场名称3',3,'2022-05-14 16:33:13','申请备注3','','用户账号3','用户姓名3','是','','未支付'),(64,'2022-05-14 08:33:13','4444444444','停车场名称4',4,'2022-05-14 16:33:13','申请备注4','','用户账号4','用户姓名4','是','','未支付'),(65,'2022-05-14 08:33:13','5555555555','停车场名称5',5,'2022-05-14 16:33:13','申请备注5','','用户账号5','用户姓名5','是','','未支付'),(66,'2022-05-14 08:33:13','6666666666','停车场名称6',6,'2022-05-14 16:33:13','申请备注6','','用户账号6','用户姓名6','是','','未支付');
/*!40000 ALTER TABLE `shenqingchewei` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shoufeibiaozhun`
--
DROP TABLE IF EXISTS `shoufeibiaozhun`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shoufeibiaozhun` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yuanqubianhao` varchar(200) DEFAULT NULL COMMENT '园区编号',
`yuanqumingcheng` varchar(200) DEFAULT NULL COMMENT '园区名称',
`yuanqumianji` varchar(200) DEFAULT NULL COMMENT '园区面积',
`meipingshoufei` float DEFAULT NULL COMMENT '每平收费',
`yuanqujianjie` longtext COMMENT '园区简介',
PRIMARY KEY (`id`),
UNIQUE KEY `yuanqubianhao` (`yuanqubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='收费标准';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shoufeibiaozhun`
--
LOCK TABLES `shoufeibiaozhun` WRITE;
/*!40000 ALTER TABLE `shoufeibiaozhun` DISABLE KEYS */;
INSERT INTO `shoufeibiaozhun` VALUES (21,'2022-05-14 08:33:13','1111111111','园区名称1','园区面积1',1,'园区简介1'),(22,'2022-05-14 08:33:13','2222222222','园区名称2','园区面积2',2,'园区简介2'),(23,'2022-05-14 08:33:13','3333333333','园区名称3','园区面积3',3,'园区简介3'),(24,'2022-05-14 08:33:13','4444444444','园区名称4','园区面积4',4,'园区简介4'),(25,'2022-05-14 08:33:13','5555555555','园区名称5','园区面积5',5,'园区简介5'),(26,'2022-05-14 08:33:13','6666666666','园区名称6','园区面积6',6,'园区简介6');
/*!40000 ALTER TABLE `shoufeibiaozhun` ENABLE KEYS */;
UNLOCK TABLES;
