开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库关键代码：
DROP TABLE IF EXISTS `changdileixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `changdileixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`changdileixing` varchar(200) NOT NULL COMMENT ‘场地类型’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT=’场地类型’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `changdileixing`
—
LOCK TABLES `changdileixing` WRITE;
/*!40000 ALTER TABLE `changdileixing` DISABLE KEYS */;
INSERT INTO `changdileixing` VALUES (51,’2022-03-11 03:01:36′,’场地类型1′),(52,’2022-03-11 03:01:36′,’场地类型2′),(53,’2022-03-11 03:01:36′,’场地类型3′),(54,’2022-03-11 03:01:36′,’场地类型4′),(55,’2022-03-11 03:01:36′,’场地类型5′),(56,’2022-03-11 03:01:36′,’场地类型6′);
/*!40000 ALTER TABLE `changdileixing` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `changdixinxi`
—
DROP TABLE IF EXISTS `changdixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `changdixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`changdimingcheng` varchar(200) NOT NULL COMMENT ‘场地名称’,
`changdileixing` varchar(200) NOT NULL COMMENT ‘场地类型’,
`changditupian` varchar(200) DEFAULT NULL COMMENT ‘场地图片’,
`changdiquyu` varchar(200) NOT NULL COMMENT ‘场地区域’,
`keyueshijian` varchar(200) DEFAULT NULL COMMENT ‘可约时间’,
`shijiage` int(11) NOT NULL COMMENT ‘时价格’,
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT ‘联系电话’,
`changdixiangqing` longtext COMMENT ‘场地详情’,
`renci` int(11) NOT NULL COMMENT ‘人次’,
`clicktime` datetime DEFAULT NULL COMMENT ‘最近点击时间’,
`clicknum` int(11) DEFAULT ‘0’ COMMENT ‘点击次数’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT=’场地信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `changdixinxi`
—
LOCK TABLES `changdixinxi` WRITE;
/*!40000 ALTER TABLE `changdixinxi` DISABLE KEYS */;
INSERT INTO `changdixinxi` VALUES (61,’2022-03-11 03:01:36′,’场地名称1′,’场地类型1′,’upload/changdixinxi_changditupian1.jpg’,’场地区域1′,’可约时间1′,1,’13823888881′,’场地详情1′,1,’2022-03-11 11:01:36′,1),(62,’2022-03-11 03:01:36′,’场地名称2′,’场地类型2′,’upload/changdixinxi_changditupian2.jpg’,’场地区域2′,’可约时间2′,2,’13823888882′,’场地详情2′,2,’2022-03-11 11:03:27′,3),(63,’2022-03-11 03:01:36′,’场地名称3′,’场地类型3′,’upload/changdixinxi_changditupian3.jpg’,’场地区域3′,’可约时间3′,3,’13823888883′,’场地详情3′,3,’2022-03-11 11:01:36′,3),(64,’2022-03-11 03:01:36′,’场地名称4′,’场地类型4′,’upload/changdixinxi_changditupian4.jpg’,’场地区域4′,’可约时间4′,4,’13823888884′,’场地详情4′,4,’2022-03-11 11:01:36′,4),(65,’2022-03-11 03:01:36′,’场地名称5′,’场地类型5′,’upload/changdixinxi_changditupian5.jpg’,’场地区域5′,’可约时间5′,5,’13823888885′,’场地详情5′,5,’2022-03-11 11:01:36′,5),(66,’2022-03-11 03:01:36′,’场地名称6′,’场地类型6′,’upload/changdixinxi_changditupian6.jpg’,’场地区域6′,’可约时间6′,6,’13823888886′,’场地详情6′,6,’2022-03-11 11:01:36′,6);
/*!40000 ALTER TABLE `changdixinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `changdiyuyue`
—
DROP TABLE IF EXISTS `changdiyuyue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `changdiyuyue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT ‘订单编号’,
`changdimingcheng` varchar(200) NOT NULL COMMENT ‘场地名称’,
`changdileixing` varchar(200) NOT NULL COMMENT ‘场地类型’,
`changdiquyu` varchar(200) NOT NULL COMMENT ‘场地区域’,
`kaishishijian` datetime NOT NULL COMMENT ‘开始时间’,
`shijiage` int(11) NOT NULL COMMENT ‘时价格’,
`shizhang` int(11) NOT NULL COMMENT ‘时长’,
`zongjia` int(11) DEFAULT NULL COMMENT ‘总价’,
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT ‘联系电话’,
`changdixiangqing` longtext COMMENT ‘场地详情’,
`renci` int(11) NOT NULL COMMENT ‘人次’,
`zhanghao` varchar(200) DEFAULT NULL COMMENT ‘账号’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`shouji` varchar(200) DEFAULT NULL COMMENT ‘手机’,
`xiadanshijian` datetime DEFAULT NULL COMMENT ‘下单时间’,
`ispay` varchar(200) DEFAULT ‘未支付’ COMMENT ‘是否支付’,
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT=’场地预约’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `changdiyuyue`
—
LOCK TABLES `changdiyuyue` WRITE;
/*!40000 ALTER TABLE `changdiyuyue` DISABLE KEYS */;
INSERT INTO `changdiyuyue` VALUES (71,’2022-03-11 03:01:36′,’1111111111′,’场地名称1′,’场地类型1′,’场地区域1′,’2022-03-11 11:01:36′,1,1,1,’13823888881′,’场地详情1′,1,’账号1′,’姓名1′,’手机1′,’2022-03-11 11:01:36′,’未支付’),(72,’2022-03-11 03:01:36′,’2222222222′,’场地名称2′,’场地类型2′,’场地区域2′,’2022-03-11 11:01:36′,2,2,2,’13823888882′,’场地详情2′,2,’账号2′,’姓名2′,’手机2′,’2022-03-11 11:01:36′,’未支付’),(73,’2022-03-11 03:01:36′,’3333333333′,’场地名称3′,’场地类型3′,’场地区域3′,’2022-03-11 11:01:36′,3,3,3,’13823888883′,’场地详情3′,3,’账号3′,’姓名3′,’手机3′,’2022-03-11 11:01:36′,’未支付’),(74,’2022-03-11 03:01:36′,’4444444444′,’场地名称4′,’场地类型4′,’场地区域4′,’2022-03-11 11:01:36′,4,4,4,’13823888884′,’场地详情4′,4,’账号4′,’姓名4′,’手机4′,’2022-03-11 11:01:36′,’未支付’),(75,’2022-03-11 03:01:36′,’5555555555′,’场地名称5′,’场地类型5′,’场地区域5′,’2022-03-11 11:01:36′,5,5,5,’13823888885′,’场地详情5′,5,’账号5′,’姓名5′,’手机5′,’2022-03-11 11:01:36′,’未支付’),(76,’2022-03-11 03:01:36′,’6666666666′,’场地名称6′,’场地类型6′,’场地区域6′,’2022-03-11 11:01:36′,6,6,6,’13823888886′,’场地详情6′,6,’账号6′,’姓名6′,’手机6′,’2022-03-11 11:01:36′,’未支付’);
/*!40000 ALTER TABLE `changdiyuyue` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `chat`
—
DROP TABLE IF EXISTS `chat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`userid` bigint(20) NOT NULL COMMENT ‘用户id’,
`adminid` bigint(20) DEFAULT NULL COMMENT ‘管理员id’,
`ask` longtext COMMENT ‘提问’,
`reply` longtext COMMENT ‘回复’,
`isreply` int(11) DEFAULT NULL COMMENT ‘是否回复’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646968008844 DEFAULT CHARSET=utf8 COMMENT=’在线咨询’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `chat`
—
LOCK TABLES `chat` WRITE;
/*!40000 ALTER TABLE `chat` DISABLE KEYS */;
INSERT INTO `chat` VALUES (211,’2022-03-11 03:01:36′,1,1,’提问1′,’回复1′,1),(212,’2022-03-11 03:01:36′,2,2,’提问2′,’回复2′,2),(213,’2022-03-11 03:01:36′,3,3,’提问3′,’回复3′,3),(214,’2022-03-11 03:01:36′,4,4,’提问4′,’回复4′,4),(215,’2022-03-11 03:01:36′,5,5,’提问5′,’回复5′,5),(216,’2022-03-11 03:01:36′,6,6,’提问6′,’回复6′,6),(1646967930647,’2022-03-11 03:05:30′,21,NULL,’1阿斯蒂芬按时撒’,NULL,0),(1646968008843,’2022-03-11 03:06:48′,21,31,NULL,’阿斯达分撒旦按时’,NULL);
/*!40000 ALTER TABLE `chat` ENABLE KEYS */;
UNLOCK TABLES;
—