毕业设计基于JavaWeb的旅游网站

喜欢ヅ旅行 2024-02-24 03:03 79阅读 0赞

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

> 项目类型：JavaWeb源码
> 
> 用户类型：2个角色（管理员+用户）
> 
> 主要技术：Jsp+Servlet+MySQL+Jquery(前端Bootstrap)
> 
> 开发工具：Eclipse/Idea均可使用，有两个不同的版本
> 
> 数据库：MySQL
> 
> 数据库表：9张

**目录**

00完整的程序目录

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演示视频

--------------------

## 00 **完整的程序目录** ##

![0e0600ef92acda6be459bd2196def3e2.png][]

## 01 **管理员端** ##

### **1.0后台登录** ###

![323487f86bf74e44f297bfc9d2632e00.png][]

### 1.1用户管理模块 ###

![72b45529d015277bed5806c6889acc22.png][]

### **1.2酒店星级管理模块** ###

![1a7713eaa50deb1371f92e2d674a02cf.png][]

### **1.3景点管理模块** ###

![e51b5c8237eddb7aa7b496be5f5d8794.png][]

### **1.4酒店管理模块** ###

![3e6384cf97be1f4e164355f3ea83eaee.png][]

### **1.5旅游攻略管理模块** ###

![129f40be6b1f8cf9b1af03e41ee08619.png][]

### **1.6发布旅游景点** ###

![4549275cdc69de3405abe4ce9c92caa8.png][]

### **1.7修改旅游攻略** ###

![46dbaeb8b906211da2bc6fdbcfc360ee.png][]

## 02 **用户端** ##

### **2.1 用户端首页** ###

![91fedb3df746ad93a748358a539fa1b4.png][]

### **2.2景点预约及查询页面** ###

![fb570ca81333c00a6aad9a8dc749636b.png][]

### **2.3旅游攻略展示页面** ###

![881d273f928288f42d07bdbe42e1527d.png][]

### **2.4评论展示页面** ###

![0c3f577b203e1b32a26a52a0a06e4a49.png][]

### **2.5景点预约订单模块** ###

![5ade87bbd6139311ed235225285749ae.png][]

### **2.6评论管理页面** ###

![7696bca214f5401d5dd266c3ebc1e2de.png][]

## 03 **项目结构** ##

![1e9b5412b973b233b5732d565bbf5e33.png][]

## 04 **数据库设计** ##

![b2ee12123925c45b9baf511a253ac085.png][]

## 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, '紫

## 项目获取: ##

[https://gitee.com/sinonfin/L-javaWebSha/tree/master][https_gitee.com_sinonfin_L-javaWebSha_tree_master]

[0e0600ef92acda6be459bd2196def3e2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/07757034cc5d452082004e0634736ae4.png
[323487f86bf74e44f297bfc9d2632e00.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/52f4c5940bb4465ea3f0d61a79be4e00.png
[72b45529d015277bed5806c6889acc22.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/3d9ad001db8842b28441f348f744120e.png
[1a7713eaa50deb1371f92e2d674a02cf.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/a25cbecf0c1d47d0bcb33b491dc3aeb1.png
[e51b5c8237eddb7aa7b496be5f5d8794.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/60c5d27d38684b0cb0661867eba3afca.png
[3e6384cf97be1f4e164355f3ea83eaee.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/0c7f530de1264105b31adf9113294280.png
[129f40be6b1f8cf9b1af03e41ee08619.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/21c0b613c6ed4496ab8ea8474551d84b.png
[4549275cdc69de3405abe4ce9c92caa8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/e4f3e754e21e47b0a65b16f78e25275e.png
[46dbaeb8b906211da2bc6fdbcfc360ee.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/d58590ad050d45588ebe57a89a8b9b11.png
[91fedb3df746ad93a748358a539fa1b4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/7f86914431934c5baad1326fc39f8d14.png
[fb570ca81333c00a6aad9a8dc749636b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/52da11e1214d40c09da742f163bd96fe.png
[881d273f928288f42d07bdbe42e1527d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/848494694a444d5890812a140a17d55c.png
[0c3f577b203e1b32a26a52a0a06e4a49.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/db3f116e6f614512a48756f74e8c0bda.png
[5ade87bbd6139311ed235225285749ae.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/70dc384cba874198808455056c355cfb.png
[7696bca214f5401d5dd266c3ebc1e2de.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/b3ec4373e0f94ccb860d22d905835341.png
[1e9b5412b973b233b5732d565bbf5e33.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/38502de9d8234d7ea0675f296688c49e.png
[b2ee12123925c45b9baf511a253ac085.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/24/5effa8a073dd4fac8cb7bb34293c4b98.png
[https_gitee.com_sinonfin_L-javaWebSha_tree_master]: https://gitee.com/sinonfin/L-javaWebSha/tree/master