선한열심

if else 처리

<isEqual property="AAA" compareValue="T">  </isEqual>

<isNotEqual property="AAA" compareValue="T">  </isNotEqual>

null 처리

<isNotEmpty property="AAA">   </isNotEmpty>

참고 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
 

class="aaa", class="bbb"

동시에 사용하기 위해서는 class="aaa bbb" 이렇게 해야함

(주의 class="aaa" class="bbb" 앞에것만 적용됨 )