主要功能介绍：本系统基于Java语言开发。在开发的时候，使用JavaWeb技术实现。核心业务围绕旅游景点门票预定展开。此外，基础功能应当能够完成对景点信息、附近酒店、旅游攻略、用户信息的管理。在此基础，构建一个对应的网站，用于展示和介绍各种旅游景点。对于相关的数据，通过MySQL存储。整个系统的开发，遵循MVC设计模式。

项目类型：JavaWeb源码 

用户类型：2个角色（管理员+用户）

主要技术：Jsp+Servlet+MySQL+Jquery(前端Bootstrap)

开发工具：Eclipse/Idea均可使用，有两个不同的版本

数据库：MySQL

数据库表：9张

🍅演示视频在底部🍅

🍅文末获取联系🍅

目录

01管理员端

1.0后台登录

1.1用户管理模块

1.2酒店星级管理模块

1.3景点管理模块

1.4酒店管理模块

1.5旅游攻略管理模块

1.6发布旅游景点

1.7修改旅游攻略

02用户端

2.1 用户端首页

2.2景点预约及查询页面

2.3旅游攻略展示页面

2.4评论展示页面

2.5景点预约订单模块

2.6评论管理页面

03项目结构

04数据库设计

05演示视频

01管理员端

1.0系统首页

1.1用户管理模块

1.2酒店星级管理模块

1.3景点管理模块

1.4酒店管理模块

1.5旅游攻略管理模块

1.6发布旅游景点

1.7修改旅游攻略

02用户端

2.1 用户端首页

2.2景点预约及查询页面

2.3旅游攻略展示页面

2.4评论展示页面

2.5景点预约订单模块

2.6评论管理页面

03项目结构

04数据库设计

05演示视频

【原创】基于JavaWeb的旅游网站

 完整的程序目录



-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int(11) NOT NULL COMMENT 'id',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, '1', '1');

-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `arename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `detail` varchar(2552) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `price` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `open` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `dayno` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;


-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (2, '亲自旅游攻略');
INSERT INTO `category` VALUES (3, '家庭旅游攻略');
INSERT INTO `category` VALUES (4, '情侣旅游攻略');
INSERT INTO `category` VALUES (5, '单人旅游攻略');
INSERT INTO `category` VALUES (6, '组团旅游攻略');

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comments` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `times` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `nid` int(11) DEFAULT NULL,
  `category` int(11) DEFAULT NULL COMMENT '0是攻略，1是景点',
  `aid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of comments
-- ----------------------------
INSERT INTO `comments` VALUES (1, '还看！！！！！！！！！！！！！！！！！', '2022-10-28 22:03', '10', 'c80cdd1d-e7df-4d65-9dfa-64358267e409.jpeg', 10, 0, NULL);
INSERT INTO `comments` VALUES (2, '还看！！！！！！！！！！！！！！！！！', '2022-10-28 22:03', '10', 'c80cdd1d-e7df-4d65-9dfa-64358267e409.jpeg', 10, 0, NULL);
INSERT INTO `comments` VALUES (3, '还看！！！！！！！！！！！！！！！！！', '2022-10-28 22:03', '10', 'c80cdd1d-e7df-4d65-9dfa-64358267e409.jpeg', 10, 0, NULL);
INSERT INTO `comments` VALUES (5, '123123', '2022-10-28 22:03', '10', '34596ea3-ebd1-46e9-9e29-91396d065913.jpg', 10, 0, NULL);
INSERT INTO `comments` VALUES (7, '在完全自然的环境中亲睹国家一级保护动物黑颈鹤的蹁跹身姿！隆冬时节的大海子，一切都还沉浸在倦慵的睡意里', '2022-10-28 22:03', '10', '34596ea3-ebd1-46e9-9e29-91396d065913.jpg', 20, 0, NULL);
INSERT INTO `comments` VALUES (8, '355', '2022-10-28 22:03', '10', '435fbd11-bfd8-4bef-afc5-dc1fb0a4500e.jpg', 18, 0, NULL);
INSERT INTO `comments` VALUES (9, '123', '2022-10-28 22:03', '10', 'edca5a82-c4a6-4cb1-a489-0ce47a720b5d.jpg', 19, 0, NULL);
INSERT INTO `comments` VALUES (10, '11', '2022-10-28 22:03', '10', 'edca5a82-c4a6-4cb1-a489-0ce47a720b5d.jpg', 19, 0, NULL);
INSERT INTO `comments` VALUES (11, '123', '2022-10-28 22:03', '10', 'edca5a82-c4a6-4cb1-a489-0ce47a720b5d.jpg', NULL, 0, 4);
INSERT INTO `comments` VALUES (12, '123', '2022-10-28 22:03', '10', 'edca5a82-c4a6-4cb1-a489-0ce47a720b5d.jpg', NULL, 0, 4);
INSERT INTO `comments` VALUES (13, '123', '2022-10-28 22:03', '10', 'edca5a82-c4a6-4cb1-a489-0ce47a720b5d.jpg', 20, 1, NULL);
INSERT INTO `comments` VALUES (14, '44', '2022-10-28 22:03', '10', 'edca5a82-c4a6-4cb1-a489-0ce47a720b5d.jpg', NULL, 0, 5);
INSERT INTO `comments` VALUES (15, '123', '2022-10-28 22:03', '10', 'edca5a82-c4a6-4cb1-a489-0ce47a720b5d.jpg', 18, 1, NULL);
INSERT INTO `comments` VALUES (16, '235', '2022-10-28 22:03', '10', 'edca5a82-c4a6-4cb1-a489-0ce47a720b5d.jpg', NULL, 0, 4);
INSERT INTO `comments` VALUES (17, '123', '2022-10-28 22:03', '10', 'edca5a82-c4a6-4cb1-a489-0ce47a720b5d.jpg', NULL, 0, 5);
INSERT INTO `comments` VALUES (18, '123', '2022-10-28 22:03', '10', 'edca5a82-c4a6-4cb1-a489-0ce47a720b5d.jpg', NULL, 0, 4);
INSERT INTO `comments` VALUES (19, '123', '2023-08-10 22:31', '5', 'a01b4a6f-441a-4e19-ac9d-b26db7550454.png', NULL, 0, 17);
INSERT INTO `comments` VALUES (20, '124124', '2023-08-10 22:31', '5', 'a01b4a6f-441a-4e19-ac9d-b26db7550454.png', NULL, 0, 17);

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `content` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `times` varchar(33) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `see_count` int(11) DEFAULT 0,
  `comment_count` int(11) DEFAULT 0,
  `editor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for record
