day10.18yiju

在这里插入图片描述在这里插入图片描述
在这里插入图片描述

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 +
            '}';
}

}

bean.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 +
    ‘}’;
    }
    }

controller.HouseViewController下面的代码

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

@Autowired
private IHouseViewService houseViewService;
private IHouseViewService houses,fh;

@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("newHouse", newHouses);
    mv.addObject("oldwHouse", oldHouses);
    mv.addObject("rentHouse", rentHouses);
    mv.setViewName("../main");
    return mv;
}

@RequestMapping("findHouseById.do")
public ModelAndView findHouseById(int houseId) {
    HouseView house = (HouseView) houseViewService.findHouseByHouseId(houseId);
    ModelAndView mv = new ModelAndView();
    mv.addObject("houseInfo", house);
    mv.setViewName("details");
    return mv;
}

dao.IHouseViewDao

package com.yiju.dao;

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

import java.util.List;

public interface IHouseViewDao {

List<HouseView> findFourHouseByType(@Param("houseType") int houseType);
HouseView findHouseByHouseId(int houseId);

// List findHouseByType(@Param(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 +
            '}';
}

}

service.iml.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);
}

@Override
public HouseView findHouseByHouseId(int houseId) {
    return houseViewDao.findHouseByHouseId(houseId);
}

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

}

service.IHouseViewService下的代码

package com.yiju.service;

import com.yiju.dao.IHouseViewDao;
import com.yiju.pojo.HouseView;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;

import java.util.List;

public interface IHouseViewService {

List<HouseView> findFourHouseByType( int houseType);
HouseView findHouseByHouseId(int houstId);
List<HouseView> findHouseByType( int houseType);

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值