java web开发房屋中介房屋出租信息网

项目描述

     后台添加发布房源信息，前台展示，采用nginx反向代理服务器存储房源图片信息，网站采用bootstrap响应式开发，对手机及平板端具有良好兼容性。

运行环境

jdk7+tomcat7+mysql+nginx

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for addhome

-- ----------------------------

DROP TABLE IF EXISTS `addhome`;

CREATE TABLE `addhome` (

  `homeid` int(11) NOT NULL AUTO_INCREMENT,

  `leibie` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homewhere` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `shi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `ting` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `wei` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `chu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `che` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `yang` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `niandai` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `mianji` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `zhuangxiu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `chaoxiang` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homeleixing` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `photo` text COLLATE utf8_unicode_ci,

  `administratorid` int(11) DEFAULT NULL,

  `price` int(11) DEFAULT NULL,

  `louceng` int(11) DEFAULT NULL,

  `xiaoqu` text COLLATE utf8_unicode_ci,

  `zhoubian` text COLLATE utf8_unicode_ci,

  `jiaotong` text COLLATE utf8_unicode_ci,

  PRIMARY KEY (`homeid`),

  KEY `pk_administratorid` (`administratorid`),

  CONSTRAINT `pk_administratorid` FOREIGN KEY (`administratorid`) REFERENCES `administrator` (`administratorid`)

) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for administrator

-- ----------------------------

DROP TABLE IF EXISTS `administrator`;

CREATE TABLE `administrator` (

  `administratorid` int(11) NOT NULL AUTO_INCREMENT,

  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `pwd` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `QQ` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `wechat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `Introduction` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,

  `photosrc` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'nophoto',

  PRIMARY KEY (`administratorid`)

) ENGINE=InnoDB AUTO_INCREMENT=2017009 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for collectionhome

-- ----------------------------

DROP TABLE IF EXISTS `collectionhome`;

