如何在JPA中动态创建序列生成器？复用Counter类动态传入序列名

方案1：实体继承+注解覆盖复用结构 #

创建抽象父类定义通用的ID生成逻辑，子类通过重写注解参数指定不同序列名，实现类结构复用：

// 抽象父类，定义通用结构
public abstract class BaseCounter {
    @Id
    @GeneratedValue(generator = "sequence-generator")
    private Long counter;

    public Long getCounter() {
        return counter;
    }

    public void setCounter(Long counter) {
        this.counter = counter;
    }
}

// 订单序列专属子类
@Entity
@GenericGenerator(
    name = "sequence-generator",
    strategy = "org.hibernate.id.enhanced.SequenceStyleGenerator",
    parameters = {
        @Parameter(name = "sequence_name", value = "order_sequence"),
        @Parameter(name = "initial_value", value = "1"),
        @Parameter(name = "increment_size", value = "1")
    }
)
public class OrderCounter extends BaseCounter {}

// 用户序列专属子类
@Entity
@GenericGenerator(
    name = "sequence-generator",
    strategy = "org.hibernate.id.enhanced.SequenceStyleGenerator",
    parameters = {
        @Parameter(name = "sequence_name", value = "user_sequence"),
        @Parameter(name = "initial_value", value = "1"),
        @Parameter(name = "increment_size", value = "1")
    }
)
public class UserCounter extends BaseCounter {}

需要新增序列时，仅需创建继承自BaseCounter的子类并修改sequence_name参数即可。

方案2：自定义动态序列生成器（运行时灵活指定） #

如果需要在运行时动态切换序列名，可以自定义实现Hibernate的IdentifierGenerator接口：

1. 编写自定义生成器类

public class DynamicSequenceGenerator extends SequenceStyleGenerator {
    @Override
    public void configure(Type type, Properties params, ServiceRegistry serviceRegistry) throws MappingException {
        // 从参数中读取动态序列名，可扩展为从实体注解/上下文获取
        String dynamicSeqName = params.getProperty("dynamic_seq_name");
        if (dynamicSeqName != null) {
            params.setProperty("sequence_name", dynamicSeqName);
        }
        super.configure(type, params, serviceRegistry);
    }
}

2. 修改Counter类使用自定义生成器

@Entity
public class Counter {
    @Id
    @GeneratedValue(generator = "dynamic-seq-generator")
    @GenericGenerator(
        name = "dynamic-seq-generator",
        strategy = "com.yourpackage.DynamicSequenceGenerator",
        parameters = {
            @Parameter(name = "initial_value", value = "1"),
            @Parameter(name = "increment_size", value = "1"),
            // 可通过SpEL或自定义规则动态指定序列名，示例：按实体名生成
            @Parameter(name = "dynamic_seq_name", value = "#entityName.toLowerCase() + '_sequence'")
        }
    )
    private Long counter;

    // getter、setter方法
}

方案3：JPA标准注解的动态命名复用 #

利用JPA的@SequenceGenerator注解覆盖机制，通过父类定义通用生成逻辑，子类指定序列名：

@MappedSuperclass
public abstract class BaseCounter {
    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "counter-generator")
    private Long counter;

    public Long getCounter() {
        return counter;
    }

    public void setCounter(Long counter) {
        this.counter = counter;
    }
}

@Entity
@SequenceGenerator(
    name = "counter-generator",
    sequenceName = "order_sequence",
    initialValue = 1,
    allocationSize = 1
)
public class OrderCounter extends BaseCounter {}

@Entity
@SequenceGenerator(
    name = "counter-generator",
    sequenceName = "goods_sequence",
    initialValue = 1,
    allocationSize = 1
)
public class GoodsCounter extends BaseCounter {}

内容的提问来源于stack exchange，提问作者user352290