开发语言: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;