java - 在hibernate中定义唯一键

Question

我的项目中有三个模型。

 public class Bank{
   private int id;
   private String title;
   ....
}
public class Branch{
   private Bank bank;
   private int id;
   private String title;
   ....
}
public class Account{
   private Branch branch;
   private int id;
   private String accountNumber;
   private String title;
   ....
}

如何定义 accountNumber 和银行 id 组合为唯一键？

Answer 1

对于复合唯一键，您可以使用@Table注释的uniqueConstraints属性:

@Table(
    name = "account",
    uniqueConstraints = {@UniqueConstraint(columnNames = {"accountNumber", "bank"})}
)
public class Account{
    private Branch branch;
    private int id;
    private String accountNumber;
    private String title;
    @ManyToOne
    private Bank bank;
}