Mybatis ＜foreach ＞与 ibatis＜iterate＞ ,list作为集合条件查询

mybatis 用法

<select id="getUserList"  parameterType="java.util.List" resultType="java.util.Map">
select *  from user
 where name IN
 <foreach collection="ids" item="id" open="(" close=")" separator=",">
         #{id}
 </foreach>
</select>

ibatis 用法

<select id="getUserList"  parameterClass="java.util.List" resulClass="java.util.Map"
select *  from user
 where name IN
<iterate open="(" close=")" property="codes" conjunction=",">
#codes[]#
</iterate>
</select>