接口定义,传入批量删除的key
void bitchDelete(@Param("ids") List<Integer> ids);
xml定义
ids代表传入的key数组
<delete id="bitchDelete" parameterType="java.lang.Integer">
delete from t_sys_role where role_id in
<foreach collection="ids" open="(" close=")" separator="," item="id">
#{id}
</foreach>
</delete>