一对一双向主键关联,一方的主键关联另一方,实体间可以相互引用。
Person11pk_sx.java
private int personId;
private String personName;
private int age;
private Address11pk_sx Address11pk_sx;
Address11pk_sx.java
private int addressId;
private String detailAddress;
private Person11pk_sx person11pk_sx;
表结构:
-- 一对一双向主键 地址表,address_id主键关联person_11pk_sx的person_id;
DROP TABLE IF EXISTS address_11pk_sx;
CREATE TABLE address_11pk_sx (
address_id int(11) PRIMARY KEY,
detail_address varchar(255)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 一对一双向主键 人员表
DROP TABLE IF EXISTS person_11pk_sx;
CREATE TABLE person_11pk_sx (
person_id integer PRIMARY KEY auto_increment,
person_name varchar(24) not null comment '姓名',
age int(3)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE address_11pk_sx add constraint fk_11pk_sx_address FOREIGN KEY(address_id) REFERENCES person_11pk_sx(person_id);
-- SELECT * FROM person_11pk_sx;
-- SELECT * FROM address_11pk_sx;
Person11pk_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.hibernateMapping.entity.Person11pk_sx" table="person_11pk_sx">
<id name="personId" column="person_id">
<generator class="identity"/>
</id>
<property name="personName">
<column name="person_name" length="24" not-null="true">
<comment>姓名</comment>
</column>
</property>
<property name="age"/>
<!-- cascade="all":在保存person对象的时候,级联保存person对象关联的address对象 -->
<one-to-one name="Address11pk_sx" cascade="all"/>
</class>
</hibernate-mapping>
Address11pk_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.hibernateMapping.entity.Address11pk_sx" table="address_11pk_sx">
<id name="addressId" column="address_id">
<generator class="foreign">
<param name="property">person11pk_sx</param>
</generator>
</id>
<property name="detailAddress" column="detail_address"/>
<!-- 表示在address表存在一个外键约束,外键参考相关联的表person -->
<one-to-one name="person11pk_sx" constrained="true" />
</class>
</hibernate-mapping>
测试类:
public class Test_pa_11pk_sx {
public static void main(String[] args) {
Person11pk_sx p1 = new Person11pk_sx();
p1.setPersonName("陈三");
Address11pk_sx add1 = new Address11pk_sx();
add1.setDetailAddress("丽水市莲都区");
p1.setAddress11pk_sx(add1);
add1.setPerson11pk_sx(p1);
Session session = HibernateUtil.getCurrentSession();
session.beginTransaction();
session.save(add1);
session.save(p1);
session.getTransaction().commit();
}
}
先save p1,再save add1,sql语句如下:
insert into person_11pk_sx(person_name, age) values(?, ?)
insert into address_11pk_sx(detail_address, address_id) values(?, ?)
先save add1,再save p1,sql语句如下:
insert into person_11pk_sx(person_name, age) values(?, ?)
insert into address_11pk_sx(detail_address, address_id) values(?, ?)
只save p1,sql语句如下:
insert into person_11pk_sx(person_name, age) values(?, ?)
insert into address_11pk_sx(detail_address, address_id) values(?, ?)
只save add1,sql语句如下:
insert into person_11pk_sx(person_name, age) values(?, ?)
insert into address_11pk_sx(detail_address, address_id) values(?, ?)
新增一条记录,则对方也会新增一条;