1 创建sequence序列
create sequence SEQ_ORA_INTEGER_KEY
minvalue 1
maxvalue 99999999
start with 1
increment by 1
cache 50
cycle;
2 注入oracle序列生成器
@Configuration
public class MybatisPlusConfig {
@Bean
public IKeyGenerator keyGenerator() {
return new OracleKeyGenerator();
}
}
3 在entity中加入@KeySequence
注解
@Data
@TableName("SHENCE_MC_JOB")
@KeySequence(value = "SEQ_ORA_INTEGER_KEY")
public class ShenCeMcJob {
@TableId(value = "id")
private Integer id;
private Long tableId;
private String tableName;
@TableLogic
private String isValid;
private Date createdDate;
private Date modifiedDate;
private String createdBy;
private String modifiedBy;
}