博主介绍：
✌我是阿龙，一名专注于Java技术领域的程序员，全网拥有10W+粉丝。作为CSDN特邀作者、博客专家、新星计划导师，我在计算机毕业设计开发方面积累了丰富的经验。同时，我也是掘金、华为云、阿里云、InfoQ等平台的优质作者。通过长期分享和实战指导，我致力于帮助更多学生完成毕业项目和技术提升。技术范围：
我熟悉的技术领域涵盖SpringBoot、Vue、SSM、HLMT、Jsp、PHP、Nodejs、Python、爬虫、数据可视化、小程序、安卓app、大数据、物联网、机器学习等方面的设计与开发。如果你有任何技术难题，我都乐意与你分享解决方案。主要内容：
我的服务内容包括：免费功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文撰写与辅导、论文降重、长期答辩答疑辅导。此外，我还提供腾讯会议一对一的专业讲解和模拟答辩演练，帮助你全面掌握答辩技巧与代码逻辑。🍅获取源码请在文末联系我🍅
如果你对我的内容感兴趣，记得先收藏！对于毕设选题、项目开发或论文撰写等相关问题，随时欢迎留言咨询，我会尽力帮助更多同学顺利完成学业。最主要的是免费咨询相关问题！！
文档学习资料（阿龙可以赠送所有的录制好的讲解视频）：
系统实现界面：
需要详细视频请DD我下方！！
实现代码：
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: cl970340
-- ------------------------------------------------------
-- Server version 5.7.31
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `cl970340`
--
/*!40000 DROP DATABASE IF EXISTS `cl970340`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `cl970340` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `cl970340`;
--
-- 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,'swiper1','file/swiperPicture1.jpg'),(2,'swiper2','file/swiperPicture2.jpg'),(3,'swiper3','file/swiperPicture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussjingdianxinxi`
--
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',
`avatarurl` longtext COMMENT '头像',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1695447985875 DEFAULT CHARSET=utf8 COMMENT='景点信息评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussjingdianxinxi`
--
LOCK TABLES `discussjingdianxinxi` WRITE;
/*!40000 ALTER TABLE `discussjingdianxinxi` DISABLE KEYS */;
INSERT INTO `discussjingdianxinxi` VALUES (1695447985874,'2023-09-23 05:46:25',1695447507124,1695447805250,'','002','好好','');
/*!40000 ALTER TABLE `discussjingdianxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussmeishituijian`
--
DROP TABLE IF EXISTS `discussmeishituijian`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussmeishituijian` (
`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',
`avatarurl` longtext COMMENT '头像',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1695448452522 DEFAULT CHARSET=utf8 COMMENT='美食推荐评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussmeishituijian`
--
LOCK TABLES `discussmeishituijian` WRITE;
/*!40000 ALTER TABLE `discussmeishituijian` DISABLE KEYS */;
INSERT INTO `discussmeishituijian` VALUES (1695447884926,'2023-09-23 05:44:44',1695447642715,1695447805250,'','002','好吃',''),(1695448452521,'2023-09-23 05:54:11',1695447642715,1695448371400,'','111','好','');
/*!40000 ALTER TABLE `discussmeishituijian` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusszhusuxinxi`
--
DROP TABLE IF EXISTS `discusszhusuxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusszhusuxinxi` (
`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',
`avatarurl` longtext COMMENT '头像',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1695449011457 DEFAULT CHARSET=utf8 COMMENT='住宿信息评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discusszhusuxinxi`
--
LOCK TABLES `discusszhusuxinxi` WRITE;
/*!40000 ALTER TABLE `discusszhusuxinxi` DISABLE KEYS */;
INSERT INTO `discusszhusuxinxi` VALUES (1695449011456,'2023-09-23 06:03:30',1695447679462,1695448914825,'','000','好','');
/*!40000 ALTER TABLE `discusszhusuxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiaotongxinxi`
--
DROP TABLE IF EXISTS `jiaotongxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaotongxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`bancihao` varchar(200) NOT NULL COMMENT '班次号',
`luxiantu` longtext COMMENT '路线图',
`jiaotonggongju` varchar(200) NOT NULL COMMENT '交通工具',
`shifadi` varchar(200) NOT NULL COMMENT '始发地',
`mudedi` varchar(200) NOT NULL COMMENT '目的地',
`tujingdidian` varchar(200) DEFAULT NULL COMMENT '途径地点',
`chufashijian` datetime NOT NULL COMMENT '出发时间',
`daodashijian` datetime NOT NULL COMMENT '到达时间',
`piaojia` double NOT NULL COMMENT '票价',
`piaoshu` int(11) NOT NULL COMMENT '票数',
`storeupnum` int(11) DEFAULT NULL COMMENT '收藏数量',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1695447568357 DEFAULT CHARSET=utf8 COMMENT='交通信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiaotongxinxi`
--
LOCK TABLES `jiaotongxinxi` WRITE;
/*!40000 ALTER TABLE `jiaotongxinxi` DISABLE KEYS */;
INSERT INTO `jiaotongxinxi` VALUES (71,'2023-09-22 14:24:43','班次号1','file/jiaotongxinxiLuxiantu1.jpg,file/jiaotongxinxiLuxiantu2.jpg,file/jiaotongxinxiLuxiantu3.jpg','飞机','始发地1','目的地1','途径地点1','2023-09-22 22:24:43','2023-09-22 22:24:43',1,1,1),(72,'2023-09-22 14:24:43','班次号2','file/jiaotongxinxiLuxiantu2.jpg,file/jiaotongxinxiLuxiantu3.jpg,file/jiaotongxinxiLuxiantu4.jpg','飞机','始发地2','目的地2','途径地点2','2023-09-22 22:24:43','2023-09-22 22:24:43',2,2,2),(73,'2023-09-22 14:24:43','班次号3','file/jiaotongxinxiLuxiantu3.jpg,file/jiaotongxinxiLuxiantu4.jpg,file/jiaotongxinxiLuxiantu5.jpg','飞机','始发地3','目的地3','途径地点3','2023-09-22 22:24:43','2023-09-22 22:24:43',3,0,3),(74,'2023-09-22 14:24:43','班次号4','file/jiaotongxinxiLuxiantu4.jpg,file/jiaotongxinxiLuxiantu5.jpg,file/jiaotongxinxiLuxiantu6.jpg','飞机','始发地4','目的地4','途径地点4','2023-09-22 22:24:43','2023-09-22 22:24:43',4,4,4),(75,'2023-09-22 14:24:43','班次号5','file/jiaotongxinxiLuxiantu5.jpg,file/jiaotongxinxiLuxiantu6.jpg,file/jiaotongxinxiLuxiantu7.jpg','飞机','始发地5','目的地5','途径地点5','2023-09-22 22:24:43','2023-09-22 22:24:43',5,5,5),(76,'2023-09-22 14:24:43','班次号6','file/jiaotongxinxiLuxiantu6.jpg,file/jiaotongxinxiLuxiantu7.jpg,file/jiaotongxinxiLuxiantu8.jpg','飞机','始发地6','目的地6','途径地点6','2023-09-22 22:24:43','2023-09-22 22:24:43',6,6,6),(1695447568356,'2023-09-23 05:39:27','K01','file/1695447529226.jpeg','飞机','上海','广州','南京，天津','2023-09-24 09:12:00','2023-09-24 21:00:00',350,21,3);
/*!40000 ALTER TABLE `jiaotongxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiaotongyuding`
--
DROP TABLE IF EXISTS `jiaotongyuding`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaotongyuding` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yudingbianhao` varchar(200) DEFAULT NULL COMMENT '预订编号',
`bancihao` varchar(200) DEFAULT NULL COMMENT '班次号',
`jiaotonggongju` varchar(200) DEFAULT NULL COMMENT '交通工具',
`shifadi` varchar(200) DEFAULT NULL COMMENT '始发地',
`mudedi` varchar(200) DEFAULT NULL COMMENT '目的地',
`chufashijian` datetime DEFAULT NULL COMMENT '出发时间',
`daodashijian` datetime DEFAULT NULL COMMENT '到达时间',
`piaojia` double DEFAULT NULL COMMENT '票价',
`piaoshu` int(11) NOT NULL COMMENT '票数',
`dingdanjine` double DEFAULT NULL COMMENT '订单金额',
`yudingshijian` datetime DEFAULT NULL COMMENT '预订时间',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份证号',
`ispay` varchar(200) DEFAULT NULL COMMENT '是否支付',
PRIMARY KEY (`id`),
UNIQUE KEY `yudingbianhao` (`yudingbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1695448958687 DEFAULT CHARSET=utf8 COMMENT='交通预订';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiaotongyuding`
--
LOCK TABLES `jiaotongyuding` WRITE;
/*!40000 ALTER TABLE `jiaotongyuding` DISABLE KEYS */;
INSERT INTO `jiaotongyuding` VALUES (81,'2023-09-22 14:24:43','1111111111','班次号1','交通工具1','始发地1','目的地1','2023-09-22 22:24:43','2023-09-22 22:24:43',1,1,1,'2023-09-22 22:24:43','用户账号1','用户姓名1','手机号码1','身份证号1','未支付'),(82,'2023-09-22 14:24:43','2222222222','班次号2','交通工具2','始发地2','目的地2','2023-09-22 22:24:43','2023-09-22 22:24:43',2,2,2,'2023-09-22 22:24:43','用户账号2','用户姓名2','手机号码2','身份证号2','未支付'),(83,'2023-09-22 14:24:43','3333333333','班次号3','交通工具3','始发地3','目的地3','2023-09-22 22:24:43','2023-09-22 22:24:43',3,3,3,'2023-09-22 22:24:43','用户账号3','用户姓名3','手机号码3','身份证号3','未支付'),(84,'2023-09-22 14:24:43','4444444444','班次号4','交通工具4','始发地4','目的地4','2023-09-22 22:24:43','2023-09-22 22:24:43',4,4,4,'2023-09-22 22:24:43','用户账号4','用户姓名4','手机号码4','身份证号4','未支付'),(85,'2023-09-22 14:24:43','5555555555','班次号5','交通工具5','始发地5','目的地5','2023-09-22 22:24:43','2023-09-22 22:24:43',5,5,5,'2023-09-22 22:24:43','用户账号5','用户姓名5','手机号码5','身份证号5','未支付'),(86,'2023-09-22 14:24:43','6666666666','班次号6','交通工具6','始发地6','目的地6','2023-09-22 22:24:43','2023-09-22 22:24:43',6,6,6,'2023-09-22 22:24:43','用户账号6','用户姓名6','手机号码6','身份证号6','未支付'),(1695446502290,'2023-09-23 05:21:41','1695446495419','班次号3','飞机','始发地3','目的地3','2023-09-22 22:24:43','2023-09-22 22:24:43',3,3,9,'2023-09-23 01:21:35','用户账号1','用户姓名1','19819881111','441622200101010001','未支付'),(1695447854609,'2023-09-23 05:44:13','1695447843148','K01','飞机','上海','广州','2023-09-24 09:12:00','2023-09-24 21:00:00',350,1,350,'2023-09-23 01:44:03','002','陈红','13823899999','','未支付'),(1695448429935,'2023-09-23 05:53:49','1695448413016','K01','飞机','上海','广州','2023-09-24 09:12:00','2023-09-24 21:00:00',350,1,350,'2023-09-23 01:53:32','111','张三','13823877776','','已支付'),(1695448958686,'2023-09-23 06:02:38','1695448952562','K01','飞机','上海','广州','2023-09-24 09:12:00','2023-09-24 21:00:00',350,2,700,'2023-09-23 02:02:32','000','王强','13823977778','','已支付');
/*!40000 ALTER TABLE `jiaotongyuding` ENABLE KEYS */;
UNLOCK TABLES;
--
-- 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 '景点名称',
`jingdiantupian` longtext COMMENT '景点图片',
`menpiaojiage` double NOT NULL COMMENT '门票价格',
`kaifangshijian` varchar(200) DEFAULT NULL COMMENT '开放时间',
`goupiaoxuzhi` longtext COMMENT '购票须知',
`jingdianjieshao` longtext COMMENT '景点介绍',
`storeupnum` int(11) DEFAULT NULL COMMENT '收藏数量',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT NULL COMMENT '点击次数',
`jingdiandizhi` varchar(200) DEFAULT NULL COMMENT '景点地址',
`lvyougonglve` longtext COMMENT '旅游攻略',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1695447507125 DEFAULT CHARSET=utf8 COMMENT='景点信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jingdianxinxi`
--
LOCK TABLES `jingdianxinxi` WRITE;
/*!40000 ALTER TABLE `jingdianxinxi` DISABLE KEYS */;
INSERT INTO `jingdianxinxi` VALUES (41,'2023-09-22 14:24:43','景点名称1','file/jingdianxinxiJingdiantupian1.jpg,file/jingdianxinxiJingdiantupian2.jpg,file/jingdianxinxiJingdiantupian3.jpg',1,'开放时间1','购票须知1','景点介绍1',1,'2023-09-23 13:51:06',2,'景点地址1','旅游攻略1'),(42,'2023-09-22 14:24:43','景点名称2','file/jingdianxinxiJingdiantupian2.jpg,file/jingdianxinxiJingdiantupian3.jpg,file/jingdianxinxiJingdiantupian4.jpg',2,'开放时间2','购票须知2','景点介绍2',2,'2023-09-23 14:00:55',4,'景点地址2','旅游攻略2'),(43,'2023-09-22 14:24:43','景点名称3','file/jingdianxinxiJingdiantupian3.jpg,file/jingdianxinxiJingdiantupian4.jpg,file/jingdianxinxiJingdiantupian5.jpg',3,'开放时间3','购票须知3','景点介绍3',3,'2023-09-22 22:24:43',3,'景点地址3','旅游攻略3'),(44,'2023-09-22 14:24:43','景点名称4','file/jingdianxinxiJingdiantupian4.jpg,file/jingdianxinxiJingdiantupian5.jpg,file/jingdianxinxiJingdiantupian6.jpg',4,'开放时间4','购票须知4','景点介绍4',4,'2023-09-23 13:43:03',5,'景点地址4','旅游攻略4'),(45,'2023-09-22 14:24:43','景点名称5','file/jingdianxinxiJingdiantupian5.jpg,file/jingdianxinxiJingdiantupian6.jpg,file/jingdianxinxiJingdiantupian7.jpg',5,'开放时间5','购票须知5','景点介绍5',5,'2023-09-22 22:24:43',5,'景点地址5','旅游攻略5'),(46,'2023-09-22 14:24:43','景点名称6','file/jingdianxinxiJingdiantupian6.jpg,file/jingdianxinxiJingdiantupian7.jpg,file/jingdianxinxiJingdiantupian8.jpg',6,'开放时间6','购票须知6','景点介绍6',6,'2023-09-22 22:24:43',6,'景点地址6','旅游攻略6'),(1695447507124,'2023-09-23 05:38:26','长隆世界','file/1695447468151.jpeg',288,'8:00-18:00','输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容','<p>入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容</p><p><img src=\"http://localhost:8080/cl970340/file/1695447504050.jpeg\" alt=\"\" data-href=\"\" style=\"\"/></p>',3,'2023-09-23 14:03:56',8,'广州','<p>入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容</p>');
/*!40000 ALTER TABLE `jingdianxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meishituijian`
--
DROP TABLE IF EXISTS `meishituijian`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meishituijian` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`meishimingcheng` varchar(200) NOT NULL COMMENT '美食名称',
`meishitupian` longtext COMMENT '美食图片',
`tuijianzhishu` varchar(200) NOT NULL COMMENT '推荐指数',
`renjunxiaofei` varchar(200) DEFAULT NULL COMMENT '人均消费',
`dakadidian` varchar(200) NOT NULL COMMENT '打卡地点',
`meishijieshao` longtext COMMENT '美食介绍',
`storeupnum` int(11) DEFAULT NULL COMMENT '收藏数量',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1695447642716 DEFAULT CHARSET=utf8 COMMENT='美食推荐';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meishituijian`
--
LOCK TABLES `meishituijian` WRITE;
/*!40000 ALTER TABLE `meishituijian` DISABLE KEYS */;
INSERT INTO `meishituijian` VALUES (91,'2023-09-22 14:24:43','美食名称1','file/meishituijianMeishitupian1.jpg,file/meishituijianMeishitupian2.jpg,file/meishituijianMeishitupian3.jpg','一星','人均消费1','打卡地点1','美食介绍1',1),(92,'2023-09-22 14:24:43','美食名称2','file/meishituijianMeishitupian2.jpg,file/meishituijianMeishitupian3.jpg,file/meishituijianMeishitupian4.jpg','一星','人均消费2','打卡地点2','美食介绍2',2),(93,'2023-09-22 14:24:43','美食名称3','file/meishituijianMeishitupian3.jpg,file/meishituijianMeishitupian4.jpg,file/meishituijianMeishitupian5.jpg','一星','人均消费3','打卡地点3','美食介绍3',3),(94,'2023-09-22 14:24:43','美食名称4','file/meishituijianMeishitupian4.jpg,file/meishituijianMeishitupian5.jpg,file/meishituijianMeishitupian6.jpg','一星','人均消费4','打卡地点4','美食介绍4',4),(95,'2023-09-22 14:24:43','美食名称5','file/meishituijianMeishitupian5.jpg,file/meishituijianMeishitupian6.jpg,file/meishituijianMeishitupian7.jpg','一星','人均消费5','打卡地点5','美食介绍5',5),(96,'2023-09-22 14:24:43','美食名称6','file/meishituijianMeishitupian6.jpg,file/meishituijianMeishitupian7.jpg,file/meishituijianMeishitupian8.jpg','一星','人均消费6','打卡地点6','美食介绍6',6),(1695447642715,'2023-09-23 05:40:42','健康轻食','file/1695447608296.jpg','四星','30-45','广州路','<p>入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容</p><p><img src=\"http://localhost:8080/cl970340/file/1695447641037.jpg\" alt=\"\" data-href=\"\" style=\"\"/></p>',0);
/*!40000 ALTER TABLE `meishituijian` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `menpiaogoumai`
--
DROP TABLE IF EXISTS `menpiaogoumai`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menpiaogoumai` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`jingdianmingcheng` varchar(200) DEFAULT NULL COMMENT '景点名称',
`menpiaojiage` double DEFAULT NULL COMMENT '门票价格',
`shuliang` int(11) NOT NULL COMMENT '数量',
`dingdanjine` double DEFAULT NULL COMMENT '订单金额',
`goumaishijian` datetime DEFAULT NULL COMMENT '购买时间',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`ispay` varchar(200) DEFAULT NULL COMMENT '是否支付',
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1695449053152 DEFAULT CHARSET=utf8 COMMENT='门票购买';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `menpiaogoumai`
--
LOCK TABLES `menpiaogoumai` WRITE;
/*!40000 ALTER TABLE `menpiaogoumai` DISABLE KEYS */;
INSERT INTO `menpiaogoumai` VALUES (61,'2023-09-22 14:24:43','1111111111','景点名称1',1,1,1,'2023-09-22 22:24:43','用户账号1','用户姓名1','手机号码1','已支付'),(62,'2023-09-22 14:24:43','2222222222','景点名称2',2,2,2,'2023-09-22 22:24:43','用户账号2','用户姓名2','手机号码2','未支付'),(63,'2023-09-22 14:24:43','3333333333','景点名称3',3,3,3,'2023-09-22 22:24:43','用户账号3','用户姓名3','手机号码3','未支付'),(64,'2023-09-22 14:24:43','4444444444','景点名称4',4,4,4,'2023-09-22 22:24:43','用户账号4','用户姓名4','手机号码4','未支付'),(65,'2023-09-22 14:24:43','5555555555','景点名称5',5,5,5,'2023-09-22 22:24:43','用户账号5','用户姓名5','手机号码5','未支付'),(66,'2023-09-22 14:24:43','6666666666','景点名称6',6,6,6,'2023-09-22 22:24:43','用户账号6','用户姓名6','手机号码6','未支付'),(1695446484065,'2023-09-23 05:21:23','1695446478536','景点名称2',2,1,2,'2023-09-23 01:21:18','用户账号1','用户姓名1','19819881111','未支付'),(1695447975682,'2023-09-23 05:46:15','1695447969447','长隆世界',288,2,576,'2023-09-23 01:46:09','002','陈红','13823899999','已支付'),(1695448515651,'2023-09-23 05:55:15','1695448509390','长隆世界',288,2,576,'2023-09-23 01:55:09','111','张三','13823877776','已支付'),(1695449053151,'2023-09-23 06:04:12','1695449047149','长隆世界',288,2,576,'2023-09-23 02:04:07','000','王强','13823977778','已支付');
/*!40000 ALTER TABLE `menpiaogoumai` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `menu`
--
DROP TABLE IF EXISTS `menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`menujson` longtext 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 `menu`
--
LOCK TABLES `menu` WRITE;
/*!40000 ALTER TABLE `menu` DISABLE KEYS */;
INSERT INTO `menu` VALUES (1,'2023-09-22 14:24:44','[{\"backMenu\":[{\"child\":[{\"appFrontIcon\":\"cuIcon-vipcard\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"轮播图\",\"menuJump\":\"列表\",\"tableName\":\"config\"},{\"appFrontIcon\":\"cuIcon-clothes\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"管理员\",\"menuJump\":\"列表\",\"tableName\":\"users\"}],\"fontClass\":\"icon-common34\",\"menu\":\"后台管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-attentionfavor\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"用户\",\"menuJump\":\"列表\",\"tableName\":\"yonghu\"}],\"fontClass\":\"icon-user3\",\"menu\":\"用户管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-news\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"查看评论\"],\"menu\":\"景点信息\",\"menuJump\":\"列表\",\"tableName\":\"jingdianxinxi\"},{\"appFrontIcon\":\"cuIcon-phone\",\"buttons\":[\"查看\",\"修改\",\"删除\"],\"menu\":\"门票购买\",\"menuJump\":\"列表\",\"tableName\":\"menpiaogoumai\"}],\"fontClass\":\"icon-common36\",\"menu\":\"景点信息管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-vip\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"交通信息\",\"menuJump\":\"列表\",\"tableName\":\"jiaotongxinxi\"},{\"appFrontIcon\":\"cuIcon-brand\",\"buttons\":[\"查看\",\"修改\",\"删除\"],\"menu\":\"交通预订\",\"menuJump\":\"列表\",\"tableName\":\"jiaotongyuding\"}],\"fontClass\":\"icon-common44\",\"menu\":\"交通信息管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-flashlightopen\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"查看评论\"],\"menu\":\"美食推荐\",\"menuJump\":\"列表\",\"tableName\":\"meishituijian\"}],\"fontClass\":\"icon-common10\",\"menu\":\"美食推荐管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-newshot\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"查看评论\"],\"menu\":\"住宿信息\",\"menuJump\":\"列表\",\"tableName\":\"zhusuxinxi\"},{\"appFrontIcon\":\"cuIcon-explore\",\"buttons\":[\"查看\",\"修改\",\"删除\",\"审核\"],\"menu\":\"住宿预订\",\"menuJump\":\"列表\",\"tableName\":\"zhusuyuding\"}],\"fontClass\":\"icon-common24\",\"menu\":\"住宿信息管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-circle\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"逃生通道\",\"menuJump\":\"列表\",\"tableName\":\"taoshengtongdao\"}],\"fontClass\":\"icon-common49\",\"menu\":\"逃生通道管理\",\"unicode\":\"\"}],\"frontMenu\":[{\"child\":[{\"appFrontIcon\":\"cuIcon-present\",\"buttons\":[\"购买\"],\"menu\":\"景点信息\",\"menuJump\":\"列表\",\"tableName\":\"jingdianxinxi\"}],\"menu\":\"景点信息\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-qrcode\",\"buttons\":[\"预订\",\"查看\"],\"menu\":\"交通信息\",\"menuJump\":\"列表\",\"tableName\":\"jiaotongxinxi\"}],\"menu\":\"交通信息\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-goodsnew\",\"buttons\":[\"查看\"],\"menu\":\"美食推荐\",\"menuJump\":\"列表\",\"tableName\":\"meishituijian\"}],\"menu\":\"美食推荐\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-keyboard\",\"buttons\":[\"预订\"],\"menu\":\"住宿信息\",\"menuJump\":\"列表\",\"tableName\":\"zhusuxinxi\"}],\"menu\":\"住宿信息\"}],\"hasBackLogin\":\"是\",\"hasBackRegister\":\"否\",\"hasFrontLogin\":\"否\",\"hasFrontRegister\":\"否\",\"roleName\":\"管理员\",\"tableName\":\"users\"},{\"backMenu\":[{\"child\":[{\"appFrontIcon\":\"cuIcon-send\",\"buttons\":[\"查看\"],\"menu\":\"我的收藏\",\"menuJump\":\"1\",\"tableName\":\"storeup\"}],\"fontClass\":\"icon-common50\",\"menu\":\"我的收藏管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-phone\",\"buttons\":[\"查看\",\"支付\"],\"menu\":\"门票购买\",\"menuJump\":\"列表\",\"tableName\":\"menpiaogoumai\"}],\"fontClass\":\"icon-common36\",\"menu\":\"景点信息管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-brand\",\"buttons\":[\"查看\",\"支付\"],\"menu\":\"交通预订\",\"menuJump\":\"列表\",\"tableName\":\"jiaotongyuding\"}],\"fontClass\":\"icon-common44\",\"menu\":\"交通信息管理\",\"unicode\":\"\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-explore\",\"buttons\":[\"查看\",\"支付\"],\"menu\":\"住宿预订\",\"menuJump\":\"列表\",\"tableName\":\"zhusuyuding\"}],\"fontClass\":\"icon-common24\",\"menu\":\"住宿信息管理\",\"unicode\":\"\"}],\"frontMenu\":[{\"child\":[{\"appFrontIcon\":\"cuIcon-present\",\"buttons\":[\"购买\"],\"menu\":\"景点信息\",\"menuJump\":\"列表\",\"tableName\":\"jingdianxinxi\"}],\"menu\":\"景点信息\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-qrcode\",\"buttons\":[\"预订\",\"查看\"],\"menu\":\"交通信息\",\"menuJump\":\"列表\",\"tableName\":\"jiaotongxinxi\"}],\"menu\":\"交通信息\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-goodsnew\",\"buttons\":[\"查看\"],\"menu\":\"美食推荐\",\"menuJump\":\"列表\",\"tableName\":\"meishituijian\"}],\"menu\":\"美食推荐\"},{\"child\":[{\"appFrontIcon\":\"cuIcon-keyboard\",\"buttons\":[\"预订\"],\"menu\":\"住宿信息\",\"menuJump\":\"列表\",\"tableName\":\"zhusuxinxi\"}],\"menu\":\"住宿信息\"}],\"hasBackLogin\":\"否\",\"hasBackRegister\":\"否\",\"hasFrontLogin\":\"是\",\"hasFrontRegister\":\"是\",\"roleName\":\"用户\",\"tableName\":\"yonghu\"}]');
/*!40000 ALTER TABLE `menu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- 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 '创建时间',
`refid` bigint(20) DEFAULT NULL COMMENT 'refid',
`tablename` varchar(200) DEFAULT NULL COMMENT '表名',
`name` varchar(200) NOT NULL COMMENT '名称',
`picture` longtext NOT NULL COMMENT '图片',
`type` varchar(200) DEFAULT NULL COMMENT '类型(1:收藏,21:赞,22:踩,31:竞拍参与,41:关注)',
`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
`remark` varchar(200) DEFAULT NULL COMMENT '备注',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1695449038882 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 (1695446464589,'2023-09-23 05:21:04',101,'zhusuxinxi','住宿名称1','file/zhusuxinxiZhusutupian1.jpg','1','','',31),(1695446509603,'2023-09-23 05:21:49',93,'meishituijian','美食名称3','file/meishituijianMeishitupian3.jpg','1','','',31),(1695447841430,'2023-09-23 05:44:00',1695447568356,'jiaotongxinxi','上海','file/1695447529226.jpeg','1','','',1695447805250),(1695447888929,'2023-09-23 05:44:48',1695447642715,'meishituijian','健康轻食','file/1695447608296.jpg','1','','',1695447805250),(1695447961761,'2023-09-23 05:46:01',1695447507124,'jingdianxinxi','长隆世界','file/1695447468151.jpeg','1','','',1695447805250),(1695448410845,'2023-09-23 05:53:30',1695447568356,'jiaotongxinxi','上海','file/1695447529226.jpeg','1','','',1695448371400),(1695448503848,'2023-09-23 05:55:03',1695447507124,'jingdianxinxi','长隆世界','file/1695447468151.jpeg','1','','',1695448371400),(1695448977289,'2023-09-23 06:02:57',1695447642715,'meishituijian','健康轻食','file/1695447608296.jpg','1','','',1695448914825),(1695449038881,'2023-09-23 06:03:58',1695447507124,'jingdianxinxi','长隆世界','file/1695447468151.jpeg','1','','',1695448914825);
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `taoshengtongdao`
--
DROP TABLE IF EXISTS `taoshengtongdao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taoshengtongdao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`didianweizhi` varchar(200) NOT NULL COMMENT '地点位置',
`taoshengditu` longtext COMMENT '逃生地图',
`xianluzhiyin` longtext NOT NULL COMMENT '线路指引',
`gengxinshijian` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1695447703388 DEFAULT CHARSET=utf8 COMMENT='逃生通道';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `taoshengtongdao`
--
LOCK TABLES `taoshengtongdao` WRITE;
/*!40000 ALTER TABLE `taoshengtongdao` DISABLE KEYS */;
INSERT INTO `taoshengtongdao` VALUES (121,'2023-09-22 14:24:44','地点位置1','file/taoshengtongdaoTaoshengditu1.jpg,file/taoshengtongdaoTaoshengditu2.jpg,file/taoshengtongdaoTaoshengditu3.jpg','线路指引1','2023-09-22 22:24:44'),(122,'2023-09-22 14:24:44','地点位置2','file/taoshengtongdaoTaoshengditu2.jpg,file/taoshengtongdaoTaoshengditu3.jpg,file/taoshengtongdaoTaoshengditu4.jpg','线路指引2','2023-09-22 22:24:44'),(123,'2023-09-22 14:24:44','地点位置3','file/taoshengtongdaoTaoshengditu3.jpg,file/taoshengtongdaoTaoshengditu4.jpg,file/taoshengtongdaoTaoshengditu5.jpg','线路指引3','2023-09-22 22:24:44'),(124,'2023-09-22 14:24:44','地点位置4','file/taoshengtongdaoTaoshengditu4.jpg,file/taoshengtongdaoTaoshengditu5.jpg,file/taoshengtongdaoTaoshengditu6.jpg','线路指引4','2023-09-22 22:24:44'),(125,'2023-09-22 14:24:44','地点位置5','file/taoshengtongdaoTaoshengditu5.jpg,file/taoshengtongdaoTaoshengditu6.jpg,file/taoshengtongdaoTaoshengditu7.jpg','线路指引5','2023-09-22 22:24:44'),(126,'2023-09-22 14:24:44','地点位置6','file/taoshengtongdaoTaoshengditu6.jpg,file/taoshengtongdaoTaoshengditu7.jpg,file/taoshengtongdaoTaoshengditu8.jpg','线路指引6','2023-09-22 22:24:44'),(1695447703387,'2023-09-23 05:41:42','1号门','file/1695447698890.jpeg','<p>入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容</p>','2023-09-23 13:41:28');
/*!40000 ALTER TABLE `taoshengtongdao` 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=6 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,31,'用户账号1','yonghu','用户','1yui6tmen5liabe9pjm9crfnlurvafo1','2023-09-23 03:02:53','2023-09-23 06:51:49'),(2,1,'admin','users','管理员','qf39fhaslweqaqdplo3abokhhvsed6b0','2023-09-23 03:09:25','2023-09-23 06:23:13'),(3,1695447805250,'002','yonghu','用户','tkku1b7pt0dg6ebc0z8jedklrviyjzh4','2023-09-23 05:43:31','2023-09-23 06:43:32'),(4,1695448371400,'111','yonghu','用户','hesdn53pyj9y1cu9snv5vubtfo6ryega','2023-09-23 05:52:57','2023-09-23 06:57:34'),(5,1695448914825,'000','yonghu','用户','qezebqgafnextsygrwpaqdlwminl3mr5','2023-09-23 06:02:00','2023-09-23 07:02:00');
/*!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 '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`username` varchar(200) NOT NULL COMMENT '用户名',
`password` varchar(200) NOT NULL COMMENT '密码',
`role` varchar(200) DEFAULT NULL 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,'2023-09-22 14:24:44','admin','admin','管理员');
/*!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 '创建时间',
`yonghuzhanghao` varchar(200) NOT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) NOT NULL COMMENT '用户姓名',
`mima` varchar(200) NOT NULL COMMENT '密码',
`touxiang` longtext COMMENT '头像',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份证号',
PRIMARY KEY (`id`),
UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1695448914826 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 (31,'2023-09-22 14:24:43','用户账号1','用户姓名1','123456','','男','19819881111','441622200101010001'),(32,'2023-09-22 14:24:43','用户账号2','用户姓名2','123456','file/yonghuTouxiang2.jpg','男','19819881112','441622200202020002'),(33,'2023-09-22 14:24:43','用户账号3','用户姓名3','123456','file/yonghuTouxiang3.jpg','男','19819881113','441622200303030003'),(34,'2023-09-22 14:24:43','用户账号4','用户姓名4','123456','file/yonghuTouxiang4.jpg','男','19819881114','441622200404040004'),(35,'2023-09-22 14:24:43','用户账号5','用户姓名5','123456','file/yonghuTouxiang5.jpg','男','19819881115','441622200505050005'),(36,'2023-09-22 14:24:43','用户账号6','用户姓名6','123456','file/yonghuTouxiang6.jpg','男','19819881116','441622200606060006'),(1695447805250,'2023-09-23 05:43:25','002','陈红','002','','女','13823899999',''),(1695448371400,'2023-09-23 05:52:51','111','张三','111','','男','13823877776',''),(1695448914825,'2023-09-23 06:01:54','000','王强','000','','男','13823977778','');
/*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zhusuxinxi`
--
DROP TABLE IF EXISTS `zhusuxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zhusuxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhusumingcheng` varchar(200) NOT NULL COMMENT '住宿名称',
`zhusutupian` longtext COMMENT '住宿图片',
`zhusuleixing` varchar(200) NOT NULL COMMENT '住宿类型',
`xingji` varchar(200) DEFAULT NULL COMMENT '星级',
`fangjianleixing` varchar(200) NOT NULL COMMENT '房间类型',
`zhusudizhi` varchar(200) DEFAULT NULL COMMENT '住宿地址',
`yiwanjiage` double NOT NULL COMMENT '一晚价格',
`fuwudianhua` varchar(200) DEFAULT NULL COMMENT '服务电话',
`fangneisheshi` longtext COMMENT '房内设施',
`storeupnum` int(11) DEFAULT NULL COMMENT '收藏数量',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1695447679463 DEFAULT CHARSET=utf8 COMMENT='住宿信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zhusuxinxi`
--
LOCK TABLES `zhusuxinxi` WRITE;
/*!40000 ALTER TABLE `zhusuxinxi` DISABLE KEYS */;
INSERT INTO `zhusuxinxi` VALUES (101,'2023-09-22 14:24:43','住宿名称1','file/zhusuxinxiZhusutupian1.jpg,file/zhusuxinxiZhusutupian2.jpg,file/zhusuxinxiZhusutupian3.jpg','民宿','一星','单人间','住宿地址1',1,'010-21500991','房内设施1',1),(102,'2023-09-22 14:24:43','住宿名称2','file/zhusuxinxiZhusutupian2.jpg,file/zhusuxinxiZhusutupian3.jpg,file/zhusuxinxiZhusutupian4.jpg','民宿','一星','单人间','住宿地址2',2,'010-21500992','房内设施2',2),(103,'2023-09-22 14:24:43','住宿名称3','file/zhusuxinxiZhusutupian3.jpg,file/zhusuxinxiZhusutupian4.jpg,file/zhusuxinxiZhusutupian5.jpg','民宿','一星','单人间','住宿地址3',3,'010-21500993','房内设施3',3),(104,'2023-09-22 14:24:43','住宿名称4','file/zhusuxinxiZhusutupian4.jpg,file/zhusuxinxiZhusutupian5.jpg,file/zhusuxinxiZhusutupian6.jpg','民宿','一星','单人间','住宿地址4',4,'010-21500994','房内设施4',4),(105,'2023-09-22 14:24:43','住宿名称5','file/zhusuxinxiZhusutupian5.jpg,file/zhusuxinxiZhusutupian6.jpg,file/zhusuxinxiZhusutupian7.jpg','民宿','一星','单人间','住宿地址5',5,'010-21500995','房内设施5',5),(106,'2023-09-22 14:24:43','住宿名称6','file/zhusuxinxiZhusutupian6.jpg,file/zhusuxinxiZhusutupian7.jpg,file/zhusuxinxiZhusutupian8.jpg','民宿','一星','单人间','住宿地址6',6,'010-21500996','房内设施6',6),(1695447679462,'2023-09-23 05:41:18','七天酒店','file/1695447656611.jpeg','连锁酒店','三星','大床房','北京路',288,'020-1234567','<p>入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容</p><p><img src=\"http://localhost:8080/cl970340/file/1695447677165.jpeg\" alt=\"\" data-href=\"\" style=\"\"/></p>',0);
/*!40000 ALTER TABLE `zhusuxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zhusuyuding`
--
DROP TABLE IF EXISTS `zhusuyuding`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zhusuyuding` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yudingbianhao` varchar(200) DEFAULT NULL COMMENT '预订编号',
`zhusumingcheng` varchar(200) DEFAULT NULL COMMENT '住宿名称',
`fangjianleixing` varchar(200) DEFAULT NULL COMMENT '房间类型',
`yiwanjiage` double DEFAULT NULL COMMENT '一晚价格',
`zhusudizhi` varchar(200) DEFAULT NULL COMMENT '住宿地址',
`ruzhutianshu` int(11) NOT NULL COMMENT '入住天数',
`dingdanjine` double DEFAULT NULL COMMENT '订单金额',
`ruzhuriqi` date NOT NULL COMMENT '入住日期',
`yudingshijian` datetime DEFAULT NULL COMMENT '预订时间',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`ispay` varchar(200) DEFAULT NULL COMMENT '是否支付',
`sfsh` varchar(200) DEFAULT NULL COMMENT '是否审核',
`shhf` longtext COMMENT '回复内容',
PRIMARY KEY (`id`),
UNIQUE KEY `yudingbianhao` (`yudingbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1695449003959 DEFAULT CHARSET=utf8 COMMENT='住宿预订';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zhusuyuding`
--
LOCK TABLES `zhusuyuding` WRITE;
/*!40000 ALTER TABLE `zhusuyuding` DISABLE KEYS */;
INSERT INTO `zhusuyuding` VALUES (111,'2023-09-22 14:24:44','1111111111','住宿名称1','房间类型1',1,'住宿地址1',1,1,'2023-09-22','2023-09-22 22:24:44','用户账号1','用户姓名1','手机号码1','未支付','是',''),(112,'2023-09-22 14:24:44','2222222222','住宿名称2','房间类型2',2,'住宿地址2',2,2,'2023-09-22','2023-09-22 22:24:44','用户账号2','用户姓名2','手机号码2','未支付','是',''),(113,'2023-09-22 14:24:44','3333333333','住宿名称3','房间类型3',3,'住宿地址3',3,3,'2023-09-22','2023-09-22 22:24:44','用户账号3','用户姓名3','手机号码3','未支付','是',''),(114,'2023-09-22 14:24:44','4444444444','住宿名称4','房间类型4',4,'住宿地址4',4,4,'2023-09-22','2023-09-22 22:24:44','用户账号4','用户姓名4','手机号码4','未支付','是',''),(115,'2023-09-22 14:24:44','5555555555','住宿名称5','房间类型5',5,'住宿地址5',5,5,'2023-09-22','2023-09-22 22:24:44','用户账号5','用户姓名5','手机号码5','未支付','是',''),(116,'2023-09-22 14:24:44','6666666666','住宿名称6','房间类型6',6,'住宿地址6',6,6,'2023-09-22','2023-09-22 22:24:44','用户账号6','用户姓名6','手机号码6','未支付','是',''),(1695447931918,'2023-09-23 05:45:31','1695447919553','七天酒店','大床房',288,'北京路',2,576,'2023-10-01','2023-09-23 01:45:19','002','陈红','13823899999','未支付','待审核',''),(1695448217601,'2023-09-23 05:50:17','1695448206969','住宿名称1','单人间',1,'住宿地址1',2,2,'2023-09-23','2023-09-23 01:50:06','用户账号1','用户姓名1','19819881111','未支付','待审核',''),(1695448478058,'2023-09-23 05:54:38','1695448469416','七天酒店','大床房',288,'北京路',2,576,'2023-09-26','2023-09-23 01:54:29','111','张三','13823877776','未支付','待审核',''),(1695448671954,'2023-09-23 05:57:51','1695448664397','七天酒店','大床房',288,'北京路',3,864,'2023-09-23','2023-09-23 01:57:44','111','张三','13823877776','未支付','待审核',''),(1695448702854,'2023-09-23 05:58:22','1695448694101','住宿名称3','单人间',3,'住宿地址3',1,3,'2023-09-23','2023-09-23 01:58:13','111','张三','13823877776','未支付','待审核',''),(1695449003958,'2023-09-23 06:03:23','1695448995778','七天酒店','大床房',288,'北京路',2,576,'2023-09-27','2023-09-23 02:03:15','000','王强','13823977778','未支付','待审核','');
/*!40000 ALTER TABLE `zhusuyuding` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2023-09-26 16:58:42
阿龙开发的项目经验展示（项目案例）：
为什么选择我：
我是程序员阿龙，专注于软件开发，拥有丰富的编程能力和实战经验。在过去的几年里，我辅导了上千名学生，帮助他们顺利完成毕业项目，同时我的技术分享也吸引了超过50W+的粉丝。我是CSDN特邀作者、博客专家、新星计划导师，并在Java领域内获得了多项荣誉，如博客之星。我的作品也被掘金、华为云、阿里云、InfoQ等多个平台推荐，成为各大平台的优质作者。
在Java技术领域和学生毕业项目实战中，我积累了深厚的知识与经验，并与高校老师、讲师及行业内的同行前辈保持着广泛的交流与合作。我的专业背景和丰富的实战经验使我能够为你提供高质量的辅导和技术支持，助你在编程学习和项目开发中取得更好的成果。选择我，你将获得的不仅是技术上的提升，更是对项目的全面理解与掌控。
免费赠送相关学习资料：
