订单详情

在order-list.jsp页面上对"详情"添加链接

<button type="button" class="btn bg-olive btn-xs"
onclick="location.href='${pageContext.request.contextPath}/orders/findById.do?id=${orders.id}'">
详情</button>

订单详情 order-show.jsp

Controller 

@RequestMapping("/findById.do")
public ModelAndView findById(String id) throws Exception {Orders orders = ordersService.findById(id);ModelAndView mv = new ModelAndView();mv.setViewName("order-show");mv.addObject("orders", orders);return mv;
}

Dao

IOrdersDao的findById方法

@Select("select * from orders where id=#{id}")
@Results({@Result(id=true,column = "id",property = "id"),@Result(column = "orderNum",property = "orderNum"),@Result(column = "orderTime",property = "orderTime"),@Result(column = "orderStatus",property = "orderStatus"),@Result(column = "peopleCount",property = "peopleCount"),@Result(column = "payType",property = "payType"),@Result(column = "orderDesc",property = "orderDesc"),@Result(column = "productId",property = "product",one = @One(select ="com.learn.ssm.dao.IProductDao.findById")),@Result(column = "id",property = "travellers",many = @Many(select ="com.learn.ssm.dao.ITravellerDao.findByOrdersId")),@Result(column = "memberId",property = "member",one = @One(select ="com.learn.ssm.dao.IMemberDao.findById")),
})
Orders findById(String id) throws Exception;

IMemberDao的findById方法

@Select("select * from member where id=#{id}")
Member findById(String id) throws Exception;

ITravellerDao.findByOrdersId方法

@Select("select * from traveller where id in (select travellerId from order_traveller where
orderId=#{ordersId})")
List<Traveller> findByOrdersId(String ordersId) throws Exception;