易居住房信息

于 2019-10-17 16:58:22 发布
阅读量675 收藏 1
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/huishuohua/article/details/102609426
版权

1.建数据库

在这里插入图片描述

– Table structure for tb_user

DROP TABLE IF EXISTS tb_user;
CREATE TABLE tb_user (
user_id INT(11) NOT NULL AUTO_INCREMENT COMMENT ‘用户唯一标识ID’,
phone VARCHAR(18) NOT NULL COMMENT ‘用户手机号，用来登录’,
password VARCHAR(255) DEFAULT NULL COMMENT ‘用户登录密码’,
email VARCHAR(255) DEFAULT NULL COMMENT ‘用户邮箱’,
nickname VARCHAR(255) DEFAULT NULL COMMENT ‘用户昵称’,
truename VARCHAR(255) DEFAULT NULL COMMENT ‘z真实姓名’,
gender TINYINT(4) DEFAULT ‘0’ COMMENT ‘性别：0：男 1：女’,
province VARCHAR(255) DEFAULT NULL COMMENT ‘省份’,
city VARCHAR(255) DEFAULT NULL COMMENT ‘城市’,
is_delete TINYINT(4) DEFAULT ‘0’ COMMENT ‘是否删除：0：未删除 1：已删除’,
create_time BIGINT(20) DEFAULT ‘0’ COMMENT ‘创建时间’,
update_time BIGINT(20) DEFAULT ‘0’ COMMENT ‘更新时间’,
PRIMARY KEY (user_id),
UNIQUE KEY tb_user_user_id_uindex (user_id),
UNIQUE KEY tb_user_nickname_uindex (nickname),
UNIQUE KEY tb_user_email_uindex (email)
) ENGINE=INNODB AUTO_INCREMENT=10017 DEFAULT CHARSET=utf8;

– Records of tb_user

INSERT INTO tb_user VALUES (‘10000’, ‘15927170000’, ‘111’, ‘0’, ‘1’, ‘0’, ‘0’, ‘0’, ‘0’, ‘1’, ‘0’, ‘0’);
INSERT INTO tb_user VALUES (‘10001’, ‘18956419371’, ‘1’, NULL, ‘123’, ‘123’, ‘0’, NULL, ‘宁波’, ‘1’, ‘1562037886530’, ‘1562567466113’);
INSERT INTO tb_user VALUES (‘10002’, ‘1592717030’, ‘111’, NULL, NULL, NULL, ‘0’, NULL, NULL, ‘0’, ‘1562038054883’, ‘1562038054883’);
INSERT INTO tb_user VALUES (‘10003’, ‘1876339880’, ‘123456’, NULL, NULL, NULL, ‘0’, NULL, NULL, ‘0’, ‘1562054809634’, ‘1562054809634’);
INSERT INTO tb_user VALUES (‘10005’, ‘15927170300’, ‘666’, NULL, ‘拾年之璐666’, ‘hualili’, ‘0’, NULL, ‘宁波市’, ‘0’, ‘1562145730371’, ‘1562383334404’);
INSERT INTO tb_user VALUES (‘10006’, ‘18171294402’, ‘123456’, NULL, NULL, NULL, ‘0’, NULL, NULL, ‘0’, ‘1562158516197’, ‘1562158516197’);
INSERT INTO tb_user VALUES (‘10007’, ‘15871755644’, ‘123456’, NULL, NULL, NULL, ‘0’, NULL, NULL, ‘0’, ‘1562295902516’, ‘1562295902516’);
INSERT INTO tb_user VALUES (‘10008’, ‘1814055144’, ‘123456’, NULL, NULL, NULL, ‘0’, NULL, NULL, ‘0’, ‘1562373638947’, ‘1562373638947’);
INSERT INTO tb_user VALUES (‘10009’, ‘15927288737’, ‘123’, NULL, ‘反对法’, ‘王二狗’, ‘0’, NULL, ‘安徽’, ‘0’, ‘1562468752380’, ‘1562512818027’);
INSERT INTO tb_user VALUES (‘10010’, ‘18164331561’, ‘123’, NULL, ‘AAA’, NULL, ‘0’, NULL, NULL, ‘1’, ‘0’, ‘0’);
INSERT INTO tb_user VALUES (‘10011’, ‘181405514’, ‘123456’, NULL, NULL, NULL, ‘0’, NULL, NULL, ‘0’, ‘1562514872076’, ‘1562514872076’);
INSERT INTO tb_user VALUES (‘10012’, ‘15927277020’, ‘chengxiuhaoshabi’, NULL, ‘是大大大’, ‘成修好’, ‘1’, NULL, ‘武汉’, ‘0’, ‘1562551549828’, ‘1562551881184’);
INSERT INTO tb_user VALUES (‘10013’, ‘15623914811’, ‘123456789’, NULL, NULL, NULL, ‘0’, NULL, NULL, ‘0’, ‘1562552611246’, ‘1562552611246’);
INSERT INTO tb_user VALUES (‘10014’, ‘13667239620’, ‘123’, NULL, NULL, NULL, ‘0’, NULL, NULL, ‘0’, ‘1562561389895’, ‘1562561389895’);
INSERT INTO tb_user VALUES (‘10015’, ‘13866781484’, ‘123456’, NULL, NULL, NULL, ‘0’, NULL, NULL, ‘0’, ‘1562570015266’, ‘1562570015266’);
INSERT INTO tb_user VALUES (‘10016’, ‘15056619779’, ‘111’, NULL, NULL, NULL, ‘0’, NULL, NULL, ‘0’, ‘1562572434929’, ‘1562572434929’);

– Table structure for tb_house

