Java Springboot3 Mybatis统一处理公共字段

最新推荐文章于 2024-08-12 21:29:36 发布

幸运黒锦鲤

最新推荐文章于 2024-08-12 21:29:36 发布

阅读量311

点赞数 8

本文链接：https://blog.csdn.net/qq_36729594/article/details/140814510

版权

springboot 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

这里本文只做最简单的功能实现

一、创建BaseEntity公共字段实体类

package com.lingyang.system.util.mybatisplus.entity;

import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.TableField;
import lombok.Data;

import java.time.LocalDateTime;

/**
 * @author **文
 * @Description:
 * @createDate 2024/7/22 10:03
 **/
@Data
public class BaseEntity {

    @TableField(fill = FieldFill.INSERT)
    private String createBy;

    @TableField(fill = FieldFill.INSERT)
    private String createById;

    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;

    @TableField(fill = FieldFill.UPDATE)
    private String updateBy;

    @TableField(fill = FieldFill.UPDATE)
    private String updateById;

    @TableField(fill = FieldFill.UPDATE)
    private LocalDateTime updateTime;

}

二、对Mybatis 或者MybatisPlus 追加处理

package com.lingyang.system.util.mybatisplus.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.OptimisticLockerInnerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

/**
 * @author **文
 * @Description:
 * @createDate 2024/7/22 11:39
 **/
@Configuration
@MapperScan({"com.lingyang.*.mapper"})
public class MybatisPlusConfig {

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();
        paginationInnerInterceptor.setOptimizeJoin(true);
        paginationInnerInterceptor.setDbType(DbType.MYSQL);
        paginationInnerInterceptor.setOverflow(true);

        interceptor.addInnerInterceptor(paginationInnerInterceptor);
        OptimisticLockerInnerInterceptor optimisticLockerInnerInterceptor = new OptimisticLockerInnerInterceptor();
        interceptor.addInnerInterceptor(optimisticLockerInnerInterceptor);
        return interceptor;
    }



}

三、工具类对原数据进行具体处理

这里要插入 create_id 、create_by。update_id、update_by 使用jwt解析出来的用户信息也可

package com.lingyang.system.util.mybatisplus.handler;

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

/**
 * @author **文
 * @Description:
 * @createDate 2024/7/22 9:44
 **/
@Component
public class MyMetaObjecthandler implements MetaObjectHandler {

    @Override
    public void insertFill(MetaObject metaObject) {
        this.setFieldValByName("create_time", System.currentTimeMillis(), metaObject);
    }

    @Override
    public void updateFill(MetaObject metaObject) {
        this.setFieldValByName("update_time", System.currentTimeMillis(), metaObject);
    }

}