농부지기

[ myBatis에서 foreach 사용하기 ]

1. 자바단

    param.put("codeList", "AAA,BBB,CCC"; List<String> plnSubsidiaryList = new ArrayList<String>(); if ( param.get("codeList") != null && !"".equals(param.get("codeList"))){ codeList= param.get("codeList").toString().split(","); for(int i=0; i<codeList.length; i++){ plnSubsidiaryList.add(codeList[i]); } } searchMap.put("subList", plnSubsidiaryList);

2. sql foreach 부분만

   <if test="subList.size != 0"> AND PLN_SUBSIDIARY_CODE in <foreach collection="subList" item="item" index="index" separator="," open="(" close=")"> #{item} </foreach> </if>