/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50527
Source Host : localhost:3306
Source Database : travel
Target Server Type : MYSQL
Target Server Version : 50527
File Encoding : 65001
Date: 2021-07-11 21:24:39
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
`roleId` int(11) NOT NULL,
`permissionId` int(11) NOT NULL,
PRIMARY KEY (`permissionId`,`roleId`),
KEY `roleId` (`roleId`),
CONSTRAINT `role_permission_ibfk_1` FOREIGN KEY (`permissionId`) REFERENCES `tab_permission` (`id`),
CONSTRAINT `role_permission_ibfk_2` FOREIGN KEY (`roleId`) REFERENCES `tab_role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of role_permission
-- ----------------------------
INSERT INTO `role_permission` VALUES ('1', '1');
INSERT INTO `role_permission` VALUES ('1', '2');
INSERT INTO `role_permission` VALUES ('1', '3');
INSERT INTO `role_permission` VALUES ('1', '4');
INSERT INTO `role_permission` VALUES ('1', '6');
INSERT INTO `role_permission` VALUES ('1', '7');
INSERT INTO `role_permission` VALUES ('1', '8');
INSERT INTO `role_permission` VALUES ('1', '9');
INSERT INTO `role_permission` VALUES ('1', '10');
INSERT INTO `role_permission` VALUES ('1', '11');
INSERT INTO `role_permission` VALUES ('1', '12');
INSERT INTO `role_permission` VALUES ('1', '13');
INSERT INTO `role_permission` VALUES ('1', '14');
INSERT INTO `role_permission` VALUES ('1', '15');
INSERT INTO `role_permission` VALUES ('1', '16');
INSERT INTO `role_permission` VALUES ('1', '17');
INSERT INTO `role_permission` VALUES ('1', '18');
INSERT INTO `role_permission` VALUES ('1', '19');
INSERT INTO `role_permission` VALUES ('1', '20');
INSERT INTO `role_permission` VALUES ('1', '21');
INSERT INTO `role_permission` VALUES ('1', '22');
INSERT INTO `role_permission` VALUES ('1', '23');
INSERT INTO `role_permission` VALUES ('1', '24');
INSERT INTO `role_permission` VALUES ('1', '25');
INSERT INTO `role_permission` VALUES ('1', '26');
INSERT INTO `role_permission` VALUES ('1', '27');
INSERT INTO `role_permission` VALUES ('1', '28');
INSERT INTO `role_permission` VALUES ('1', '29');
INSERT INTO `role_permission` VALUES ('1', '30');
INSERT INTO `role_permission` VALUES ('1', '31');
INSERT INTO `role_permission` VALUES ('1', '32');
INSERT INTO `role_permission` VALUES ('1', '33');
INSERT INTO `role_permission` VALUES ('1', '34');
INSERT INTO `role_permission` VALUES ('1', '35');
INSERT INTO `role_permission` VALUES ('1', '36');
INSERT INTO `role_permission` VALUES ('1', '37');
INSERT INTO `role_permission` VALUES ('1', '38');
INSERT INTO `role_permission` VALUES ('1', '39');
INSERT INTO `role_permission` VALUES ('1', '40');
INSERT INTO `role_permission` VALUES ('1', '41');
INSERT INTO `role_permission` VALUES ('1', '42');
INSERT INTO `role_permission` VALUES ('1', '43');
INSERT INTO `role_permission` VALUES ('1', '44');
INSERT INTO `role_permission` VALUES ('1', '45');
INSERT INTO `role_permission` VALUES ('1', '46');
INSERT INTO `role_permission` VALUES ('1', '47');
INSERT INTO `role_permission` VALUES ('1', '48');
INSERT INTO `role_permission` VALUES ('1', '49');
INSERT INTO `role_permission` VALUES ('1', '50');
INSERT INTO `role_permission` VALUES ('1', '51');
INSERT INTO `role_permission` VALUES ('1', '52');
INSERT INTO `role_permission` VALUES ('1', '53');
INSERT INTO `role_permission` VALUES ('1', '54');
INSERT INTO `role_permission` VALUES ('1', '55');
INSERT INTO `role_permission` VALUES ('1', '56');
INSERT INTO `role_permission` VALUES ('1', '57');
INSERT INTO `role_permission` VALUES ('1', '58');
INSERT INTO `role_permission` VALUES ('1', '59');
INSERT INTO `role_permission` VALUES ('1', '60');
INSERT INTO `role_permission` VALUES ('5', '25');
INSERT INTO `role_permission` VALUES ('5', '26');
INSERT INTO `role_permission` VALUES ('5', '27');
INSERT INTO `role_permission` VALUES ('5', '28');
INSERT INTO `role_permission` VALUES ('5', '29');
INSERT INTO `role_permission` VALUES ('5', '30');
INSERT INTO `role_permission` VALUES ('5', '31');
INSERT INTO `role_permission` VALUES ('5', '32');
INSERT INTO `role_permission` VALUES ('5', '33');
INSERT INTO `role_permission` VALUES ('5', '34');
INSERT INTO `role_permission` VALUES ('5', '35');
INSERT INTO `role_permission` VALUES ('5', '36');
INSERT INTO `role_permission` VALUES ('5', '37');
INSERT INTO `role_permission` VALUES ('5', '38');
INSERT INTO `role_permission` VALUES ('5', '39');
INSERT INTO `role_permission` VALUES ('5', '40');
INSERT INTO `role_permission` VALUES ('5', '41');
INSERT INTO `role_permission` VALUES ('5', '42');
INSERT INTO `role_permission` VALUES ('6', '43');
INSERT INTO `role_permission` VALUES ('6', '44');
INSERT INTO `role_permission` VALUES ('6', '45');
INSERT INTO `role_permission` VALUES ('6', '46');
INSERT INTO `role_permission` VALUES ('6', '47');
INSERT INTO `role_permission` VALUES ('6', '48');
INSERT INTO `role_permission` VALUES ('6', '49');
INSERT INTO `role_permission` VALUES ('6', '50');
INSERT INTO `role_permission` VALUES ('6', '51');
INSERT INTO `role_permission` VALUES ('6', '52');
INSERT INTO `role_permission` VALUES ('6', '53');
INSERT INTO `role_permission` VALUES ('6', '54');
INSERT INTO `role_permission` VALUES ('6', '55');
INSERT INTO `role_permission` VALUES ('6', '56');
INSERT INTO `role_permission` VALUES ('7', '58');
INSERT INTO `role_permission` VALUES ('7', '59');
-- ----------------------------
-- Table structure for `route_order`
-- ----------------------------
DROP TABLE IF EXISTS `route_order`;
CREATE TABLE `route_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`orderId` varchar(32) NOT NULL,
`ordertime` varchar(50) DEFAULT NULL,
`rname` varchar(5011) DEFAULT NULL,
`starttime` varchar(20) DEFAULT NULL,
`totalp` varchar(20) DEFAULT NULL,
`paymoney` double DEFAULT NULL,
`uname` varchar(50) DEFAULT NULL,
`telephone` varchar(50) DEFAULT NULL,
`uid` int(11) NOT NULL,
`beginday` varchar(50) DEFAULT NULL,
`endday` varchar(50) DEFAULT NULL,
`rid` int(11) NOT NULL,
`tid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of route_order
-- ----------------------------
INSERT INTO `route_order` VALUES ('1', '25c8d05969654ef1b367ab1a3d58c558', '2021-07-11 20:54:20', '【湖北宜昌+东湖樱花园+长江三峡+恩施大峡谷+维多利亚号豪华邮轮体验 单高单卧5天】女儿城 云龙河地缝 巴乡古寨特色“摔碗酒”篝火晚会 恩施土司城【贵宾团】', '2021-07-13', '1张', '2199', '111', '15053170996', '27', null, null, '5', null);
INSERT INTO `route_order` VALUES ('2', '716b27379ea54474ba71b082e5af073e', '2021-07-11 21:18:49', '【春节 买1送1 云南香格里拉+丽江+大理 高铁7天 超贵团】石卡雪山 虎跳峡 独克宗祈福 拉市海 洱海公园 花语牧场 昆明红嘴鸥【畅享温泉SPA】', '2021-07-13', '1张', '5799', 'dudu', '18595362511', '28', null, null, '28', null);
-- ----------------------------
-- Table structure for `tab_account`
-- ----------------------------
DROP TABLE IF EXISTS `tab_account`;
CREATE TABLE `tab_account` (
`aid` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`money` double DEFAULT NULL,
PRIMARY KEY (`aid`),
KEY `uid` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tab_account
-- ----------------------------
INSERT INTO `tab_account` VALUES ('1', '5', '7317');
INSERT INTO `tab_account` VALUES ('2', '10', '10000');
INSERT INTO `tab_account` VALUES ('3', '11', '10000');
INSERT IN
Java项目:在线旅游系统(java+jsp+SSM+Spring+mysql+maven)
版权申诉
5星 · 超过95%的资源 30 浏览量
2022-03-19
08:32:12
上传
评论 5
收藏 83.6MB RAR 举报 
Java项目:在线旅游系统(java+jsp+SSM+Spring+mysql+maven) （3216个子文件） 
HotelController.class 6KB Route.class 6KB UserServlet.class 5KB PersonalServiceImpl.class 5KB UserServiceImpl.class 5KB UserController.class 5KB OrderServlet.class 5KB RouteController.class 5KB RouteDaoImpl.class 5KB RoleController.class 5KB RouteServlet.class 4KB LogAop.class 4KB PersonalDaoImpl.class 4KB SellerController.class 4KB OrderDaoImpl.class 4KB PersonalServlet.class 4KB Hotel.class 4KB RouteServiceImpl.class 4KB PermissionController.class 3KB ImageController.class 3KB SaveMessageServlet.class 3KB Order.class 3KB MessageController.class 3KB User.class 3KB CategoryController.class 3KB IUserDao.class 3KB OrderController.class 3KB UserDaoImpl.class 3KB IHotelDao.class 3KB HotelServiceImpl.class 3KB CheckCodeServlet.class 3KB TopDaoImpl.class 3KB WordFilter.class 3KB UpdateUserServlet.class 3KB HotelServiceImpl.class 3KB RoomController.class 3KB IRoleDao.class 3KB RouteOrder.class 3KB OrderServiceImpl.class 3KB MD5PasswordEncoder.class 3KB BaseServlet.class 3KB RoleServiceImpl.class 2KB TopServlet.class 2KB FavoriteDaoImpl.class 2KB MessageDaoImpl.class 2KB WordFilter$1.class 2KB SysLogController.class 2KB SysLog.class 2KB FindAllMessageServlet.class 2KB MessageServiceImpl.class 2KB IRouteDao.class 2KB JDBCUtils.class 2KB ISellerDao.class 2KB RouteImg.class 2KB Md5Util.class 2KB HotelServlet.class 2KB SellerServiceImpl.class 2KB Seller.class 2KB HotelDaoImpl.class 2KB MessageServiceImpl.class 2KB Upload.class 2KB CategoryServiceImpl.class 2KB Role.class 2KB TopServiceImpl.class 2KB OrderServiceImpl.class 2KB CharchaterFilter.class 2KB PermissionServiceImpl.class 2KB PageBean.class 2KB IPermissionDao.class 2KB HoteltypeServiceImpl.class 2KB RouteServiceImpl.class 2KB Message.class 2KB TransactionConfig.class 2KB UserServiceImpl.class 2KB Permission.class 1KB Hoteldetail.class 1KB ICategoryDao.class 1KB ResultInfo.class 1KB IMessageDao.class 1KB FavoriteServiceImpl.class 1KB CategoryServlet.class 1KB ImgServiceImpl.class 1KB Category.class 1KB SysLogServiceImpl.class 1KB IHoteltypeDao.class 1KB HoteldetailDaoImpl.class 1KB RouteImgDaoImpl.class 1KB HoteltypeDaoImpl.class 1KB SellerDaoImpl.class 1KB IOrderDao.class 1KB CategoryDaoImpl.class 1KB Account.class 988B Favorite.class 986B DateUtils.class 977B IHotelService.class 969B Hoteltype.class 965B ISysLogDao.class 918B IUserService.class 869B IImgDao.class 815B IRoleService.class 719B共 3216 条
- 1
- 2
- 3
- 4
- 5
- 6
- 33
资源评论
YF_Galaxy2022-08-22怎么能有这么好的资源！只能用感激涕零来形容TAT...
YAZEN·旧日残像2022-05-28用户下载后在一定时间内未进行评价，系统默认好评。