DROP TABLE IF EXISTS tb_house;
CREATE TABLE tb_house (
house_id INT(11) NOT NULL AUTO_INCREMENT COMMENT ‘房源表唯一标识ID’,
user_id INT(11) NOT NULL COMMENT ‘发布此房源的用户ID,外键’,
house_type TINYINT(4) DEFAULT NULL COMMENT ‘房源类型：0新房、1旧房、2租房’,
house_title VARCHAR(255) DEFAULT NULL COMMENT ‘房源帖子标题’,
house_headimg VARCHAR(255) DEFAULT NULL COMMENT ‘房源帖子头像’,
house_planimg1 VARCHAR(255) DEFAULT NULL COMMENT ‘房屋户型平面图1’,
house_planimg2 VARCHAR(255) DEFAULT NULL COMMENT ‘房屋户型平面图2’,
house_img1 VARCHAR(255) DEFAULT NULL COMMENT ‘房屋室内图1’,
house_img2 VARCHAR(255) DEFAULT NULL COMMENT ‘房屋室内图2’,
house_img3 VARCHAR(255) DEFAULT NULL COMMENT ‘房屋室内图3’,
house_img4 VARCHAR(255) DEFAULT NULL COMMENT ‘房屋室内图4’,
house_img5 VARCHAR(255) DEFAULT NULL COMMENT ‘房屋室内图5’,
house_img6 VARCHAR(255) DEFAULT NULL COMMENT ‘房屋室内图6’,
house_price DECIMAL(20,2) DEFAULT ‘0.00’ COMMENT ‘房源预计售价’,
price_unit VARCHAR(255) DEFAULT NULL COMMENT ‘售价单位：元/月，元/套、元/年……’,
house_address VARCHAR(255) DEFAULT NULL COMMENT ‘房源地址’,
is_delete TINYINT(4) DEFAULT ‘0’ COMMENT ‘是否删除：0：未删除 1：已删除’,
create_time BIGINT(15) DEFAULT ‘0’ COMMENT ‘创建时间’,
update_time BIGINT(15) DEFAULT ‘0’ COMMENT ‘更新时间’,
PRIMARY KEY (house_id),
UNIQUE KEY tb_house_house_id_uindex (house_id),
KEY house_userid (user_id),
CONSTRAINT house_userid FOREIGN KEY (user_id) REFERENCES tb_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB AUTO_INCREMENT=10046 DEFAULT CHARSET=utf8;

– Records of tb_house

INSERT INTO tb_house VALUES (‘10001’, ‘10005’, ‘0’, ‘奥园誉山湖’, ‘20190704logo01.jpg’, ‘20190704type01.jpg’, NULL, ‘20190704internal01.jpg’, ‘20190704internal02.jpg’, ‘20190704internal03.jpg’, ‘20190704internal04.jpg’, ‘20190704internal05.jpg’, ‘20190704internal06.jpg’, ‘1300000.00’, ‘元/套’, ‘[慈溪]桃园中路与规划一路交汇处’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10002’, ‘10005’, ‘0’, ‘湖畔樾山\r\n’, ‘20190704logo02.jpg’, ‘20190704type02.jpg’, NULL, ‘20190704internal07.jpg’, ‘20190704internal08.jpg’, ‘20190704internal09.jpg’, ‘20190704internal010.jpg’, ‘20190704internal011.jpg’, ‘20190704internal012.jpg’, ‘1560000.00’, ‘元/套’, ‘[海曙] 常青路与苍松路交汇处’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10003’, ‘10005’, ‘0’, ‘金地华章’, ‘20190704logo03.jpg’, ‘20190704type03.jpg’, NULL, ‘20190704internal013.jpg’, ‘20190704internal014.jpg’, ‘20190704internal015.jpg’, ‘20190704internal016.jpg’, ‘20190704internal017.jpg’, ‘20190704internal018.jpg’, ‘1260000.00’, ‘元/套’, ‘[海曙] 常青路与苍松路交汇处’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10004’, ‘10005’, ‘0’, ‘凯旋府’, ‘20190704logo04.jpg’, ‘20190704type04.jpg’, NULL, ‘20190704internal019.jpg’, ‘20190704internal020.jpg’, ‘20190704internal021.jpg’, ‘20190704internal022.jpg’, ‘20190704internal023.jpg’, ‘20190704internal024.jpg’, ‘1100000.00’, ‘元/套’, ’ [北仑]新碶街道明州西路和凤洋二路交汇处’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10005’, ‘10005’, ‘0’, ‘绿地·悦山府’, ‘20190704logo12.jpg’, ‘20190704type06.jpg’, NULL, ‘20190704internal025.jpg’, ‘20190704internal026.jpg’, ‘20190704internal027.jpg’, ‘20190704internal028.jpg’, ‘20190704internal029.jpg’, ‘20190704internal030.jpg’, ‘1830000.00’, ‘元/套’, ‘[余姚]南雷南路与远东路交汇处’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10006’, ‘10005’, ‘0’, ‘绿地观堂’, ‘20190704logo05.jpg’, ‘20190704type07.jpg’, NULL, ‘20190704internal031.jpg’, ‘20190704internal032.jpg’, ‘20190704internal033.jpg’, ‘20190704internal034.jpg’, ‘20190704internal035.jpg’, ‘20190704internal036.jpg’, ‘1560000.00’, ‘元/套’, ‘[海曙] 包家路’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10007’, ‘10005’, ‘0’, ‘漫悦湾’, ‘20190704logo06.jpg’, ‘20190704type08.jpg’, NULL, ‘20190704internal037.jpg’, ‘20190704internal038.jpg’, ‘20190704internal039.jpg’, ‘20190704internal040.jpg’, ‘20190704internal041.jpg’, ‘20190704internal042.jpg’, ‘1730000.00’, ‘元/套’, ‘[余姚] 姚北新城欣朗路与迎霞北路交汇处’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10009’, ‘10005’, ‘0’, ‘新希望堇麟府’, ‘20190704logo08.jpg’, ‘20190704type010.jpg’, NULL, ‘20190704internal049.jpg’, ‘20190704internal050.jpg’, ‘20190704internal051.jpg’, ‘20190704internal052.jpg’, ‘20190704internal053.jpg’, ‘20190704internal054.jpg’, ‘990000.00’, ‘元/套’, ‘[鄞州] 下应南路与立德路交汇处’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10010’, ‘10005’, ‘0’, ‘中海枫桥里’, ‘20190704logo09.jpg’, ‘20190704type011.jpg’, NULL, ‘20190704internal055.jpg’, ‘20190704internal056.jpg’, ‘20190704internal057.jpg’, ‘20190704internal058.jpg’, ‘20190704internal059.jpg’, ‘20190704internal060.jpg’, ‘1280000.00’, ‘元/套’, ‘[江北] 天沁路与李家西路交汇处’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10011’, ‘10005’, ‘0’, ‘中梁象山中心大厦’, ‘20190704logo10.jpg’, ‘20190704type05.jpg’, NULL, ‘20190704internal061.jpg’, ‘20190704internal062.jpg’, ‘20190704internal063.jpg’, ‘20190704internal064.jpg’, ‘20190704internal065.jpg’, ‘20190704internal066.jpg’, ‘1360000.00’, ‘元/套’, ‘[象山] 丹阳路与新华路交汇处（财富中心对面）’, ‘0’, ‘1562479560517’, ‘1562479590517’);
INSERT INTO tb_house VALUES (‘10012’, ‘10009’, ‘0’, ‘中南锦悦府’, ‘20190704logo11.jpg’, ‘20190704type012.jpg’, NULL, ‘20190704internal067.jpg’, ‘20190704internal068.jpg’, ‘20190704internal069.jpg’, ‘20190704internal070.jpg’, ‘20190704internal071.jpg’, ‘20190704internal072.jpg’, ‘1490000.00’, ‘元/套’, ‘[北仑] 小港中机路和联合路交汇处’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10013’, ‘10005’, ‘2’, ‘荣安香园 3室2厅1卫’, ‘logo21.jpg’, ‘type21.jpg’, NULL, ‘internal31.jpg’, ‘internal32.jpg’, ‘internal33.jpg’, ‘internal34.jpg’, ‘internal35.jpg’, ‘internal36.jpg’, ‘3900.00’, ‘元/月’, ‘荣安香园(鄞州下应)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10014’, ‘10009’, ‘2’, ‘万科城湖景房，5500元月带车位’, ‘logo40.jpg’, ‘type40.jpg’, NULL, ‘internal41.jpg’, ‘internal42.jpg’, ‘internal43.jpg’, ‘internal44.jpg’, ‘internal45.jpg’, ‘internal46.jpg’, ‘5500.00’, ‘元/月’, ‘万科城(镇海庄市)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10015’, ‘10009’, ‘2’, ‘高新区 高端小区和美城旁 金东岸 精装公寓 急租’, ‘logo50.jpg’, ‘type50.jpg’, NULL, ‘internal51.jpg’, ‘internal52.jpg’, ‘internal53.jpg’, ‘internal54.jpg’, ‘internal55.jpg’, ‘internal56.jpg’, ‘4800.00’, ‘元/月’, ‘二品花园(北仑下海)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10016’, ‘10009’, ‘2’, ‘凤凰国际 50平 朝南 1室1厅1卫 单身公寓 拎包入’, ‘logo60.jpg’, ‘type60.jpg’, NULL, ‘internal61.jpg’, ‘internal62.jpg’, ‘internal63.jpg’, ‘internal64.jpg’, ‘internal65.jpg’, ‘internal66.jpg’, ‘2100.00’, ‘元/月’, ’ 金东岸(高新区一品广场)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10017’, ‘10009’, ‘2’, ‘百合公寓68平精装两室3200包物业 看房方便’, ‘logo70.jpg’, ‘type21.jpg’, NULL, ‘internal71.jpg’, ‘internal72.jpg’, ‘internal73.jpg’, ‘internal74.jpg’, ‘internal75.jpg’, ‘internal76.jpg’, ‘3400.00’, ‘元/月’, ‘东北上城(余姚广场)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10018’, ‘10009’, ‘2’, ‘百合公寓 2室1厅 南 绿城百合公寓 2室1厅’, ‘logo80.jpg’, ‘type40.jpg’, NULL, ‘internal81.jpg’, ‘internal82.jpg’, ‘internal83.jpg’, ‘internal84.jpg’, ‘internal85.jpg’, ‘internal86.jpg’, ‘3350.00’, ‘元/月’, ’ 绿城百合公寓(象山市区)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10019’, ‘10009’, ‘2’, ‘康桥风尚 可短租 免介绍费 房东直租 含物业费 干净’, ‘logo90.jpg’, ‘type90.jpg’, NULL, ‘internal91.jpg’, ‘internal92.jpg’, ‘internal93.jpg’, ‘internal94.jpg’, ‘internal95.jpg’, ‘internal96.jpg’, ‘1800.00’, ‘元/月’, ‘康桥风尚(江北文教)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10020’, ‘10009’, ‘2’, ‘有巢公馆可短租 近地铁 天一广场 直租无中介 独卫精装公寓’, ‘logo100.jpg’, ‘type100.jpg’, NULL, ‘internal101.jpg’, ‘internal102.jpg’, ‘internal103.jpg’, ‘internal104.jpg’, ‘internal105.jpg’, ‘internal106.jpg’, ‘2600.00’, ‘元/月’, ’ 银亿环球中心B座(商住楼) (海曙 天一广场)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10021’, ‘10009’, ‘2’, ‘杭州湾观澜苑 3房2厅2卫 精装2200 南北通透’, ‘logo110.jpg’, ‘type110.jpg’, NULL, ‘internal111.jpg’, ‘internal112.jpg’, ‘internal113.jpg’, ‘internal114.jpg’, ‘internal115.jpg’, ‘internal116.jpg’, ‘2000.00’, ‘元/月’, ’ 世纪城观澜苑 (杭州湾新区 世纪城)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10022’, ‘10009’, ‘2’, ‘桃源小区 三房朝南三室两厅一卫 清爽干净出租 有钥匙看房方便’, ‘logo120.jpg’, ‘type120.jpg’, NULL, ‘internal121.jpg’, ‘internal122.jpg’, ‘internal123.jpg’, ‘internal124.jpg’, ‘internal125.jpg’, ‘internal126.jpg’, ‘2600.00’, ‘元/月’, ‘桃源小区(奉化 惠中商城)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10023’, ‘10009’, ‘2’, ‘中海雍城世 近南部商务区 高教园区 院士公园 精装一室’, ‘logo130.jpg’, ‘type130.jpg’, NULL, ‘internal131.jpg’, ‘internal132.jpg’, ‘internal133.jpg’, ‘internal134.jpg’, ‘internal135.jpg’, ‘internal136.jpg’, ‘4500.00’, ‘元/月’, ‘中海雍城世家二期 (鄞州 首南)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10024’, ‘10009’, ‘2’, ‘拎包入住，家具齐全，值得拥有’, ‘logo80.jpg\r\n’, ‘type90.jpg’, NULL, ‘internal91.jpg’, ‘internal92.jpg’, ‘internal93.jpg’, ‘internal94.jpg’, ‘internal95.jpg’, ‘internal96.jpg’, ‘1200.00’, ‘元/月’, ‘春晖家园 (宁海 宁海大厦)’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10025’, ‘10009’, ‘1’, ‘百步亭锦湖金利，业主诚心急售’, ‘1logo11.jpg’, ‘1type11.jpg’, NULL, ‘1internal111.jpg’, ‘1internal112.jpg’, ‘1internal113.jpg’, ‘1internal114.jpg’, ‘1internal115.jpg’, ‘1internal116.jpg’, ‘1702300.00’, ‘元/套’, ‘百步亭锦湖金利’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10026’, ‘10009’, ‘1’, ‘出售万科景苑精装二房’, ‘1logo12.jpg’, ‘1type12.jpg’, NULL, ‘1internal121.jpg’, ‘1internal122.jpg’, ‘1internal123.jpg’, ‘1internal124.jpg’, ‘1internal125.jpg’, ‘1internal126.jpg’, ‘1562200.00’, ‘元/套’, ‘万科景苑’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10027’, ‘10000’, ‘1’, ‘保利上城近地铁三房急售’, ‘1logo13.jpg’, ‘1type13.jpg’, NULL, ‘1internal131.jpg’, ‘1internal132.jpg’, ‘1internal133.jpg’, ‘1internal134.jpg’, ‘1internal135.jpg’, ‘1internal136.jpg’, ‘1976800.00’, ‘元/套’, ‘保利上城’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10028’, ‘10000’, ‘1’, ‘光谷MAMO老房低税诚意出售’, ‘1logo14.jpg’, ‘1type14.jpg’, NULL, ‘1internal141.jpg’, ‘1internal142.jpg’, ‘1internal143.jpg’, ‘1internal144.jpg’, ‘1internal145.jpg’, ‘1internal146.jpg’, ‘2021600.00’, ‘元/套’, ‘光谷MAMO’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10029’, ‘10000’, ‘1’, ‘光谷满庭春老房近地铁诚售’, ‘1logo15.jpg’, ‘1type15.jpg’, NULL, ‘1internal151.jpg’, ‘1internal152.jpg’, ‘1internal153.jpg’, ‘1internal154.jpg’, ‘1internal155.jpg’, ‘1internal156.jpg’, ‘1224400.00’, ‘元/套’, ‘光谷满庭春’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10030’, ‘10000’, ‘1’, ‘卧龙墨水湖边低税急出售’, ‘1logo16.jpg’, ‘1type16.jpg’, NULL, ‘1internal161.jpg’, ‘1internal162.jpg’, ‘1internal163.jpg’, ‘1internal164.jpg’, ‘1internal165.jpg’, ‘1internal166.jpg’, ‘1536400.00’, ‘元/套’, ‘卧龙墨水湖边’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10031’, ‘10000’, ‘1’, ‘大江天际精装三房位置优越’, ‘1logo17.jpg’, ‘1type17.jpg’, NULL, ‘1internal171.jpg’, ‘1internal172.jpg’, ‘1internal173.jpg’, ‘1internal174.jpg’, ‘1internal175.jpg’, ‘1internal176.jpg’, ‘1848400.00’, ‘元/套’, ‘大江天际’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10032’, ‘10000’, ‘1’, ‘新天地社区’, ‘1logo18.jpg’, ‘1type18.jpg’, NULL, ‘1internal181.jpg’, ‘1internal182.jpg’, ‘1internal183.jpg’, ‘1internal184.jpg’, ‘1internal185.jpg’, ‘1internal186.jpg’, ‘1532600.00’, ‘元/套’, ‘新天地社区’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10033’, ‘10000’, ‘1’, ‘清江山水’, ‘1logo19.jpg’, ‘1type19.jpg’, NULL, ‘1internal191.jpg’, ‘1internal192.jpg’, ‘1internal193.jpg’, ‘1internal194.jpg’, ‘1internal195.jpg’, ‘1internal196.jpg’, ‘1442200.00’, ‘元/套’, ‘清江山水’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10034’, ‘10000’, ‘1’, ‘百步亭幸福时代’, ‘1logo20.jpg’, ‘1type20.jpg’, NULL, ‘1internal201.jpg’, ‘1internal202.jpg’, ‘1internal203.jpg’, ‘1internal204.jpg’, ‘1internal205.jpg’, ‘1internal206.jpg’, ‘1351800.00’, ‘元/套’, ‘百步亭幸福时代’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10035’, ‘10000’, ‘1’, ‘金域天下’, ‘1logo21.jpg’, ‘1type21.jpg’, NULL, ‘1internal211.jpg’, ‘1internal212.jpg’, ‘1internal213.jpg’, ‘1internal214.jpg’, ‘1internal215.jpg’, ‘1internal216.jpg’, ‘1261400.00’, ‘元/套’, ‘金域天下’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10036’, ‘10000’, ‘1’, ‘顶清江山水’, ‘1logo22.jpg’, ‘1type22.jpg’, NULL, ‘1internal221.jpg’, ‘1internal222.jpg’, ‘1internal223.jpg’, ‘1internal224.jpg’, ‘1internal225.jpg’, ‘1internal226.jpg’, ‘1672200.00’, ‘元/套’, ‘顶清江山水’, ‘0’, ‘1562479560517’, ‘1562479560517’);
INSERT INTO tb_house VALUES (‘10041’, ‘10005’, ‘0’, ‘二号府邸’, ‘2019070766e89890-f6d1-480b-a61b-df4720e267fb’, ‘20190707415b7176-6bec-4d16-80e0-bc9160eac301’, ‘201907074de09f47-08fd-4a27-a3d2-5425db54ace5’, ‘201907070a8ae23d-8f69-4204-a28f-b15b6628e4c3’, ‘20190707dbf753c9-3408-4d46-adee-641e098b9ee7’, ‘201907077314d576-79a6-46bc-a376-4fdb28347a54’, ‘20190707d8e47adf-5d70-43d9-bef7-2e77ff82c9f5’, ‘20190707ec6074ed-7346-4a7b-977e-e4682a33153c’, ‘’, ‘1.00’, ‘元/套’, ‘和平大道1178号’, ‘0’, ‘1562498010533’, ‘1562498010533’);
INSERT INTO tb_house VALUES (‘10042’, ‘10009’, ‘0’, ‘招租，超级大床房，有阳台’, ‘20190704logo11.jpg’, ‘’, ‘’, ‘20190708803995c3-5bb6-4f1c-86f4-6681a4e1b772’, ‘2019070806a948ba-f3d1-44de-9a16-bc3b7b83d36f’, ‘20190708a093e103-0fc8-4bce-b2fd-ad6323253eff’, ‘20190708b1c9eed7-1b03-4c2d-b50d-ced941e48b67’, ‘20190708da29137d-7840-41ce-bcd1-9d6de2ad21fe’, ‘20190708e5381bcc-b2b6-4812-8928-3bd82a79a683’, ‘45000000.00’, ‘元/套’, ‘宁波市天堂西地狱门口’, ‘1’, ‘1562547324907’, ‘1562547324907’);
INSERT INTO tb_house VALUES (‘10043’, ‘10012’, ‘0’, ‘学生宿舍’, ‘20190708e0591b74-75ff-4c76-8185-bb156ad7bdc8’, ‘2019070803e9b500-9bbc-473e-a5e1-4d55ce2adf3a’, ‘201907089cc39295-afef-4eee-94ca-a752af20c409’, ‘20190708e7ebc4bf-d7c7-462b-af58-d89f82429d17’, ‘201907080dcf7b08-1a50-4bd7-b8df-f92621017e2e’, ‘2019070853dc0160-93dc-42d7-af4d-13dc7109dff3’, ‘’, ‘’, ‘’, ‘200.00’, ‘元/套’, ‘余家头海虹4栋540’, ‘1’, ‘1562551806097’, ‘1562551806097’);
INSERT INTO tb_house VALUES (‘10045’, ‘10016’, ‘0’, ‘房子’, ‘201907083b155f50-ed1f-427f-a85b-c9bfe365e552’, ‘20190708fb3c1561-91d4-4c54-91b5-d2cde69ba918’, ‘20190708fd47e1b0-6a28-47d8-8dc7-e5e634b8ceae’, ‘2019070826f2834a-ddff-486b-a447-decc425b7d06’, ‘201907084d99f477-5939-4a2a-8395-64ecd1e3fd6d’, ‘20190708ffcac347-5fcd-47ee-b8df-fe329a1f2f50’, NULL, NULL, NULL, ‘15.00’, ‘元/月’, ‘打啊’, ‘0’, ‘1562572577153’, ‘1562572577153’);

– Table structure for tb_house_info

DROP TABLE IF EXISTS tb_house_info;
CREATE TABLE tb_house_info (
info_id INT(11) NOT NULL AUTO_INCREMENT COMMENT ‘房源详细信息表唯一标识ID’,
house_id INT(11) DEFAULT NULL COMMENT ‘外键：对应房源表ID’,
house_nature VARCHAR(255) DEFAULT NULL COMMENT ‘房源性质：商品房、住宅房’,
house_model VARCHAR(255) DEFAULT NULL COMMENT ‘房源类型：普通住宅、公寓式住宅、别墅、独栋’,
house_year INT(11) DEFAULT NULL COMMENT ‘房源建造时间’,
house_valid VARCHAR(255) DEFAULT NULL COMMENT ‘房源期限：70年、100年、永久’,
house_layout VARCHAR(255) DEFAULT NULL COMMENT ‘房源户型：几室几厅几卫’,
house_area VARCHAR(255) DEFAULT NULL COMMENT ‘房源面积’,
house_turn VARCHAR(255) DEFAULT NULL COMMENT ‘朝向’,
house_floor INT(11) DEFAULT NULL COMMENT ‘楼层’,
floor_all INT(11) DEFAULT NULL COMMENT ‘总楼层’,
house_decorate VARCHAR(255) DEFAULT NULL COMMENT ‘装饰类型：精装、简装’,
house_lift TINYINT(4) DEFAULT NULL COMMENT ‘是否有电梯：0无 1有’,
create_time BIGINT(15) DEFAULT ‘0’ COMMENT ‘创建时间’,
update_time BIGINT(15) DEFAULT ‘0’ COMMENT ‘更新时间’,
PRIMARY KEY (info_id),
UNIQUE KEY tb_house_info_info_id_uindex (info_id),
KEY info_houseid (house_id),
CONSTRAINT info_houseid FOREIGN KEY (house_id) REFERENCES tb_house (house_id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB AUTO_INCREMENT=10045 DEFAULT CHARSET=utf8;

– Records of tb_house_info

INSERT INTO tb_house_info VALUES (‘10000’, ‘10001’, ‘商品房’, ‘普通住宅’, ‘2010’, ‘70年’, ‘4室2厅2卫1厨’, '99.21 ', ‘东’, ‘4’, ‘24’, ‘简装’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10001’, ‘10002’, ‘商品房’, ‘普通住宅’, ‘2014’, ‘70年’, ‘3室2厅1卫1厨’, '78.23 ', ‘东’, ‘5’, ‘24’, ‘简装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10002’, ‘10003’, ‘商品房’, ‘普通住宅’, ‘2013’, ‘70年’, ‘3室2厅1卫1厨’, '103.25 ', ‘东’, ‘8’, ‘24’, ‘简装’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10003’, ‘10004’, ‘商品房’, ‘普通住宅’, ‘2015’, ‘70年’, ‘3室2厅1卫1厨’, '97.60 ', ‘东’, ‘12’, ‘24’, ‘简装’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10004’, ‘10005’, ‘商品房’, ‘普通住宅’, ‘2011’, ‘70年’, ‘2室2厅1卫1厨’, '99.62 ', ‘西’, ‘16’, ‘24’, ‘精装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10005’, ‘10006’, ‘商品房’, ‘普通住宅’, ‘2013’, ‘70年’, ‘2室2厅1卫1厨’, '101.64 ', ‘西’, ‘10’, ‘24’, ‘精装’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10006’, ‘10007’, ‘商品房’, ‘普通住宅’, ‘2014’, ‘70年’, ‘3室1厅1卫1厨’, '103.66 ', ‘西’, ‘6’, ‘24’, ‘精装’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10008’, ‘10009’, ‘商品房’, ‘普通住宅’, ‘2011’, ‘70年’, ‘4室2厅1卫1厨’, '107.70 ', ‘西’, ‘4’, ‘24’, ‘精装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10009’, ‘10010’, ‘商品房’, ‘普通住宅’, ‘2014’, ‘70年’, ‘5室2厅2卫1厨’, '109.72 ', ‘南’, ‘8’, ‘24’, ‘精装’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10010’, ‘10011’, ‘商品房’, ‘普通住宅’, ‘2013’, ‘70年’, ‘3室1厅1卫1厨’, '111.74 ', ‘南’, ‘9’, ‘24’, ‘精装’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10011’, ‘10012’, ‘商品房’, ‘普通住宅’, ‘2015’, ‘70年’, ‘4室2厅2卫1厨’, '113.76 ', ‘南’, ‘21’, ‘24’, ‘简装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10012’, ‘10013’, ‘商品房’, ‘普通住宅’, ‘2010’, ‘70年’, ‘二室一厅一卫’, '99.21 ', ‘南’, ‘4’, ‘24’, ‘精装’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10013’, ‘10014’, ‘商品房’, ‘普通住宅’, ‘2014’, ‘70年’, ‘一室一厅一卫’, '78.23 ', ‘南’, ‘5’, ‘24’, ‘简装’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10014’, ‘10015’, ‘商品房’, ‘普通住宅’, ‘2013’, ‘70年’, ‘一室一厅一卫’, '103.25 ', ‘南’, ‘8’, ‘24’, ‘简装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10015’, ‘10016’, ‘商品房’, ‘普通住宅’, ‘2015’, ‘70年’, ‘一室一厅一卫’, '97.60 ', ‘南’, ‘12’, ‘24’, ‘简装’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10016’, ‘10017’, ‘商品房’, ‘普通住宅’, ‘2011’, ‘70年’, ‘一室一厅一卫’, '99.62 ', ‘北’, ‘16’, ‘24’, ‘简装’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10017’, ‘10018’, ‘商品房’, ‘普通住宅’, ‘2013’, ‘70年’, ‘一室一厅一卫’, '101.64 ', ‘北’, ‘10’, ‘24’, ‘简装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10018’, ‘10019’, ‘商品房’, ‘普通住宅’, ‘2014’, ‘70年’, ‘三室二厅一卫’, '103.66 ', ‘北’, ‘6’, ‘24’, ‘简装’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10019’, ‘10020’, ‘商品房’, ‘普通住宅’, ‘2016’, ‘70年’, ‘一室一厅一卫’, '105.68 ', ‘北’, ‘7’, ‘24’, ‘简装’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10020’, ‘10021’, ‘商品房’, ‘普通住宅’, ‘2011’, ‘70年’, ‘一室二厅一卫’, '107.70 ', ‘北’, ‘4’, ‘24’, ‘简装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10021’, ‘10022’, ‘商品房’, ‘普通住宅’, ‘2014’, ‘70年’, ‘一室一厅一卫’, '109.72 ', ‘北’, ‘8’, ‘24’, ‘简装’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10022’, ‘10023’, ‘商品房’, ‘普通住宅’, ‘2013’, ‘70年’, ‘二室一厅一卫’, '111.74 ', ‘北’, ‘9’, ‘24’, ‘简装’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10023’, ‘10024’, ‘商品房’, ‘普通住宅’, ‘2015’, ‘70年’, ‘一室一厅一卫’, '113.76 ', ‘北’, ‘21’, ‘24’, ‘简装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10025’, ‘10026’, ‘商品房’, ‘普通住宅’, ‘2014’, ‘70年’, ‘两室一厅’, ‘78’, ‘东南’, ‘5’, ‘24’, ‘简装’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10027’, ‘10028’, ‘商品房’, ‘普通住宅’, ‘2015’, ‘70年’, ‘三室两厅’, ‘98’, ‘西南’, ‘12’, ‘24’, ‘精装’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10028’, ‘10029’, ‘商品房’, ‘普通住宅’, ‘2011’, ‘70年’, ‘两室一厅’, ‘100’, ‘东’, ‘16’, ‘24’, ‘精装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10029’, ‘10030’, ‘商品房’, ‘普通住宅’, ‘2013’, ‘70年’, ‘三室两厅两卫’, ‘102’, ‘东南’, ‘10’, ‘24’, ‘简装’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10030’, ‘10031’, ‘商品房’, ‘普通住宅’, ‘2014’, ‘70年’, ‘三室两厅’, ‘104’, ‘南’, ‘6’, ‘24’, ‘简装’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10031’, ‘10032’, ‘商品房’, ‘普通住宅’, ‘2016’, ‘70年’, ‘两室一厅’, ‘106’, ‘西南’, ‘7’, ‘24’, ‘精装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10032’, ‘10033’, ‘商品房’, ‘普通住宅’, ‘2011’, ‘70年’, ‘三室两厅两卫’, ‘108’, ‘东’, ‘4’, ‘24’, ‘精装’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10033’, ‘10034’, ‘商品房’, ‘普通住宅’, ‘2014’, ‘70年’, ‘三室两厅’, ‘110’, ‘东南’, ‘8’, ‘24’, ‘简装’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10034’, ‘10035’, ‘商品房’, ‘普通住宅’, ‘2013’, ‘70年’, ‘两室一厅’, ‘112’, ‘南’, ‘9’, ‘24’, ‘简装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10035’, ‘10036’, ‘商品房’, ‘普通住宅’, ‘2015’, ‘70年’, ‘三室两厅两卫’, ‘114’, ‘西南’, ‘21’, ‘24’, ‘精装’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10040’, ‘10041’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘1’, ‘1562498010578’, ‘1562498010578’);
INSERT INTO tb_house_info VALUES (‘10041’, ‘10042’, ‘住宅房’, ‘公寓式住宅’, ‘2009’, ‘70’, ‘三厅二室八卫’, ‘180.5’, ‘偏西北’, ‘8’, ‘20’, ‘精装’, ‘1’, ‘1562547324992’, ‘1562547324992’);
INSERT INTO tb_house_info VALUES (‘10042’, ‘10043’, ‘宿舍’, ‘宿舍’, ‘2019’, ‘1’, ‘1是1听’, ‘20’, ‘天’, ‘5’, ‘5’, ‘破’, ‘1’, ‘1562551806149’, ‘1562551806149’);
INSERT INTO tb_house_info VALUES (‘10044’, ‘10045’, ‘商品房’, ‘住宅’, ‘2008’, ‘70年’, ‘一室一厅’, ‘50’, ‘达到’, ‘11’, ‘20’, ‘精装’, ‘1’, ‘1562572577168’, ‘1562572577168’);

2.新建项目
在这里插入图片描述
在这里插入图片描述
archetypeCatalog internal

在这里插入图片描述
3.建包结构
在这里插入图片描述

bean 下的实体类

House

package com.yiju.bean;

import java.math.BigDecimal;

/**

  • 房屋表
    */
    public class House {

    private int houseId; //房源表唯一标识ID
    private int userId; //发布此房源的用户ID
    private int houseType; //房源类型 0:新房 1:旧房 2:租房
    private String houseTitle; //房源帖子标题
    private String houseHeadimg; //房源帖子头像
    private String housePlanimg1; //房屋户型平面图1 外键
    private String housePlanimg2; //房屋户型平面图2 外键
    private String houseImg1; //房源室内图1
    private String houseImg2; //房源室内图2
    private String houseImg3; //房源室内图3
    private String houseImg4; //房源室内图4
    private String houseImg5; //房源室内图5
    private String houseImg6; //房源室内图6
    private BigDecimal housePrice; //房源预计售价
    private String priceUnit; //售价单位 元/每月 元/每套 元/每年
    private String houseAddress; //房源地址
    private int isDelete; //0:未删除 1:已删除
    private long createTime; //创建时间
    private long updateTime; //更新时间

    public int getHouseId() {
    return houseId;
    }

    public void setHouseId(int houseId) {
    this.houseId = houseId;
    }

    public int getUserId() {
    return userId;
    }

    public void setUserId(int userId) {
    this.userId = userId;
    }

    public int getHouseType() {
    return houseType;
    }

    public void setHouseType(int houseType) {
    this.houseType = houseType;
    }

    public String getHouseTitle() {
    return houseTitle;
    }

    public void setHouseTitle(String houseTitle) {
    this.houseTitle = houseTitle;
    }

    public String getHouseHeadimg() {
    return houseHeadimg;
    }

    public void setHouseHeadimg(String houseHeadimg) {
    this.houseHeadimg = houseHeadimg;
    }

    public String getHousePlanimg1() {
    return housePlanimg1;
    }

    public void setHousePlanimg1(String housePlanimg1) {
    this.housePlanimg1 = housePlanimg1;
    }

    public String getHousePlanimg2() {
    return housePlanimg2;
    }

    public void setHousePlanimg2(String housePlanimg2) {
    this.housePlanimg2 = housePlanimg2;
    }

    public String getHouseImg1() {
    return houseImg1;
    }

    public void setHouseImg1(String houseImg1) {
    this.houseImg1 = houseImg1;
    }

    public String getHouseImg2() {
    return houseImg2;
    }

    public void setHouseImg2(String houseImg2) {
    this.houseImg2 = houseImg2;
    }

    public String getHouseImg3() {
    return houseImg3;
    }

    public void setHouseImg3(String houseImg3) {
    this.houseImg3 = houseImg3;
    }

    public String getHouseImg4() {
    return houseImg4;
    }

    public void setHouseImg4(String houseImg4) {
    this.houseImg4 = houseImg4;
    }

    public String getHouseImg5() {
    return houseImg5;
    }

    public void setHouseImg5(String houseImg5) {
    this.houseImg5 = houseImg5;
    }

    public String getHouseImg6() {
    return houseImg6;
    }

    public void setHouseImg6(String houseImg6) {
    this.houseImg6 = houseImg6;
    }

    public BigDecimal getHousePrice() {
    return housePrice;
    }

    public void setHousePrice(BigDecimal housePrice) {
    this.housePrice = housePrice;
    }

    public String getPriceUnit() {
    return priceUnit;
    }

    public void setPriceUnit(String priceUnit) {
    this.priceUnit = priceUnit;
    }

    public String getHouseAddress() {
    return houseAddress;
    }

    public void setHouseAddress(String houseAddress) {
    this.houseAddress = houseAddress;
    }

    public int getIsDelete() {
    return isDelete;
    }

    public void setIsDelete(int isDelete) {
    this.isDelete = isDelete;
    }

    public long getCreateTime() {
    return createTime;
    }

    public void setCreateTime(long createTime) {
    this.createTime = createTime;
    }

    public long getUpdateTime() {
    return updateTime;
    }

    public void setUpdateTime(long updateTime) {
    this.updateTime = updateTime;
    }

    @Override
    public String toString() {
    return “House{” +
    “houseId=” + houseId +
    “, userId=” + userId +
    “, houseType=” + houseType +
    “, houseTitle=’” + houseTitle + ‘’’ +
    “, houseHeadimg=’” + houseHeadimg + ‘’’ +
    “, housePlanimg1=’” + housePlanimg1 + ‘’’ +
    “, housePlanimg2=’” + housePlanimg2 + ‘’’ +
    “, houseImg1=’” + houseImg1 + ‘’’ +
    “, houseImg2=’” + houseImg2 + ‘’’ +
    “, houseImg3=’” + houseImg3 + ‘’’ +
    “, houseImg4=’” + houseImg4 + ‘’’ +
    “, houseImg5=’” + houseImg5 + ‘’’ +
    “, houseImg6=’” + houseImg6 + ‘’’ +
    “, housePrice=” + housePrice +
    “, priceUnit=’” + priceUnit + ‘’’ +
    “, houseAddress=’” + houseAddress + ‘’’ +
    “, isDelete=” + isDelete +
    “, createTime=” + createTime +
    “, updateTime=” + updateTime +
    ‘}’;
    }
    }

HouseInfo

package com.yiju.bean;

/**

  • 房屋信息表
    */
    public class HouseInfo {

    private int infoId; //房源详细信息表唯一标识ID
    private int houseId; //对应房源表唯一ID
    private String houseNature; //房源性质:商品房 住宅房
    private String houseModel; //普通式住宅 公寓式住宅 别墅 独栋
    private int houseYear; //房源建造时间
    private String houseValid; //房源期限: 70年、100年、永久
    private String houseLayout; //房源户型：几室几厅几卫
    private String houseArea; //房源面积
    private String houseTurn; //朝向
    private int houseFloor; //楼层
    private int floorAll; //总楼层
    private String houseDecorate; //装饰类型：精装 简装
    private String houseLift; //是否有电梯: 0无 1有
    private long createTime; //创建时间
    private long updateTime; //更新时间

    public int getInfoId() {
    return infoId;
    }

    public void setInfoId(int infoId) {
    this.infoId = infoId;
    }

    public int getHouseId() {
    return houseId;
    }

    public void setHouseId(int houseId) {
    this.houseId = houseId;
    }

    public String getHouseNature() {
    return houseNature;
    }

    public void setHouseNature(String houseNature) {
    this.houseNature = houseNature;
    }

    public String getHouseModel() {
    return houseModel;
    }

    public void setHouseModel(String houseModel) {
    this.houseModel = houseModel;
    }

    public int getHouseYear() {
    return houseYear;
    }

    public void setHouseYear(int houseYear) {
    this.houseYear = houseYear;
    }

    public String getHouseValid() {
    return houseValid;
    }

    public void setHouseValid(String houseValid) {
    this.houseValid = houseValid;
    }

    public String getHouseLayout() {
    return houseLayout;
    }

    public void setHouseLayout(String houseLayout) {
    this.houseLayout = houseLayout;
    }

    public String getHouseArea() {
    return houseArea;
    }

    public void setHouseArea(String houseArea) {
    this.houseArea = houseArea;
    }

    public String getHouseTurn() {
    return houseTurn;
    }

    public void setHouseTurn(String houseTurn) {
    this.houseTurn = houseTurn;
    }

    public int getHouseFloor() {
    return houseFloor;
    }

    public void setHouseFloor(int houseFloor) {
    this.houseFloor = houseFloor;
    }

    public int getFloorAll() {
    return floorAll;
    }

    public void setFloorAll(int floorAll) {
    this.floorAll = floorAll;
    }

    public String getHouseDecorate() {
    return houseDecorate;
    }

    public void setHouseDecorate(String houseDecorate) {
    this.houseDecorate = houseDecorate;
    }

    public String getHouseLift() {
    return houseLift;
    }

    public void setHouseLift(String houseLift) {
    this.houseLift = houseLift;
    }

    public long getCreateTime() {
    return createTime;
    }

    public void setCreateTime(long createTime) {
    this.createTime = createTime;
    }

    public long getUpdateTime() {
    return updateTime;
    }

    public void setUpdateTime(long updateTime) {
    this.updateTime = updateTime;
    }

    @Override
    public String toString() {
    return “HouseInfo{” +
    “infoId=” + infoId +
    “, houseId=” + houseId +
    “, houseNature=’” + houseNature + ‘’’ +
    “, houseModel=’” + houseModel + ‘’’ +
    “, houseYear=” + houseYear +
    “, houseValid=’” + houseValid + ‘’’ +
    “, houseLayout=’” + houseLayout + ‘’’ +
    “, houseArea=’” + houseArea + ‘’’ +
    “, houseTurn=’” + houseTurn + ‘’’ +
    “, houseFloor=” + houseFloor +
    “, floorAll=” + floorAll +
    “, houseDecorate=’” + houseDecorate + ‘’’ +
    “, houseLift=’” + houseLift + ‘’’ +
    “, createTime=” + createTime +
    “, updateTime=” + updateTime +
    ‘}’;
    }
    }

HouseViewController

package com.yiju.controller;

import com.yiju.pojo.HouseView;
import com.yiju.service.IHouseViewService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import java.util.List;

@Controller
@RequestMapping(“house”)
public class HouseViewController {

@Autowired
private IHouseViewService houseViewService;

@RequestMapping("findFourHouse.do")
public ModelAndView findFourHouse(){
    ModelAndView mv=new ModelAndView();
    List<HouseView> newHouses = houseViewService.findFourHouseByType(0);
    List<HouseView> oldHouses = houseViewService.findFourHouseByType(1);
    List<HouseView> rentHouses = houseViewService.findFourHouseByType(2);
    mv.addObject("newHouses",newHouses);
    mv.addObject("oldHouses",oldHouses);
    mv.addObject("rentHouses",rentHouses);
    mv.setViewName("../main");
    return mv;

}

}

IHouseViewDao

package com.yiju.dao;

import com.yiju.pojo.HouseView;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface IHouseViewDao {
List findFourHouseByType(@Param(“houseType”) int houseType);
}

pojo

HouseView

package com.yiju.pojo;

import java.math.BigDecimal;

public class HouseView {

private int houseId; //房源ID
private String trueName; //发布人
private String houseTitle; //房源标题
private String houseHeadimg; //房源帖子头像
private BigDecimal housePrice; //房屋价格
private String priceUnit; //售价单位:元/每月 元/套 元/年
private int houseFloor; //楼层
private int floorAll; //全部楼层
private String houseAddress; //房源地址
private String houseLayout; //几室几厅几卫
private String houseDecorate; //精装,简装
private String houseArea; //房间面积
private long createTime; //创建时间
private String houseTurn; //房屋朝向
private String houseNature; //房屋性质
private String houseModel; //房屋类型
private String houseYear; //建造年份
private String houseValid; //有效期
private int houseLift; //是否有电梯
private String housePlanimg1;
private String housePlanimg2;
private String houseImg1; //房源室内图1
private String houseImg2; //房源室内图2
private String houseImg3; //房源室内图3
private String houseImg4; //房源室内图4
private String houseImg5; //房源室内图5
private String houseImg6; //房源室内图6
private String date; //获取年月日
private int bed; //床：0无 1有
private int washing; //洗衣机：0无 1有
private int air; //空调: 0无 1有
private int balcony; //阳台：0无 1有
private int ice; //冰箱：0无 1有
private int toilet; //卫生间：0无 1有
private int kitchen; //厨房：0无 1有
private int tv; //电视：0无 1有
private int heater; //热水器：0无 1有
private int wardrobe; //衣柜：0无 1有
private int heating; //暖气：0无 1有
private int internet; //宽带：0无 1有
private int sofa; //沙发：0无 1有
private int houseType;

public int getHouseType() {
    return houseType;
}

public void setHouseType(int houseType) {
    this.houseType = houseType;
}

public int getHouseId() {
    return houseId;
}

public void setHouseId(int houseId) {
    this.houseId = houseId;
}

public String getTrueName() {
    return trueName;
}

public void setTrueName(String trueName) {
    this.trueName = trueName;
}

public String getHouseTitle() {
    return houseTitle;
}

public void setHouseTitle(String houseTitle) {
    this.houseTitle = houseTitle;
}

public String getHouseHeadimg() {
    return houseHeadimg;
}

public void setHouseHeadimg(String houseHeadimg) {
    this.houseHeadimg = houseHeadimg;
}

public BigDecimal getHousePrice() {
    return housePrice;
}

public void setHousePrice(BigDecimal housePrice) {
    this.housePrice = housePrice;
}

public String getPriceUnit() {
    return priceUnit;
}

public void setPriceUnit(String priceUnit) {
    this.priceUnit = priceUnit;
}

public int getHouseFloor() {
    return houseFloor;
}

public void setHouseFloor(int houseFloor) {
    this.houseFloor = houseFloor;
}

public int getFloorAll() {
    return floorAll;
}

public void setFloorAll(int floorAll) {
    this.floorAll = floorAll;
}

public String getHouseAddress() {
    return houseAddress;
}

public void setHouseAddress(String houseAddress) {
    this.houseAddress = houseAddress;
}

public String getHouseLayout() {
    return houseLayout;
}

public void setHouseLayout(String houseLayout) {
    this.houseLayout = houseLayout;
}

public String getHouseDecorate() {
    return houseDecorate;
}

public void setHouseDecorate(String houseDecorate) {
    this.houseDecorate = houseDecorate;
}

public String getHouseArea() {
    return houseArea;
}

public void setHouseArea(String houseArea) {
    this.houseArea = houseArea;
}

public long getCreateTime() {
    return createTime;
}

public void setCreateTime(long createTime) {
    this.createTime = createTime;
}

public String getHouseTurn() {
    return houseTurn;
}

public void setHouseTurn(String houseTurn) {
    this.houseTurn = houseTurn;
}

public String getHouseNature() {
    return houseNature;
}

public void setHouseNature(String houseNature) {
    this.houseNature = houseNature;
}

public String getHouseModel() {
    return houseModel;
}

public void setHouseModel(String houseModel) {
    this.houseModel = houseModel;
}

public String getHouseYear() {
    return houseYear;
}

public void setHouseYear(String houseYear) {
    this.houseYear = houseYear;
}

public String getHouseValid() {
    return houseValid;
}

public void setHouseValid(String houseValid) {
    this.houseValid = houseValid;
}

public int getHouseLift() {
    return houseLift;
}

public void setHouseLift(int houseLift) {
    this.houseLift = houseLift;
}

public String getHousePlanimg1() {
    return housePlanimg1;
}

public void setHousePlanimg1(String housePlanimg1) {
    this.housePlanimg1 = housePlanimg1;
}

public String getHousePlanimg2() {
    return housePlanimg2;
}

public void setHousePlanimg2(String housePlanimg2) {
    this.housePlanimg2 = housePlanimg2;
}

public String getHouseImg1() {
    return houseImg1;
}

public void setHouseImg1(String houseImg1) {
    this.houseImg1 = houseImg1;
}

public String getHouseImg2() {
    return houseImg2;
}

public void setHouseImg2(String houseImg2) {
    this.houseImg2 = houseImg2;
}

public String getHouseImg3() {
    return houseImg3;
}

public void setHouseImg3(String houseImg3) {
    this.houseImg3 = houseImg3;
}

public String getHouseImg4() {
    return houseImg4;
}

public void setHouseImg4(String houseImg4) {
    this.houseImg4 = houseImg4;
}

public String getHouseImg5() {
    return houseImg5;
}

public void setHouseImg5(String houseImg5) {
    this.houseImg5 = houseImg5;
}

public String getHouseImg6() {
    return houseImg6;
}

public void setHouseImg6(String houseImg6) {
    this.houseImg6 = houseImg6;
}

public String getDate() {
    return date;
}

public void setDate(String date) {
    this.date = date;
}

public int getBed() {
    return bed;
}

public void setBed(int bed) {
    this.bed = bed;
}

public int getWashing() {
    return washing;
}

public void setWashing(int washing) {
    this.washing = washing;
}

public int getAir() {
    return air;
}

public void setAir(int air) {
    this.air = air;
}

public int getBalcony() {
    return balcony;
}

public void setBalcony(int balcony) {
    this.balcony = balcony;
}

public int getIce() {
    return ice;
}

public void setIce(int ice) {
    this.ice = ice;
}

public int getToilet() {
    return toilet;
}

public void setToilet(int toilet) {
    this.toilet = toilet;
}

public int getKitchen() {
    return kitchen;
}

public void setKitchen(int kitchen) {
    this.kitchen = kitchen;
}

public int getTv() {
    return tv;
}

public void setTv(int tv) {
    this.tv = tv;
}

public int getHeater() {
    return heater;
}

public void setHeater(int heater) {
    this.heater = heater;
}

public int getWardrobe() {
    return wardrobe;
}

public void setWardrobe(int wardrobe) {
    this.wardrobe = wardrobe;
}

public int getHeating() {
    return heating;
}

public void setHeating(int heating) {
    this.heating = heating;
}

public int getInternet() {
    return internet;
}

public void setInternet(int internet) {
    this.internet = internet;
}

public int getSofa() {
    return sofa;
}

public void setSofa(int sofa) {
    this.sofa = sofa;
}

@Override
public String toString() {
    return "HouseView{" +
            "houseId=" + houseId +
            ", trueName='" + trueName + '\'' +
            ", houseTitle='" + houseTitle + '\'' +
            ", houseHeadimg='" + houseHeadimg + '\'' +
            ", housePrice=" + housePrice +
            ", priceUnit='" + priceUnit + '\'' +
            ", houseFloor=" + houseFloor +
            ", floorAll=" + floorAll +
            ", houseAddress='" + houseAddress + '\'' +
            ", houseLayout='" + houseLayout + '\'' +
            ", houseDecorate='" + houseDecorate + '\'' +
            ", houseArea='" + houseArea + '\'' +
            ", createTime=" + createTime +
            ", houseTurn='" + houseTurn + '\'' +
            ", houseNature='" + houseNature + '\'' +
            ", houseModel='" + houseModel + '\'' +
            ", houseYear='" + houseYear + '\'' +
            ", houseValid='" + houseValid + '\'' +
            ", houseLift=" + houseLift +
            ", housePlanimg1='" + housePlanimg1 + '\'' +
            ", housePlanimg2='" + housePlanimg2 + '\'' +
            ", houseImg1='" + houseImg1 + '\'' +
            ", houseImg2='" + houseImg2 + '\'' +
            ", houseImg3='" + houseImg3 + '\'' +
            ", houseImg4='" + houseImg4 + '\'' +
            ", houseImg5='" + houseImg5 + '\'' +
            ", houseImg6='" + houseImg6 + '\'' +
            ", date='" + date + '\'' +
            ", bed=" + bed +
            ", washing=" + washing +
            ", air=" + air +
            ", balcony=" + balcony +
            ", ice=" + ice +
            ", toilet=" + toilet +
            ", kitchen=" + kitchen +
            ", tv=" + tv +
            ", heater=" + heater +
            ", wardrobe=" + wardrobe +
            ", heating=" + heating +
            ", internet=" + internet +
            ", sofa=" + sofa +
            ", houseType=" + houseType +
            '}';
}

}

HouseViewService

package com.yiju.service.iml;

import com.yiju.dao.IHouseViewDao;
import com.yiju.pojo.HouseView;
import com.yiju.service.IHouseViewService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class HouseViewService implements IHouseViewService {

@Autowired
private IHouseViewDao  houseViewDao;
@Override
public List<HouseView> findFourHouseByType(int houseType) {
    return houseViewDao.findFourHouseByType(houseType);
}

}

IHouseViewService

package com.yiju.service;

import com.yiju.pojo.HouseView;

import java.util.List;

public interface IHouseViewService {
List findFourHouseByType(int houseType);
}

4.配置文件
在这里插入图片描述
在这里插入图片描述

<?xml version="1.0" encoding="UTF-8" ?> select * from tb_house a,tb_house_info b where a.house_id=b.house_id and a.is_delete=0 and a.house_type=#{houseType} order by rand()limit 4

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?> 

<!-- 1.配置数据库相关参数properties的属性：${url} -->
<context:property-placeholder location="classpath:db.properties"/>

<!-- 2.配置数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="driverClass" value="${jdbc.driver}"/>
    <property name="jdbcUrl" value="${jdbc.url}"/>
    <property name="user" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
    <property name="maxPoolSize" value="30"/>
    <property name="minPoolSize" value="2"/>
</bean>

<!-- 3.配置SqlSessionFactory对象 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <!-- 注入数据库连接池 -->
    <property name="dataSource" ref="dataSource"/>
    <!-- 扫描bean包 使用别名 -->
    <property name="typeAliasesPackage" value="com.yiju.bean"></property>

    <!--配置加载映射文件 UserMapper.xml-->
    <property name="mapperLocations" value="classpath:mapper/*.xml"/>

    <!--加载分页插件-->
    <property name="plugins">
                       <array>
            <bean class="com.github.pagehelper.PageInterceptor">
                <property name="properties">
                    <props>
                        <prop key="helperDialect">mysql</prop>
                        <prop key="reasonable">true</prop>
                    </props>
                </property>
            </bean>
        </array>
    </property>

    <property name="configuration">
        <bean class="org.apache.ibatis.session.Configuration">
            <!--可以加入驼峰命名法其他mybatis的配置也就是mybatis.cfg.xml的相关配置都会转移到这里-->
            <property name="mapUnderscoreToCamelCase" value="true"/>
        </bean>
    </property>
</bean>

<!-- 自动生成dao,mapper-->
<!-- 4.配置扫描Dao接口包，动态实现Dao接口，注入到spring容器中 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <!-- 给出需要扫描Dao接口包 -->
    <property name="basePackage" value="com.yiju.dao"/>
    <!-- 注入sqlSessionFactory -->
    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>

<!--自动扫描-->
<context:component-scan base-package="com.yiju"/>


<!-- 配置事务-->
<!-- 5.配置事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"/>
</bean>
<!-- 6.开启事务注解-->
<tx:annotation-driven></tx:annotation-driven>

db.properties

#以下内容根据自己来配置
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/yiju?useSSL=true&characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456

log4j.properties

Global logging configuration

log4j.rootLogger=DEBUG, stdout

Console output…

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

spring-mvc.xml

<?xml version="1.0" encoding="UTF-8"?> 

<!-- 1.注解扫描位置-->
<context:component-scan base-package="com.yiju.controller" />

<!-- 2.配置映射处理和适配器-->
<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping"/>
<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter"/>

<!-- 3.视图的解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    <property name="prefix" value="/pages/" />
    <property name="suffix" value=".jsp" />
</bean>

<!-- 4.配置文件上传配置 -->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
    <!-- 配置文件上传编码 -->
    <property name="defaultEncoding" value="utf-8"/>
    <!-- 配置文件上传大小 -->
    <property name="maxUploadSize" value="10485760"/>
</bean>

web.xml

<?xml version="1.0" encoding="UTF-8"?>

contextConfigLocation classpath*:applicationContext.xml org.springframework.web.context.ContextLoaderListener org.springframework.web.context.request.RequestContextListener characterEncodingFilter org.springframework.web.filter.CharacterEncodingFilter encoding UTF-8 characterEncodingFilter /* dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:spring-mvc.xml 1 dispatcherServlet *.do

index.jsp

<%–
Created by IntelliJ IDEA.
User: 19668
Date: 2019/10/17
Time: 14:35
To change this template use File | Settings | File Templates.
–%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

Title

main.jsp

<%@ taglib prefix=“c” uri=“http://java.sun.com/jsp/jstl/core” %>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

易居住房信息平台 
<!--    下面是几个导入的包-->
<link type="text/css" href="css/css.css" rel="stylesheet"/>
<link type="text/css" href="css/searchInputStyle.css" rel="stylesheet"/>
<link type="text/css" href="css/searchReset.css" rel="stylesheet"/>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/jquery2.min.js"></script>
<script type="text/javascript" src="js/js.js"></script>
<!--    上面是几个导入的包-->

<%--轮播图的CSS--%>
<style>
    * {
        margin: 0;
        padding: 0;
    }

    li {
        list-style: none;
    }

    #adv {
        /*margin:110px auto;*/
        width: 1190px;
        position: relative;
    }

    #adv li {
        display: none;
    }

    #adv .show {
        display: block;
    }

    #next, #prev {
        position: absolute;
        top: 45%;
        cursor: pointer;
        transition: all .5s;
        opacity: .7;
    }

    #next:hover, #prev:hover {
        transform: scale(1.1);
        opacity: 1;
    }

    #prev {
        left: 10px;
        height: 15%;
    }

    #next {
        right: 10px;
        height: 15%;
    }
