mybatis批量删除数据,一般是以id数组来删除:
Dao文件中如下:
int deleteBatch(String[] ids);
mapper文件中如下:
<delete id="deleteBatch" parameterType="java.lang.String">
delete from table_name where id in
<foreach item="item" index="index" collection="array" open="(" separator="," close=")">
#{item}
</foreach>
</delete>
注意:
1,collection=”array”,表示传入的参数是数组,
2,collection=”list”,表示传入的参数为集合