mybatis-plus笔记

Oracle

        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>11.2.0.1.0</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
            <version>3.2.0</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3.4</version>
        </dependency>

-- Create table
CREATE TABLE APP_MANAGEMENT
(
    ID                  NUMBER(18) NOT NULL,
    APP_ID    	        VARCHAR2(100) NOT NULL,
    APP_SECRET          VARCHAR2(100) NOT NULL,
    APP_TYPE            VARCHAR2(10) DEFAULT '0' NOT NULL,
    APP_STATUS          VARCHAR2(10) DEFAULT '0' NOT NULL,
    CREATE_BY          VARCHAR2(50) DEFAULT NULL,
    CREATE_TIME        TIMESTAMP(6) DEFAULT NULL,
    UPDATE_BY          VARCHAR2(50) DEFAULT NULL,
    UPDATE_TIME        TIMESTAMP(6) DEFAULT NULL,
    REMARK               VARCHAR2(500) DEFAULT NULL,
    EXTRA               VARCHAR2(500) DEFAULT NULL,
    CONSTRAINT APP_MANAGEMENT PRIMARY KEY (ID)
);


-- Add comments to the columns
COMMENT ON TABLE APP_MANAGEMENT IS '应用管理表';
COMMENT ON COLUMN APP_MANAGEMENT.ID IS '主键ID';
COMMENT ON COLUMN APP_MANAGEMENT.APP_ID IS '应用id';
COMMENT ON COLUMN APP_MANAGEMENT.APP_SECRET IS '应用secret';
COMMENT ON COLUMN APP_MANAGEMENT.APP_TYPE IS '应用类型，0：业务应用(只能获取/生成本系统的签名)，1：系统应用(可以获取/生成任意系统的签名)';
COMMENT ON COLUMN APP_MANAGEMENT.APP_STATUS IS '应用状态，0：禁用，1：启用';
COMMENT ON COLUMN APP_MANAGEMENT.CREATE_BY IS '创建人';
COMMENT ON COLUMN APP_MANAGEMENT.CREATE_TIME IS '创建时间';
COMMENT ON COLUMN APP_MANAGEMENT.UPDATE_BY IS '更新人';
COMMENT ON COLUMN APP_MANAGEMENT.UPDATE_TIME IS '更新时间';
COMMENT ON COLUMN APP_MANAGEMENT.REMARK IS '备注';
COMMENT ON COLUMN APP_MANAGEMENT.EXTRA IS '备用拓展字段';


-----create unique index
CREATE UNIQUE INDEX INDEX_1 ON APP_MANAGEMENT(APP_ID);
CREATE UNIQUE INDEX INDEX_2 ON APP_MANAGEMENT(OA_APP_ID, APP_ID);


-- Create sequence
create sequence SEQ_APP_MANAGEMENT
    minvalue 1
    maxvalue 9999999999999999999999999999
    start with 1
    increment by 1
    cache 10;

package com.demo.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.incrementer.OracleKeyGenerator;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
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;

@Configuration
@MapperScan(value = {"com.demo.**.mapper*"})
public class MybatisPlusConfig {

    /**
     * 分页插件
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor(DbType.ORACLE);
        paginationInnerInterceptor.setOptimizeJoin(false);

        // 向Mybatis过滤器链中添加分页拦截器
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(paginationInnerInterceptor);
        return interceptor;
    }

    @Bean
    public OracleKeyGenerator oracleKeyGenerator() {
        return new OracleKeyGenerator();
    }
}

package com.demo.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.KeySequence;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.Column;
import java.io.Serializable;
import java.util.Date;

/**
 * @Description: 应用管理表
 */
@Data
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = false)
@TableName("APP_MANAGEMENT")
@KeySequence(value = "SEQ_APP_MANAGEMENT")
@ApiModel(value = "app_management对象", description = "应用管理表")
public class AppManagement implements Serializable {
    private static final long serialVersionUID = 1L;