</style>

        </tr>
    </table>
</div><!--width1190/-->
房屋
<%--FIXME 这里是搜索栏，需要实现相应的模糊搜索功能 --%>
000-00000000

<%--广告轮播栏End --%>

<%–展示主页推荐栏–%>

<%--【新房推荐】--%> <%--FIXME 这里添加跳转事件--%>

❤新房推荐更多>>

<%--FIXME 这里使用Foreach循环，从数据库读取房屋信息 --%>

${nb.houseTitle}

${nh.houseLayout} | ${nh.houseArea} | ${nh.houseDecorate} 
        <div class="clears"></div>
    </div><!--index-fang-list/-->
    <%----%>

    <%--旧房推荐--%>
    <h2 class="title"><a style="color:#F1323B">❤</a>二手房推荐 <a
            href="#">更多&gt;&gt;</a></h2>
    <div class="index-fang-list">

        <c:forEach items="${oldHouses}" var="oh">
            <dl>
                <dt><a href="#"><img src="http://image.cxhit.com/${oh.houseHeadimg}" width="286"
                                     height="188"/></a></dt>
                <dd>
                    <h3><a href="#">${ob.houseTitle}</a></h3>
                    <div class="hui">${oh.houseLayout} | ${oh.houseArea} | ${oh.houseDecorate}</div>
                </dd>
            </dl>
        </c:forEach>


        <div class="clears"></div>
    </div><!--index-fang-list/-->

    <%--【二手房推荐】--%>
    <h2 class="title"><a style="color:#F1323B">❤</a>租房推荐 <a
            href="#">更多&gt;&gt;</a></h2>
    <div class="index-ershou">

        <%--左侧栏--%>
        <div class="in-er-left">
            <a href="#"><img src="images/fangt1.jpg" width="380" height="285"/></a>
            <div class="in-er-left-text"><strong class="fl">闵行南方发的撒的发的司法</strong><strong
                    class="fr alignRight">¥2841</strong></div>
        </div><!--in-er-left/-->

        <%--右侧栏--%>
        <div class="in-er-right">

            <c:forEach items="${rentHouses}" var="rh">
                <dl>
                    <dt><a href="#"><img
                            src="http://image.cxhit.com/${rh.houseHeadimg}"
                            style="width: 150px; height: 115px;" width="150" height="115"/></a></dt>
                    <dd>
                        <h3>
                            <a href="#">${rh.houseTitle}</a>
                        </h3>
                        <br>
                        <div class="in-er-right-text">
                            ${rh.houseAddress}
                        </div>
                        <div class="price">¥<strong>${rh.housePrice}${rh.priceUnit}</strong></div>
                    </dd>
                    <div class="clears"></div>
                </dl>
            </c:forEach>
            <div class="clears"></div>

        </div><!--in-er-right/-->
        <div class="clears"></div>
    </div><!--index-ershou/-->
    <%--【二手房推荐END】--%>

