对于ORM而言,一个重要的特性就是对实体之间关联关系的管理。数据关联是ORM一个重要的特征,但往往也是导致性能低下的原因,在开发中要特别注意这一点。
一对一关联有两种类型:主键关联和唯一外键关联
一.主键关联:
一对一主键关联形式,即两张关联表通过主键形成一对一映射关系。
例如,一个中国公民只能有一份护照。
1.数据模型如下
2.表定义sql
DROP TABLE T_User;
DROP TABLE T_Passport;
CREATE TABLE T_Passport (
id INT NOT NULL
, serial VARCHAR ( 30 )
, expiry INT
, PRIMARY KEY (id)
);
CREATE TABLE T_User (
id INT NOT NULL AUTO_INCREMENT
, name VARCHAR ( 50 )
, age INT
, PRIMARY KEY (id)
, INDEX (id)
, CONSTRAINT FK_T_User_1 FOREIGN KEY (id)
REFERENCES T_Passport (id)
);
3.POJO类
TUser.java
package cn.blogjava.start;
public class TUser implements java.io.Serializable {
// Fields
private Integer id;
private Integer age;
private String name;
private TPassport passport;
// Constructors
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this .age = age;
}
public TPassport getPassport() {
return passport;
}
public void setPassport(TPassport passport) {
this .passport = passport;
}
/** default constructor */
public TUser() {
}
/** constructor with id */
public TUser(Integer id) {
this .id = id;
}
// Property accessors
public Integer getId() {
return this .id;
}
public void setId(Integer id) {
this .id = id;
}
public String getName() {
return this .name;
}
public void setName(String name) {
this .name = name;
}
}
TPassport.java
package cn.blogjava.start;
import java.io.Serializable;
public class TPassport implements Serializable {
private Integer id;
private String serial;
private Integer expiry;
private TUser user;
public Integer getExpiry() {
return expiry;
}
public void setExpiry(Integer expiry) {
this .expiry = expiry;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this .id = id;
}
public String getSerial() {
return serial;
}
public void setSerial(String serial) {
this .serial = serial;
}
public TUser getUser() {
return user;
}
public void setUser(TUser user) {
this .user = user;
}
}
3.配置文件
TUser.hbm.xml
<? xml version="1.0" ?>
<! DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
< hibernate-mapping >
< class name ="cn.blogjava.start.TUser" table ="T_User" catalog ="sample" >
< id name ="id" type ="integer" >
< column name ="id" />
< generator class ="native" />
</ id >
< property name ="name" type ="string" >
< column name ="name" length ="100" not-null ="true" />
</ property >
< property name ="age" type ="java.lang.Integer" column ="age" />
< one-to-one name ="passport"
class ="cn.blogjava.start.TPassport"
cascade ="all"
outer-join ="true"
/>
</ class >
</ hibernate-mapping >
TPassport.hbm.xml
<? xml version="1.0" ?>
<! DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
< hibernate-mapping >
< class name ="cn.blogjava.start.TPassport" table ="T_Passport" catalog ="sample" >
< id name ="id" type ="integer" column ="id" >
< generator class ="foreign" >
< param name ="property" > user </ param >
</ generator >
</ id >
< property name ="serial" type ="string" column ="serial" />
< property name ="expiry" type ="java.lang.Integer" column ="expiry" />
< one-to-one name ="user"
class ="cn.blogjava.start.TUser"
constrained ="true"
/>
</ class >
</ hibernate-mapping >
4.测试代码
package cn.blogjava.start;
import java.util.List;
import junit.framework.Assert;
import junit.framework.TestCase;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
public class HibernateTest extends TestCase {
Session session = null ;
protected void setUp() {
try {
Configuration config = new Configuration().configure();
SessionFactory sessionFactory = config.buildSessionFactory();
session = sessionFactory.openSession();
} catch (HibernateException e) {
e.printStackTrace();
}
}
protected void tearDown() {
try {
session.close();
} catch (HibernateException e) {
e.printStackTrace();
}
}
public void testInsert() {
Transaction tran = null ;
try {
TUser user = new TUser();
user.setName( " byf " );
user.setAge( new Integer( 26 ));
TPassport passport = new TPassport();
passport.setSerial( " PCN123456 " );
passport.setExpiry( new Integer( 20081010 ));
// 设置相互关联
user.setPassport(passport);
passport.setUser(user);
tran = session.beginTransaction();
session.save(user);
session.flush();
tran.commit();
Assert.assertEquals(user.getId().intValue() > 0 , true );
} catch (HibernateException e) {
e.printStackTrace();
Assert.fail(e.getMessage());
if (tran != null ) {
try {
tran.rollback();
} catch (Exception e1) {
e1.printStackTrace();
}
}
}
}
/**
* 对象读取测试(Select方法)
*/
public void testSelect(){
String hql = " from TUser where name='byf' " ;
try {
List userList = session.createQuery(hql).list();
TUser user = (TUser)userList.get( 0 );
System.out.println( " user name is " + user.getName());
System.out.println( " passport serial NO. is " + user.getPassport().getSerial());
Assert.assertEquals(user.getName(), " byf " );
} catch (Exception e) {
e.printStackTrace();
Assert.fail(e.getMessage());
}
}
}