    /**
     * 主键
     */
    @Column(name = "ID")
    @TableId(value = "ID", type = IdType.INPUT)
    @ApiModelProperty(value = "主键")
    private String id;
    /**
     * 应用id
     */
    @Column(name = "APP_ID")
    @ApiModelProperty(value = "应用id")
    private String appId;
    /**
     * 应用secret
     */
    @Column(name = "APP_SECRET")
    @ApiModelProperty(value = "应用secret")
    private String appSecret;
    /**
     * 应用类型，0：业务应用(只能获取/生成本系统的签名)，1：系统应用(可以获取/生成任意系统的签名)
     */
    @Column(name = "APP_TYPE")
    @ApiModelProperty(value = "应用类型")
    private String appType;
    /**
     * 应用状态，0：禁用，1：启用
     */
    @Column(name = "APP_STATUS")
    @ApiModelProperty(value = "应用状态")
    private String appStatus;
    /**
     * 创建人
     */
    @Column(name = "CREATE_BY")
    @ApiModelProperty(value = "创建人")
    private String createBy;
    /**
     * 创建日期
     */
    @Column(name = "CREATE_TIME")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "创建日期")
    private Date createTime;
    /**
     * 更新人
     */
    @Column(name = "UPDATE_BY")
    @ApiModelProperty(value = "更新人")
    private String updateBy;
    /**
     * 更新日期
     */
    @Column(name = "UPDATE_TIME")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "更新日期")
    private Date updateTime;
    /**
     * 备用拓展字段
     */
    @Column(name = "EXTRA")
    @ApiModelProperty(value = "备用拓展字段")
    private String extra;
}

MySQL

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.21</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
            <version>3.2.0</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3.4</version>
        </dependency>