</div><!--width1190/-->

<jsp:include page=“pages/basefoot.jsp”></jsp:include>

pom.xml

<?xml version="1.0" encoding="UTF-8"?>


4.0.0

com.yiju
yiju
1.0-SNAPSHOT
war

yiju Maven Webapp

http://www.example.com

org.springframework spring-core ${spring.version} 
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-web</artifactId>
  <version>${spring.version}</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-oxm</artifactId>
  <version>${spring.version}</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-tx</artifactId>
  <version>${spring.version}</version>
</dependency>

<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-jdbc</artifactId>
  <version>${spring.version}</version>
</dependency>

<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-webmvc</artifactId>
  <version>${spring.version}</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-aop</artifactId>
  <version>${spring.version}</version>
</dependency>

<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context-support</artifactId>
  <version>${spring.version}</version>
</dependency>

<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-test</artifactId>
  <version>${spring.version}</version>
</dependency>
<!-- mybatis核心包 -->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>${mybatis.version}</version>
</dependency>
<!-- mybatis/spring包 -->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis-spring</artifactId>
  <version>1.2.2</version>
</dependency>
<!-- 导入java ee jar 包 -->
<dependency>
  <groupId>javax</groupId>
  <artifactId>javaee-api</artifactId>
  <version>7.0</version>
