设计人和身份证的关系的时候,也可以使用外键维护他们的关系,只不过这样的话多个身份证可以引用一个身份证,就会造成多对一这种情况,我们可以把多对一增加一个unique=“true",这样的话就可以变成一对一关系了。基于外键的一对一关系,idcard的主键不再由person帮他生成,他有自己的主键生成策略。
sql语句:
create table person(
id number(10) primary key,
name varchar2(20)
)
create table idcard(
id number(10) primary key ,
describe varchar2(20),
personid number(10) ,
constraint fk_idcard_personid foreign key(personid) references person(id)
)
配置文件
Person.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.shizhan.po.Person" table="PERSON" schema="SCOTT">
<id name="id" type="java.lang.Long">
<column name="ID" precision="10" scale="0" />
<generator class="native" />
</id>
<property name="name" type="java.lang.String">
<column name="name" length="20" />
</property>
<one-to-one name="idCard" cascade="all" property-ref="person"/>
</class>
</hibernate-mapping>
IdCard.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.shizhan.po.IdCard" table="IDCARD" schema="SCOTT">
<id name="id" type="java.lang.Long">
<column name="ID" precision="10" scale="0" />
<!-- 主键自己生成 -->
<generator class="native" />
</id>
<property name="describe" type="java.lang.String">
<column name="DESCRIBE" length="20" />
</property>
<many-to-one name="person" unique="true" column="personid" />
</class>
</hibernate-mapping>
Person类:
package com.shizhan.po;
public class Person {
private Long id ;
private String name;
private IdCard idCard;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public IdCard getIdCard() {
return idCard;
}
public void setIdCard(IdCard idCard) {
this.idCard = idCard;
}
}
IdCard类:
package com.shizhan.po;
public class IdCard {
private Long id ;
private String describe;
private Person person;
public Person getPerson() {
return person;
}
public void setPerson(Person person) {
this.person = person;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getDescribe() {
return describe;
}
public void setDescribe(String describe) {
this.describe = describe;
}
}
测试:
package com.shizhan.test;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.shizhan.po.IdCard;
import com.shizhan.po.Person;
import com.shizhan.util.DBUtil;
public class Test {
public static void main(String[] args) {
Session session = DBUtil.getSession();
Transaction tx = session.beginTransaction();
IdCard idCard = new IdCard();
idCard.setDescribe("xxxx");
Person person = new Person();
person.setName("shizhan");
person.setIdCard(idCard);
//得告诉idcard,他的主对象是谁,否则会出错
idCard.setPerson(person);
session.save(person);
tx.commit();
session.close();
}
}