【java】【ibatis】1対N関係のレコードをList<Map<>>で取得する方法

それがこれ。
ポイントはresultMap="A0160Plus"のgroupBy属性

◆SQLMap

<resultMap id="A0162ResultMapPlus" class="java.util.HashMap"                            
    groupBy="A0162＿NO">                       
    <result column="SEIRINO" property="A0162_SEIRINO" />                        
    <result column="BUYER＿NO" property="A0162_BUYER＿NO" />                      
    <result column="A0162＿NO" property="A0162＿NO" />                        
    <result column="A0162＿NAME" property="A0162＿NAME" />                        
</resultMap>                            
<resultMap id="A0164ResultMapPlus" class="java.util.HashMap"                            
    groupBy="A0164＿NO">                       
    <result column="SEIRINO" property="A0164_SEIRINO" />                        
    <result column="BUYER＿NO" property="A0164_BUYER＿NO" />                      
    <result column="A0164＿NO" property="A0164＿NO" />                        
    <result column="A0164＿NAME" property="A0164＿NAME" />                        
</resultMap>                            
<resultMap id="A0168ResultMapPlus" class="java.util.HashMap"                            
    groupBy="A0168＿NO">                       
    <result column="SEIRINO" property="A0168_SEIRINO" />                        
    <result column="BUYER＿NO" property="A0168_BUYER＿NO" />                      
    <result column="A0168＿NO" property="A0168＿NO" />                        
    <result column="A0168＿NAME" property="A0168＿NAME" />                        
</resultMap>                            
<resultMap id="A0160Plus" class="java.util.HashMap" groupBy="SEIRINO,BUYER＿NO">                           
    <result column="SEIRINO" property="SEIRINO" />                      
    <result column="BUYER＿NO" property="BUYER＿NO" />                        
    <result column="BUYER＿NAME" property="BUYER＿NAME" />                        
    <result property="A0162" resultMap="user.A0162ResultMapPlus"                        
        javaType="java.util.ArrayList" />                   
    <result property="A0164" resultMap="user.A0164ResultMapPlus"                        
        javaType="java.util.ArrayList" />                   
    <result property="A0168" resultMap="user.A0168ResultMapPlus"                        
        javaType="java.util.ArrayList" />                   
</resultMap>                            
<select id="getA0160Plus" resultMap="A0160Plus" parameterClass="Map">                           
    select                      
    c.seiriNo, c.buyer＿no as buyer＿no,c.buyer＿name as buyer＿name,                      
    o.seiriNo as A0162_SEIRINO, o.buyer＿no as A0162_BUYER＿NO,o.A0162＿no as                        
    A0162＿NO,o.A0162＿name as A0162＿NAME,                         
    a.seiriNo as                        
    A0164_SEIRINO,a.buyer＿no as A0164_BUYER＿NO, a.A0164＿no as                     
    A0164＿NO,a.A0164＿name as A0164＿NAME ,                     
    b.seiriNo as A0168_SEIRINO,b.buyer＿no as A0168_BUYER＿NO, b.A0168＿no as                        
    A0168＿NO,b.A0168＿name as A0168＿NAME                       
    from                        
    ((A0160z c                         
    left outer                         
    join                        
    A0162 o on c.SEIRINO = o.SEIRINO and                        
    c.buyer＿no = o.buyer＿no)                       
    left                        
    outer                      
    join  A0164 a on o.SEIRINO =                       
    a.SEIRINO and o.buyer＿no =                        
    a.buyer＿no )                     
    left outer                      
    join  A0168 b on                       
    c.SEIRINO = b.SEIRINO and c.buyer＿no = b.buyer＿no                       
    order by c.SEIRINO ,                        
    c.BUYER＿NO,o.A0162＿no,a.A0164＿no,b.A0168＿no                     

</select>                           

◆java側

・List> ListmapPlus =
queryDAO.executeForObjectList("user.getA0160Plus", null);