<select id="iterateTest" parameterClass="java.util.HashMap" resultMap="java.util.HashMap"> SELECT COLUMN1 , COLUMN2 FROM TABLE_NAME WHERE COLUMN_NAME <iterate prepend="IN" property="iList" open="(" close=")" conjunction=","> #iList[]# </iterate> </select> |
List list = new ArrayList(); list.add("A"); list.add("B"); list.add("C"); HashMap map = new HashMap(); map.put("idList", list); |
<select id="iterateTest2" parameterClass="java.util.HashMap" resultMap="java.util.HashMap"> SELECT COLUMN1 , COLUMN2 FROM TABLE_NAME WHERE COLUMN_NAME <iterate prepend="IN" property="iList" open="(" close=")" conjunction=","> #iList[].A# </iterate> </select> |
Map subMap = new HashMap(); |