开发语言: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年注册会计师全国统一考试辅导教材《税法》第九章第一节)’,'<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);\”>房产</span><span style=\”background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\”>,是指有墙面和立体结构,能够遮风避雨,可供人们在其中生活、学习、工作、娱乐、居住或贮藏物资的场所。(出处:2009年注册会计师全国统一考试辅导教材《税法》第九章第一节)</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 ‘创建时间’,
`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 */;