Mybatis-plus分页、自动填充时间戳配置

git项目地址

码云项目地址

• 配置分页插件
• 配置自动填充新增数据时的创建时间、更新时间
• 配置自动填充更新数据时的更新时间

依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.0</version>
</dependency>

yaml配置

mybatis-plus:
  configuration:
    call-setters-on-nulls: true
    local-cache-scope: "statement"
    log-impl: "org.apache.ibatis.logging.stdout.StdOutImpl"
    map-underscore-to-camel-case: true
  global-config:
    banner: false
  mapper-locations: "classpath*:/mapper/**/*.xml"

配置

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.apache.ibatis.reflection.MetaObject;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

/**
 * 配置mybatis-plus分页拦截器和自动填充POJO时间戳
 *
 * @author yanzhao
 * @date 2022/1/13 15:45
 * @since 1.0.0
 */
@Configuration
public class MybatisPlusConfig implements MetaObjectHandler {

    /**
     * 配置分页拦截器
     *
     * @return
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }

    /**
     * 新增时自动填充
     *
     * @param metaObject
     */
    @Override
    public void insertFill(MetaObject metaObject) {
        this.strictInsertFill(metaObject, "gmtCreate", Long.class, System.currentTimeMillis());
        this.strictInsertFill(metaObject, "gmtModified", Long.class, System.currentTimeMillis());
    }

    /**
     * 更新时自动填充
     *
     * @param metaObject
     */
    @Override
    public void updateFill(MetaObject metaObject) {
        this.strictUpdateFill(metaObject, "gmtModified", Long.class, System.currentTimeMillis());
    }
}

POJO

import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.example.edu.config.MybatisPlusConfig;
import lombok.Data;

import java.io.Serializable;

/**
 * @author yanzhao
 * @date 2021/11/22 11:27
 * @since 1.0.0
 */
@Data
public class BaseModel implements Serializable {

    @TableId(type = IdType.AUTO)
    private Long id;

    /**
     * fill = FieldFill.INSERT：新增时自动填充
     *
     * @see MybatisPlusConfig
     */
    @TableField(fill = FieldFill.INSERT)
    private Long gmtCreate;

    /**
     * fill = FieldFill.INSERT_UPDATE：新增和修改时自动填充
     *
     * @see MybatisPlusConfig
     */
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Long gmtModified;
}