-- ----------------------------
DROP TABLE IF EXISTS `record`;
CREATE TABLE `record`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `createtime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ydate` varchar(111) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `state` int(255) DEFAULT NULL COMMENT '0预约成功，1取消预约',
  `aid` int(11) DEFAULT NULL,
  `yuyueno` varchar(112) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `numbers` int(11) DEFAULT NULL,
  `zf` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of record
-- ----------------------------
INSERT INTO `record` VALUES (1, 5, '2023-01-31', '2023-01-31', 1, 16, '20221031130900058', 1, 0);
INSERT INTO `record` VALUES (2, 5, '2023-01-31', '2023-01-31', 0, 16, '20221209224806764', 1, 0);
INSERT INTO `record` VALUES (3, 5, '2023-08-10', '2023-08-10', 0, 17, '20230810223118858', 2, NULL);

-- ----------------------------
-- Table structure for room
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roomname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `details` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of room
-- ----------------------------
INSERT INTO `room` VALUES (5, '江山大酒店', '五星级', '江山大酒店位于昭阳区海楼路，近振兴路，这里集行政办公、高档商场、休闲娱乐、生活小区为一体，交通极其便利。', '9fbf4731-9184-44c2-aca2-17805a608c7d.jpg', '18020185141');
INSERT INTO `room` VALUES (6, '富松大酒店', '一星级', '富松大酒店位于昭阳区金鹰大道，是由昭通富松酒店管理有限公司投资装修的现代新型豪华酒店。酒店占地8亩，总建筑面积1万多平方米，是集客房、餐饮、康体、娱乐休闲、会议服务为一体的精品型商务酒店。酒店分地下一层、地上十层，地面上下可停泊100多辆车，酒店拥有140多套豪华气派的客房，包括标准间、商务单间、豪华单间、情侣房、豪华套房等各类房型。', '9fbf4731-9184-44c2-aca2-17805a608c7d.jpg', '18020185142');
INSERT INTO `room` VALUES (8, '轻奢酒店 ', '二星级', '酒店位于昭通市昭阳区昭通大道旁省耕山水商业区F幢，昭通市第一人民医院正对面，地处昭阳区繁华商圈省耕山水商业区，是一家高端商务智能酒店。距渝昆高速出口约6公里，交通非常便捷。酒店所处商业区内有各种特色餐饮、百货超市、时尚购物街区、咖啡、茶楼、酒吧、KTV等场所，号称昭通第一湖的省耕文化公园就在酒店旁边。', '9fbf4731-9184-44c2-aca2-17805a608c7d.jpg', '18020182141');
INSERT INTO `room` VALUES (9, '紫光大酒店(水富店) ', '一星级', '紫光大酒店(水富店)地处水富县并临江而建，景观优美，商旅便利、游客云集。 这是由昭通紫光大酒店管理公司投资打造的高端酒店，为您提供住宿、餐饮、会议、休闲茶吧、停车等服务。酒店将尊崇品质、注重细节，让宾客感受俯瞰长江及城市美景同时感受个性管家服务、客房自助茶歇及百兆极速宽带带来的尊贵服务的魅力。', '9fbf4731-9184-44c2-aca2-17805a608c7d.jpg', '1802035141');
INSERT INTO `room` VALUES (10, '紫光大酒店 ', '四星级', '紫光大酒店位于朱提大道与民航路交汇处，临近民航路、圆宝山公园，距离昭通机场仅需3分钟车程，交通十分便利。 昭通紫光大酒店占地面积34740平方米，拥有六栋欧式别墅，设有12种时尚、舒适的客房，并附设多个会议室及大型多功能宴会厅、中餐厅、西餐厅、茶吧、大堂吧等。', '9fbf4731-9184-44c2-aca2-17805a608c7d.jpg', '18020185149');

