开发语言：Java 框架：ssm JDK版本：JDK1.8 服务器：tomcat7 数据库：mysql 5.7（一定要5.7版本） 数据库工具：Navicat11 开发软件：eclipse/myeclipse/idea Maven包：Maven3.3.9 浏览器：谷歌浏览器
数据库脚本：
DROP TABLE IF EXISTS chat;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
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=1651733916921 DEFAULT CHARSET=utf8 COMMENT='在线咨询';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table chat
--
LOCK TABLES chat WRITE;
/*!40000 ALTER TABLE chat DISABLE KEYS /;
INSERT INTO chat VALUES (101,'2022-05-05 06:50:54',1,1,'提问1','回复1',1),(102,'2022-05-05 06:50:54',2,2,'提问2','回复2',2),(103,'2022-05-05 06:50:54',3,3,'提问3','回复3',3),(104,'2022-05-05 06:50:54',4,4,'提问4','回复4',4),(105,'2022-05-05 06:50:54',5,5,'提问5','回复5',5),(106,'2022-05-05 06:50:54',6,6,'提问6','回复6',6),(1651733800655,'2022-05-05 06:56:40',1651733771883,NULL,'客户咨询楼盘管理员',NULL,0),(1651733916920,'2022-05-05 06:58:36',1651733771883,1,NULL,'管理员回复客户咨询问题',NULL);
/!40000 ALTER TABLE chat ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table chengshi
--
DROP TABLE IF EXISTS chengshi;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE chengshi (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
chengshi varchar(200) NOT NULL COMMENT '城市',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1651733824059 DEFAULT CHARSET=utf8 COMMENT='城市';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table chengshi
--
LOCK TABLES chengshi WRITE;
/*!40000 ALTER TABLE chengshi DISABLE KEYS /;
INSERT INTO chengshi VALUES (21,'2022-05-05 06:50:54','城市1'),(22,'2022-05-05 06:50:54','城市2'),(23,'2022-05-05 06:50:54','城市3'),(24,'2022-05-05 06:50:54','城市4'),(25,'2022-05-05 06:50:54','城市5'),(26,'2022-05-05 06:50:54','城市6'),(1651733824058,'2022-05-05 06:57:03','广州');
/!40000 ALTER TABLE chengshi ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table config
--
DROP TABLE IF EXISTS config;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
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=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table config
--
LOCK TABLES config WRITE;
/*!40000 ALTER TABLE config DISABLE KEYS /;
INSERT INTO config VALUES (1,'picture1','upload/1651733926616.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/!40000 ALTER TABLE config ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table dingfangxinxi
--
DROP TABLE IF EXISTS dingfangxinxi;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE dingfangxinxi (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
dingfangbianhao varchar(200) DEFAULT NULL COMMENT '定房编号',
loupanmingcheng varchar(200) DEFAULT NULL COMMENT '楼盘名称',
fangwumingcheng varchar(200) DEFAULT NULL COMMENT '房屋名称',
fangxing varchar(200) DEFAULT NULL COMMENT '房型',
mianji float DEFAULT NULL COMMENT '面积',
pingfangjia float DEFAULT NULL COMMENT '平方价',
dingfangshijian date DEFAULT NULL COMMENT '定房时间',
kehuzhanghao varchar(200) DEFAULT NULL COMMENT '客户账号',
kehuxingming varchar(200) DEFAULT NULL COMMENT '客户姓名',
PRIMARY KEY (id),
UNIQUE KEY dingfangbianhao (dingfangbianhao)
) ENGINE=InnoDB AUTO_INCREMENT=1651734079141 DEFAULT CHARSET=utf8 COMMENT='定房信息';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table dingfangxinxi
--
LOCK TABLES dingfangxinxi WRITE;
/*!40000 ALTER TABLE dingfangxinxi DISABLE KEYS /;
INSERT INTO dingfangxinxi VALUES (71,'2022-05-05 06:50:54','1111111111','楼盘名称1','房屋名称1','房型1',1,1,'2022-05-05','客户账号1','客户姓名1'),(72,'2022-05-05 06:50:54','2222222222','楼盘名称2','房屋名称2','房型2',2,2,'2022-05-05','客户账号2','客户姓名2'),(73,'2022-05-05 06:50:54','3333333333','楼盘名称3','房屋名称3','房型3',3,3,'2022-05-05','客户账号3','客户姓名3'),(74,'2022-05-05 06:50:54','4444444444','楼盘名称4','房屋名称4','房型4',4,4,'2022-05-05','客户账号4','客户姓名4'),(75,'2022-05-05 06:50:54','5555555555','楼盘名称5','房屋名称5','房型5',5,5,'2022-05-05','客户账号5','客户姓名5'),(76,'2022-05-05 06:50:54','6666666666','楼盘名称6','房屋名称6','房型6',6,6,'2022-05-05','客户账号6','客户姓名6'),(1651734079140,'2022-05-05 07:01:19','1651733993190','恒大楼盘','202','三房两厅',128,65,'2022-05-05','111','111');
/!40000 ALTER TABLE dingfangxinxi ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table fangwuxinxi
--
DROP TABLE IF EXISTS fangwuxinxi;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE fangwuxinxi (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
fangwubianhao varchar(200) DEFAULT NULL COMMENT '房屋编号',
loupanmingcheng varchar(200) DEFAULT NULL COMMENT '楼盘名称',
fangwumingcheng varchar(200) DEFAULT NULL COMMENT '房屋名称',
fangxing varchar(200) DEFAULT NULL COMMENT '房型',
tupian varchar(200) DEFAULT NULL COMMENT '图片',
louceng varchar(200) DEFAULT NULL COMMENT '楼层',
mianji float DEFAULT NULL COMMENT '面积',
pingfangjia float DEFAULT NULL COMMENT '平方价',
caiguangqingkuang longtext COMMENT '采光情况',
fangwuxiangqing longtext COMMENT '房屋详情',
PRIMARY KEY (id),
UNIQUE KEY fangwubianhao (fangwubianhao)
) ENGINE=InnoDB AUTO_INCREMENT=1651733888590 DEFAULT CHARSET=utf8 COMMENT='房屋信息';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table fangwuxinxi
--
LOCK TABLES fangwuxinxi WRITE;
/*!40000 ALTER TABLE fangwuxinxi DISABLE KEYS /;
INSERT INTO fangwuxinxi VALUES (41,'2022-05-05 06:50:54','1111111111','楼盘名称1','房屋名称1','两房一厅','upload/fangwuxinxi_tupian1.jpg','楼层1',1,1,'采光情况1','房屋详情1'),(42,'2022-05-05 06:50:54','2222222222','楼盘名称2','房屋名称2','两房一厅','upload/fangwuxinxi_tupian2.jpg','楼层2',2,2,'采光情况2','房屋详情2'),(43,'2022-05-05 06:50:54','3333333333','楼盘名称3','房屋名称3','两房一厅','upload/fangwuxinxi_tupian3.jpg','楼层3',3,3,'采光情况3','房屋详情3'),(44,'2022-05-05 06:50:54','4444444444','楼盘名称4','房屋名称4','两房一厅','upload/fangwuxinxi_tupian4.jpg','楼层4',4,4,'采光情况4','房屋详情4'),(45,'2022-05-05 06:50:54','5555555555','楼盘名称5','房屋名称5','两房一厅','upload/fangwuxinxi_tupian5.jpg','楼层5',5,5,'采光情况5','房屋详情5'),(46,'2022-05-05 06:50:54','6666666666','楼盘名称6','房屋名称6','两房一厅','upload/fangwuxinxi_tupian6.jpg','楼层6',6,6,'采光情况6','房屋详情6'),(1651733888589,'2022-05-05 06:58:07','1651733781903','恒大楼盘','202','三房两厅','upload/1651733876138.jpg','2',128,65,'所谓房产，是指有墙面和立体结构，能够遮风避雨，可供人们在其中生活、学习、工作、娱乐、居住或贮藏物资的场所。（出处：2009年注册会计师全国统一考试辅导教材《税法》第九章第一节）','
<span style=\"background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\">所谓<span style=\"background-color: rgb(255, 255, 255); color: rgb(247, 49, 49);\">房产<span style=\"background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\">，是指有墙面和立体结构，能够遮风避雨，可供人们在其中生活、学习、工作、娱乐、居住或贮藏物资的场所。（出处：2009年注册会计师全国统一考试辅导教材《税法》第九章第一节）
');
/!40000 ALTER TABLE fangwuxinxi ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table forum
--
DROP TABLE IF EXISTS forum;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
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=1651734022498 DEFAULT CHARSET=utf8 COMMENT='楼市论坛';
/!40101 SET character_set_client = @saved_cs_client */;
