学习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.旅游网首页