cover

【原创】基于JavaWeb的旅游网站（旅游网站毕业设计）

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

文章共4,692字 · 阅读需要大约16分钟

一键AI生成摘要，助你高效阅读

问答

那条学长V

4686人浏览 · 2023-08-10 23:10:44

那条学长V · 2023-08-10 23:10:44 发布

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

项目类型：JavaWeb源码

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

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

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

数据库：MySQL

数据库表：9张

🍅演示视频在底部🍅

🍅文末获取联系🍅

目录

1.0后台登录

1.1用户管理模块

1.2酒店星级管理模块

1.3景点管理模块

1.4酒店管理模块

1.5旅游攻略管理模块

1.6发布旅游景点

1.7修改旅游攻略

2.1 用户端首页

2.2景点预约及查询页面

2.3旅游攻略展示页面

2.4评论展示页面

2.5景点预约订单模块

2.6评论管理页面

04 数据库设计

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;

GitCode 开源社区

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

更多推荐

cover

GitTalk | 使用面向业务的狮偶编程语言提升开发效率

GitCode 开源社区

cover

GitTalk | DevUI Suits 场景解决方案

GitCode 开源社区

cover

GitTalk | DevUI Admin 前端项目构建

GitCode 开源社区

所有评论(0)

查看更多评论

那条学长V

已为社区贡献6条内容