Java实现旅游网系统

最新推荐文章于 2025-02-13 11:58:59 发布

原创最新推荐文章于 2025-02-13 11:58:59 发布 · 8.2k 阅读

46 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

Java Web

学习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;