Mybatis-plus批量删除

最新推荐文章于 2025-06-13 00:44:06 发布

我告诉你XXX

最新推荐文章于 2025-06-13 00:44:06 发布

阅读量1.5w

点赞数 2

CC 4.0 BY-SA版权

文章标签： java

本文链接：https://blog.csdn.net/weixin_55617164/article/details/118157944

这篇博客展示了如何在Java SpringBoot应用中通过Service和Mapper实现根据ID列表删除User记录。首先定义了User实体类，包含主键ID、姓名、年龄和邮箱字段。接着是UserList类，用于存储待删除的用户ID列表。Service接口定义了deleteIds方法，接收UserList对象并执行删除操作。ServiceImpl实现了该接口，检查ID列表是否为空，然后使用MyBatis的QueryWrapper进行条件查询并删除对应用户。最后，Controller接收请求，调用Service并返回删除结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

实体类

package com.baizhi.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;

import java.io.Serializable;

/**
 * <p>
 * InnoDB free: 11264 kB
 * </p>
 *
 * @author 狂神
 * @since 2021-06-22
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@ApiModel(value="User对象", description="InnoDB free: 11264 kB")
public class User implements Serializable {

    private static final long serialVersionUID=1L;

    @ApiModelProperty(value = "主键ID")
    @TableId(value = "id", type = IdType.ID_WORKER)
    private Long id;

    @ApiModelProperty(value = "姓名")
    private String name;

    @ApiModelProperty(value = "年龄")
    private Integer age;

    @ApiModelProperty(value = "邮箱")
    private String email;


}

集合类

package com.baizhi.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.List;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class UserList{
     private List<Long> ids;
}

service

  String deleteIds(UserList userList);

ServiceImpl

 @Override
    public String deleteIds(UserList userList) {
        List<Long> ids = userList.getIds();
        if (!ids .isEmpty()&&ids.size()==0) {
          return "没有数据";
        }else{
            QueryWrapper<User> wrapper = new QueryWrapper<>();
            wrapper.in("id",ids);
            userMapper.delete(wrapper);
        }
        return "删除成功";
    }

controller

  @DeleteMapping("/delete")
    public String delete(@RequestBody UserList userList) {
        userService.deleteIds(userList);
        return "删除成功";
    }