MybatisPlus批量操作（插入、删除、更新）

原创

诗水人间 2021-08-07 09:58:46 ©著作权

文章标签 spring mysql 项目搭建常用操作 java 文章分类 Java 后端开发

©著作权归作者所有：来自51CTO博客作者诗水人间的原创作品，请联系作者获取转载授权，否则将追究法律责任

MP的BaseMapper没有提供批量的DML操作。

但是在IService接口中却定义了这些常用操作

定义一个接口

import com.baomidou.mybatisplus.extension.service.IService;
import org.springframework.stereotype.Service;
import top.yumbo.springcloud.car.entity.Car;// 自定义的实体

@Service
public  interface  TCarIService extends IService<Car> {
}

定义接口实现类

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;
import top.yumbo.springcloud.car.dao.TCarDao;
import top.yumbo.springcloud.car.entity.Car;

@Service
public class TCarIServiceImpl extends ServiceImpl<TCarDao, Car> implements TCarIService{
}

同时需要有Dao层的那个接口

dao层接口的定义

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;
import top.yumbo.springcloud.car.entity.Car;

@Mapper
@Component
public interface TCarDao extends BaseMapper<Car> {

}

实体Car的配置参考例子，使用了lombok所以代码如下

import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.*;

import java.io.Serializable;

@Data
@AllArgsConstructor
@NoArgsConstructor
@Getter
@Setter
@TableName(value = "t_car")
public class Car implements Serializable {
  @TableId
  private long carId;
  private String carType;
  private String carBrand;
  private String carColor;
  private double carPrice;
  private String carDescription;
  private String carInfo;
  private String carArea;
  private String carImage;
  private String carRegtime;
  private String carMileage;
  private String carStatus;
}

yml配置

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mp?useSSL=false&serverTimezone=GMT%2B8
    username: root
    password: 123456
mybatis-plus:
  configuration:
    map-underscore-to-camel-case: true  # 开启驼峰命名