使用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

																							<!---ecms    -->																										

sql查询语句如下:

         	 	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

看下这个查

本文来源gao!%daima.com搞$代*!码$网9

询 getOrderGoodsList

 <!---ecms  通过订单号获取订单商品列表 -->            	 	      	 	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#)        

返回结果也是一个resultMap — orderGoodsMap

喜欢 (0)赏

[搞代码]

分享 (0)