一.
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
-
@Override
public HouseView findHouseByHouseId(int houseId) {
return houseViewDao.findHouseByHouseById(houseId);
} -
@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.
p
a
g
e
C
o
n
t
e
x
t
.
r
e
q
u
e
s
t
.
c
o
n
t
e
x
t
P
a
t
h
/
h
o
u
s
e
/
f
i
n
d
H
o
u
s
e
B
y
I
d
.
d
o
?
h
o
u
s
e
I
d
=
{pageContext.request.contextPath}/house/findHouseById.do?houseId=
pageContext.request.contextPath/house/findHouseById.do?houseId={nh.houseId}
2.
${pageContext.request.contextPath}/house/findHouse.do?houseType=0¤tPage=0