iBatis 的多重循环牵套

 

     < select  id = "goreyTest" parameterClass = "GoreyBean" resultMap = "goreyResult" >
         SELECT
             *
         FROM  
            TBL
         WHERE
            ID  =  #id#
             AND  
             < iterate property = "objList"  open = "("  close = ")" conjunction = " OR " >
                ( NAME  =  #objList [] .name#
                 AND  ( TARGET  IN  
                 < iterate property = "objList [] .objList"  open = "("  close = ")" conjunction = "," >
                    #objList [] .objList [] .target#
                 </ iterate >  ) )
             </ iterate >  
             AND  DEL_FLG  =   ' 0 '
     </ select >

因为某种需求，尝试了上面的iBatis的SQLMAP,而且也通过测试了。
但是，这只是理论上的可行性是通过的。
实际应用的时候，由于数据量的增大，上面的SQL文解析以后也会
变的超大。