第一步:mapper
int dels(List<Integer> ids);
第二步:写xml
<delete id="dels" parameterType="Integer"> delete from library.user where id in <foreach item="ids" collection="list" index="index" open="(" separator="," close=")"> #{ids} </foreach> </delete> 第三步:service public int dels(List<Integer> ids){ return userMapper.dels(ids); }
第四步controller
//批量删除 @PostMapping("/dels") public int dels(@RequestBody List<Integer> ids){ //删除 if (!ids.isEmpty()){ return userService.dels(ids); }else { return 0; } }
前端是vue+element
<el-popconfirm icon="el-icon-info" icon-color="red" title="这是一段内容确定删除吗?" @confirm="dels" > <el-button type="danger" slot="reference" style="margin: 0 10px">批量删除<i class="el-icon-remove-outline"></i></el-button> </el-popconfirm>
dels的方法
dels(){ let ids=this.multipleSelection.map(value => value.id)//[{}]=>[1,2] request.post("http://localhost:9090/user/dels/",ids).then(res=> { if (res) { this.$message.success("批量删除成功!") this.load() }else if (res==0){ this.$message.error("请选择!") this.load() } else { this.$message.error("批量删除失败!") this.load() } }) }