1500字范文 > 微信小程序场地预约系统+后台管理系统SSM-JAVA【数据库设计论文源码开题报告】

微信小程序场地预约系统+后台管理系统SSM-JAVA【数据库设计论文源码开题报告】

时间：2023-10-16 01:37:33

功能介绍

本系统实现的是和场地相关的信息管理和发布，加入了场地公告的功能。

操作角色为管理员和用户。

管理员的功能为场地类型管理、场地管理、用户管理、预约管理、取消申请管理、退回押金管理；

用户的功能为查询场地、预约场地、支付费用和使用场地、退回押金、取消预约。本系统的功能涵盖到场地相关的方方面面，使爱好运动的用户可以有专业的平台进行场地预约。

数据库脚本

-- Current Database: `ssma582q`--/*!40000 DROP DATABASE IF EXISTS `ssma582q`*/;CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssma582q` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;USE `ssma582q`;---- Table structure for table `changdileixing`--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`),UNIQUE KEY `changdileixing` (`changdileixing`)) ENGINE=InnoDB AUTO_INCREMENT=1645409453687 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 (21,'-02-20 09:26:26','篮球'),(22,'-02-20 09:26:26','羽毛球'),(23,'-02-20 09:26:26','乒乓球'),(24,'-02-20 09:26:26','足球'),(25,'-02-20 09:26:26','橄榄球'),(26,'-02-20 09:26:26','排球'),(1645409453686,'-02-21 02:10:52','网球');/*!40000 ALTER TABLE `changdileixing` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `changdishiyong`--DROP TABLE IF EXISTS `changdishiyong`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `changdishiyong` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`yuyuebianhao` varchar(200) DEFAULT NULL COMMENT '预约编号',`changdimingcheng` varchar(200) DEFAULT NULL COMMENT '场地名称',`changdileixing` varchar(200) DEFAULT NULL COMMENT '场地类型',`yajin` int(11) DEFAULT NULL COMMENT '押金',`shijianchangci` datetime DEFAULT NULL COMMENT '时间场次',`shiyongshijian` datetime DEFAULT NULL COMMENT '使用时间',`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',`dianhua` varchar(200) DEFAULT NULL COMMENT '电话',`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',`shhf` longtext COMMENT '审核回复',`userid` bigint(20) DEFAULT NULL COMMENT '用户id',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1645408868735 DEFAULT CHARSET=utf8 COMMENT='场地使用';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `changdishiyong`--LOCK TABLES `changdishiyong` WRITE;/*!40000 ALTER TABLE `changdishiyong` DISABLE KEYS */;INSERT INTO `changdishiyong` VALUES (51,'-02-20 09:26:26','预约编号1','场地名称1','场地类型1',1,'-02-20 17:26:26','-02-20 17:26:26','账号1','姓名1','13823888881','是','',1),(52,'-02-20 09:26:26','预约编号2','场地名称2','场地类型2',2,'-02-20 17:26:26','-02-20 17:26:26','账号2','姓名2','13823888882','是','',2),(53,'-02-20 09:26:26','预约编号3','场地名称3','场地类型3',3,'-02-20 17:26:26','-02-20 17:26:26','账号3','姓名3','13823888883','是','',3),(54,'-02-20 09:26:26','预约编号4','场地名称4','场地类型4',4,'-02-20 17:26:26','-02-20 17:26:26','账号4','姓名4','13823888884','是','',4),(55,'-02-20 09:26:26','预约编号5','场地名称5','场地类型5',5,'-02-20 17:26:26','-02-20 17:26:26','账号5','姓名5','13823888885','是','',5),(56,'-02-20 09:26:26','预约编号6','场地名称6','场地类型6',6,'-02-20 17:26:26','-02-20 17:26:26','账号6','姓名6','13823888886','是','',6),(1645408868734,'-02-21 02:01:08','1645408704694','场地名称5','羽毛球',5,'-02-21 09:58:24','-02-21 10:01:02','11','依依','13823813811','是','',1645408653755);/*!40000 ALTER TABLE `changdishiyong` 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 '场地图片',`zhuangtai` varchar(200) DEFAULT NULL COMMENT '状态',`yajin` int(11) NOT NULL COMMENT '押金',`changdixiangqing` longtext COMMENT '场地详情',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1645409526116 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 (31,'-02-20 09:26:26','场地名称1','篮球','upload/changdixinxi_changditupian1.jpg','空场地',1,'场地详情1'),(32,'-02-20 09:26:26','场地名称2','排球','upload/changdixinxi_changditupian2.jpg','空场地',2,'场地详情2'),(33,'-02-20 09:26:26','场地名称3','橄榄球','upload/changdixinxi_changditupian3.jpg','已预约',3,'场地详情3'),(34,'-02-20 09:26:26','场地名称4','足球','upload/changdixinxi_changditupian4.jpg','已预约',4,'场地详情4'),(35,'-02-20 09:26:26','场地名称5','羽毛球','upload/changdixinxi_changditupian5.jpg','空场地',5,'场地详情5'),(36,'-02-20 09:26:26','场地名称6','乒乓球','upload/changdixinxi_changditupian6.jpg','已预约',6,'场地详情6'),(1645409526115,'-02-21 02:12:05','1号网球场','网球','upload/1645409511526.jpg','空场地',11,'双方的太过于后瑟夫认同感和的人功夫二十多个他');/*!40000 ALTER TABLE `changdixinxi` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `config`--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/1645409623208.jpg');/*!40000 ALTER TABLE `config` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `discusschangdixinxi`--DROP TABLE IF EXISTS `discusschangdixinxi`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `discusschangdixinxi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`refid` bigint(20) NOT NULL COMMENT '关联表id',`userid` bigint(20) NOT NULL COMMENT '用户id',`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',`content` longtext NOT NULL COMMENT '评论内容',`reply` longtext COMMENT '回复内容',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1645409233471 DEFAULT CHARSET=utf8 COMMENT='场地信息评论表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `discusschangdixinxi`--LOCK TABLES `discusschangdixinxi` WRITE;/*!40000 ALTER TABLE `discusschangdixinxi` DISABLE KEYS */;INSERT INTO `discusschangdixinxi` VALUES (101,'-02-20 09:26:27',1,1,'用户名1','评论内容1','回复内容1'),(102,'-02-20 09:26:27',2,2,'用户名2','评论内容2','回复内容2'),(103,'-02-20 09:26:27',3,3,'用户名3','评论内容3','回复内容3'),(104,'-02-20 09:26:27',4,4,'用户名4','评论内容4','回复内容4'),(105,'-02-20 09:26:27',5,5,'用户名5','评论内容5','回复内容5'),(106,'-02-20 09:26:27',6,6,'用户名6','评论内容6','回复内容6'),(1645409233470,'-02-21 02:07:12',35,1645408653755,'11','成都好吧那你回家手电筒付给乙方','');/*!40000 ALTER TABLE `discusschangdixinxi` 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=97 DEFAULT CHARSET=utf8 COMMENT='场地公告';/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `quxiaoshenqing`--DROP TABLE IF EXISTS `quxiaoshenqing`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `quxiaoshenqing` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`yuyuebianhao` varchar(200) DEFAULT NULL COMMENT '预约编号',`changdimingcheng` varchar(200) DEFAULT NULL COMMENT '场地名称',`changdileixing` varchar(200) DEFAULT NULL COMMENT '场地类型',`yajin` int(11) DEFAULT NULL COMMENT '押金',`shijianchangci` datetime DEFAULT NULL COMMENT '时间场次',`quxiaoshijian` datetime DEFAULT NULL COMMENT '取消时间',`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',`dianhua` varchar(200) DEFAULT NULL COMMENT '电话',`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',`shhf` longtext COMMENT '审核回复',`userid` bigint(20) DEFAULT NULL COMMENT '用户id',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1645408882204 DEFAULT CHARSET=utf8 COMMENT='取消申请';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `quxiaoshenqing`------ Table structure for table `storeup`--DROP TABLE IF EXISTS `storeup`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `storeup` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`userid` bigint(20) NOT NULL COMMENT '用户id',`refid` bigint(20) DEFAULT NULL COMMENT '收藏id',`tablename` varchar(200) DEFAULT NULL COMMENT '表名',`name` varchar(200) NOT NULL COMMENT '收藏名称',`picture` varchar(200) NOT NULL COMMENT '收藏图片',`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1645408704242 DEFAULT CHARSET=utf8 COMMENT='收藏表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `storeup`--LOCK TABLES `storeup` WRITE;/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;INSERT INTO `storeup` VALUES (1645408704241,'-02-21 01:58:23',1645408653755,35,'changdixinxi','场地名称5','upload/changdixinxi_changditupian5.jpg','1',NULL);/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `token`--DROP TABLE IF EXISTS `token`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `token` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`userid` bigint(20) NOT NULL COMMENT '用户id',`username` varchar(100) NOT NULL COMMENT '用户名',`tablename` varchar(100) DEFAULT NULL COMMENT '表名',`role` varchar(100) DEFAULT NULL COMMENT '角色',`token` varchar(200) NOT NULL COMMENT '密码',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='token表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `token`--LOCK TABLES `token` WRITE;/*!40000 ALTER TABLE `token` DISABLE KEYS */;INSERT INTO `token` VALUES (1,11,'账号1','yonghu','用户','olcvk38749xua2ci77263u66s9gq50p2','-02-21 01:42:43','-02-21 02:52:38'),(2,1,'abo','users','管理员','g8ciwh4pqkzy5dtseiotjjphcrws5wiy','-02-21 01:46:54','-02-21 03:09:56'),(3,1645408653755,'11','yonghu','用户','6tlwidgjj9uoxqi950ek9ltz62yds0gy','-02-21 01:57:39','-02-21 03:06:12');/*!40000 ALTER TABLE `token` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `tuihuiyajin`--DROP TABLE IF EXISTS `tuihuiyajin`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `tuihuiyajin` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`yuyuebianhao` varchar(200) DEFAULT NULL COMMENT '预约编号',`changdimingcheng` varchar(200) DEFAULT NULL COMMENT '场地名称',`changdileixing` varchar(200) DEFAULT NULL COMMENT '场地类型',`yajin` int(11) DEFAULT NULL COMMENT '押金',`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',`dianhua` varchar(200) DEFAULT NULL COMMENT '电话',`tuihuishijian` datetime DEFAULT NULL COMMENT '退回时间',`userid` bigint(20) DEFAULT NULL COMMENT '用户id',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1645409592140 DEFAULT CHARSET=utf8 COMMENT='退回押金';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `tuihuiyajin`------ Table structure for table `users`--DROP TABLE IF EXISTS `users`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `users` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`username` varchar(100) NOT NULL COMMENT '用户名',`password` varchar(100) NOT NULL COMMENT '密码',`role` varchar(100) DEFAULT '管理员' COMMENT '角色',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `users`--LOCK TABLES `users` WRITE;/*!40000 ALTER TABLE `users` DISABLE KEYS */;INSERT INTO `users` VALUES (1,'abo','abo','管理员','-02-20 09:26:27');/*!40000 ALTER TABLE `users` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `wodeyuyue`--DROP TABLE IF EXISTS `wodeyuyue`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `wodeyuyue` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`yuyuebianhao` varchar(200) DEFAULT NULL COMMENT '预约编号',`changdimingcheng` varchar(200) DEFAULT NULL COMMENT '场地名称',`changdileixing` varchar(200) DEFAULT NULL COMMENT '场地类型',`yajin` int(11) DEFAULT NULL COMMENT '押金',`shijianchangci` datetime DEFAULT NULL COMMENT '时间场次',`yuyueshijian` datetime DEFAULT NULL COMMENT '预约时间',`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',`dianhua` varchar(200) DEFAULT NULL COMMENT '电话',`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',`userid` bigint(20) DEFAULT NULL COMMENT '用户id',PRIMARY KEY (`id`),UNIQUE KEY `yuyuebianhao` (`yuyuebianhao`)) ENGINE=InnoDB AUTO_INCREMENT=1645408732848 DEFAULT CHARSET=utf8 COMMENT='我的预约';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `wodeyuyue`------ Table structure for table `yonghu`--DROP TABLE IF EXISTS `yonghu`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `yonghu` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`zhanghao` varchar(200) NOT NULL COMMENT '账号',`xingming` varchar(200) NOT NULL COMMENT '姓名',`mima` varchar(200) NOT NULL COMMENT '密码',`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',`nianling` int(11) DEFAULT NULL COMMENT '年龄',`dianhua` varchar(200) NOT NULL COMMENT '电话',PRIMARY KEY (`id`),UNIQUE KEY `zhanghao` (`zhanghao`)) ENGINE=InnoDB AUTO_INCREMENT=1645408653756 DEFAULT CHARSET=utf8 COMMENT='用户';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `yonghu`--