批量删除的实现

hello_yuyi

已于 2022-05-21 09:18:31 修改

阅读量276

点赞数

文章标签： web

于 2022-05-21 09:14:50 首次发布

本文链接：https://blog.csdn.net/hello_yuyi/article/details/124894270

版权

<el-button type="warning" @click="deBatch">批量删除</el-button>

method方法
deBatch () {
  let ids = this.multipleSelection.map(v => v.id)
  subjectApi.deleteBatch(ids).then(
    re => {
      if (re.code === 1) {
        this.$message.success('批量删除成功')
      } else {
        this.$message.error('删除失败')
      }
    }
  )
},

//    批量删除后端

    @PostMapping(value = "/subject/delete/batch")
    public RestResponse deleteBatch(@RequestBody List<Integer> ids) {
        subjectService.deleteByIds(ids);
        return RestResponse.ok();
    }

service

Integer deleteByIds(List<Integer> ids);

serviceimp

@Override
public Integer deleteByIds(List<Integer> ids) {return subjectMapper.deleteByIds(ids); }

mapper

Integer deleteByIds(List<Integer> ids);

<delete id="deleteByIds">
  DELETE FROM t_subject

  WHERE
  id IN (
  <foreach collection="ids" item="id" separator=",">
    #{id}
  </foreach>
  )
</delete>