一对一双向外键关联(Annotation方法):
一夫(Husband)一妻(Wife)的一对一双向外键关联
Husband和Wife实体类:
生成的建表语句:
alter table Husband
drop
foreign key FKAEEA401BC6294CED
alter table Wife
drop
foreign key FK29233185D75BEA
drop table if exists Husband
drop table if exists Wife
create table Husband (
id integer not null auto_increment,
name varchar(255),
wifeid integer,
primary key (id)
)
create table Wife (
id integer not null auto_increment,
name varchar(255),
husband_id integer,
primary key (id)
)
alter table Husband
add index FKAEEA401BC6294CED (wifeid),
add constraint FKAEEA401BC6294CED
foreign key (wifeid)
references Wife (id)
alter table Wife
add index FK29233185D75BEA (husband_id),
add constraint FK29233185D75BEA
foreign key (husband_id)
references Husband (id)
双向关联在数据库中只需一边设置外键就行了,所以wife的husband_id就可以不要
mappedBy="wife"告诉hibernate,Wife和husband之间是一个1对1的关联,
对方husband类的wife属性已经做映射了,你就不用管我生成的外键的关联了
对方那边是主导,你不用管我这边的设置
这个时候wife建表语句中就没有husband_id属性了
凡是双向关联必设mappedBy
所以wife实体类注解写成:
@OneToOne(mappedBy="wife")
public Husband getHusband() {
return husband;
}
一夫(Husband)一妻(Wife)的一对一双向外键关联
Husband和Wife实体类:
package cn.edu.hpu.one2one; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.OneToOne; @Entity public class Husband { private int id; private String name; private Wife wife; @Id @GeneratedValue public int getId() { return id; } public void setId(int id) { this.id = id; } @OneToOne @JoinColumn(name="wifeid") public Wife getWife() { return wife; } public void setWife(Wife wife) { this.wife = wife; } public String getName() { return name; } public void setName(String name) { this.name = name; } }
package cn.edu.hpu.one2one; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.OneToOne; @Entity public class Wife { private int id; private String name; private Husband husband; @Id @GeneratedValue public int getId() { return id; } public void setId(int id) { this.id = id; } @OneToOne public Husband getHusband() { return husband; } public void setHusband(Husband husband) { this.husband = husband; } public String getName() { return name; } public void setName(String name) { this.name = name; } }
生成的建表语句:
alter table Husband
drop
foreign key FKAEEA401BC6294CED
alter table Wife
drop
foreign key FK29233185D75BEA
drop table if exists Husband
drop table if exists Wife
create table Husband (
id integer not null auto_increment,
name varchar(255),
wifeid integer,
primary key (id)
)
create table Wife (
id integer not null auto_increment,
name varchar(255),
husband_id integer,
primary key (id)
)
alter table Husband
add index FKAEEA401BC6294CED (wifeid),
add constraint FKAEEA401BC6294CED
foreign key (wifeid)
references Wife (id)
alter table Wife
add index FK29233185D75BEA (husband_id),
add constraint FK29233185D75BEA
foreign key (husband_id)
references Husband (id)
双向关联在数据库中只需一边设置外键就行了,所以wife的husband_id就可以不要
mappedBy="wife"告诉hibernate,Wife和husband之间是一个1对1的关联,
对方husband类的wife属性已经做映射了,你就不用管我生成的外键的关联了
对方那边是主导,你不用管我这边的设置
这个时候wife建表语句中就没有husband_id属性了
凡是双向关联必设mappedBy
所以wife实体类注解写成:
@OneToOne(mappedBy="wife")
public Husband getHusband() {
return husband;
}
生成的表中wife就没有husband_id字段了
转载请注明出处:http://blog.csdn.net/acmman