/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 50553
Source Host : localhost:3306
Source Schema : jsppg6y3
Target Server Type : MySQL
Target Server Version : 50553
File Encoding : 65001
Date: 22/10/2020 16:43:13
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for chat
-- ----------------------------
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`userid` bigint(20) NOT NULL COMMENT '用户id',
`adminid` bigint(20) NULL DEFAULT NULL COMMENT '管理员id',
`ask` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '提问',
`reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复',
`isreply` int(11) NULL DEFAULT NULL COMMENT '是否回复',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1602839997212 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客服聊天表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of chat
-- ----------------------------
INSERT INTO `chat` VALUES (1, '2020-10-16 12:04:48', 1, 1, '提问1', '回复1', 1);
INSERT INTO `chat` VALUES (2, '2020-10-16 12:04:48', 2, 2, '提问2', '回复2', 2);
INSERT INTO `chat` VALUES (3, '2020-10-16 12:04:48', 3, 3, '提问3', '回复3', 3);
INSERT INTO `chat` VALUES (1602839997211, '2020-10-16 17:19:56', 1602838630129, NULL, '客服 你好\r\n', '你好\r\n', 1);
-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置参数名称',
`value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置文件' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES (1, 'picture1', 'http://localhost:8080/jspPG6Y3/upload/1602840376921.jpg');
INSERT INTO `config` VALUES (2, 'picture2', 'http://localhost:8080/jspPG6Y3/upload/1602821974145.jpg');
INSERT INTO `config` VALUES (3, 'picture3', 'http://localhost:8080/jspPG6Y3/upload/1602821980960.jpg');
INSERT INTO `config` VALUES (4, 'picture4', 'http://localhost:8080/jspPG6Y3/upload/1602821987832.jpg');
INSERT INTO `config` VALUES (5, 'picture5', 'http://localhost:8080/jspPG6Y3/upload/1602821995557.jpg');
INSERT INTO `config` VALUES (6, 'homepage', NULL);
-- ----------------------------
-- Table structure for discussfangxingjieshao
-- ----------------------------
DROP TABLE IF EXISTS `discussfangxingjieshao`;
CREATE TABLE `discussfangxingjieshao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '房型介绍评论表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of discussfangxingjieshao
-- ----------------------------
INSERT INTO `discussfangxingjieshao` VALUES (1, '2020-10-16 12:04:50', 1, '评论内容1', 1);
INSERT INTO `discussfangxingjieshao` VALUES (2, '2020-10-16 12:04:50', 2, '评论内容2', 2);
INSERT INTO `discussfangxingjieshao` VALUES (3, '2020-10-16 12:04:50', 3, '评论内容3', 3);
-- ----------------------------
-- Table structure for discussjiudianzhoubian
-- ----------------------------
DROP TABLE IF EXISTS `discussjiudianzhoubian`;
CREATE TABLE `discussjiudianzhoubian` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '酒店周边评论表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of discussjiudianzhoubian
-- ----------------------------
INSERT INTO `discussjiudianzhoubian` VALUES (1, '2020-10-16 12:04:50', 1, '评论内容1', 1);
INSERT INTO `discussjiudianzhoubian` VALUES (2, '2020-10-16 12:04:50', 2, '评论内容2', 2);
INSERT INTO `discussjiudianzhoubian` VALUES (3, '2020-10-16 12:04:50', 3, '评论内容3', 3);
-- ----------------------------
-- Table structure for discusskefangxinxi
-- ----------------------------
DROP TABLE IF EXISTS `discusskefangxinxi`;
CREATE TABLE `discusskefangxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1602839827943 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客房信息评论表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of discusskefangxinxi
-- ----------------------------
INSERT INTO `discusskefangxinxi` VALUES (1, '2020-10-16 12:04:49', 1, '评论内容1', 1);
INSERT INTO `discusskefangxinxi` VALUES (2, '2020-10-16 12:04:49', 2, '评论内容2', 2);
INSERT INTO `discusskefangxinxi` VALUES (3, '2020-10-16 12:04:49', 3, '评论内容3', 3);
INSERT INTO `discusskefangxinxi` VALUES (1602838709281, '2020-10-16 16:58:28', 1602821836081, '还行', 1602838630129);
INSERT INTO `discusskefangxinxi` VALUES (1602839827942, '2020-10-16 17:17:07', 1602837680451, '挺好看的额', 1602838630129);
-- ----------------------------
-- Table structure for discussqinzihuodong
-- ----------------------------
DROP TABLE IF EXISTS `discussqinzihuodong`;
CREATE TABLE `discussqinzihuodong` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1602839868479 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '亲子活动评论表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of discussqinzihuodong
-- ----------------------------
INSERT INTO `discussqinzihuodong` VALUES (1, '2020-10-16 12:04:49', 1, '评论内容1', 1);
INSERT INTO `discussqinzihuodong` VALUES (2, '2020-10-16 12:04:49', 2, '评论内容2', 2);
INSERT INTO `discussqinzihuodong` VALUES (3, '2020-10-16 12:04:50', 3, '评论内容3', 3);
INSERT INTO `discussqinzihuodong` VALUES (1602839868478, '2020-10-16 17:17:48', 1602822454994, '带小孩子参加很好', 1602838630129);
-- ----------------------------
-- Table structure for fangxingjieshao
-- ----------------------------
DROP TABLE IF EXISTS `fangxingjieshao`;
CREATE TABLE `fangxingjieshao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`biaoti` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '�
3937-SSM双月湾亲子高端酒店网站（源码+数据库+lun文）.zip （1750个子文件） 
YonghuController.class 10KB CommonController.class 10KB ChatController.class 9KB JiudianzhoubianController.class 8KB FangxingjieshaoController.class 8KB QinzihuodongController.class 8KB KefangxinxiController.class 8KB MenpiaoyudingController.class 8KB KefangyudingController.class 8KB StoreupController.class 8KB MessagesController.class 8KB DiscussfangxingjieshaoController.class 8KB DiscussjiudianzhoubianController.class 8KB DiscussqinzihuodongController.class 8KB DiscusskefangxinxiController.class 8KB JianshaofangyuanController.class 8KB ZengjiafangyuanController.class 8KB KefangleibieController.class 8KB JiudiancaiwuController.class 8KB ShebeixinxiController.class 8KB NewsController.class 7KB MPUtil.class 7KB UserController.class 6KB KefangyudingEntity.class 6KB KefangxinxiEntity.class 5KB MenpiaoyudingEntity.class 5KB QinzihuodongEntity.class 5KB TokenServiceImpl.class 4KB FileController.class 4KB JiudiancaiwuEntity.class 4KB JiudianzhoubianEntity.class 4KB BaiduUtil.class 4KB DiscussjiudianzhoubianServiceImpl.class 4KB DiscussfangxingjieshaoServiceImpl.class 4KB YonghuEntity.class 4KB DiscussqinzihuodongServiceImpl.class 4KB DiscusskefangxinxiServiceImpl.class 4KB JianshaofangyuanServiceImpl.class 4KB FangxingjieshaoServiceImpl.class 4KB ZengjiafangyuanServiceImpl.class 4KB JiudianzhoubianServiceImpl.class 4KB MenpiaoyudingServiceImpl.class 4KB JiudiancaiwuServiceImpl.class 4KB QinzihuodongServiceImpl.class 4KB KefangyudingServiceImpl.class 4KB KefangleibieServiceImpl.class 4KB KefangxinxiServiceImpl.class 4KB ShebeixinxiServiceImpl.class 4KB MessagesServiceImpl.class 4KB StoreupServiceImpl.class 4KB YonghuServiceImpl.class 4KB ConfigController.class 4KB FangxingjieshaoEntity.class 4KB ChatServiceImpl.class 4KB NewsServiceImpl.class 4KB KefangyudingModel.class 4KB KefangyudingVO.class 4KB ShebeixinxiEntity.class 4KB AuthorizationInterceptor.class 3KB ChatEntity.class 3KB JianshaofangyuanEntity.class 3KB ZengjiafangyuanEntity.class 3KB StoreupEntity.class 3KB MessagesEntity.class 3KB Query.class 3KB DiscussjiudianzhoubianEntity.class 3KB DiscussfangxingjieshaoEntity.class 3KB DiscussqinzihuodongEntity.class 3KB DiscusskefangxinxiEntity.class 3KB KefangxinxiModel.class 3KB KefangxinxiVO.class 3KB NewsEntity.class 3KB UserServiceImpl.class 3KB QinzihuodongModel.class 3KB MenpiaoyudingModel.class 3KB MenpiaoyudingVO.class 3KB QinzihuodongVO.class 3KB PageUtils.class 3KB TokenEntity.class 3KB JiudiancaiwuModel.class 2KB KefangleibieEntity.class 2KB JiudiancaiwuVO.class 2KB CommonServiceImpl.class 2KB JiudianzhoubianModel.class 2KB JiudianzhoubianVO.class 2KB YonghuModel.class 2KB YonghuVO.class 2KB R.class 2KB DiscussfangxingjieshaoService.class 2KB DiscussjiudianzhoubianService.class 2KB DiscussjiudianzhoubianDao.class 2KB DiscussfangxingjieshaoDao.class 2KB DiscussqinzihuodongService.class 2KB UserEntity.class 2KB DiscusskefangxinxiService.class 2KB ValidatorUtils.class 2KB DiscussqinzihuodongDao.class 2KB SpringContextUtils.class 2KB DiscusskefangxinxiDao.class 2KB JianshaofangyuanService.class 2KB共 1750 条
- 1
- 2
- 3
- 4
- 5
- 6
- 18
资源评论
Java旅途
- 粉丝: 1w+
- 资源: 3050
最新资源
- C183579-123578-c1235789.jpg
- Qt5.14 绘画板 Qt Creator C++项目
- python实现Excel表格合并
- Java实现读取Excel批量发送邮件.zip
- 【java毕业设计】商城后台管理系统源码（springboot+vue+mysql+说明文档）.zip
- 【java毕业设计】开发停车位管理系统(调用百度地图API)源码（springboot+vue+mysql+说明文档）.zip
- 星耀软件库(升级版).apk.1
- 基于Django后端和Vue前端的多语言购物车项目设计源码
- 基于Python与Vue的浮光在线教育平台源码设计
- 31129647070291Eclipson MXS R.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
