Mybatis 사용법 - foreach문 사용 (파라미터: table)

java

List<Map<String, Object>> lstCode = getExecutor().selectList("SELECT_CODE", param);
param.put("CODELST",    lstCode);
mesExecutor.selectDataTable("SELECT_List ", param));

 

 

/* SELECT_CODE */
        SELECT GRP_CD  AS CODE
             , KEY_VAL_1 AS ID
          FROM
               TEMP   
         WHERE 1=1

/* SELECT_List */
          WITH TMP AS
               (
               <foreach collection="CODELST" item="item" index="index" separator="UNION ALL">
                    SELECT #{item.CODE} CD, #{item.ID} ID FROM DUAL
               </foreach>
               )
        SELECT *
          FROM SysTMP A 
             , TMP B
         WHERE 1=1
           AND A.CD = B.CD
           AND A.ID     = B.ID