框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea[请下载Eclipse运行]
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库
-- ----------------------------
-- Table structure for `chat`
-- ----------------------------
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`adminid` bigint(20) DEFAULT NULL COMMENT '管理员id',
`ask` longtext COMMENT '提问',
`reply` longtext COMMENT '回复',
`isreply` int(11) DEFAULT NULL COMMENT '是否回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1614751906890 DEFAULT CHARSET=utf8 COMMENT='客服聊天表';
-- ----------------------------
-- Records of chat
-- ----------------------------
INSERT INTO `chat` VALUES ('81', '2023-01-31 13:33:33', '1', '1', '提问1', '回复1', '1');
INSERT INTO `chat` VALUES ('82', '2023-01-31 13:33:33', '2', '2', '提问2', '回复2', '2');
INSERT INTO `chat` VALUES ('83', '2023-01-31 13:33:33', '3', '3', '提问3', '回复3', '3');
INSERT INTO `chat` VALUES ('84', '2023-01-31 13:33:33', '4', '4', '提问4', '回复4', '4');
INSERT INTO `chat` VALUES ('85', '2023-01-31 13:33:33', '5', '5', '提问5', '回复5', '5');
INSERT INTO `chat` VALUES ('86', '2023-01-31 13:33:33', '6', '6', '提问6', '回复6', '6');
INSERT INTO `chat` VALUES ('1614751809095', '2023-01-31 14:10:08', '1614751541738', null, '在吗', null, '0');
INSERT INTO `chat` VALUES ('1614751906889', '2023-01-31 14:11:46', '1614751541738', '1', null, '在的', null);
-- ----------------------------
-- Table structure for `config`
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='配置文件';
-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES ('1', 'picture1', 'http://localhost:8080/lvyouwangzhanxt/upload/picture1.jpg');
INSERT INTO `config` VALUES ('2', 'picture2', 'http://localhost:8080/lvyouwangzhanxt/upload/picture2.jpg');
INSERT INTO `config` VALUES ('3', 'picture3', 'http://localhost:8080/lvyouwangzhanxt/upload/picture3.jpg');
INSERT INTO `config` VALUES ('6', 'homepage', null);
-- ----------------------------
-- Table structure for `discussjingdianxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `discussjingdianxinxi`;
CREATE TABLE `discussjingdianxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1614751645725 DEFAULT CHARSET=utf8 COMMENT='景点信息评论表';
-- ----------------------------
-- Records of discussjingdianxinxi
-- ----------------------------
INSERT INTO `discussjingdianxinxi` VALUES ('121', '2023-01-31 13:33:33', '1', '1', '评论内容1', '回复内容1');
INSERT INTO `discussjingdianxinxi` VALUES ('122', '2023-01-31 13:33:33', '2', '2', '评论内容2', '回复内容2');
INSERT INTO `discussjingdianxinxi` VALUES ('123', '2023-01-31 13:33:33', '3', '3', '评论内容3', '回复内容3');
INSERT INTO `discussjingdianxinxi` VALUES ('124', '2023-01-31 13:33:33', '4', '4', '评论内容4', '回复内容4');
INSERT INTO `discussjingdianxinxi` VALUES ('125', '2023-01-31 13:33:33', '5', '5', '评论内容5', '回复内容5');
INSERT INTO `discussjingdianxinxi` VALUES ('126', '2023-01-31 13:33:33', '6', '6', '评论内容6', '回复内容6');
INSERT INTO `discussjingdianxinxi` VALUES ('1614751645724', '2023-01-31 14:07:25', '1614751257489', '1614751541738', '很不错的景点', null);
-- ----------------------------
-- Table structure for `discussjiudianxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `discussjiudianxinxi`;
CREATE TABLE `discussjiudianxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1614751669470 DEFAULT CHARSET=utf8 COMMENT='酒店信息评论表';
-- ----------------------------
-- Records of discussjiudianxinxi
-- ----------------------------
INSERT INTO `discussjiudianxinxi` VALUES ('131', '2023-01-31 13:33:33', '1', '1', '评论内容1', '回复内容1');
INSERT INTO `discussjiudianxinxi` VALUES ('132', '2023-01-31 13:33:33', '2', '2', '评论内容2', '回复内容2');
INSERT INTO `discussjiudianxinxi` VALUES ('133', '2023-01-31 13:33:33', '3', '3', '评论内容3', '回复内容3');
INSERT INTO `discussjiudianxinxi` VALUES ('134', '2023-01-31 13:33:33', '4', '4', '评论内容4', '回复内容4');
INSERT INTO `discussjiudianxinxi` VALUES ('135', '2023-01-31 13:33:33', '5', '5', '评论内容5', '回复内容5');
INSERT INTO `discussjiudianxinxi` VALUES ('136', '2023-01-31 13:33:33', '6', '6', '评论内容6', '回复内容6');
INSERT INTO `discussjiudianxinxi` VALUES ('1614751669469', '2023-01-31 14:07:49', '1614751359689', '1614751541738', '很不错的酒店', null);
-- ----------------------------
-- Table structure for `discusskefangxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `discusskefangxinxi`;
CREATE TABLE `discusskefangxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8 COMMENT='客房信息评论表';
-- ----------------------------
-- Records of discusskefangxinxi
-- ----------------------------
INSERT INTO `discusskefangxinxi` VALUES ('141', '2023-01-31 13:33:33', '1', '1', '评论内容1', '回复内容1');
INSERT INTO `discusskefangxinxi` VALUES ('142', '2023-01-31 13:33:33', '2', '2', '评论内容2', '回复内容2');
INSERT INTO `discusskefangxinxi` VALUES ('143', '2023-01-31 13:33:33', '3', '3', '评论内容3', '回复内容3');
INSERT INTO `discusskefangxinxi` VALUES ('144', '2023-01-31 13:33:33', '4', '4', '评论内容4', '回复内容4');
INSERT INTO `discusskefangxinxi` VALUES ('145', '2023-01-31 13:33:33', '5', '5', '评论内容5', '回复内容5');
INSERT INTO `discusskefangxinxi` VALUES ('146', '2023-01-31 13:33:33', '6', '6', '评论内容6', '回复内容6');
-- ----------------------------
-- Table structure for `forum`
-- ----------------------------
DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) DEFAULT NULL COMMENT '帖子标题',
`content` longtext NOT NULL COMMENT '帖子内容',
`parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(200) DEFAULT NULL COMMENT '用户名',
`isdone` varchar(200) DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1614751773802 DEFAULT CHARSET=utf8 COMMENT='交流论坛';
-- ----------------------------
-- Records of forum
-- ----------------------------
INSERT INTO `forum` VALUES ('91', '2023-01-31 13:33:33', '帖子标题1', '帖子内容1', '1', '1', '用户名1', '开放');
INSERT INTO `forum` VALUES ('92', '2023-01-31 13:33:33', '帖子标题2', '帖子内容2', '2', '2', '用户名2', '开放');
INSERT INTO `forum` VALUES ('93', '2023-01-31 13:33:33', '帖子标题3', '帖子内容3', '3', '3', '用户名3', '开放');
INSERT INTO `forum` VALUES ('94', '2023-01-31 13:33:33', '帖子标题4', '帖子内容4', '4', '4', '用户名4', '开放');
INSERT INTO `forum` VALUES ('95', '2023-01-31 13:33:33', '帖子标题5', '帖子内容5', '5', '5', '用户名5', '开放');
INSERT INTO `forum` VALUES ('96', '2023-01-31 13:33:33', '帖子标题6', '帖子内容6', '6', '6', '用户名6', '开放');
INSERT INTO `forum` VALUES ('1614751764342', '2023-01-31 14:09:23', '旅游景点游玩攻略', '<p>旅游景点游玩攻略</p>\n<p><img src=\"../../../upload/1614751760318.jpg\" alt=\"\" width=\"679\" height=\"452\" /></p>', '0', '1614751541738', '1', '开放');
-- ----------------------------
-- Table structure for `goupiaoxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `goupiaoxinxi`;
CREATE TABLE `goupiaoxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`jingdianmingcheng` varchar(200) DEFAULT NULL COMMENT '景点名称',
`jingdiandizhi` varchar(200) DEFAULT NULL COMMENT '景点地址',
`menpiaojiage` int(11) DEFAULT NULL COMMENT '景点价格',
`shuliang` int(11) NOT NULL COMMENT '数量',
`zongjine` varchar(200) DEFAULT NULL COMMENT '总金额',
`goupiaoriqi` date DEFAULT NULL COMMENT '购买日期',
`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1645341064626 DEFAULT CHARSET=utf8 COMMENT='景点预定';
-- ----------------------------
-- Records of goupiaoxinxi
-- ----------------------------
-- ----------------------------
-- Table structure for `jingdianxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `jingdianxinxi`;
CREATE TABLE `jingdianxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jingdianmingcheng` varchar(200) NOT NULL COMMENT '景点名称',
`jingdiantupian` varchar(200) DEFAULT NULL COMMENT '景点图片',
`jingdiandengji` varchar(200) DEFAULT NULL COMMENT '景点等级',
`jingdiandizhi` varchar(200) DEFAULT NULL COMMENT '景点地址',
`menpiaojiage` int(11) DEFAULT NULL COMMENT '景点价格',
`kaifangshijian` varchar(200) DEFAULT NULL COMMENT '景点时间',
`jingdianjieshao` longtext COMMENT '景点介绍',
`goupiaoxuzhi` longtext COMMENT '购买须知',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1614751257495 DEFAULT CHARSET=utf8 COMMENT='景点信息';
