xml -- forearch遍历用法

// in的多参数查找，比较常见
<select id="selectSearchAttrIds" resultType="java.lang.Long">
    SELECT attr_id FROM `pms_attr` WHERE attr_id IN
    <foreach collection="attrIds" item="id" separator="," open="(" close=")">
      #{id}
    </foreach>
    AND search_type = 1
</select>

List<Long> selectSearchAttrIds(@Param("attrIds") List<Long> attrIds);