CREATE TABLE `qrcode_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `template_code` varchar(50)  NOT NULL COMMENT '模板编码，全局唯一',
  `template_name` varchar(200)  NOT NULL COMMENT '模板名称',
  `template_content` varchar(500)  NOT NULL COMMENT '二维码内容',
  `app_id` varchar(50)  DEFAULT NULL COMMENT '所属应用的appId',
  `status` varchar(10)  NOT NULL DEFAULT '1' COMMENT '状态，0：启用，1：禁用',
  `create_by` varchar(50)  DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(50)  DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500)  DEFAULT NULL COMMENT '备注',
   PRIMARY KEY (`id`) USING BTREE,
   UNIQUE KEY `index_code` (`template_code`) USING BTREE
) ENGINE=InnoDB COMMENT='二维码模板表';

package com.demo.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
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;

@Configuration
@MapperScan(value = {"com.demo.**.mapper*"})
public class MybatisPlusConfig {

    /**
     * 分页插件
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor(DbType.MYSQL);
        paginationInnerInterceptor.setOptimizeJoin(false);

        // 向Mybatis过滤器链中添加分页拦截器
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(paginationInnerInterceptor);
        return interceptor;
    }
}

package com.demo.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
 * 二维码模板主表
 */
@Data
@TableName("qrcode_template")
public class QrcodeTemplate implements Serializable {
    /**
     * 自增id
     */
    @TableId(type = IdType.AUTO)
    private Integer id;
    /**
     * 模板编码，全局唯一
     */
    @Excel(name = "编码", width = 15)
    @TableField("template_code")
    private String templateCode;
    /**
     * 模板名称
     */
    @TableField("template_name")
    private String templateName;
    /**
     * 二维码内容
     */
    @TableField("template_content")
    private String templateContent;
    /**
     * 所属应用的appId
     */
    @TableField("app_id")
    private String appId;
    /**
     * 状态，0：启用，1：禁用
     */
    @TableField("status")
    private String status;
    /**
     * 创建人
     */
    @TableField("create_by")
    private String createBy;
    /**
     * 创建时间
     */
    @TableField("create_time")
    private Date createTime;
    /**
     * 更新人
     */
    @TableField("update_by")
    private String updateBy;
    /**
     * 更新时间
     */
    @TableField("update_time")
    private Date updateTime;
    /**
     * 备注
     */
    @TableField("remark")
    private String remark;

}

公共

package com.demo.config;

import com.demo.LoginUser;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.binding.MapperMethod.ParamMap;
import org.apache.ibatis.executor.Executor;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.mapping.SqlCommandType;
import org.apache.ibatis.plugin.*;
import org.springframework.stereotype.Component;

import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.lang.reflect.Field;
import java.util.Date;
import java.util.Properties;

/**
 * mybatis拦截器，自动注入创建人、创建时间、修改人、修改时间
 */
@Slf4j
@Component
@Intercepts({ @Signature(type = Executor.class, method = "update", args = { MappedStatement.class, Object.class }) })
public class MybatisInterceptor implements Interceptor {

	@Override
	public Object intercept(Invocation invocation) throws Throwable {
		MappedStatement mappedStatement = (MappedStatement) invocation.getArgs()[0];
		String sqlId = mappedStatement.getId();
		log.debug("------sqlId------" + sqlId);
		SqlCommandType sqlCommandType = mappedStatement.getSqlCommandType();
		Object parameter = invocation.getArgs()[1];
		log.debug("------sqlCommandType------" + sqlCommandType);

		if (parameter == null) {
			return invocation.proceed();
		}
		if (SqlCommandType.INSERT == sqlCommandType) {
			LoginUser sysUser = this.getLoginUser();
			Field[] fields = this.getAllFields(parameter);
			for (Field field : fields) {
				log.debug("------field.name------" + field.getName());
				try {
					if ("createBy".equals(field.getName())) {
						field.setAccessible(true);
						Object local_createBy = field.get(parameter);
						field.setAccessible(false);
						if (local_createBy == null || local_createBy.equals("")) {
							if (sysUser != null) {
								// 登录人账号
								field.setAccessible(true);
								field.set(parameter, sysUser.getUsername());
								field.setAccessible(false);
							}
						}
					}
					if ("createTime".equals(field.getName())) {
						field.setAccessible(true);
						Object local_createDate = field.get(parameter);
						field.setAccessible(false);
						if (local_createDate == null || local_createDate.equals("")) {
							field.setAccessible(true);
							field.set(parameter, new Date());
							field.setAccessible(false);
						}
					}
				} catch (Exception e) {
				}
			}
		}
		if (SqlCommandType.UPDATE == sqlCommandType) {
			LoginUser sysUser = this.getLoginUser();
			Field[] fields = null;
			if (parameter instanceof ParamMap) {
				ParamMap<?> p = (ParamMap<?>) parameter;
				if (p.containsKey("et")) {
					parameter = p.get("et");
				} else {
					parameter = p.get("param1");
				}
				if (parameter == null) {
					return invocation.proceed();
				}
				fields = this.getAllFields(parameter);
			} else {
				fields = this.getAllFields(parameter);
			}

			for (Field field : fields) {
				log.debug("------field.name------" + field.getName());
				try {
					if ("updateBy".equals(field.getName())) {
						//获取登录用户信息
						if (sysUser != null) {
							// 登录账号
							field.setAccessible(true);
							field.set(parameter, sysUser.getUsername());
							field.setAccessible(false);
						}
					}
					if ("updateTime".equals(field.getName())) {
						field.setAccessible(true);
						field.set(parameter, new Date());
						field.setAccessible(false);
					}
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		}
		return invocation.proceed();
	}

	@Override
	public Object plugin(Object target) {
		return Plugin.wrap(target, this);
	}

	@Override
	public void setProperties(Properties properties) {
		// TODO Auto-generated method stub
	}
	    /**
     * 获取类中的属性，包含父类
     * @return Field[] 对象中的属性
     */
    public Field[] getAllFields(Object object) {
        Class<?> clazz = object.getClass();
        List<Field> fieldList = new ArrayList<>();
        while (clazz != null) {
            fieldList.addAll(new ArrayList<>(Arrays.asList(clazz.getDeclaredFields())));
            clazz = clazz.getSuperclass();
        }
        Field[] fields = new Field[fieldList.size()];
        fieldList.toArray(fields);
        return fields;
    }

}