xml文件
collection="" 遍历的集合(这里要写数据类型 不是变量名!!!!)
<!--批量删除
collection="" 遍历的集合(这里要写数据类型 不是变量名!!!!)
index="" 遍历时候的索引
item="" 每此遍历需要得到的对象
open="" 以什么符号开始
close="" 以什么符号结束
separator="" 作为分割符的字符(或者字符串?)
-->
<delete id="deleteBatch" parameterType="list">
delete from user where id in
<foreach collection="list" item="id" open="(" close=")" separator=",">
#{id}
</foreach>
</delete>
mapper层
public interface UserMapper {
public int deleteBatch(List<Long> longs);
}
Controller层
//localhost:8080/user/deleteBatch [1,2,3]
注意接收的参数列表要写@RequestBody注解
@ResponseBody
@RequestMapping("deleteBatch")
public String deleteBatch(@RequestBody List<Long> longs){
if (userService.deleteBatch(longs)){
return "批量删除成功";
}else {
return "批量删除失败";
}
}