基于ssm的體育場館運(yùn)營設(shè)計與實現(xiàn)-計算機(jī)畢業(yè)設(shè)計源碼+LW文檔
開發(fā)語言：Java
框架：ssm
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ù)庫關(guān)鍵代碼：
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 '創(chuàng)建時間',
? `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 '創(chuàng)建時間',
? `changdimingcheng` varchar(200) NOT NULL COMMENT '場地名稱',
? `changdileixing` varchar(200) NOT NULL COMMENT '場地類型',
? `changditupian` varchar(200) DEFAULT NULL COMMENT '場地圖片',
? `changdiquyu` varchar(200) NOT NULL COMMENT '場地區(qū)域',
? `keyueshijian` varchar(200) DEFAULT NULL COMMENT '可約時間',
? `shijiage` int(11) NOT NULL COMMENT '時價格',
? `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
? `changdixiangqing` longtext COMMENT '場地詳情',
? `renci` int(11) NOT NULL COMMENT '人次',
? `clicktime` datetime DEFAULT NULL COMMENT '最近點擊時間',
? `clicknum` int(11) DEFAULT '0' COMMENT '點擊次數(shù)',
? 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','場地區(qū)域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','場地區(qū)域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','場地區(qū)域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','場地區(qū)域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','場地區(qū)域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','場地區(qū)域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 '創(chuàng)建時間',
? `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '訂單編號',
? `changdimingcheng` varchar(200) NOT NULL COMMENT '場地名稱',
? `changdileixing` varchar(200) NOT NULL COMMENT '場地類型',
? `changdiquyu` varchar(200) NOT NULL COMMENT '場地區(qū)域',
? `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 '聯(lián)系電話',
? `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 '手機(jī)',
? `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='場地預(yù)約';
/*!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','場地區(qū)域1','2022-03-11 11:01:36',1,1,1,'13823888881','場地詳情1',1,'賬號1','姓名1','手機(jī)1','2022-03-11 11:01:36','未支付'),(72,'2022-03-11 03:01:36','2222222222','場地名稱2','場地類型2','場地區(qū)域2','2022-03-11 11:01:36',2,2,2,'13823888882','場地詳情2',2,'賬號2','姓名2','手機(jī)2','2022-03-11 11:01:36','未支付'),(73,'2022-03-11 03:01:36','3333333333','場地名稱3','場地類型3','場地區(qū)域3','2022-03-11 11:01:36',3,3,3,'13823888883','場地詳情3',3,'賬號3','姓名3','手機(jī)3','2022-03-11 11:01:36','未支付'),(74,'2022-03-11 03:01:36','4444444444','場地名稱4','場地類型4','場地區(qū)域4','2022-03-11 11:01:36',4,4,4,'13823888884','場地詳情4',4,'賬號4','姓名4','手機(jī)4','2022-03-11 11:01:36','未支付'),(75,'2022-03-11 03:01:36','5555555555','場地名稱5','場地類型5','場地區(qū)域5','2022-03-11 11:01:36',5,5,5,'13823888885','場地詳情5',5,'賬號5','姓名5','手機(jī)5','2022-03-11 11:01:36','未支付'),(76,'2022-03-11 03:01:36','6666666666','場地名稱6','場地類型6','場地區(qū)域6','2022-03-11 11:01:36',6,6,6,'13823888886','場地詳情6',6,'賬號6','姓名6','手機(jī)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 '創(chuàng)建時間',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `adminid` bigint(20) DEFAULT NULL COMMENT '管理員id',
? `ask` longtext COMMENT '提問',
? `reply` longtext COMMENT '回復(fù)',
? `isreply` int(11) DEFAULT NULL COMMENT '是否回復(fù)',
? 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','回復(fù)1',1),(212,'2022-03-11 03:01:36',2,2,'提問2','回復(fù)2',2),(213,'2022-03-11 03:01:36',3,3,'提問3','回復(fù)3',3),(214,'2022-03-11 03:01:36',4,4,'提問4','回復(fù)4',4),(215,'2022-03-11 03:01:36',5,5,'提問5','回復(fù)5',5),(216,'2022-03-11 03:01:36',6,6,'提問6','回復(fù)6',6),(1646967930647,'2022-03-11 03:05:30',21,NULL,'1阿斯蒂芬按時撒',NULL,0),(1646968008843,'2022-03-11 03:06:48',21,31,NULL,'阿斯達(dá)分撒旦按時',NULL);
/*!40000 ALTER TABLE `chat` ENABLE KEYS */;
UNLOCK TABLES;
--
