Dies ist das. Der Punkt ist das groupBy-Attribut von 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>
◆ Java-Seite
・ List <Map <String, Object >> ListmapPlus = queryDAO.executeForObjectList("user.getA0160Plus", null);