功能介绍
本系统的功能包括前台和后台两方面，前台的功能为旅游景点信息、拼团信息、旅游资讯信息、论坛信息等，用户可以参与拼团，发起者可以发起拼团和管理拼团订单、参团信息。后台的功能为用户管理、评价管理、景点信息管理、拼团旅游管理等。在前台的主要操作人员为注册用户和发起人，都可以发布帖子参与讨论，在后台的主要操作人员为管理员，负责用户信息、发起人信息和前台信息的管理。
数据库脚本
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssm8o1q4` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;USE `ssm8o1q4`;---- Table structure for table `cantuanxinxi`--DROP TABLE IF EXISTS `cantuanxinxi`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `cantuanxinxi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`pintuanmingcheng` varchar(200) DEFAULT NULL COMMENT '拼团名称',`pintuantupian` varchar(200) DEFAULT NULL COMMENT '拼团图片',`kaituanrenshu` int(11) DEFAULT NULL COMMENT '开团人数',`pintuanrenshu` int(11) NOT NULL COMMENT '拼团人数',`pintuanjiage` int(11) DEFAULT NULL COMMENT '拼团价格',`jine` int(11) DEFAULT NULL COMMENT '金额',`lvyoutianshu` varchar(200) DEFAULT NULL COMMENT '旅游天数',`faqizhanghao` varchar(200) DEFAULT NULL COMMENT '发起账号',`faqixingming` varchar(200) DEFAULT NULL COMMENT '发起姓名',`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',`cantuanbeizhu` varchar(200) DEFAULT NULL COMMENT '参团备注',`cantuanshijian` datetime DEFAULT NULL COMMENT '参团时间',`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',`cheliangzhuangtai` varchar(200) NOT NULL COMMENT '车辆状态',`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',`shhf` longtext COMMENT '审核回复',`userid` bigint(20) DEFAULT NULL COMMENT '用户id',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1652237226269 DEFAULT CHARSET=utf8 COMMENT='参团信息';/*!40101 SET character_set_client = @saved_cs_client */;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 */;DROP TABLE IF EXISTS `discussjingdianxinxi`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `discussjingdianxinxi` (`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=1652237059867 DEFAULT CHARSET=utf8 COMMENT='景点信息评论表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `discussjingdianxinxi`------ Table structure for table `faqiren`--DROP TABLE IF EXISTS `faqiren`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `faqiren` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`faqizhanghao` varchar(200) NOT NULL COMMENT '发起账号',`mima` varchar(200) NOT NULL COMMENT '密码',`faqixingming` varchar(200) NOT NULL COMMENT '发起姓名',`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',`xiangpian` varchar(200) DEFAULT NULL COMMENT '相片',PRIMARY KEY (`id`),UNIQUE KEY `faqizhanghao` (`faqizhanghao`)) ENGINE=InnoDB AUTO_INCREMENT=1652236957809 DEFAULT CHARSET=utf8 COMMENT='发起人';/*!40101 SET character_set_client = @saved_cs_client */;DROP TABLE IF EXISTS `forum`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `forum` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`title` varchar(200) DEFAULT NULL COMMENT '帖子标题',`content` longtext NOT NULL COMMENT '帖子内容',`parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',`userid` bigint(20) NOT NULL COMMENT '用户id',`username` varchar(200) DEFAULT NULL COMMENT '用户名',`isdone` varchar(200) DEFAULT NULL COMMENT '状态',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=165223717 DEFAULT CHARSET=utf8 COMMENT='论坛表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `forum`--DROP TABLE IF EXISTS `jingdianfenlei`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `jingdianfenlei` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`jingdianfenlei` varchar(200) NOT NULL COMMENT '景点分类',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1652237374894 DEFAULT CHARSET=utf8 COMMENT='景点分类';/*!40101 SET character_set_client = @saved_cs_client */;-- Table structure for table `jingdianxinxi`--DROP TABLE IF EXISTS `jingdianxinxi`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `jingdianxinxi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`jingdianmingcheng` varchar(200) NOT NULL COMMENT '景点名称',`jingdianfenlei` varchar(200) NOT NULL COMMENT '景点分类',`jingdiantupian` varchar(200) DEFAULT NULL COMMENT '景点图片',`jingdiandizhi` varchar(200) NOT NULL COMMENT '景点地址',`jingdianjianjie` longtext COMMENT '景点简介',`jingdianxiangqing` longtext COMMENT '景点详情',`kaifashijian` varchar(200) DEFAULT NULL COMMENT '开发时间',`menpiaojiage` int(11) DEFAULT NULL COMMENT '门票价格',`faburiqi` date DEFAULT NULL COMMENT '发布日期',`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1652237431213 DEFAULT CHARSET=utf8 COMMENT='景点信息';/*!40101 SET character_set_client = @saved_cs_client */;---- 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=1652237515243 DEFAULT CHARSET=utf8 COMMENT='旅游资讯';/*!40101 SET character_set_client = @saved_cs_client */;-- Table structure for table `pingjiaxinxi`--DROP TABLE IF EXISTS `pingjiaxinxi`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `pingjiaxinxi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`pintuanmingcheng` varchar(200) DEFAULT NULL COMMENT '拼团名称',`pintuantupian` varchar(200) DEFAULT NULL COMMENT '拼团图片',`jine` int(11) DEFAULT NULL COMMENT '金额',`lvyoutianshu` varchar(200) DEFAULT NULL COMMENT '旅游天数',`faqizhanghao` varchar(200) DEFAULT NULL COMMENT '发起账号',`faqixingming` varchar(200) DEFAULT NULL COMMENT '发起姓名',`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',`kaituanshijian` varchar(200) DEFAULT NULL COMMENT '开团时间',`pingjianeirong` longtext COMMENT '评价内容',`pingjiashijian` datetime DEFAULT NULL COMMENT '评价时间',`userid` bigint(20) DEFAULT NULL COMMENT '用户id',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1652237302070 DEFAULT CHARSET=utf8 COMMENT='评价信息';/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `pintuandingdan`--DROP TABLE IF EXISTS `pintuandingdan`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `pintuandingdan` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`pintuanmingcheng` varchar(200) DEFAULT NULL COMMENT '拼团名称',`pintuantupian` varchar(200) DEFAULT NULL COMMENT '拼团图片',`kaituanrenshu` int(11) DEFAULT NULL COMMENT '开团人数',`pintuanrenshu` int(11) NOT NULL COMMENT '拼团人数',`pintuanjiage` int(11) DEFAULT NULL COMMENT '拼团价格',`jine` int(11) DEFAULT NULL COMMENT '金额',`lvyoutianshu` varchar(200) DEFAULT NULL COMMENT '旅游天数',`faqizhanghao` varchar(200) DEFAULT NULL COMMENT '发起账号',`faqixingming` varchar(200) DEFAULT NULL COMMENT '发起姓名',`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',`cantuanbeizhu` varchar(200) DEFAULT NULL COMMENT '参团备注',`cantuanshijian` varchar(200) DEFAULT NULL COMMENT '参团时间',`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',`cheliangzhuangtai` varchar(200) NOT NULL COMMENT '车辆状态',`kaituanshijian` datetime DEFAULT NULL COMMENT '开团时间',`kaituanbeizhu` longtext COMMENT '开团备注',`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',`userid` bigint(20) DEFAULT NULL COMMENT '用户id',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1652237272573 DEFAULT CHARSET=utf8 COMMENT='拼团订单';/*!40101 SET character_set_client = @saved_cs_client */;DROP TABLE IF EXISTS `pintuanlvyou`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `pintuanlvyou` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`pintuanmingcheng` varchar(200) NOT NULL COMMENT '拼团名称',`pintuantupian` varchar(200) DEFAULT NULL COMMENT '拼团图片',`kaituanrenshu` int(11) NOT NULL COMMENT '开团人数',`pintuanrenshu` int(11) NOT NULL COMMENT '拼团人数',`pintuanjiage` varchar(200) DEFAULT NULL COMMENT '拼团价格',`lvyoutianshu` varchar(200) DEFAULT NULL COMMENT '旅游天数',`lvyoujingdian` longtext COMMENT '旅游景点',`xiangqing` longtext COMMENT '详情',`faqizhanghao` varchar(200) DEFAULT NULL COMMENT '发起账号',`faqixingming` varchar(200) DEFAULT NULL COMMENT '发起姓名',`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',`userid` bigint(20) DEFAULT NULL COMMENT '用户id',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1652237149935 DEFAULT CHARSET=utf8 COMMENT='拼团旅游';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `pintuanlvyou`------ 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=1652237193574 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 (1652236969881,'-05-11 02:42:49',1652236957808,33,'jingdianxinxi','景点名称3','upload/jingdianxinxi_jingdiantupian3.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,1652236957808,'22','faqiren','发起人','grqffmyy7h0ma7jgfrhkab66ga4smsyl','-05-11 02:42:44','-05-11 03:48:32'),(2,1652236870653,'11','yonghu','用户','eezn70f06um328oa59sofidgyn08415r','-05-11 02:46:20','-05-11 03:48:02'),(3,1,'abo','users','管理员','pqbghr937n1tt7g8arl4vcz7h0l9hdch','-05-11 02:49:15','-05-11 03:49:15');/*!40000 ALTER TABLE `token` ENABLE KEYS */;UNLOCK TABLES;---- 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','管理员','-05-11 02:38:58');/*!40000 ALTER TABLE `users` ENABLE KEYS */;UNLOCK TABLES;---- 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 '账号',`mima` varchar(200) NOT NULL COMMENT '密码',`xingming` varchar(200) NOT NULL COMMENT '姓名',`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',`xiangpian` varchar(200) DEFAULT NULL COMMENT '相片',PRIMARY KEY (`id`),UNIQUE KEY `zhanghao` (`zhanghao`)) ENGINE=InnoDB AUTO_INCREMENT=1652236870654 DEFAULT CHARSET=utf8 COMMENT='用户';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `yonghu`--LOCK TABLES `yonghu` WRITE;/*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;INSERT INTO `yonghu` VALUES (11,'-05-11 02:38:57','账号1','123456','姓名1','男','773890001@','13823888881','upload/yonghu_xiangpian1.jpg'),(12,'-05-11 02:38:57','账号2','123456','姓名2','男','773890002@','13823888882','upload/yonghu_xiangpian2.jpg'),(13,'-05-11 02:38:57','账号3','123456','姓名3','男','773890003@','13823888883','upload/yonghu_xiangpian3.jpg'),(14,'-05-11 02:38:57','账号4','123456','姓名4','男','773890004@','13823888884','upload/yonghu_xiangpian4.jpg'),(15,'-05-11 02:38:57','账号5','123456','姓名5','男','773890005@','13823888885','upload/yonghu_xiangpian5.jpg'),(16,'-05-11 02:38:57','账号6','123456','姓名6','男','773890006@','13823888886','upload/yonghu_xiangpian6.jpg'),(1652236870653,'-05-11 02:41:10','11','11','张三','男','131@','13111111111','upload/1652237204884.jpg');
