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