mybatis自动填充时间字段示例代码

@retention (retentionpolicy.runtime)

@target ( {elementtype.field})

public @interface createdonfuncation {

  string value() default "" ;

}

@retention (retentionpolicy.runtime)

@target ( {elementtype.field})

public @interface updatedonfuncation {

  string value() default "" ;

}

@getter

@builder (tobuilder = true )

@tostring

public class userinfo {

  private long id;

  private string name;

  private string email;

  @createdonfuncation

  private localdatetime createdon;

  @updatedonfuncation

  private localdatetime updatedon;

}

package com.lind.basic.mybatis;

import com.baomidou.mybatisplus.extension.handlers.abstractsqlparserhandler;

import java.lang.reflect.field;

import java.time.localdatetime;

import java.util.properties;

import lombok.data;

import lombok.equalsandhashcode;

import lombok.experimental.accessors;

import org.apache.ibatis.logging.log;

import org.apache.ibatis.logging.logfactory;

import org.apache.ibatis.mapping.mappedstatement;

import org.apache.ibatis.mapping.sqlcommandtype;

import org.apache.ibatis.plugin.interceptor;

import org.apache.ibatis.plugin.intercepts;

import org.apache.ibatis.plugin.invocation;

import org.apache.ibatis.plugin.plugin;

import org.apache.ibatis.plugin.signature;

/**

  * 时间拦截器.

  */

@equalsandhashcode (callsuper = true )

@data

@accessors (chain = true )

@intercepts ( {

  @signature (

  type = org.apache.ibatis.executor.executor. class ,

  method = "update" ,

  args = {mappedstatement. class , object. class })})

public class createupdatetimeinterceptor extends abstractsqlparserhandler implements interceptor {

  private static final log logger = logfactory.getlog(com.baomidou.mybatisplus.extension.plugins.sqlexplaininterceptor. class );

  private properties properties;

  @override

  public object intercept(invocation invocation) throws throwable {

  mappedstatement mappedstatement = (mappedstatement) invocation.getargs()[ 0 ];

  // 获取 sql 命令

  sqlcommandtype sqlcommandtype = mappedstatement.getsqlcommandtype();

  // 获取参数

  object parameter = invocation.getargs()[ 1 ];

  // 获取私有成员变量

  field[] declaredfields = parameter.getclass().getdeclaredfields();

  for (field field : declaredfields) {

  if (field.getannotation(createdonfuncation. class ) != null ) {

  if (sqlcommandtype.insert.equals(sqlcommandtype)) { // insert 语句插入 createtime

   field.setaccessible( true );

   field.set(parameter, localdatetime.now());

  }

  }

  if (field.getannotation(updatedonfuncation. class ) != null ) { // insert 或 update 语句插入 updatetime

  if (sqlcommandtype.insert.equals(sqlcommandtype) || sqlcommandtype.update.equals(sqlcommandtype)) {

   field.setaccessible( true );

   field.set(parameter, localdatetime.now());

  }

  }

  }

  return invocation.proceed();

  }

  @override

  public object plugin(object target) {

  if (target instanceof org.apache.ibatis.executor.executor) {

  return plugin.wrap(target, this );

  }

  return target;

  }

  @override

  public void setproperties(properties prop) {

  this .properties = prop;

  }

}

@test

public void insert() {

userinfo userinfo = userinfo.builder()

.name( "lind" )

.email( "test@sina测试数据" )

.build();

userinfomapper.insert(userinfo);

system.out.println( "userinfo:" + userinfo.tostring());

}

userinfo:userinfo

(

id= 1085780948955959297 ,

name=lind,

email=test @sina 测试数据,

createdon= 2019 - 01 -17t14: 08 : 45.665 ,

updatedon= 2019 - 01 -17t14: 08 : 45.665

)