使用resultMap实现ibatis复合数据结构查询(1.多重属性查询;2.属

public class OrderDetail {

 @XmlElement(required = true)
 protected String orderSn;
 @XmlElement(required = true)
 protected String orderAmount;
 @XmlElement(required = true)
 protected String orderStatus;
 @XmlElement(required = true)
 protected String orderAddTime;
 @XmlElement(required = true)
 protected Logistics logistics;
 @XmlElement(required = true)
 protected OrderGoods orderGoods;
 @XmlElement(required = true)
 protected List listData;

 ... getter setter...

}

	
	
	
	
	
	
	
	 -->
	
	
	
	
	
	
	
	
	

 
 	 	select 
 order_sn as orderSn,
 order_amount as orderAmount,
 order_status as orderStatus,
 add_time as orderAddTime,
 consignee,
 country,
 
 b.region_name province,
 c.region_name city,
 d.region_name district,
 address,
 mobile,
 shipping_name as shippingName
 
	from ecs_order_info o	
	 left join ecs_region b on o.province=b.region_id
	 	 left join ecs_region c on o.city=c.region_id
	 	 left join ecs_region d on o.district=d.region_id 	
	where order_sn=#orderSn#
 

 
  	 	
 	 	select goods_name as goodsName,
 goods_number as goodsNumber
 from ecs_order_goods where order_id=
 	 	(select order_id from ecs_order_info where order_sn=#orderSn#)