Mybatis-plus两种批量插入方法比较（带源码）

1 SQL注入器方式

1.1 SqlInjector 注入器类

package com.example.demo.config.mybatis;

import com.baomidou.mybatisplus.core.injector.AbstractMethod;
import com.baomidou.mybatisplus.core.injector.DefaultSqlInjector;
import com.baomidou.mybatisplus.extension.injector.methods.InsertBatchSomeColumn;

import java.util.List;

/**
 * @author liyue
 * @date 2021/12/8 15:32
 */
public class SqlInjector extends DefaultSqlInjector {
   

    @Override
    public List<AbstractMethod> getMethodList(Class<?> mapperClass) {
   
        List<AbstractMethod> methodList = super.getMethodList(mapperClass);
        methodList.add(new InsertBatchSomeColumn());
        return methodList;
    }
}

1.2 MyBatisPlusConfig 配置类

package com.example.demo.config.mybatis;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

/**
 * @author liyue
 * @date 2021/12/8 15:31
 */
@EnableTransactionManagement
@Configuration
@MapperScan("com.example.demo.mapper")
public class MyBatisPlusConfig {
   

    @Bean
    public SqlInjector sqlInjector(){
   
        return new SqlInjector();
    }
}

1.3 Mapper基础类

package com.example.demo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;

/**
 * @author liyue
 * @date 2021/12/8 15:35
 */
public interface MyBaseMapper<T> extends BaseMapper<T> {
   

    /**
     * 批量插入
     * @param entityList
     * @return
     */
    Integer insertBatchSomeColumn(List<T> entityList);
}

1.4 UserMapper 继承MyBaseMapper类

package com.example.demo.mapper;

import com.example.demo.entity.User;

/**
 * @author liyue
 * @date 2021/12/6 15:32
 */
public interface UserMapper extends MyBaseMapper<User> {
   
}

2 IService方式

2.1 BatchHandlerMapper 接口

BatchHandlerMapper 接口继承IService

package com.example.demo.mapper;

import com.baomidou.mybatisplus.extension.service.IService;
import com.example.demo.entity.Dept;

/**
 * @author liyue
 * @date 2021/12/8 16:42
 */
public interface BatchHandlerMapper extends IService<Dept> {
   
}

2.2 DeptMapper 接