初入mybatis,接触foreach,mark记录方便以后自己查阅
SQL:
AND REGION_ID IN <foreach item="item" index="index" collection="areaIds" open="(" separator="," close=")"> #{item} </foreach>
JAVA代码:
//拼接所有下级节点areaCode List<String> areaStr = new ArrayList<String>(); if (null != childList){ for(SysAreaTreeModel s:childList) { areaStr.add(s.getCode()); } } hm.put("areaIds",areaStr);
还有一种String[] 的用法,考虑到项目中几乎不会用到,此处就不介绍及了解了。