订单操作-订单详情查询代码实现

订单详情

在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;