基于javaweb江西紅色旅游網站的設計與實現(xiàn)-計算機畢業(yè)設計源碼+LW文檔
開發(fā)語言：Java
框架：ssm
JDK版本：JDK1.8
服務器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea[請下載Eclipse運行]
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫
-- ----------------------------
-- 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 '創(chuàng)建時間',
? `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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時間',
? `refid` bigint(20) NOT NULL COMMENT '關聯(lián)表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 '創(chuàng)建時間',
? `refid` bigint(20) NOT NULL COMMENT '關聯(lián)表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 '創(chuàng)建時間',
? `refid` bigint(20) NOT NULL COMMENT '關聯(lián)表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 '創(chuàng)建時間',
? `title` varchar(200) DEFAULT NULL COMMENT '帖子標題',
? `content` longtext NOT NULL COMMENT '帖子內容',
? `parentid` bigint(20) DEFAULT NULL COMMENT '父節(jié)點id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `username` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `isdone` varchar(200) DEFAULT NULL COMMENT '狀態(tài)',
? 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 '創(chuàng)建時間',
? `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 '數(shù)量',
? `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 '創(chuàng)建時間',
? `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 '點擊次數(shù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1614751257495 DEFAULT CHARSET=utf8 COMMENT='景點信息';
