[Java] [ibatis] Comment obtenir des enregistrements de relation 1 à N avec List <Map <>>

C'est ça. Le point est l'attribut groupBy de resultMap = "A0160Plus"

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

◆ côté java

・ Liste <Carte <Chaîne, Objet >> ListmapPlus = queryDAO.executeForObjectList("user.getA0160Plus", null);