一对一双向外键联合主键(annotation方式)

主键类

package org.hibernate.tutorial.domain;


public class WifePK implements Serializable {
private int id;
private String name;

public int getId() {
return id;
}
public String getName() {
return name;
}
public void setId(int id) {
this.id = id;
}
public void setName(String name) {
this.name = name;
}

}



设置对象主键


@Entity
@IdClass(WifePK.class)
public class Wife {
private int id;
private String name;
private String age;


@Id
public int getId() {
return id;
}
public String getName() {
return name;
}
public void setId(int id) {
this.id = id;
}
@Id
public void setName(String name) {
this.name = name;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}

}



设置关联

@Entity
public class Husband {
private int id;
private String name;
private Wife wife;
@Id
@GeneratedValue
public int getId() {
return id;
}
public String getName() {
return name;
}

@OneToOne
@JoinColumns(
{
@JoinColumn(name="wifeId",referencedColumnName="id"),
@JoinColumn(name="wifeName",referencedColumnName="name")
}
)
public Wife getWife() {
return wife;
}
public void setId(int id) {
this.id = id;
}
public void setName(String name) {
this.name = name;
}
public void setWife(Wife wife) {
this.wife = wife;
}

}




hibernate.hb.xml配置和测试
[quote]
<mapping class="org.hibernate.tutorial.domain.Husband"/>
<mapping class="org.hibernate.tutorial.domain.Wife"/> [/quote]

public class OneToOneORMappingTest {
public static void main(String[] args) {
new SchemaExport(new AnnotationConfiguration().configure("/hibernate.cfg.xml")).create(true, false);
}
}


结果

alter table Husband
drop
foreign key FK_sdshifqwgidsm93jdh5kfl0e4

drop table if exists Husband

drop table if exists Wife

create table Husband (
id integer not null auto_increment,
name varchar(255),
wifeId integer,
wifeName varchar(255),
primary key (id)
)

create table Wife (
id integer not null,
name varchar(255) not null,
age varchar(255),
primary key (id, name)
)

alter table Husband
add index FK_sdshifqwgidsm93jdh5kfl0e4 (wifeId, wifeName),
add constraint FK_sdshifqwgidsm93jdh5kfl0e4
foreign key (wifeId, wifeName)
references Wife (id, name)
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值