mybatis-plus oracle 自增主键配置

1. 链接oracle数据库，查询sequence
   
2. MybatisplusConfig配置

@Configuration
@MapperScan(basePackages = {
        "xxx1",
        "xxx2",
        "xxx3",
})
public class MybatisPlusConfig {

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

	...
}

3. 实体类中增加@KeySequence和@TableId注解

@KeySequence(value = “SEQ_LOAN_ORDER”, dbType = DbType.ORACLE)用于指定sequence和dbType
@TableId(value = “ID”)指定主键映射字段

@TableName("LOAN_ORDER")
@KeySequence(value = "SEQ_LOAN_ORDER", dbType = DbType.ORACLE)
public class LoanOrder implements Serializable {

    private static final long serialVersionUID = 1L;

    @TableId(value = "ID")
    private Long id;
    private String orderNo;
    ...
    
}

注：mybatisplus版本不同，使用上稍有不同，此处使用的依赖版本mybatisplus为3.5.2。