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

以订单为例,直接上代码: 1.多重属性查询 java实体 public class OrderDetail { @XmlElement(required = true) protected String orderSn; @XmlElement(required = true) protected String orderAmount; @XmlElement(required = true) protected String order

以订单为例,直接上代码:

1.多重属性查询

java实体

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...

}

class="orderDetail" 即为上面的类,有个属性logistics的类型是复合类型Logistics

	
	
	
	
	
	
	
	 -->
	
	
	
	
	
	
	
	
	

 
 	 	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#
 

2.属性中含有列表查询

orderDetail有个属性orderGoods的类型是List复合类型,应在resultMap的属性定义中给这个list做查询 :getOrderGoodsList

看下这个查询 getOrderGoodsList

 
  	 	
 	 	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#)