基于ajax和mysql的樓市銷售系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開發(fā)語言：Java
框架：ssm
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫腳本：
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 '創(chuàng)建時(shí)間',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `adminid` bigint(20) DEFAULT NULL COMMENT '管理員id',
? `ask` longtext COMMENT '提問',
? `reply` longtext COMMENT '回復(fù)',
? `isreply` int(11) DEFAULT NULL COMMENT '是否回復(fù)',
? 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','回復(fù)1',1),(102,'2022-05-05 06:50:54',2,2,'提問2','回復(fù)2',2),(103,'2022-05-05 06:50:54',3,3,'提問3','回復(fù)3',3),(104,'2022-05-05 06:50:54',4,4,'提問4','回復(fù)4',4),(105,'2022-05-05 06:50:54',5,5,'提問5','回復(fù)5',5),(106,'2022-05-05 06:50:54',6,6,'提問6','回復(fù)6',6),(1651733800655,'2022-05-05 06:56:40',1651733771883,NULL,'客戶咨詢樓盤管理員',NULL,0),(1651733916920,'2022-05-05 06:58:36',1651733771883,1,NULL,'管理員回復(fù)客戶咨詢問題',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 '創(chuàng)建時(shí)間',
? `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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時(shí)間',
? `dingfangbianhao` varchar(200) DEFAULT NULL COMMENT '定房編號(hào)',
? `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 '平方價(jià)',
? `dingfangshijian` date DEFAULT NULL COMMENT '定房時(shí)間',
? `kehuzhanghao` varchar(200) DEFAULT NULL COMMENT '客戶賬號(hào)',
? `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','客戶賬號(hào)1','客戶姓名1'),(72,'2022-05-05 06:50:54','2222222222','樓盤名稱2','房屋名稱2','房型2',2,2,'2022-05-05','客戶賬號(hào)2','客戶姓名2'),(73,'2022-05-05 06:50:54','3333333333','樓盤名稱3','房屋名稱3','房型3',3,3,'2022-05-05','客戶賬號(hào)3','客戶姓名3'),(74,'2022-05-05 06:50:54','4444444444','樓盤名稱4','房屋名稱4','房型4',4,4,'2022-05-05','客戶賬號(hào)4','客戶姓名4'),(75,'2022-05-05 06:50:54','5555555555','樓盤名稱5','房屋名稱5','房型5',5,5,'2022-05-05','客戶賬號(hào)5','客戶姓名5'),(76,'2022-05-05 06:50:54','6666666666','樓盤名稱6','房屋名稱6','房型6',6,6,'2022-05-05','客戶賬號(hào)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 '創(chuàng)建時(shí)間',
? `fangwubianhao` varchar(200) DEFAULT NULL COMMENT '房屋編號(hào)',
? `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 '平方價(jià)',
? `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,'所謂房產(chǎn)，是指有墻面和立體結(jié)構(gòu)，能夠遮風(fēng)避雨，可供人們?cè)谄渲猩?、學(xué)習(xí)、工作、娛樂、居住或貯藏物資的場(chǎng)所。（出處：2009年注冊(cè)會(huì)計(jì)師全國統(tǒng)一考試輔導(dǎo)教材《稅法》第九章第一節(jié)）','<p><span style=\"background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\">所謂</span><span style=\"background-color: rgb(255, 255, 255); color: rgb(247, 49, 49);\">房產(chǎn)</span><span style=\"background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\">，是指有墻面和立體結(jié)構(gòu)，能夠遮風(fēng)避雨，可供人們?cè)谄渲猩?、學(xué)習(xí)、工作、娛樂、居住或貯藏物資的場(chǎng)所。（出處：2009年注冊(cè)會(huì)計(jì)師全國統(tǒng)一考試輔導(dǎo)教材《稅法》第九章第一節(jié)）</span></p>');
/*!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 '創(chuàng)建時(shí)間',
? `title` varchar(200) DEFAULT NULL COMMENT '帖子標(biāo)題',
? `content` longtext NOT NULL COMMENT '帖子內(nèi)容',
? `parentid` bigint(20) DEFAULT NULL COMMENT '父節(jié)點(diǎn)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=1651734022498 DEFAULT CHARSET=utf8 COMMENT='樓市論壇';
/*!40101 SET character_set_client = @saved_cs_client */;
