基于EasyCode定制Mybatisplus全自动单表实现：新增/批量新增/修改/批量删除/分页查询/ID查询

基于EasyCode定制Mybatisplus全自动单表实现CRUD接口

• 分页查询
• ID查询
• 新增
• 批量新增
• 修改
• 批量删除

注意使用了MybatisPlus的自动填充功能，和insertBatchSomeColumn扩展批量插入功能,分页插件

需要几个增加插件实现类

自动填充

package com.gton.config.autofull;

import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.reflection.MetaObject;
import org.springframework.stereotype.Component;

import java.time.LocalDateTime;

/**
 * @description: Mybatis -plus  自动填充
 * @author: GuoTong
 * @createTime: 2021-10-05 18:12
 * @since JDK 1.8 OR 11
 **/
@Slf4j
@Component
public class MyMetaObjectHandler implements MetaObjectHandler {

    @Override
    public void insertFill(MetaObject metaObject) {
        log.info("start insert fill ....");
        // 或者
        this.strictInsertFill(metaObject, "createTime", LocalDateTime::now, LocalDateTime.class); // 起始版本 3.3.3(推荐)
        this.strictInsertFill(metaObject, "updateTime", LocalDateTime::now, LocalDateTime.class); // 起始版本 3.3.3(推荐)
    }

    @Override
    public void updateFill(MetaObject metaObject) {
        log.info("start update fill ....");
        this.strictUpdateFill(metaObject, "updateTime", LocalDateTime::now, LocalDateTime.class); // 起始版本 3.3.3(推荐)

    }
}

分页插件

    /**
     * Description:  新的分页插件
     *
     * @author: GuoTong
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        // 向Mybatis过滤器链中添加分页拦截器
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        // 添加乐观锁插件
        interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
        return interceptor;
    }

自定义扩展批量插入

package com.gton.handler;

import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.core.injector.AbstractMethod;
import com.baomidou.mybatisplus.core.injector.DefaultSqlInjector;
import com.baomidou.mybatisplus.core.metadata.TableInfo;
import com.baomidou.mybatisplus.extension.injector.methods.InsertBatchSomeColumn;

import java.util.List;

/**
 * @description: MyBatis-Plus提供的InsertBatchSomeColumn方法
 * @author: GuoTong
 * @createTime: 2022-12-06 16:24
 * @since JDK 1.8 OR 11
 **/
public class EasySqlInjector extends DefaultSqlInjector {


    @Override
    public List getMethodList(Class mapperClass, TableInfo tableInfo) {
        // 注意：此SQL注入器继承了DefaultSqlInjector(默认注入器)，调用了DefaultSqlInjector的getMethodList方法，保留了mybatis-plus的自带方法
        List methodList = super.getMethodList(mapperClass, tableInfo);
        methodList.add(new InsertBatchSomeColumn(i -> i.getFieldFill() != FieldFill.UPDATE));
        return methodList;
    }

}

批量插入插件注入

 /**
     * Description: 批量插入优化
     *
     * @author: GuoTong
     */
    @Bean
    public EasySqlInjector sqlInjector() {
        return new EasySqlInjector();
    }

Controller的目标效果示例：

package com.gton.user.controller;

/**
 * (GpLogin)表控制层
 *
 * @author GT
 * @since 2022-12-06 20:13:00
 */
@RestController
@RequestMapping("gpLogin")
@SwaggerScanClass
public class GpLoginController {
    /**
     * 服务对象
     */
    @Autowired
    private GpLoginService gpLoginService;

    @Autowired
    private OpenFeignToCommodityServer openFeignToCommodityServer;

    /**
     * Description:  openfegin 调用
     *
     * @param request HttpServletRequest
     * @author: GuoTong
     * @date: 2022-12-06 16:52:18
     * @return:com.gton.io.Resp Resp
     */
    @RequestMapping(value = "/list", method = RequestMethod.GET)
    public Resp list(HttpServletRequest request) {

        String id = request.getParameter("id");
        if (StringUtils.isEmpty(id)) {
            id = "1598659338353319937";
        }
        Resp