数组作为SQL查询参数

数组作为sql的查询条件，其实就是让其符合如下格式

where id in (001,002,003)

若有一参数为

String[] ids = ["001","002","003"]

在mybatis中可以写为

where a.id in
   <foreach collection="array" item="id" separator="," open="(" close=")">
       #{id}
   </foreach>

其中item="id"的id为数组中遍历的每个元素

ex：

int deleteActivityByIds(String[] ids);

<delete id="deleteActivityByIds" parameterType="string">
    delete from tbl_activity where id in
    <foreach collection="array" item="id" separator="," open="(" close=")">
        #{id}
    </foreach>
</delete>