介绍:
jsp,servlet,mysql,Navicat,eclipse
效果截图:
数据库表:
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;
– Records of tab_category
INSERT INTO
tab_category
VALUES (‘8’, ‘全球自由行’);
INSERT INTO
tab_category
VALUES (‘5’, ‘国内游’);
INSERT INTO
tab_category
VALUES (‘4’, ‘处境游’);
INSERT INTO
tab_category
VALUES (‘7’, ‘抱团定制’);
INSERT INTO
tab_category
VALUES (‘6’, ‘港澳游’);
INSERT INTO
tab_category
VALUES (‘2’, ‘酒店’);
INSERT INTO
tab_category
VALUES (‘1’, ‘门票’);
INSERT INTO
tab_category
VALUES (‘3’, ‘香港车票’);
– Table structure for
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;
– Records of tab_favorite
INSERT INTO
tab_favorite
VALUES (‘1’, ‘2019-04-16’, ‘1’);
INSERT INTO
tab_favorite
VALUES (‘1’, ‘2019-06-27’, ‘7’);
INSERT INTO
tab_favorite
VALUES (‘2’, ‘2019-04-16’, ‘1’);
INSERT INTO
tab_favorite
VALUES (‘2’, ‘2019-06-27’, ‘7’);
INSERT INTO
tab_favorite
VALUES (‘26’, ‘2019-06-27’, ‘7’);
– Table structure for
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
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=514 DEFAULT CHARSET=utf8;