Hibernate关联之 一对一连接表双向关联

Hibernate 一对一连接表双向关联

一、模型介绍

一个人（Person）对应一个地址（Address）。

二、实体（省略getter、setter方法）

public class Person11tabboth {

private int personid;

private String name;

private int age;

private Address11tabboth address11tabboth;

public class Address11tabboth{

private int addressid;

private String addressdetail;

private Person11tabboth  person11tabboth;

三、表模型

mysql> desc person_11tabboth;

+----------+--------------+------+-----+---------+----------------+

| Field    | Type         | Null | Key | Default | Extra          |

+----------+--------------+------+-----+---------+----------------+

| personid | int(11)      | NO   | PRI | NULL    | auto_increment |

| name     | varchar(255) | YES  |     | NULL    |                |

| age      | int(11)      | YES  |     | NULL    |                |

+----------+--------------+------+-----+---------+----------------+   mysql> desc join_11tabboth; +-----------+---------+------+-----+---------+-------+ | Field     | Type    | Null | Key | Default | Extra | +-----------+---------+------+-----+---------+-------+ | addressid | int(11) | NO   | UNI |         |       | | personid  | int(11) | NO   | PRI |         |       | +-----------+---------+------+-----+---------+-------+

mysql> desc address_11tabboth;

+---------------+--------------+------+-----+---------+----------------+

| Field         | Type         | Null | Key | Default | Extra          |

+---------------+--------------+------+-----+---------+----------------+

| addressid     | int(11)      | NO   | PRI | NULL    | auto_increment |

| addressdetail | varchar(255) | YES  |     | NULL    |                |

+---------------+--------------+------+-----+---------+----------------+

四、生成的SQL脚本

/* Formatted on 2007/08/22 17:35 (QP5 v5.50) */

CREATE TABLE `person_11tabboth` (

`personid` int(11) NOT NULL auto_increment,

`name` varchar(255) default NULL,

`age` int(11) default NULL,

PRIMARY KEY  (`personid`)

) ENGINE=InnoDB DEFAULT CHARSET=gbk;

/* Formatted on 2007/08/22 17:34 (QP5 v5.50) */

CREATE TABLE `address_11tabboth` (

`addressid` int(11) NOT NULL auto_increment,

`addressdetail` varchar(255) default NULL,

PRIMARY KEY  (`addressid`)

) ENGINE=InnoDB DEFAULT CHARSET=gbk;   /* Formatted on 2007/08/22 18:35 (QP5 v5.50) */ CREATE TABLE `join_11tabboth` (   `addressid` int(11) NOT NULL,   `personid` int(11) NOT NULL,   PRIMARY KEY  (`personid`),   UNIQUE KEY `addressid` (`addressid`),   UNIQUE KEY `personid` (`personid`),   KEY `FKF4AA80E44327AAB6` (`personid`),   KEY `FKF4AA80E460C0C9F0` (`addressid`),   CONSTRAINT `FKF4AA80E460C0C9F0` FOREIGN KEY (`addressid`) REFERENCES `address_11tab_sx` (`addressid`),   CONSTRAINT `FKF4AA80E44327AAB6` FOREIGN KEY (`personid`) REFERENCES `person_11tab_sx` (`personid`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk;

五、映射方法

OneToOneTabBothPerson.hbm.xml <hibernate-mapping> <class name="com.bean.Person11tabboth" table="PERSON_11tabboth"> <id name="personid"> <generator class="identity"/> </id> <property name="name"/> <property name="age"/> <join table="join_11tabboth" optional="true"> <key column="personid" unique="true"/> <many-to-one name="address11tabboth" column="addressid" not-null="true" unique="true"/> </join> </class> </hibernate-mapping> OneToOneTabBothAddress.hbm.xml <hibernate-mapping> <class name="com.bean.Address11tabboth" table="ADDRESS_11tabboth"> <id name="addressid"> <generator class="identity"/> </id> <property name="addressdetail"/> <join table="join_11tabboth" inverse="true" optional="true" > <key column="addressid" unique="true"/> <many-to-one name="person11tabboth" column="personid" not-null="true" unique="true"/> </join> </class> </hibernate-mapping> 六、测试 public class Test_11tabboth { @Test public void test_11tabboth(){ Address11tabboth add = new Address11tabboth(); add.setAddressdetail("天津市南开区"); Person11tabboth p = new Person11tabboth(); p.setName("cy"); p.setAge(26); add.setPerson11tabboth(p); p.setAddress11tabboth(add); Session session = HibernateUtil.getCurrentSession(); Transaction tx = session.beginTransaction(); session.saveOrUpdate(p); session.saveOrUpdate(add); tx.commit(); HibernateUtil.closeSession(); } }