Hibernate之对象关系映射04一对一双向关联

一对一双向关联，可以从任何一方获取对方。

参考自熔岩博客：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，因为它们相互引用没法获取对方。