</dependency>

<!-- 导入Mysql数据库链接jar包 -->
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>5.1.30</version>
</dependency>
<!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
<dependency>
  <groupId>commons-dbcp</groupId>
  <artifactId>commons-dbcp</artifactId>
  <version>1.2.2</version>
</dependency>
<!-- JSTL标签类 -->
<dependency>
  <groupId>jstl</groupId>
  <artifactId>jstl</artifactId>
  <version>1.2</version>
</dependency>
<!-- 日志文件管理包 -->
<!-- log start -->
<dependency>
  <groupId>log4j</groupId>
  <artifactId>log4j</artifactId>
  <version>${log4j.version}</version>
</dependency>

<!-- 数据连接池 -->
<dependency>
  <groupId>com.mchange</groupId>
  <artifactId>c3p0</artifactId>
  <version>${c3p0.version}</version>
</dependency>

<dependency>
  <groupId>taglibs</groupId>
  <artifactId>standard</artifactId>
  <version>${taglibs.version}</version>
</dependency>

<dependency>
  <groupId>org.slf4j</groupId>
  <artifactId>slf4j-api</artifactId>
  <version>${slf4j.version}</version>
</dependency>
<dependency>
  <groupId>org.slf4j</groupId>
  <artifactId>slf4j-log4j12</artifactId>
  <version>${slf4j.version}</version>