-- ----------------------------
-- Table structure for type
-- ----------------------------
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of type
-- ----------------------------
INSERT INTO `type` VALUES (1, '一星级');
INSERT INTO `type` VALUES (2, '二星级');
INSERT INTO `type` VALUES (3, '三星级');
INSERT INTO `type` VALUES (4, '四星级');
INSERT INTO `type` VALUES (5, '五星级');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stno` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sums` double(11, 2) DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (5, '1', '1', '张三2123', 'zhangsan@qq.com', '2023-01-31', 0.00, 'a01b4a6f-441a-4e19-ac9d-b26db7550454.png');
INSERT INTO `user` VALUES (6, '002', '123456', '李四2', '114@qq.com', '2023-01-31', 0.00, '34596ea3-ebd1-46e9-9e29-91396d065913.jpg');
INSERT INTO `user` VALUES (8, 'zhangsan', '123456', '张三', 'zhangsan@qq.com', '2023-01-31', 0.00, '34596ea3-ebd1-46e9-9e29-91396d065913.jpg');
INSERT INTO `user` VALUES (9, 'lisi', '123456', '李四', '74361313@qq.com', '2023-01-31', 0.00, '435fbd11-bfd8-4bef-afc5-dc1fb0a4500e.jpg');

SET FOREIGN_KEY_CHECKS = 1;

Logo
GitCode 开源社区

旨在为数千万中国开发者提供一个无缝且高效的云端环境，以支持学习、使用和贡献开源项目。

更多推荐

[转载]在Windows环境下安装GNU Radio

转自：在Windows环境下安装GNURadio_恐弱智_新浪博客GNU Radio是用Python开发的，大部分开源的工程能够在Linux环境下运行良好，而Windows下却运行的很勉强，而且安装配置都很复杂。GNU Radio算是个例外了，不光提供了Windows的二进制安装，还有比较详细的说明。我是Python小白，所以折腾了好久才弄好，特意记录下来，免得以后再装还折腾。GNU Radio的

avatar GitCode 开源社区

centOS 8 使用dnf安装Docker

DNF是什么？CentOS 8使用YUM软件包管理器版本v4.0.4。现在，该版本使用DNF(已删除YUM)。DNF是软件包管理器。它会在Linux发行版上安装，执行更新并删除软件包。使用DNF安装Docker跳过具有损坏依赖性的程序包一个有效的解决方案是使您的CentOS 8系统使用以下--nobest命令安装最符合条件的版本：sudo dnf install docker...

avatar GitCode 开源社区

定时同步数据库表(mysql+linux+crontab)

sync.sh里面的参数需要改变，ip/username/password/database/tablesync.sh#!/bin/sh# Please change the IP and password of the data source db.# Then change the table name.filename=/home/nington/db/$(date +%Y-%m

avatar GitCode 开源社区