批量删除数据我们需要在页面获取在页面获取到多选按钮对应数据的id值
// 复选框选中数据集合
multipleSelection: []
值存在这个数据
let multipleSelection = this.multipleSelection;
for (let i = 0; i < multipleSelection.length; i++) {
this.ids[i] = multipleSelection[i].id;
}
遍历获取id值将他存到ids里面用axios发送请求,然后服务端接收请求
将他传给SQL映射文件
delete from tb_brand where id in
<foreach collection="ids" item="id" separator="," open="(" close=")">
${id}
</foreach>
</delete>
动态获取id值
public void deleteByIds(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
BufferedReader reader = request.getReader();
String s = reader.readLine();
System.out.println(s);
int[] ints = JSON.parseObject(s, int[].class);
BrandServiceImpl brandServlet = new BrandServiceImpl();
brandServlet.deleteByIds(ints);
response.getWriter().write("ok");
}
主要是要将客服端传过来的 json对象转换成数组
int[] ints = JSON.parseObject(s, int[].class);