基于微信小程序的房屋交易平台+后台管理系统(SSM+mysql)

管理系统(SSM+mysql)"/>

基于微信小程序的房屋交易平台+后台管理系统(SSM+mysql)

功能介绍

管理员：首页、个人中心、房子户型管理、门店信息管理、用户管理、经纪人管理、房源信息管理、售房订单管理、 租房信息管理、租房订单管理、求购信息管理、求租信息管理、系统管理，

用户；首页、房源信息、租房信息、我的等

数据库脚本

/*
SQLyog Ultimate v9.30 
MySQL - 5.7.26 : Database - ssms5akf
*********************************************************************
*//*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE=''*/;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`ssms5akf` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;USE `ssms5akf`;/*Table structure for table `config` */DROP TABLE IF EXISTS `config`;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=7 DEFAULT CHARSET=utf8 COMMENT='配置文件';/*Data for the table `config` */insert  into `config`(`id`,`name`,`value`) values (1,'picture1','http://localhost:8080/ssms5akf/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/ssms5akf/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/ssms5akf/upload/picture3.jpg'),(6,'homepage','http://localhost:8080/ssms5akf/upload/1615190729864.jpg');/*Table structure for table `fangyuanxinxi` */DROP TABLE IF EXISTS `fangyuanxinxi`;CREATE TABLE `fangyuanxinxi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`fangyuanmingcheng` varchar(200) DEFAULT NULL COMMENT '房源名称',`fangyuanleixing` varchar(200) DEFAULT NULL COMMENT '房源类型',`fangzihuxing` varchar(200) DEFAULT NULL COMMENT '房子户型',`fangyuanquyu` varchar(200) DEFAULT NULL COMMENT '房源区域',`fangyuantupian` varchar(200) DEFAULT NULL COMMENT '房源图片',`zhuangtai` varchar(200) DEFAULT NULL COMMENT '状态',`jutiweizhi` varchar(200) DEFAULT NULL COMMENT '具体位置',`mianji` varchar(200) DEFAULT NULL COMMENT '面积',`meimijiage` varchar(200) DEFAULT NULL COMMENT '每米价格',`zongjine` varchar(200) DEFAULT NULL COMMENT '总金额',`jingjirenzhanghao` varchar(200) DEFAULT NULL COMMENT '经纪人账号',`jingjirenxingming` varchar(200) DEFAULT NULL COMMENT '经纪人姓名',`fabushijian` datetime DEFAULT NULL COMMENT '发布时间',`userid` bigint(20) DEFAULT NULL COMMENT '用户id',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1615190981006 DEFAULT CHARSET=utf8 COMMENT='房源信息';/*Data for the table `fangyuanxinxi` */insert  into `fangyuanxinxi`(`id`,`addtime`,`fangyuanmingcheng`,`fangyuanleixing`,`fangzihuxing`,`fangyuanquyu`,`fangyuantupian`,`zhuangtai`,`jutiweizhi`,`mianji`,`meimijiage`,`zongjine`,`jingjirenzhanghao`,`jingjirenxingming`,`fabushijian`,`userid`) values (51,'2021-03-08 15:56:41','房源名称1','新房','房子户型1','房源区域1','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian1.jpg','待售','具体位置1','面积1','每米价格1','总金额1','经纪人账号1','经纪人姓名1','2021-03-08 15:56:41',1),(52,'2021-03-08 15:56:41','房源名称2','新房','房子户型2','房源区域2','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian2.jpg','待售','具体位置2','面积2','每米价格2','总金额2','经纪人账号2','经纪人姓名2','2021-03-08 15:56:41',2),(53,'2021-03-08 15:56:41','房源名称3','新房','房子户型3','房源区域3','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian3.jpg','待售','具体位置3','面积3','每米价格3','总金额3','经纪人账号3','经纪人姓名3','2021-03-08 15:56:41',3),(54,'2021-03-08 15:56:41','房源名称4','新房','房子户型4','房源区域4','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian4.jpg','待售','具体位置4','面积4','每米价格4','总金额4','经纪人账号4','经纪人姓名4','2021-03-08 15:56:41',4),(55,'2021-03-08 15:56:41','房源名称5','新房','房子户型5','房源区域5','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian5.jpg','待售','具体位置5','面积5','每米价格5','总金额5','经纪人账号5','经纪人姓名5','2021-03-08 15:56:41',5),(56,'2021-03-08 15:56:41','房源名称6','新房','房子户型6','房源区域6','http://localhost:8080/ssms5akf/upload/fangyuanxinxi_fangyuantupian6.jpg','待售','具体位置6','面积6','每米价格6','总金额6','经纪人账号6','经纪人姓名6','2021-03-08 15:56:41',6),(1615190981005,'2021-03-08 16:09:40','房源信息','新房','三房','深圳','http://localhost:8080/ssms5akf/upload/1615190968878.jpg','待售','范德萨范德萨','120','10000','1200000','123','胡继','2021-03-08 16:16:56',1615190622179);/*Table structure for table `fangzihuxing` */DROP TABLE IF EXISTS `fangzihuxing`;CREATE TABLE `fangzihuxing` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`fangzihuxing` varchar(200) NOT NULL COMMENT '房子户型',PRIMARY KEY (`id`),UNIQUE KEY `fangzihuxing` (`fangzihuxing`)
) ENGINE=InnoDB AUTO_INCREMENT=1615190571580 DEFAULT CHARSET=utf8 COMMENT='房子户型';/*Data for the table `fangzihuxing` */insert  into `fangzihuxing`(`id`,`addtime`,`fangzihuxing`) values (11,'2021-03-08 15:56:41','房子户型1'),(12,'2021-03-08 15:56:41','房子户型2'),(13,'2021-03-08 15:56:41','房子户型3'),(14,'2021-03-08 15:56:41','房子户型4'),(15,'2021-03-08 15:56:41','房子户型5'),(16,'2021-03-08 15:56:41','房子户型6'),(1615190571579,'2021-03-08 16:02:50','三房');/*Table structure for table `jingjiren` */DROP TABLE IF EXISTS `jingjiren`;CREATE TABLE `jingjiren` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`jingjirenzhanghao` varchar(200) NOT NULL COMMENT '经纪人账号',`jingjirenxingming` varchar(200) NOT NULL COMMENT '经纪人姓名',`mima` varchar(200) NOT NULL COMMENT '密码',`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',`nianling` int(11) DEFAULT NULL COMMENT '年龄',`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',`dianziyouxiang` varchar(200) DEFAULT NULL COMMENT '电子邮箱',`mendianmingcheng` varchar(200) DEFAULT NULL COMMENT '门店名称',`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',PRIMARY KEY (`id`),UNIQUE KEY `jingjirenzhanghao` (`jingjirenzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1615190622180 DEFAULT CHARSET=utf8 COMMENT='经纪人';/*Data for the table `jingjiren` */insert  into `jingjiren`(`id`,`addtime`,`jingjirenzhanghao`,`jingjirenxingming`,`mima`,`xingbie`,`nianling`,`lianxidianhua`,`dianziyouxiang`,`mendianmingcheng`,`touxiang`) values (41,'2021-03-08 15:56:41','经纪人1','经纪人姓名1',