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

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,操作更方便哦

  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

IT论之程序员

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值