联合主键关联就是被关联类的多个属性联合作为主键,而关联类中从数据库表级别的映射关系来看,也有多个外键作为联合主键来关联被关联的对象。
首先做一个主键类(WifePK.java):
public class WifePK implements Serializable{
private int id;
private String name;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
注意:联合主键类必须要实现Serializable接口,一般要重写hashCode和equals方法,如果不实现这个接口,也可以正常生产数据库,但是,我们在数据库总做CRUD操作的时候,就会报错。
然后就是我们的实体类(Wife.java):
@Entity
@IdClass(WifePK.class)
public class Wife {
private int id;
private String name;
private int age;
@Id
public int getId() {
return id;
}
@Id
public String getName() {
return name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public void setId(int id) {
this.id = id;
}
public void setName(String name) {
this.name = name;
}
}
在Wife类头部,我们通过@IdClass这个标识来制定所使用的主键类是哪个类。
最后就是我们的Husband.java类:
@Entity
public class Husband {
private int id;
private String name;
private Wife wife;
@Id
@GeneratedValue
public int getId() {
return id;
}
@OneToOne
@JoinColumns({
@JoinColumn(name="wifeid",referencedColumnName="id"),
@JoinColumn(name="wifename",referencedColumnName="name")
})
public Wife getWife() {
return wife;
}
public void setWife(Wife wife) {
this.wife = wife;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
在Husband中,我们通过@OnetoOne来指定这是一个一对一关联,然后通过@JoinColumns来制定联合主键所对应的联合外键在Husband数据表中是如何关联的。测试生成的数据库语句如下所示:
09:22:09,987 DEBUG SchemaExport:377 -
create table Husband (
id integer not null auto_increment,
name varchar(255),
wifeid integer,
wifename varchar(255),
primary key (id)
)
09:22:10,130 DEBUG SchemaExport:377 -
create table Wife (
id integer not null,
name varchar(255) not null,
age integer not null,
primary key (id, name)
)
09:22:10,177 DEBUG SchemaExport:377 -
alter table Husband
add index FKAEEA401B4E7D3B35 (wifeid, wifename),
add constraint FKAEEA401B4E7D3B35
foreign key (wifeid, wifename)
references Wife (id, name)
09:22:10,400 INFO SchemaExport:268 - schema export complete
如上代码所示:在Husband表中添加了wifeid,wifename作为外键关联到wife表中的联合主键。