|
Hibernate 一对一主键双向关联 |
|
|
|
一、模型介绍 |
|
|
|
一个人(Person)对应一个地址(Address)。 |
|
|
|
二、实体(省略getter、setter方法) |
|
|
|
public class Person11pk_sx { |
|
private int personid; |
|
private String name; |
|
private int age; |
|
private Address11pk_sx address11pk_sx; |
|
|
|
public class Address11pk_sx { |
|
private int addressid; |
|
private String addressdetail; |
|
private Person11pk_sx person11pk_sx; |
|
|
|
三、表模型 |
|
|
|
mysql> desc person_11pk_sx; |
|
+----------+--------------+------+-----+---------+----------------+ |
|
| 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 address_11pk_sx; |
|
+---------------+--------------+------+-----+---------+-------+ |
|
| Field | Type | Null | Key | Default | Extra | |
|
+---------------+--------------+------+-----+---------+-------+ |
|
| addressid | int(11) | NO | PRI | | | |
|
| addressdetail | varchar(255) | YES | | NULL | | |
|
+---------------+--------------+------+-----+---------+-------+ |
|
|
|
四、生成的SQL脚本 |
|
|
|
/* Formatted on 2007/08/22 17:28 (QP5 v5.50) */ |
|
CREATE TABLE `person_11pk_sx` ( |
|
`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:28 (QP5 v5.50) */ |
|
CREATE TABLE `address_11pk_sx` ( |
|
`addressid` int(11) NOT NULL, |
|
`addressdetail` varchar(255) default NULL, |
|
PRIMARY KEY (`addressid`), |
|
KEY `FKF92E79EDC0D17B9` (`addressid`), |
|
CONSTRAINT `FKF92E79EDC0D17B9` FOREIGN KEY (`addressid`) REFERENCES `person_11pk_sx` (`personid`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=gbk; |
|
|
|
五、映射方法 |
|
|
|
<hibernate-mapping> |
|
<class name="com.lavasoft.sx._1_1_pk.Person11pk_sx" table="PERSON_11pk_sx"> |
|
<id name="personid"> |
|
<generator class="identity"/> |
|
</id> |
|
<property name="name"/> |
|
<property name="age"/> |
|
<one-to-one name="address11pk_sx" cascade="all"/> |
|
</class> |
|
</hibernate-mapping> |
|
|
|
<hibernate-mapping> |
|
<class name="com.lavasoft.sx._1_1_pk.Address11pk_sx" table="ADDRESS_11pk_sx"> |
|
<id name="addressid"> |
|
<generator class="foreign"> |
|
<param name="property">person11pk_sx</param> |
|
</generator> |
|
</id> |
|
<property name="addressdetail"/> |
|
<!--表明主键由关联属性生成--> |
|
<one-to-one name="person11pk_sx" cascade="all" constrained="true"/> |
|
</class> |
|
</hibernate-mapping> |
|
|
|
六、测试方法 |
|
|
|
public class Test_11pk_sx { |
|
public static void main(String[] args){ |
|
Address11pk_sx add = new Address11pk_sx(); |
|
Person11pk_sx p = new Person11pk_sx(); |
|
|
|
add.setAddressdetail("郑州市经三路"); |
|
p.setAge(12); |
|
p.setName("wudalang"); |
|
|
|
add.setPerson11pk_sx(p); |
|
p.setAddress11pk_sx(add); |
|
|
|
Session session = HibernateUtil.getCurrentSession(); |
|
Transaction tx = session.beginTransaction(); |
|
session.save(p); |
|
// session.save(add); |
|
tx.commit(); |
|
HibernateUtil.closeSession(); |
|
} |
|
} |
|
|
|
七、测试结果 |
|
|
|
1) :正常保存. |
|
session.save(p); |
|
// session.save(add); |
|
|
|
Hibernate: insert into PERSON_11pk_sx (name, age) values (?, ?) |
|
Hibernate: insert into ADDRESS_11pk_sx (addressdetail, addressid) values (?, ?) |
|
|
|
|