1.新建两个POJO类
Member.java
package com.mxl.onetoone;
public class Member {
private int id;
private String name;
private int age;
private IdCard card;
//省去setter,getter
}
IdCard.java
package com.mxl.onetoone;
public class IdCard {
private int id;
private String num;
private Member member;
//省去setter,getter
}
2.在src下新建hibernate的主配置文件,名为hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- 数据库驱动jar包 -->
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<!-- 连接数据库的URL -->
<property name="connection.url">jdbc:mysql:///test</property>
<!-- 连接数据库的用户名 -->
<property name="connection.username">root</property>
<!-- 连接数据库的密码 -->
<property name="connection.password">123456</property>
<!-- 将SQL语句打印到控制台 -->
<property name="show_sql">true</property>
<!-- 连接池个数 -->
<property name="connection.pool_size">1</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<mapping resource="com/mxl/onetoone/IdCard.hbm.xml"/>
<mapping resource="com/mxl/onetoone/Member.hbm.xml"/>
</session-factory>
</hibernate-configuration>
3.新建一个名为Member.hbm.xml的xml的文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.mxl.onetoone">
<class name="Member" table="member">
<id name="id" column="id">
<!-- id值由数据库自动生成 -->
<generator class="native"></generator>
</id>
<property name="age" column="age"></property>
<property name="name" column="name"/>
<one-to-one name="card" class="com.mxl.onetoone.IdCard" cascade="all"></one-to-one>
</class>
</hibernate-mapping>
IdCard.hbm.xml的xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.mxl.onetoone.IdCard" table="idcard">
<id name="id" column="id">
<!-- 外键 -->
<generator class="foreign">
<param name="property">member</param>
</generator>
</id>
<property name="num" column="num"></property>
<one-to-one name="member" class="com.mxl.onetoone.Member" constrained="true"></one-to-one>
</class>
</hibernate-mapping>
在Member.hbm.xml文件中
<class name="Member" table="member">
name:是类名称,table:是与Member类相对应的数据表
<property name="age" column="age"></property>
name:是Member类中的的属性。column是表中的字段名,该项可省略,如果省略则该值与name的值相同
<one-to-one name="card" class="com.mxl.onetoone.IdCard" cascade="all"></one-to-one>
建立一对一的关联。class:与Member类进行关联的类名,cascade级联关系,值为all。对Memberd类的对象进行修改(删除)时,同时修改(删除)IdCard类对象。
<id name="id" column="id">
<!-- 外键 -->
<generator class="foreign">
<param name="property">member</param>
</generator>
</id>
表示采用member产生的主键ID值作为该字段的值。
4.编写一个测试新增记录的类
public static void main(String []args){
Session session = HibernateUtil.sessionFactory.openSession();
Transaction tx = session.beginTransaction();
Member m = new Member();
m.setAge(34);
m.setName("TT");
IdCard card = new IdCard();
card.setNum("628443201");
card.setMember(m);
m.setCard(card);
session.save(m);
tx.commit();
}
运行后可以在控制台看到如下信息
Hibernate: insert into member (age, name) values (?, ?)
Hibernate: insert into idcard (num, id) values (?, ?)
在上面的程序中只调用一次session.save()方法,就产生了两条SQL语句。
5.session.delete()方法删除Member中的一条记录
Session session = HibernateUtil.sessionFactory.openSession();
Transaction tx = session.beginTransaction();
//从数据表member中加载id为9的记录
Member m = (Member)session.load(com.mxl.onetoone.Member.class,9);
session.delete(m);
tx.commit();
在控制台出现如下SQL信息
Hibernate: select member0_.id as id2_1_, member0_.age as age2_1_, member0_.name as name2_1_, idcard1_.id as id1_0_, idcard1_.num as num1_0_ from member member0_ left outer join idcard idcard1_ on member0_.id=idcard1_.id where member0_.id=?
Hibernate: delete from idcard where id=?
Hibernate: delete from member where id=?
只调用了一次session.delete()方法,就删除了两个表中的记录。
如果把Member.hbm.xml文件中的cascade值改为none,再执行如上的程序控制台信息如下
Hibernate: select member0_.id as id2_1_, member0_.age as age2_1_, member0_.name as name2_1_, idcard1_.id as id1_0_, idcard1_.num as num1_0_ from member member0_ left outer join idcard idcard1_ on member0_.id=idcard1_.id where member0_.id=?
Hibernate: delete from member where id=?
则只执行了一条delete语句,只删除member表中的记录,而idcard表中相应的记录则没有删除。