mybatis中foreach用法

<sql id="query_user_where"> <!-- 如果 userQueryVo中传入查询条件，再进行sql拼接--><!-- test中userCustom.username表示从userQueryVo读取属性值--><if test="userCustom!=null"><if test="userCustom.username!=null and userCustom.username!=''">and username like '%${userCustom.username}%'</if><if test="userCustom.sex!=null and userCustom.sex!=''">and sex = #{userCustom.sex}</if><!-- 根据id集合查询用户信息 --><!-- 最终拼接的效果：SELECT id ,username ,birthday  FROM USER WHERE username LIKE '%小明%' AND id IN (16,22,25)collection：集合的属性open：开始循环拼接的串close：结束循环拼接的串item：每次循环取到的对象separator：每两次循环中间拼接的串 --> <foreach collection="ids" open=" AND id IN ( " close=")" item="id" separator=","> #{id} </foreach> <!--  SELECT id ,username ,birthday  FROM USER WHERE username LIKE '%小明%' AND (id = 16 OR id = 22 OR id = 25)   <foreach collection="ids" open=" AND ( " close=")" item="id" separator="OR"> id = #{id} </foreach>  --><!-- 还有很的查询条件 --></if> </sql>