mybatis ÖÐʹÓÃforeach Ñ­»·²éѯ

class CompanyQueryParamDtoÏÂ

 /** ¶à³ÇÊÐid */
 private List<Long> cityIds;

xml

<if test="cityIds != null and cityIds.size() > 0">
 and a.city_id in
    <foreach collection="cityIds" item="item" open="(" close=")" separator=",">
         ${item}
    </foreach>
</if>
```

תÔØÓÚ:https://my.oschina.net/u/2545762/blog/760152