|
Hibernate 一对一外键双向关联 |
|
|
|
|
|
一、模型介绍 |
|
|
|
|
|
一个人(Person)对应一个地址(Address)。 |
|
|
|
|
|
二、实体(省略getter、setter方法) |
|
|
|
|
|
public class Person11fk_sx { |
|
|
private int personid; |
|
|
private String name; |
|
|
private int age; |
|
|
private Address11fk_sx address11fk_sx; |
|
|
|
|
|
public class Address11fk_sx { |
|
|
private int addressid; |
|
|
private String addressdetail; |
|
|
private Person11fk_sx person11fk_sx; |
|
|
|
|
|
三、表模型 |
|
|
|
|
|
mysql> desc person_11fk_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_11fk_sx; |
|
|
+---------------+--------------+------+-----+---------+----------------+ |
|
|
| Field | Type | Null | Key | Default | Extra | |
|
|
+---------------+--------------+------+-----+---------+----------------+ |
|
|
| addressid | int(11) | NO | PRI | NULL | auto_increment | |
|
|
| addressdetail | varchar(255) | YES | | NULL | | |
|
|
| person11fk_sx | int(11) | YES | UNI | NULL | | |
|
|
+---------------+--------------+------+-----+---------+----------------+ |
|
|
|
|
|
四、生成的SQL脚本 |
|
|
|
|
|
/* Formatted on 2007/08/22 17:15 (QP5 v5.50) */ |
|
|
CREATE TABLE `address_11fk_sx` ( |
|
|
`addressid` int(11) NOT NULL auto_increment, |
|
|
`addressdetail` varchar(255) default NULL, |
|
|
`person11fk_sx` int(11) default NULL, |
|
|
PRIMARY KEY (`addressid`), |
|
|
UNIQUE KEY `person11fk_sx` (`person11fk_sx`), |
|
|
KEY `FKF05FC94AAD732F4` (`person11fk_sx`), |
|
|
CONSTRAINT `FKF05FC94AAD732F4` FOREIGN KEY (`person11fk_sx`) REFERENCES `person_11fk_sx` (`personid`) |
|
|
) ENGINE=InnoDB DEFAULT CHARSET=gbk; |
|
|
|
|
|
/* Formatted on 2007/08/22 17:16 (QP5 v5.50) */ |
|
|
CREATE TABLE `person_11fk_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; |
|
|
|
|
|
五、映射方法 |
|
|
|
|
|
<hibernate-mapping> |
|
|
<class name="com.lavasoft.sx._1_1_fk.Person11fk_sx" table="PERSON_11fk_sx"> |
|
|
<id name="personid"> |
|
|
<generator class="identity"/> |
|
|
</id> |
|
|
<property name="name"/> |
|
|
<property name="age"/> |
|
|
<one-to-one name="address11fk_sx" |
|
|
cascade="all" |
|
|
property-ref="person11fk_sx"/> |
|
|
</class> |
|
|
</hibernate-mapping> |
|
|
|
|
|
<hibernate-mapping> |
|
|
<class name="com.lavasoft.sx._1_1_fk.Address11fk_sx" table="ADDRESS_11fk_sx"> |
|
|
<id name="addressid"> |
|
|
<generator class="identity"/> |
|
|
</id> |
|
|
<property name="addressdetail"/> |
|
|
<!--unique="true"表示本实体是"1"--> |
|
|
<many-to-one name="person11fk_sx" unique="true"/> |
|
|
</class> |
|
|
</hibernate-mapping> |
|
|
|
|
|
六、测试方法 |
|
|
|
|
|
public class Test_11fk_sx { |
|
|
public static void main(String[] args) { |
|
|
Address11fk_sx add = new Address11fk_sx(); |
|
|
Person11fk_sx p = new Person11fk_sx(); |
|
|
|
|
|
add.setAddressdetail("郑州市经三路"); |
|
|
p.setAge(12); |
|
|
p.setName("wudalang"); |
|
|
|
|
|
add.setPerson11fk_sx(p); |
|
|
p.setAddress11fk_sx(add); |
|
|
|
|
|
Session session = HibernateUtil.getCurrentSession(); |
|
|
Transaction tx = session.beginTransaction(); |
|
|
session.save(p); |
|
|
tx.commit(); |
|
|
HibernateUtil.closeSession(); |
|
|
} |
|
|
} |
|
|
|
|
|
七、测试结果 |
|
|
|
|
|
1) :正常保存. |
|
|
session.save(p); |
|
|
|
|
|
Hibernate: insert into PERSON_11fk_sx (name, age) values (?, ?) |
|
|
Hibernate: insert into ADDRESS_11fk_sx (addressdetail, person11fk_sx) values (?, ?) |
|
|
|
|
|
|
|