易居住房信息1018

一.

2.
显示房屋全部信息+显示5条

一.根据id
interface IHouseViewDao

1.HouseView findHouseByHouseId(int houseId);
2.List findHouseByType(int currentPage,int houseType);

二.查询数据

1.
select * from tb_house a,tb_house_info b where a.house_id=b.house_id and a.is_delete=0
and a.house_id=#{houseId}

 2. <select id="findHouseByType" parameterType="int" resultType="com.yiju.pojo.HouseView">
    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}
</select>

三.定义方法
interface IHouseViewService

1.HouseView findHouseByHouseId(int houseId);
2.List findHouseByType(int currentPage,int houseType);

四.实现方法
HouseViewService class

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

2. @Override
   public List findHouseByType(int currentPage,int houseType) {
   PageHelper.startPage(currentPage,5);
   return houseViewDao.findHouseByType(houseType);
   }

五.实现页面跳转

class HouseViewController

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

@RequestMapping(“findHouse.do”)
public ModelAndView findHouse(int currentPage,int houseType ){
ModelAndView mv=new ModelAndView();
List houses = houseViewService.findHouseByType(currentPage,houseType);
List fh = houseViewService.findFourHouseByType(houseType);
PageInfo pageInfo=new PageInfo<>(houses);
mv.addObject(“pageInfo”,pageInfo);

    mv.addObject("fh",fh);
    if(houseType==0){
        mv.setViewName("newhouse");
    }else if(houseType==1){
        mv.setViewName("oldhouse");
    }else{
        mv.setViewName("renthouse");
    }
    return mv;
}

六.main跳转绝对路径

1.$pageContext.request.contextPath/house/findHouseById.do?houseId=${nh.houseId}

2.
${pageContext.request.contextPath}/house/findHouse.do?houseType=0&currentPage=0