基于javaweb江西红色旅游网站的设计与实现-计算机毕业设计源码+LW文档

原创

毕设大神 2023-08-19 10:06:53 ©著作权

©著作权归作者所有：来自51CTO博客作者毕设大神的原创作品，请联系作者获取转载授权，否则将追究法律责任

开发语言：Java 框架：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', '旅游景点游玩攻略', '

旅游景点游玩攻略

', '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='景点信息';