Java黑马旅游网项目

/* SQLyog Ultimate v10.00 Beta1 MySQL - 5.5.51 : Database - travel ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`travel` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `travel`; /*Table structure for table `admin` */ DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, `password` varchar(15) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `admin` */ insert into `admin`(`id`,`name`,`password`) values (1,'sun','123'); /*Table structure for table `hotel_favorite` */ DROP TABLE IF EXISTS `hotel_favorite`; CREATE TABLE `hotel_favorite` ( `rid` int(11) DEFAULT NULL, `date` date DEFAULT NULL, `uid` int(11) DEFAULT NULL, `status` varchar(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `hotel_favorite` */ insert into `hotel_favorite`(`rid`,`date`,`uid`,`status`) values (4,'2022-03-07',9,'Y'),(11,'2022-03-07',9,'Y'),(10,'2022-03-07',9,'Y'),(9,'2022-03-07',9,'Y'),(7,'2022-03-07',9,'Y'),(8,'2022-03-07',9,'Y'),(8,'2022-03-10',43,'Y'),(2,'2022-03-11',43,'Y'); /*Table structure for table `hotel_route` */ DROP TABLE IF EXISTS `hotel_route`; CREATE TABLE `hotel_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`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; /*Data for the table `hotel_route` */ insert into `hotel_route`(`rid`,`rname`,`price`,`routeIntroduce`,`rflag`,`rdate`,`isThemeTour`,`count`,`cid`,`rimage`,`sid`,`sourceId`) values (2,'万达广场酒店',200,'领包入住，两点退房','1','2018-02-09 01:13:17','0',990,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48858.jpeg',1,'22066'),(3,'万达喜来登酒店',153,'领包入住，两点退房','1','2018-02-09 01:13:17','0',0,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48857.jpeg',1,'21998'),(4,'中豪国际酒店长安万达店',120,'领包入住，两点退房','1','2018-02-09 01:13:17','0',0,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48851.jpeg',1,'21943'),(5,'吴江海悦大酒店',250,'领包入住，两点退房','1','2018-02-09 01:13:17','0',0,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48852.jpeg',1,'21917'),(6,'希岸酒店',142,'领包入住，两点退房','1','2018-02-09 01:13:17','0',0,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48854.jpeg',1,'16968'),(7,'开平丰越酒店',102,'领包入住，两点退房','1','2018-02-09 01:13:17','0',0,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48853.jpeg',1,'14974'),(8,'机自水晶酒店',99,'领包入住，两点退房','1','2018-02-09 01:13:17','0',0,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48855.jpeg',1,'13580'),(9,'秀山毫升大酒店',199,'领包入住，两点退房','1','2018-02-09 01:13:17','0',0,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48856.jpeg',1,'2702'),(10,'私立蓝鸟卡酒店',154,'领包入住，两点退房','1','2018-02-09 01:13:17','0',0,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48859.jpeg',1,'20523'),(11,'维也纳国际酒店',132,'领包入住，两点退房','1','2018-02-09 01:13:17','0',0,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48817.jpeg',1,'20517'),(12,'肇庆国际大酒店',199,'领包入住，两点退房','1','2018-02-09 01:13:17','0',0,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48827.jpeg',1,'20060'); /*Table structure for table `tab_category` */ DROP TABLE IF EXISTS `tab_category`; 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; /*Data for the table `tab_category` */ insert into `tab_category`(`cid`,`cname`) values (8,'全球自由行'),(5,'国内游'),(4,'处境游'),(7,'抱团定制'),(6,'港澳游'),(2,'酒店'),(1,'门票'),(3,'香港车票'); /*Table structure for table `tab_favorite` */ DROP TABLE IF EXISTS `tab_favorite`; 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; /*Data for the table `tab_favorite` */ insert into `tab_favorite`(`rid`,`date`,`uid`) values (1,'2022-03-04',9),(2,'2022-03-04',9),(3,'2022-03-04',9),(4,'2022-03-04',9),(5,'2022-03-05',9),(6,'2022-03-04',9),(8,'2022-03-04',9),(30,'2022-03-04',9); /*Table structure for table `tab_hotel_img` */ DROP TABLE IF EXISTS `tab_hotel_img`; CREATE TABLE `tab_hotel_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`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; /*Data for the table `tab_hotel_img` */ insert into `tab_hotel_img`(`rgid`,`rid`,`bigPic`,`smallPic`) values (1,2,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48858.jpeg','img/product/smalll/84d6b3bae1097071e2aaa0db4ba48858.jpeg'),(2,3,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48857.jpeg','img/product/smalll/84d6b3bae1097071e2aaa0db4ba48857.jpeg'),(3,4,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48851.jpeg','img/product/smalll/84d6b3bae1097071e2aaa0db4ba48851.jpeg'),(4,5,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48852.jpeg','img/product/smalll/84d6b3bae1097071e2aaa0db4ba48852.jpeg'),(5,6,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48854.jpeg','img/product/smalll/84d6b3bae1097071e2aaa0db4ba48854.jpeg'),(6,7,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48853.jpeg','img/product/smalll/84d6b3bae1097071e2aaa0db4ba48853.jpeg'),(7,8,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48855.jpeg','img/product/smalll/84d6b3bae1097071e2aaa0db4ba48855.jpeg'),(8,9,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48856.jpeg','img/product/smalll/84d6b3bae1097071e2aaa0db4ba48856.jpeg'),(9,10,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48859.jpeg','img/product/smalll/84d6b3bae1097071e2aaa0db4ba48859.jpeg'),(10,11,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48817.jpeg','img/product/smalll/84d6b3bae1097071e2aaa0db4ba48817.jpeg'),(11,12,'img/product/smalll/84d6b3bae1097071e2aaa0db4ba48827.jpeg','img/product/smalll/84d6b3bae1097071e2aaa0db4ba48827.jpeg'); /*Table structure for table `tab_route` */ DROP TABLE IF EXISTS `tab_route`; 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 `F