</dependency>

<!-- 导入servlet-api/jsp -->
<dependency>
  <groupId>javax.servlet</groupId>
  <artifactId>javax.servlet-api</artifactId>
  <version>3.1.0</version>
  <scope>provided</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/javax.servlet.jsp/javax.servlet.jsp-api -->
<dependency>
  <groupId>javax.servlet.jsp</groupId>
  <artifactId>javax.servlet.jsp-api</artifactId>
  <version>2.3.1</version>
  <scope>provided</scope>
</dependency>

<!--PageHelper-->
<dependency>
  <groupId>com.github.pagehelper</groupId>
  <artifactId>pagehelper</artifactId>
  <version>5.1.2</version>
</dependency>

<!-- 上传文件 -->
<!-- https://mvnrepository.com/artifact/commons-fileupload/commons-fileupload -->
<dependency>
  <groupId>commons-fileupload</groupId>
  <artifactId>commons-fileupload</artifactId>
  <version>1.3.1</version>
</dependency>

<!-- https://mvnrepository.com/artifact/commons-io/commons-io -->
<dependency>
  <groupId>commons-io</groupId>
  <artifactId>commons-io</artifactId>
  <version>2.2</version>
</dependency>

<!--七牛云-->
<dependency>
  <groupId>com.qiniu</groupId>
  <artifactId>qiniu-java-sdk</artifactId>
  <version>7.1.1</version>
