基于ajax和mysql楼市销售系统设计实现-计算机毕业设计源码LW文档

开发语言：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年注册会计师全国统一考试辅导教材《税法》第九章第一节）','

所谓房产，是指有墙面和立体结构，能够遮风避雨，可供人们在其中生活、学习、工作、娱乐、居住或贮藏物资的场所。（出处：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 */;