基于springboot園區(qū)管理系統(tǒng)的設(shè)計與實現(xiàn)-計算機畢業(yè)設(shè)計源碼+LW文檔
開發(fā)語言：Java
框架：springboot
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫腳本：
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ù)名稱',
? `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 `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 '創(chuàng)建時間',
? `fuwubianhao` varchar(200) DEFAULT NULL COMMENT '服務(wù)編號',
? `fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服務(wù)類型',
? `fuwushijian` datetime DEFAULT NULL COMMENT '服務(wù)時間',
? `fuwurenyuan` varchar(200) DEFAULT NULL COMMENT '服務(wù)人員',
? `fuwufeiyong` float DEFAULT NULL COMMENT '服務(wù)費用',
? `fuwuzhangdan` longtext COMMENT '服務(wù)賬單',
? `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用戶賬號',
? `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用戶姓名',
? `dingdanzhuangtai` varchar(200) DEFAULT NULL COMMENT '訂單狀態(tài)',
? `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
? PRIMARY KEY (`id`),
? UNIQUE KEY `fuwubianhao` (`fuwubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='服務(wù)信息';
/*!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','服務(wù)類型1','2022-05-14 16:33:13','服務(wù)人員1',1,'服務(wù)賬單1','用戶賬號1','用戶姓名1','進行中','未支付'),(82,'2022-05-14 08:33:13','2222222222','服務(wù)類型2','2022-05-14 16:33:13','服務(wù)人員2',2,'服務(wù)賬單2','用戶賬號2','用戶姓名2','進行中','未支付'),(83,'2022-05-14 08:33:13','3333333333','服務(wù)類型3','2022-05-14 16:33:13','服務(wù)人員3',3,'服務(wù)賬單3','用戶賬號3','用戶姓名3','進行中','未支付'),(84,'2022-05-14 08:33:13','4444444444','服務(wù)類型4','2022-05-14 16:33:13','服務(wù)人員4',4,'服務(wù)賬單4','用戶賬號4','用戶姓名4','進行中','未支付'),(85,'2022-05-14 08:33:13','5555555555','服務(wù)類型5','2022-05-14 16:33:13','服務(wù)人員5',5,'服務(wù)賬單5','用戶賬號5','用戶姓名5','進行中','未支付'),(86,'2022-05-14 08:33:13','6666666666','服務(wù)類型6','2022-05-14 16:33:13','服務(wù)人員6',6,'服務(wù)賬單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 '創(chuàng)建時間',
? `yuyuebianhao` varchar(200) DEFAULT NULL COMMENT '預(yù)約編號',
? `fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服務(wù)類型',
? `beizhu` varchar(200) DEFAULT NULL COMMENT '備注',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? `yuyueshijian` datetime DEFAULT NULL COMMENT '預(yù)約時間',
? `dizhi` varchar(200) DEFAULT NULL COMMENT '地址',
? `yuyuexiangqing` longtext COMMENT '預(yù)約詳情',
? `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用戶賬號',
? `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用戶姓名',
? `zhuangtai` varchar(200) DEFAULT NULL COMMENT '狀態(tài)',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? PRIMARY KEY (`id`),
? UNIQUE KEY `yuyuebianhao` (`yuyuebianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='服務(wù)預(yù)約';
/*!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','預(yù)約詳情1','用戶賬號1','用戶姓名1','已接單','是',''),(72,'2022-05-14 08:33:13','2222222222','保潔','備注2','upload/fuwuyuyue_tupian2.jpg','2022-05-14 16:33:13','地址2','預(yù)約詳情2','用戶賬號2','用戶姓名2','已接單','是',''),(73,'2022-05-14 08:33:13','3333333333','保潔','備注3','upload/fuwuyuyue_tupian3.jpg','2022-05-14 16:33:13','地址3','預(yù)約詳情3','用戶賬號3','用戶姓名3','已接單','是',''),(74,'2022-05-14 08:33:13','4444444444','保潔','備注4','upload/fuwuyuyue_tupian4.jpg','2022-05-14 16:33:13','地址4','預(yù)約詳情4','用戶賬號4','用戶姓名4','已接單','是',''),(75,'2022-05-14 08:33:13','5555555555','保潔','備注5','upload/fuwuyuyue_tupian5.jpg','2022-05-14 16:33:13','地址5','預(yù)約詳情5','用戶賬號5','用戶姓名5','已接單','是',''),(76,'2022-05-14 08:33:13','6666666666','保潔','備注6','upload/fuwuyuyue_tupian6.jpg','2022-05-14 16:33:13','地址6','預(yù)約詳情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 '創(chuàng)建時間',
? `zhangdanbianhao` varchar(200) DEFAULT NULL COMMENT '賬單編號',
? `jiaofeibiaoti` varchar(200) DEFAULT NULL COMMENT '繳費標(biāo)題',
? `shoufeileibie` varchar(200) DEFAULT NULL COMMENT '收費類別',
? `meidujiage` float DEFAULT NULL COMMENT '每度價格',
? `shuliang` int(11) DEFAULT NULL COMMENT '數(shù)量',
? `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','繳費標(biāo)題1','收費類別1',1,1,1,'備注1','賬單詳情1','用戶賬號1','用戶姓名1','未支付'),(92,'2022-05-14 08:33:13','2222222222','繳費標(biāo)題2','收費類別2',2,2,2,'備注2','賬單詳情2','用戶賬號2','用戶姓名2','未支付'),(93,'2022-05-14 08:33:13','3333333333','繳費標(biāo)題3','收費類別3',3,3,3,'備注3','賬單詳情3','用戶賬號3','用戶姓名3','未支付'),(94,'2022-05-14 08:33:13','4444444444','繳費標(biāo)題4','收費類別4',4,4,4,'備注4','賬單詳情4','用戶賬號4','用戶姓名4','未支付'),(95,'2022-05-14 08:33:13','5555555555','繳費標(biāo)題5','收費類別5',5,5,5,'備注5','賬單詳情5','用戶賬號5','用戶姓名5','未支付'),(96,'2022-05-14 08:33:13','6666666666','繳費標(biāo)題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 '創(chuàng)建時間',
? `title` varchar(200) NOT NULL COMMENT '標(biāo)題',
? `introduction` longtext COMMENT '簡介',
? `picture` varchar(200) NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='園區(qū)新聞';
/*!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 '創(chuàng)建時間',
? `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 '審核回復(fù)',
? `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 '創(chuàng)建時間',
? `yuanqubianhao` varchar(200) DEFAULT NULL COMMENT '園區(qū)編號',
? `yuanqumingcheng` varchar(200) DEFAULT NULL COMMENT '園區(qū)名稱',
? `yuanqumianji` varchar(200) DEFAULT NULL COMMENT '園區(qū)面積',
? `meipingshoufei` float DEFAULT NULL COMMENT '每平收費',
? `yuanqujianjie` longtext COMMENT '園區(qū)簡介',
? PRIMARY KEY (`id`),
? UNIQUE KEY `yuanqubianhao` (`yuanqubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='收費標(biāo)準(zhǔn)';
/*!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','園區(qū)名稱1','園區(qū)面積1',1,'園區(qū)簡介1'),(22,'2022-05-14 08:33:13','2222222222','園區(qū)名稱2','園區(qū)面積2',2,'園區(qū)簡介2'),(23,'2022-05-14 08:33:13','3333333333','園區(qū)名稱3','園區(qū)面積3',3,'園區(qū)簡介3'),(24,'2022-05-14 08:33:13','4444444444','園區(qū)名稱4','園區(qū)面積4',4,'園區(qū)簡介4'),(25,'2022-05-14 08:33:13','5555555555','園區(qū)名稱5','園區(qū)面積5',5,'園區(qū)簡介5'),(26,'2022-05-14 08:33:13','6666666666','園區(qū)名稱6','園區(qū)面積6',6,'園區(qū)簡介6');
/*!40000 ALTER TABLE `shoufeibiaozhun` ENABLE KEYS */;
UNLOCK TABLES;
