1、单个数组参数
<select id="" parameterType="java.util.List" resultType="">
<foreach collection="array" open="(" separator="," close=")" item="item">
#{item}
</foreach>
</select>
2、单个集合参数
<select id="" parameterType="java.util.List" resultType="">
<foreach collection="list" open="(" separator="," close=")" item="item">
#{item}
</foreach>
</select>
3、多个参数,必须用Map
<select id="" parameterType="java.util.Map" resultType="">
<foreach collection="map的key值" open="(" separator="," close=")" item="item">
#{item}
</foreach>
</select>