Skip to content

sequence.md

Latest commit

 

History

History
78 lines (55 loc) · 1.75 KB

sequence.md

File metadata and controls

78 lines (55 loc) · 1.75 KB

Sequence主键

实体主键支持Sequence @since 2.0.8

  • oracle主键策略配置Sequence
  • GlobalConfiguration配置KeyGenerator
  GlobalConfiguration gc = new GlobalConfiguration();
  //gc.setDbType("oracle");//不需要这么配置了，自动获取数据库类型
  gc.setKeyGenerator(new OracleKeyGenerator());
mybatis-plus:
  global-config:
    key-generator: com.baomidou.mybatisplus.incrementer.OracleKeyGenerator
  • 实体类配置主键Sequence,指定主键@TableId(type=IdType.INPUT)//不能使用AUTO
@TableName("TEST_SEQUSER")
@KeySequence("SEQ_TEST")//类注解
public class TestSequser{
  @TableId(value = "ID", type = IdType.INPUT)
  private Long id;

}
  • 支持父类定义@KeySequence, 子类使用，这样就可以几个表共用一个Sequence
@KeySequence("SEQ_TEST")
public abstract class Parent{

}

public class Child extends Parent{

}

以上步骤就可以使用Sequence当主键了。

Spring MVC：xml配置，请参考【安装集成】

如何使用Sequence作为主键，但是实体主键类型是String

也就是说，表的主键是varchar2, 但是需要从sequence中取值

  • 1.实体定义@KeySequence 注解clazz指定类型String.class
  • 2.实体定义主键的类型String
@KeySequence(value = "SEQ_ORACLE_STRING_KEY", clazz = String.class)
public class YourEntity{
    
    @TableId(value = "ID_STR", type = IdType.INPUT)
    private String idStr;
    ...
}
  • 3.正常配置GlobalConfiguration.keyGenerator
@Bean
public GlobalConfiguration globalConfiguration() {
    GlobalConfiguration conf = new GlobalConfiguration();
    conf.setKeyGenerator(new OracleKeyGenerator());
    return conf;
}