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;
}
}