JAVA OPEN API2013. 8. 22. 10:39

참고 AAAVO 안에
aaa1 ~ 4
<List> aaaList


 <resultMap id="CCCList" class="CCCVO">
  <result property="ccc1"   column="ccc1" />
  <result property="ccc2"   column="ccc2" />
 </resultMap>
 <resultMap id="BBBList" class="BBBVO" groupBy="bbb1">
  <result property="bbb1"      column="bbb1"/>
  <result property="bbb2"     column="bbb2"/>
  <result property="cccList"  resultMap="aNew.CCCList"/>
 </resultMap>
 <resultMap id="AAA" class="AAAVO" groupBy="aaa1">
        <result property="aaa1"        column="aaa1"/>  
        <result property="aaa2"    column="aaa2" />
  <result property="aaaList"  resultMap="aNew.BBBList"/>
    </resultMap>
   
 <select id="aNew.getList" resultMap="AAA">
 </select>
 
 
필드 aaa1, aaa2, bbb1, bbb2, ccc1, ccc2
       a1   a2        b11   b21      c11   c21
       a1   a2        b11   b21      c12   c22
       a1   a2        b11   b21      c13   c23
       a1   a2        b12   b22      c14   c24
       a1   a2        b12   b22      c15   c25
       a1   a2        b12   b22      c16   c26
 

Posted by 선한열심