以订单为例,直接上代码: 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

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