mysql复合属性,使用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 ListlistData;

... getter setter...

}

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

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

看下这个查询 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#)

返回结果也是一个resultMap -- orderGoodsMap

本文原创发布php中文网，转载请注明出处，感谢您的尊重！