</dependency>

<dependency>
  <groupId>com.mchange</groupId>
  <artifactId>c3p0</artifactId>
  <version>0.9.5.2</version>
  <scope>compile</scope>
</dependency>
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis-spring</artifactId>
  <version>1.3.1</version>
  <scope>compile</scope>
</dependency>
<dependency>
  <groupId>com.github.pagehelper</groupId>
  <artifactId>pagehelper</artifactId>
  <version>RELEASE</version>
  <scope>compile</scope>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-jdbc</artifactId>
  <version>5.0.2.RELEASE</version>
  <scope>compile</scope>
</dependency>

<!--PageHelper-->
<dependency>
  <groupId>com.github.pagehelper</groupId>
  <artifactId>pagehelper</artifactId>
  <version>5.1.2</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-web</artifactId>
  <version>5.0.2.RELEASE</version>
  <scope>compile</scope>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-webmvc</artifactId>
  <version>5.0.2.RELEASE</version>
  <scope>compile</scope>
</dependency>

<!--阿里云短信验证码SDK-->
<dependency>
  <groupId>com.aliyun</groupId>
  <artifactId>aliyun-java-sdk-core</artifactId>
  <version>4.1.0</version>
</dependency>

<dependency>
  <groupId>com.aliyun</groupId>
  <artifactId>aliyun-java-sdk-dysmsapi</artifactId>
  <version>1.1.0</version>
