Java实现旅游网系统

水深无声 2022-01-29 02:34 218阅读 0赞

***学习Java实现旅游网系统，本文实现该系统的功能截图，和数据库设计SQL语句供大家参考***

## 旅游网系统 ##

本系统是做一个在线旅游的系统，支持登录、注册、查看旅游路线、旅游详情等等功能。

## 主要技术 ##

Spring、SpringMVC、Mybatis  
JSP、JSTL、jQuery、HTML、CSS、JS  
Mysql  
bootstrap  
开发工具和环境  
Eclipse  
Maven  
Tomcat 7  
JDK 1.8  
Mysql 5.6  
Win10 操作系统

## 数据库设计 ##

CREATE TABLE `tab_category` (
      `cid` int(11) NOT NULL AUTO_INCREMENT,
      `cname` varchar(100) NOT NULL,
      PRIMARY KEY (`cid`),
      UNIQUE KEY `AK_nq_categoryname` (`cname`)
    ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
    
    CREATE TABLE `tab_favorite` (
      `rid` int(11) NOT NULL,
      `date` date NOT NULL,
      `uid` int(11) NOT NULL,
      PRIMARY KEY (`rid`,`uid`),
      KEY `FK_user_favorite` (`uid`),
      CONSTRAINT `FK_route_favorite` FOREIGN KEY (`rid`) REFERENCES `tab_route` (`rid`),
      CONSTRAINT `FK_user_favorite` FOREIGN KEY (`uid`) REFERENCES `tab_user` (`uid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    CREATE TABLE `tab_route` (
      `rid` int(11) NOT NULL AUTO_INCREMENT,
      `rname` varchar(500) NOT NULL,
      `price` double NOT NULL,
      `routeIntroduce` varchar(1000) DEFAULT NULL,
      `rflag` char(1) NOT NULL,
      `rdate` varchar(19) DEFAULT NULL,
      `isThemeTour` char(1) NOT NULL,
      `count` int(11) DEFAULT '0',
      `cid` int(11) NOT NULL,
      `rimage` varchar(200) DEFAULT NULL,
      `sid` int(11) DEFAULT NULL,
      `sourceId` varchar(50) DEFAULT NULL,
      PRIMARY KEY (`rid`),
      UNIQUE KEY `AK_nq_sourceId` (`sourceId`),
      KEY `FK_category_route` (`cid`),
      KEY `FK_seller_route` (`sid`),
      CONSTRAINT `FK_category_route` FOREIGN KEY (`cid`) REFERENCES `tab_category` (`cid`),
      CONSTRAINT `FK_seller_route` FOREIGN KEY (`sid`) REFERENCES `tab_seller` (`sid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
    
    CREATE TABLE `tab_route_img` (
      `rgid` int(11) NOT NULL AUTO_INCREMENT,
      `rid` int(11) NOT NULL,
      `bigPic` varchar(200) NOT NULL,
      `smallPic` varchar(200) DEFAULT NULL,
      PRIMARY KEY (`rgid`),
      KEY `FK_route_routeimg` (`rid`),
      CONSTRAINT `FK_route_routeimg` FOREIGN KEY (`rid`) REFERENCES `tab_route` (`rid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
    
    CREATE TABLE `tab_seller` (
      `sid` int(11) NOT NULL AUTO_INCREMENT,
      `sname` varchar(200) NOT NULL,
      `consphone` varchar(20) NOT NULL,
      `address` varchar(200) DEFAULT NULL,
      PRIMARY KEY (`sid`),
      UNIQUE KEY `AK_Key_2` (`sname`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
    
    CREATE TABLE `tab_user` (
      `uid` int(11) NOT NULL AUTO_INCREMENT,
      `username` varchar(100) NOT NULL,
      `password` varchar(32) NOT NULL,
      `name` varchar(100) DEFAULT NULL,
      `birthday` date DEFAULT NULL,
      `sex` char(1) DEFAULT NULL,
      `telephone` varchar(11) DEFAULT NULL,
      `email` varchar(100) DEFAULT NULL,
      `status` char(1) DEFAULT NULL,
      `code` varchar(50) DEFAULT NULL,
      PRIMARY KEY (`uid`),
      UNIQUE KEY `AK_nq_username` (`username`),
      UNIQUE KEY `AK_nq_code` (`code`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

## 1.旅游网首页 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 1]

## 2.旅游网登录功能 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 2]

## 3.旅游网注册功能 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 3]

## 4.旅游路线功能 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 4]

## 5.旅游详情信息 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 5]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70]: /images/20220129/83c37ef8e68e4731a3d740b2105ae558.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 1]: /images/20220129/3aa3c38902104b5b811031127daa3d69.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 2]: /images/20220129/c62c3baf4644496eb8a691126f4cbb02.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 3]: /images/20220129/ebaf95c6ce584f4fbc0d0f020f1c94e8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 4]: /images/20220129/dc304a66ffad4fcc95f736f71e1b35c6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 5]: /images/20220129/8cc80f98e9d246e18fefd1e3cc651713.png