day8

DAY8

宜居-2

DAO

public interface IHouse {
    List<HouseView> findFourHouseByType(int houseType);

    List<HouseView> searchThreeRandomHouse(int housetype);

    int selectCount(int housetype);

    List<HouseView> searchHouseByTypeAndPage(HashMap<String, Object> map);
}

Pojo

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 class PageInfo<T> {
    private int currentPage;
    private int pageSize;
    private List<T> lists;
    private int totalPage;
    private int totalCount;
}