</dependency>
<dependency>
  <groupId>org.mortbay.jetty</groupId>
  <artifactId>jetty-util</artifactId>
  <version>6.1.25</version>
</dependency>
<!--阿里云-->


<!-- JSONObject对象依赖的jar包 -->
<dependency>
  <groupId>commons-beanutils</groupId>
  <artifactId>commons-beanutils</artifactId>
  <version>1.9.3</version>
</dependency>
<dependency>
  <groupId>commons-collections</groupId>
  <artifactId>commons-collections</artifactId>
  <version>3.2.1</version>
</dependency>
<dependency>
  <groupId>commons-lang</groupId>
  <artifactId>commons-lang</artifactId>
  <version>2.6</version>
</dependency>
<dependency>
  <groupId>commons-logging</groupId>
  <artifactId>commons-logging</artifactId>
  <version>1.1.1</version>
</dependency>
<dependency>
  <groupId>net.sf.ezmorph</groupId>
  <artifactId>ezmorph</artifactId>
  <version>1.0.6</version>
</dependency>
<dependency>
  <groupId>net.sf.json-lib</groupId>
  <artifactId>json-lib</artifactId>
  <version>2.2.3</version>
  <classifier>jdk15</classifier><!-- 指定jdk版本 -->
</dependency>

<!-- Json依赖架包下载 -->
yiju maven-clean-plugin 3.1.0 maven-resources-plugin 3.0.2 maven-compiler-plugin 3.8.0 maven-surefire-plugin 2.22.1 maven-war-plugin 3.2.2 maven-install-plugin 2.5.2 maven-deploy-plugin 2.8.2
milulama
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值