Java+Springboot+Mybatis+Mysql+Bootstrap+Maven实现景区旅游管理系统

《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！

10.用户-景点预订​

11.用户-我的预订​

12.管理员-登录​

13.管理员-用户管理​

14.管理员-酒店管理​

15.管理员-景点管理​

16.管理员-攻略管理​

17.管理员-路线管理​

三、部分代码

IndexController

LoginController

ReserveController

RouteController

StrategyController

SystemController

UserCenterController

四、其他

1.更多系统

2.源码下载

3.运行项目

4.备注

5.支持博主

---

一、系统介绍

======

1.开发环境

---

开发工具：Eclipse2021

JDK版本：jdk1.8

Mysql版本：8.0.13

2.技术选型

---

Java+Swing+Mysql

3.系统功能

---

用户

1.注册登录

2.旅游路线选择

3.旅游攻略选择

4.酒店预订

5.景点预订

管理员

1.用户管理

2.酒店管理

3.景点管理

4.攻略管理

5.路线管理

4.数据库

---

/*

Navicat Premium Data Transfer

Source Server : MYSQL

Source Server Type : MySQL

Source Server Version : 80013

Source Host : localhost:3306

Source Schema : springboot_travel

Target Server Type : MySQL

Target Server Version : 80013

File Encoding : 65001

Date: 22/10/2021 10:49:18

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

---

– Table structure for attractions

---

DROP TABLE IF EXISTS attractions;

CREATE TABLE attractions (

id varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

image varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

attractions_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

attractions_address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

attractions_describe varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

attractions_status int(2) NULL DEFAULT 0,

create_date datetime NOT NULL,

PRIMARY KEY (id) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

---

– Records of attractions

---

INSERT INTO attractions VALUES (‘1’, ‘MY_jingdian_01’, ‘清凉寨景区’, ‘蔡店街道西北部’, ‘景区总面积6000余亩，年平均温度低于武汉市中心城区4-6度；山体高大陡峭，植被丰富，层峦叠嶂。木兰清凉寨十里中华樱花、映山红、油菜花、茶花花花飘香，推出的攀水瀑布、古炭窑、滴水观音、九龙飞瀑等旅游景点，加入丰富多彩的祈福、采茶等活动。’, 0, ‘2020-03-04 20:00:09’);

INSERT INTO attractions VALUES (‘9’, ‘MY_jingdian_06’, ‘桐乡乌镇古镇旅游区’, ‘：浙江省嘉兴桐乡市乌镇石佛南路18号’, ‘乌镇是典型的江南水乡古镇，素有“鱼米之乡，丝绸之府”之称。全镇以河成街，桥街相连，依河筑屋，深宅大 院，重脊高檐，河埠廊坊，过街骑楼，穿竹石栏，临河水阁，古色古香，水镇一体，呈现一派古朴、明洁的幽静，是江南典型的“小桥、流水、人家”石板小路，古旧木屋，还有清清湖水的气息，仿佛都在提示着一种情致，一种氛围。\r\n’, 0, ‘2020-03-04 20:00:09’);

---

– Table structure for hotel

---

DROP TABLE IF EXISTS hotel;

CREATE TABLE hotel (

id varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

image varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

hotel_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

hotel_address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

hotel_describe varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

hotel_status int(2) NULL DEFAULT 0,

create_date datetime NOT NULL,

PRIMARY KEY (id) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

---

– Records of hotel

---

INSERT INTO hotel VALUES (‘1’, ‘MY_kezhan_01’, ‘吉安国际酒店111’, ‘吉安县城庐陵大道庐陵广场111’, ‘酒店功能完善，设有包括总统套房、豪华商务套房等各色客房297间，酒店拥有中餐厅、西餐厅、韩国餐厅、火锅餐厅四个不同风味的餐饮场所，就餐总座位数1600余位，另设有可接待500人的宴会厅、可容纳400人的国际会议中心以及夜总会、spa桑拿及足道、露天泳池、健身中心和网球场，可为宾客提供各式全新五星水准的酒店住宿、饮食、宴会、会议、康体和娱乐一体化的服务。另500多个车位的大型停车场，为宾客的出行提供了更多的便利。’, 1, ‘2020-02-05 19:36:37’);

INSERT INTO hotel VALUES (‘11’, ‘MY_kezhan_01’, ‘海澜大酒店’, ‘江阴市苏南工业重镇新桥镇海澜工业园内’, ‘海澜大酒店是一家商务、会议型豪华酒店，是江阴市首家五星级酒店。酒店座落在苏南工业重镇新桥镇海澜工业园内，北枕长江，南靠太湖，毗邻张家港市中心，宁太（沿江）高速横亘其侧，交通极其便利。酒店按欧式风格设计装修，环境优美，格调高雅。客房舒适、豪华，餐饮风味独特，各类康乐休闲设施一应俱全，设施先进的商务中心随时为您提供周到、快捷的服务。’, 0, ‘2020-02-04 19:37:04’);

INSERT INTO hotel VALUES (‘29’, ‘MY_kezhan_04’, ‘米兰酒店’, ‘广西省南宁市’, ‘酒店按欧式风格设计装修，环境优美，格调高雅。客房舒适、豪华，餐饮风味独特，各类康乐休闲设施一应俱全，设施先进的商务中心随时为您提供周到、快捷的服务。’, 0, ‘2020-02-04 19:37:49’);

---

– Table structure for sys_user

---

DROP TABLE IF EXISTS sys_user;

CREATE TABLE sys_user (

id int(11) NOT NULL AUTO_INCREMENT,

username varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

password varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

PRIMARY KEY (id) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

---

– Records of sys_user

---

INSERT INTO sys_user VALUES (1, ‘admin’, ‘admin’);

INSERT INTO sys_user VALUES (2, ‘zuidaima’, ‘111111’);

---

– Table structure for travel_route

---

DROP TABLE IF EXISTS travel_route;

CREATE TABLE travel_route (

id varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

route_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

route_describe varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

route_status int(2) NOT NULL DEFAULT 0,

route_address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

collect_number int(32) NOT NULL DEFAULT 0,

create_date datetime NULL DEFAULT NULL,

update_date datetime NULL DEFAULT NULL,

PRIMARY KEY (id) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = ut