我们有三个实体对象Student,Team,Cerificate
其中Student和Team是1对1的关系,采用主键关联的方式(Student的id和Certificate的id保持一致)
Team和Student是一对多的关系(反之为1对多)
在Mysql中运行以下脚本,建立数据库
id varchar ( 100 ) NOT NULL default '' ,
description varchar ( 100 ) default '' ,
PRIMARY KEY (id)
);
CREATE TABLE student (
team_id varchar ( 100 ) default '' ,
id varchar ( 100 ) NOT NULL default '' ,
name varchar ( 20 ) default '' ,
cardId varchar ( 20 ) NOT NULL default '' ,
age int ( 11 ) default ' 0 ' ,
PRIMARY KEY (id)
);
CREATE TABLE team (
id varchar ( 100 ) NOT NULL default '' ,
teamName varchar ( 100 ) default '' ,
PRIMARY KEY (id)
);
INSERT INTO certificate VALUES ( ' 1 ' , ' 110108 ' );
INSERT INTO certificate VALUES ( ' 2 ' , ' 110109 ' );
INSERT INTO student VALUES ( ' 1 ' , ' 1 ' , ' tomclus ' , ' 2006m ' , 33 );
INSERT INTO student VALUES ( ' 2 ' , ' 2 ' , ' tom ' , ' 2007m ' , 22 );
INSERT INTO team VALUES ( ' 1 ' , ' team1 ' );
建立对应的Pojo对象
public class Certificate ...... ... {
private String id;
private String description;
private Student stu;
public Student getStu() .........{
return stu;
}
public void setStu(Student stu) .........{
this.stu = stu;
}
public String getDescription() .........{
return description;
}
public void setDescription(String description) .........{
this.description = description;
}
public String getId() .........{
return id;
}
public void setId(String id) .........{
this.id = id;
}
}
package Search.immediately;
import java.util.HashSet;
import java.util.Set;
public class Team ...... ... {
private String id;
private Set students=new HashSet();
private String teamName;
private Set tests;
public Set getTests() .........{
return tests;
}
public void setTests(Set tests) .........{
this.tests = tests;
}
public String getId() .........{
return id;
}
public void setId(String id) .........{
this.id = id;
}
public String getTeamName() .........{
return teamName;
}
public void setTeamName(String name) .........{
this.teamName = name;
}
public Set getStudents() .........{
return students;
}
public void setStudents(Set students) .........{
this.students = students;
}
}
package Search.immediately;
public class Certificate ...... ... {
private String id;
private String description;
private Student stu;
public Student getStu() .........{
return stu;
}
public void setStu(Student stu) .........{
this.stu = stu;
}
public String getDescription() .........{
return description;
}
public void setDescription(String description) .........{
this.description = description;
}
public String getId() .........{
return id;
}
public void setId(String id) .........{
this.id = id;
}
}
<!--推荐1对多,多对多使用延迟加载,而多1对1,多对1采用预先抓取-->
设置student对team及certificate进行预先抓取
Student.hbm.xml
<! DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
< hibernate-mapping package ="Search.fetch" >
< class name ="Student" table ="student" lazy ="true" >
< id name ="id" column ="id" unsaved-value ="null" >
< generator class ="uuid.hex" ></ generator >
</ id >
< property name ="cardId" column ="cardId" ></ property >
< property name ="name" column ="name" ></ property >
< property name ="age" column ="age" ></ property >
<!-- 推荐1对多,多对多使用延迟加载,而多1对1,多对1采用预先抓取 -->
< one-to-one name ="cer"
class ="Search.fetch.Certificate"
constrained ="true"
outer-join ="true"
cascade ="all" >
</ one-to-one >
<!-- 推荐1对多,多对多使用延迟加载,而多1对1,多对1采用预先抓取 -->
< many-to-one name ="team"
column ="team_id"
outer-join ="true"
class ="Search.fetch.Team" ></ many-to-one >
</ class >
</ hibernate-mapping >
team.hbm.xml
<! DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
< hibernate-mapping package ="Search.fetch" >
< class name ="Team" table ="team" lazy ="true" >
< id name ="id" column ="id" >
< generator class ="uuid.hex" ></ generator >
</ id >
< property name ="teamName" column ="teamName" ></ property >
<!-- 关闭外连接,并设置lazy="true",表示读取team对象后,并不立即把其所有的student信息取回 -->
< set name ="students" lazy ="true" inverse ="true" outer-join ="false" >
< key column ="team_id" ></ key >
< one-to-many class ="Search.fetch.Student" />
</ set >
</ class >
</ hibernate-mapping >
Certificate.hbm.xml
<! DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
< hibernate-mapping package ="Search.fetch" >
< class name ="Certificate" table ="certificate" lazy ="false" >
<!-- 共享主键关联,在子方配置constrained=true -->
< id name ="id" column ="id" >
< generator class ="foreign" >
< param name ="property" > stu </ param >
</ generator >
</ id >
< property name ="description" column ="description" ></ property >
<!-- 推荐1对多,多对多使用延迟加载,而多1对1,多对1采用预先抓取 -->
< one-to-one name ="stu"
class ="Search.fetch.Student"
outer-join ="true"
constrained ="true" >
</ one-to-one >
</ class >
</ hibernate-mapping >
hibernate.cfg.xml
<! DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd" >
<!-- Generated by MyEclipse Hibernate Tools. -->
< hibernate-configuration >
< session-factory >
< property name ="connection.username" > root </ property >
< property name ="connection.url" >
jdbc:mysql://localhost:3306/hibernateconformity?characterEncoding=gb2312 & useUnicode=true
</ property >
< property name ="dialect" >
org.hibernate.dialect.MySQLDialect
</ property >
< property name ="myeclipse.connection.profile" > mysql </ property >
< property name ="connection.password" > 1234 </ property >
< property name ="connection.driver_class" >
com.mysql.jdbc.Driver
</ property >
< property name ="hibernate.dialect" >
org.hibernate.dialect.MySQLDialect
</ property >
< property name ="hibernate.show_sql" > true </ property >
< property name ="current_session_context_class" > thread </ property >
< mapping resource ="Search/fetch/Certificate.hbm.xml" />
< mapping resource ="Search/fetch/Student.hbm.xml" />
< mapping resource ="Search/fetch/Team.hbm.xml" />
</ session-factory >
</ hibernate-configuration >
测试代码:
import java.io.File;
import java.io.FileInputStream;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class Test ... {
public static void main(String[] args) ...{
String filePath=System.getProperty("user.dir")+File.separator+"src/Search/fetch"+File.separator+"hibernate.cfg.xml";
File file=new File(filePath);
SessionFactory sessionFactory=new Configuration().configure(file).buildSessionFactory();
Session session=sessionFactory.openSession();
Student stu=(Student)session.get(Student.class, "1");
System.out.println(stu.getName());
System.out.println("-------------------------");
System.out.println(stu.getTeam().getTeamName());
System.out.println("-------------------------");
System.out.println(stu.getTeam().getStudents().size());
}
}
结果:
Hibernate: select student0_.id as id1_3_, student0_.cardId as cardId1_3_, student0_.name as name1_3_, student0_.age as age1_3_, student0_.team_id as team5_1_3_, certificat1_.id as id0_0_, certificat1_.description as descript2_0_0_, student2_.id as id1_1_, student2_.cardId as cardId1_1_, student2_.name as name1_1_, student2_.age as age1_1_, student2_.team_id as team5_1_1_, team3_.id as id2_2_, team3_.teamName as teamName2_2_ from student student0_ inner join certificate certificat1_ on student0_.id=certificat1_.id left outer join student student2_ on certificat1_.id=student2_.id left outer join team team3_ on student0_.team_id=team3_.id where student0_.id=?
使用外连接读取student对象,以及和他关联的team对象,certificate对象
tomclus
-------------------------
team1
-------------------------
Hibernate: select students0_.team_id as team5_3_, students0_.id as id3_, students0_.id as id1_2_, students0_.cardId as cardId1_2_, students0_.name as name1_2_, students0_.age as age1_2_, students0_.team_id as team5_1_2_, certificat1_.id as id0_0_, certificat1_.description as descript2_0_0_, student2_.id as id1_1_, student2_.cardId as cardId1_1_, student2_.name as name1_1_, student2_.age as age1_1_, student2_.team_id as team5_1_1_ from student students0_ inner join certificate certificat1_ on students0_.id=certificat1_.id left outer join student student2_ on certificat1_.id=student2_.id where students0_.team_id=?
由于team对students采用了延迟加载,所以在调用System.out.println(stu.getTeam().getStudents().size());的时候,进行SQL执行,同样使用了预先抓取,抓取对象是team中student对象所关联的certificate对象
2