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

主要功能介绍
:本系统基于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 完整的程序目录

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


项目获取:

https://gitee.com/sinonfin/L-javaWebSha/tree/master

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值