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

<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 */;