// 注意:此SQL注入器继承了DefaultSqlInjector(默认注入器),调用了DefaultSqlInjector的getMethodList方法,保留了mybatis-plus的自带方法
public class EasySqlInjector extends DefaultSqlInjector {
@Override
public List<AbstractMethod> getMethodList(Class<?> mapperClass) {
List<AbstractMethod> methodList = super.getMethodList(mapperClass);
methodList.add(new InsertBatchSomeColumn(i -> i.getFieldFill() != FieldFill.UPDATE));
return methodList;
}
}
@Configuration
public class MybatisPlusConfig {
@Bean
public EasySqlInjector easySqlInjector () {
return new EasySqlInjector();
}
}
//自定义mapper
public interface EasyBaseMapper<T> extends BaseMapper<T> {
/**
* 批量插入 仅适用于mysql
*
* @param entityList 实体列表
* @return 影响行数
*/
Integer insertBatchSomeColumn(Collection<T> entityList);
}
//每个类的mapper继承自定义的mapper就可以使用insertBatchSomeColumn批量插入方法
public interface SysProjectPermissionMapper extends EasyBaseMapper<SysProjectPermissionEntity> {
}
baseMapper.insertBatchSomeColumn(permissions);