[2025]基于HTML平台的崇左市太平古城智慧旅游APP软件设计与实现、基于HTML5的崇左市太平古城智慧旅游APP开发、崇左市太平古城智慧旅游APP设计、HTML5驱动的崇左市太平古城智慧旅游系统

博主介绍：
    ✌我是阿龙，一名专注于 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','输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容','
入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容 
',3,'2023-09-23 14:03:56',8,' 广州 ','
 入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容
');
/*!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','广州路','
入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容
',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','
入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容
','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','
入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容输入购票须知内容
',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 技术领域和学生毕业项目实战中，我积累了深厚的知识与经验，并与高校老师、讲师及行业内的同行前辈保持着广泛的交流与合作。我的专业背景和丰富的实战经验使我能够为你提供高质量的辅导和技术支持，助你在编程学习和项目开发中取得更好的成果。选择我，你将获得的不仅是技术上的提升，更是对项目的全面理解与掌控。

免费赠送相关学习资料：