一对一双向关联,可以从任何一方获取对方。
参考自熔岩博客:http://lavasoft.blog.51cto.com/62575/39335
Address11tab_sx.java
private int addressId;
private String detailAddress;
private Person11tab_sx person11tab_sx;
Person11tab_sx.java
private int personId;
private String personName;
private int age;
private Address11tab_sx Address11tab_sx;
双方互相引用
表结构:
-- 一对一双向关联人员表
DROP TABLE IF EXISTS person_11tab_sx;
CREATE TABLE person_11tab_sx (
person_id int(11) PRIMARY KEY auto_increment,
person_name varchar(20),
age int(3)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 一对一双向关联家庭住址表
DROP TABLE IF EXISTS address_11tab_sx;
CREATE TABLE address_11tab_sx (
address_id int(11) PRIMARY KEY auto_increment,
detail_address varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 为 一对一单向关联的中间表 增加外键
ALTER TABLE join_11tab_sx ADD CONSTRAINT fk_join_11tab_sx_person FOREIGN KEY(person_id) REFERENCES person_11tab_sx(person_id);
ALTER TABLE join_11tab_sx ADD CONSTRAINT fk_join_11tab_sx_address FOREIGN KEY(address_id) REFERENCES address_11tab_sx(address_id);
-- SELECT * FROM person_11tab_sx;
-- SELECT * FROM address_11tab_sx;
-- SELECT * FROM join_11tab_sx;
这个表结构同
Hibernate之对象关系映射01一对一单向关联,表结构是一样的,都是利用中间表存储,不同在于实体类对象可相互引用。
Address11tab_sx.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.ack.hibernate.hibernateMapping.entity.Address11tab_sx" table="address_11tab_sx">
<id name="addressId" column="address_id">
<generator class="identity"/>
</id>
<property name="detailAddress" column="detail_address"/>
<join table="join_11tab_sx" optional="true" inverse="true">
<key column="address_id" unique="true"/>
<!--其中unique=“true”属性,将多对一确定为“1-1”-->
<many-to-one name="person11tab_sx"
column="person_id"
not-null="true"
unique="true"/>
</join>
</class>
</hibernate-mapping>
Person11tab_sx.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.ack.hibernate.hibernateMapping.entity.Person11tab_sx" table="person_11tab_sx">
<id name="personId" column="person_id">
<generator class="identity"/>
</id>
<property name="personName" column="person_name"/>
<property name="age"/>
<!--使用join元素显式确定连接表-->
<join table="join_11tab_sx" optional="true">
<key column="person_id" unique="true"/>
<!--其中unique=“true”属性,将多对一确定为“1-1”-->
<many-to-one name="address11tab_sx"
column="address_id"
not-null="true"
unique="true"/>
</join>
</class>
</hibernate-mapping>
测试类:
public class Test_pa_11tab_sx {
public static void main(String[] args) {
Person11tab_sx p1 = new Person11tab_sx();
p1.setPersonName("陈三");
Address11tab_sx add1 = new Address11tab_sx();
add1.setDetailAddress("丽水市莲都区");
p1.setAddress11tab_sx(add1);
add1.setPerson11tab_sx(p1);
Session session = HibernateUtil.getCurrentSession();
session.beginTransaction();
session.save(p1);
session.save(add1);
session.getTransaction().commit();
}
}
此测试类中也要相互引用。
先save p1,再save add1,sql语句如下:
insert into person_11tab_sx(person_name, age) values(?, ?)
insert into address_11tab_sx(detail_address) values(?)
insert into join_11tab_sx(address_id, person_id) values(?, ?)
先save add1,再save p1,sql语句如下:
insert into address_11tab_sx(detail_address) values(?)
insert into person_11tab_sx(person_name, age) values(?, ?)
insert into join_11tab_sx(address_id, person_id) values(?, ?)
只save一个都会报错:org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing,因为它们相互引用没法获取对方。