CREATE TABLE `collectionhome` (

  `collectionid` int(11) NOT NULL AUTO_INCREMENT,

  `homeid` int(11) DEFAULT NULL,

  `username` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,

  PRIMARY KEY (`collectionid`),

  KEY `fk9` (`username`),

  KEY `fk10` (`homeid`),

  CONSTRAINT `fk10` FOREIGN KEY (`homeid`) REFERENCES `addhome` (`homeid`),

  CONSTRAINT `fk9` FOREIGN KEY (`username`) REFERENCES `userinfo` (`username`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for contant

-- ----------------------------

DROP TABLE IF EXISTS `contant`;

CREATE TABLE `contant` (

  `c_id` int(11) NOT NULL AUTO_INCREMENT,

  `c_person` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `c_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `c_qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `c_value` text COLLATE utf8_unicode_ci,

  `c_date` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`c_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for customer

-- ----------------------------

DROP TABLE IF EXISTS `customer`;

CREATE TABLE `customer` (

  `customserid` int(11) NOT NULL AUTO_INCREMENT,

  `customername` varchar(255) DEFAULT NULL,

  `customerjianjie` text,

  `customeryear` varchar(255) DEFAULT NULL,

  `photosrc` varchar(500) DEFAULT NULL,

  PRIMARY KEY (`customserid`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Table structure for goodsale

-- ----------------------------

DROP TABLE IF EXISTS `goodsale`;

CREATE TABLE `goodsale` (

  `administratorid` int(11) DEFAULT NULL,

  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `pwd` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `QQ` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `wechat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `Introduction` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,

  `photosrc` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'nophoto',

  KEY `fk8` (`administratorid`),

  CONSTRAINT `fk8` FOREIGN KEY (`administratorid`) REFERENCES `administrator` (`administratorid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for hotlease

-- ----------------------------

DROP TABLE IF EXISTS `hotlease`;

CREATE TABLE `hotlease` (

  `homeid` int(11) DEFAULT NULL,

  `leibie` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homewhere` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `shi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `ting` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `wei` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `chu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `che` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `yang` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `niandai` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `mianji` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `zhuangxiu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `chaoxiang` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homeleixing` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `photo` text COLLATE utf8_unicode_ci,

  `administratorid` int(11) DEFAULT NULL,

  `price` int(11) DEFAULT NULL,

  `louceng` int(11) DEFAULT NULL,

  `xiaoqu` text COLLATE utf8_unicode_ci,

  `zhoubian` text COLLATE utf8_unicode_ci,

  `jiaotong` text COLLATE utf8_unicode_ci,

  KEY `fk1` (`homeid`),

  KEY `fk2` (`administratorid`),

  CONSTRAINT `fk1` FOREIGN KEY (`homeid`) REFERENCES `addhome` (`homeid`),

  CONSTRAINT `fk2` FOREIGN KEY (`administratorid`) REFERENCES `administrator` (`administratorid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for hotsale

-- ----------------------------

DROP TABLE IF EXISTS `hotsale`;

CREATE TABLE `hotsale` (

  `homeid` int(11) DEFAULT NULL,

  `leibie` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homewhere` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `shi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `ting` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `wei` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `chu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `che` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `yang` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `niandai` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `mianji` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `zhuangxiu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `chaoxiang` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homeleixing` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `photo` text COLLATE utf8_unicode_ci,

  `administratorid` int(11) DEFAULT NULL,

  `price` int(11) DEFAULT NULL,

  `louceng` int(11) DEFAULT NULL,

  `xiaoqu` text COLLATE utf8_unicode_ci,

  `zhoubian` text COLLATE utf8_unicode_ci,

  `jiaotong` text COLLATE utf8_unicode_ci,

  KEY `fk3` (`homeid`),

  KEY `fk4` (`administratorid`),

  CONSTRAINT `fk3` FOREIGN KEY (`homeid`) REFERENCES `addhome` (`homeid`),

  CONSTRAINT `fk4` FOREIGN KEY (`administratorid`) REFERENCES `administrator` (`administratorid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for housexq

-- ----------------------------

DROP TABLE IF EXISTS `housexq`;

CREATE TABLE `housexq` (

  `homeid` int(255) NOT NULL AUTO_INCREMENT,

  `leibie` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `home` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `position` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `shi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `ting` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `wei` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `zhuangxiu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `person` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  PRIMARY KEY (`homeid`),

  KEY `fk5` (`person`),

  CONSTRAINT `fk5` FOREIGN KEY (`person`) REFERENCES `userinfo` (`username`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for leaedhome

-- ----------------------------

DROP TABLE IF EXISTS `leaedhome`;

CREATE TABLE `leaedhome` (

  `homeid` int(11) NOT NULL AUTO_INCREMENT,

  `leibie` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homewhere` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `shi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `ting` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `wei` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `chu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `che` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `yang` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `niandai` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `mianji` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `zhuangxiu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `chaoxiang` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `homeleixing` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `photo` text COLLATE utf8_unicode_ci,

  `administratorid` int(11) DEFAULT NULL,

  `price` int(11) DEFAULT NULL,

  `louceng` int(11) DEFAULT NULL,

  `xiaoqu` text COLLATE utf8_unicode_ci,

  `zhoubian` text COLLATE utf8_unicode_ci,

  `jiaotong` text COLLATE utf8_unicode_ci,

  PRIMARY KEY (`homeid`),

  KEY `fk6` (`administratorid`),

  CONSTRAINT `fk6` FOREIGN KEY (`administratorid`) REFERENCES `administrator` (`administratorid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for news

-- ----------------------------

DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (

  `newsid` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `news` longtext COLLATE utf8_unicode_ci,

  `photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `personid` int(11) DEFAULT NULL,

  `context` text COLLATE utf8_unicode_ci,

  PRIMARY KEY (`newsid`),

  KEY `fk7` (`personid`),

  CONSTRAINT `fk7` FOREIGN KEY (`personid`) REFERENCES `administrator` (`administratorid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for userinfo

-- ----------------------------

DROP TABLE IF EXISTS `userinfo`;

CREATE TABLE `userinfo` (

  `id` bigint(20) NOT NULL AUTO_INCREMENT,

  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

  `pwd` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`id`),

  KEY `username` (`username`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

下载地址

链接：https://pan.baidu.com/s/1Gp_Pl1RovxI8Voba_m15Ug  提取码：z7qw  复制这段内容后打开百度网盘手机App，操作更方便哦