hibernate 全面学习【hibernate抓取策略 】

Hibernate抓取策略

默认fetch的配置,也就fetch="select",参见Student.hbm.xml文件，如：
<many-to-one name="classes" column="classid" fetch="select" />

Hibernate抓取策略

设置fetch="join",参见Student.hbm.xml文件，如：
<many-to-one name="classes" column="classid" fetch="join" />

但是会导致lazy失效

Hibernate抓取策略

设置fetch＝“join”，参见：Classes.hbm.xml,如：
<set name="students" inverse="true" fetch="join">

但会导致lazy失效

Hibernate抓取策略

设置fetch＝“subselect”，参见：Classes.hbm.xml,如：
<set name="students" inverse="true" fetch="subselect">

Hibernate抓取策略

针对fetch="select"配置进行优化，加入batch，如：
<class name="com.bjsxt.hibernate.Classes" table="t_classes" batch-size="5">

Hibernate抓取策略

在集合上设置batch

<hibernate-mapping>
	<class name="com.bjsxt.hibernate.Classes" table="t_classes">
		<id name="id">
			<generator class="native"/>
		</id>
		<property name="name"/>
		<!-- 
			<set name="students" cascade="all" order-by="id">
		 -->
		 <set name="students" inverse="true">
			<key column="classid"/>
			<one-to-many class="com.bjsxt.hibernate.Student"/>
		</set>
	</class>
</hibernate-mapping>


<hibernate-mapping>
	<class name="com.bjsxt.hibernate.Student" table="t_student">
		<id name="id">
			<generator class="native"/>
		</id>
		<property name="name"/>
		<many-to-one name="classes" column="classid" fetch="select" />
	</class>
</hibernate-mapping>

package com.bjsxt.hibernate;

import java.io.Serializable;

import org.hibernate.Session;

import junit.framework.TestCase;

public class FetchTest extends TestCase {

	public void testFetch1() {
		Session session = null;
		try {
			session = HibernateUtils.getSession();
			Student student = (Student)session.load(Student.class, 1);
			System.out.println("学生姓名：" + student.getName());
			System.out.println("所属班级:" + student.getClasses().getName());
		}catch(Exception e) {
			e.printStackTrace();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}
}

[code]
<hibernate-mapping>
<class name="com.bjsxt.hibernate.Classes" table="t_classes">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<!--
<set name="students" cascade="all" order-by="id">
-->
<set name="students" inverse="true">
<key column="classid"/>
<one-to-many class="com.bjsxt.hibernate.Student"/>
</set>
</class>
</hibernate-mapping>

<hibernate-mapping>
<class name="com.bjsxt.hibernate.Student" table="t_student">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<many-to-one name="classes" column="classid" fetch="join" />
</class>
</hibernate-mapping>
package com.bjsxt.hibernate;

import java.io.Serializable;

import org.hibernate.Session;

import junit.framework.TestCase;

public class FetchTest extends TestCase {

public void testFetch1() {
Session session = null;
try {
session = HibernateUtils.getSession();
Student student = (Student)session.load(Student.class, 1);
System.out.println("学生姓名：" + student.getName());
System.out.println("所属班级:" + student.getClasses().getName());
}catch(Exception e) {
e.printStackTrace();
}finally {
HibernateUtils.closeSession(session);
}
}
}

[/code]


[code]
<hibernate-mapping>
<class name="com.bjsxt.hibernate.Classes" table="t_classes">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<!--
<set name="students" cascade="all" order-by="id">
-->
<set name="students" inverse="true" fetch="select">
<key column="classid"/>
<one-to-many class="com.bjsxt.hibernate.Student"/>
</set>
</class>
</hibernate-mapping>
<hibernate-mapping>
<class name="com.bjsxt.hibernate.Student" table="t_student">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<many-to-one name="classes" column="classid"/>
</class>
</hibernate-mapping>
package com.bjsxt.hibernate;

import java.io.Serializable;
import java.util.Iterator;
import java.util.Set;

import org.hibernate.Session;

import junit.framework.TestCase;

public class FetchTest extends TestCase {

public void testFetch1() {
Session session = null;
try {
session = HibernateUtils.getSession();
Classes classes = (Classes)session.load(Classes.class, 1);
System.out.println("班级:" + classes.getName());
Set students = classes.getStudents();
for (Iterator iter = students.iterator(); iter.hasNext();) {
Student student = (Student)iter.next();
System.out.println(student.getName());
}
}catch(Exception e) {
e.printStackTrace();
}finally {
HibernateUtils.closeSession(session);
}
}
[/code]

[code]
<hibernate-mapping>
<class name="com.bjsxt.hibernate.Classes" table="t_classes">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<!--
<set name="students" cascade="all" order-by="id">
-->
<set name="students" inverse="true" fetch="join">
<key column="classid"/>
<one-to-many class="com.bjsxt.hibernate.Student"/>
</set>
</class>
</hibernate-mapping>
<hibernate-mapping>
<class name="com.bjsxt.hibernate.Student" table="t_student">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<many-to-one name="classes" column="classid"/>
</class>
</hibernate-mapping>

package com.bjsxt.hibernate;

import java.io.Serializable;
import java.util.Iterator;
import java.util.Set;

import org.hibernate.Session;

import junit.framework.TestCase;

public class FetchTest extends TestCase {

public void testFetch1() {
Session session = null;
try {
session = HibernateUtils.getSession();
Classes classes = (Classes)session.load(Classes.class, 1);
System.out.println("班级:" + classes.getName());
Set students = classes.getStudents();
for (Iterator iter = students.iterator(); iter.hasNext();) {
Student student = (Student)iter.next();
System.out.println(student.getName());
}
}catch(Exception e) {
e.printStackTrace();
}finally {
HibernateUtils.closeSession(session);
}
}
}

[/code]

[code]
<hibernate-mapping>
<class name="com.bjsxt.hibernate.Classes" table="t_classes">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<!--
<set name="students" cascade="all" order-by="id">
-->
<set name="students" inverse="true" fetch="subselect">
<key column="classid"/>
<one-to-many class="com.bjsxt.hibernate.Student"/>
</set>
</class>
</hibernate-mapping>

package com.bjsxt.hibernate;

import java.io.Serializable;
import java.util.Iterator;
import java.util.List;
import java.util.Set;

import org.hibernate.Session;

import junit.framework.TestCase;

public class FetchTest extends TestCase {

public void testFetch1() {
Session session = null;
try {
session = HibernateUtils.getSession();
Classes classes = (Classes)session.load(Classes.class, 1);
System.out.println("班级:" + classes.getName());
Set students = classes.getStudents();
for (Iterator iter = students.iterator(); iter.hasNext();) {
Student student = (Student)iter.next();
System.out.println(student.getName());
}
}catch(Exception e) {
e.printStackTrace();
}finally {
HibernateUtils.closeSession(session);
}
}

public void testFetch2() {
Session session = null;
try {
session = HibernateUtils.getSession();
List Classes = session.createQuery("select c from Classes c where c.id in(1, 2, 3)").list();
for (Iterator iter = Classes.iterator(); iter.hasNext();) {
Classes cls = (Classes)iter.next();
System.out.println("班级：" + cls.getName());
for (Iterator iter1 = cls.getStudents().iterator(); iter1.hasNext();) {
Student student = (Student)iter1.next();
System.out.println(student.getName());
}
}
}catch(Exception e) {
e.printStackTrace();
}finally {
HibernateUtils.closeSession(session);
}
}

}

[/code]

[code]
<hibernate-mapping>
<class name="com.bjsxt.hibernate.Classes" table="t_classes" batch-size="5">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<!--
<set name="students" cascade="all" order-by="id">
-->
<set name="students" inverse="true">
<key column="classid"/>
<one-to-many class="com.bjsxt.hibernate.Student"/>
</set>
</class>
</hibernate-mapping>

<hibernate-mapping>
<class name="com.bjsxt.hibernate.Student" table="t_student">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<many-to-one name="classes" column="classid"/>
</class>
</hibernate-mapping>

package com.bjsxt.hibernate;

import java.io.Serializable;
import java.util.Iterator;
import java.util.List;

import org.hibernate.Session;

import junit.framework.TestCase;

public class FetchTest extends TestCase {

public void testFetch1() {
Session session = null;
try {
session = HibernateUtils.getSession();
List students = session.createQuery("select s from Student s where s.id in(:ids)")
.setParameterList("ids", new Object[]{1, 11, 21, 31, 41, 51, 61, 71, 81, 91})
.list();
for (Iterator iter = students.iterator(); iter.hasNext();) {
Student student = (Student)iter.next();
System.out.println("学生：" + student.getName());
System.out.println("班级：" + student.getClasses().getName());
}
}catch(Exception e) {
e.printStackTrace();
}finally {
HibernateUtils.closeSession(session);
}
}
}

[/code]


[code]
<hibernate-mapping>
<class name="com.bjsxt.hibernate.Classes" table="t_classes">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<!--
<set name="students" cascade="all" order-by="id">
-->
<set name="students" inverse="true" batch-size="5">
<key column="classid"/>
<one-to-many class="com.bjsxt.hibernate.Student"/>
</set>
</class>
</hibernate-mapping>

<hibernate-mapping>
<class name="com.bjsxt.hibernate.Student" table="t_student">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<many-to-one name="classes" column="classid"/>
</class>
</hibernate-mapping>

package com.bjsxt.hibernate;

import java.io.Serializable;
import java.util.Iterator;
import java.util.List;
import java.util.Set;

import org.hibernate.Session;

import junit.framework.TestCase;

public class FetchTest extends TestCase {

public void testFetch1() {
Session session = null;
try {
session = HibernateUtils.getSession();
List classes = session.createQuery("from Classes").list();
for (Iterator iter = classes.iterator(); iter.hasNext();) {
Classes cls = (Classes)iter.next();
System.out.println("班级：" + cls.getName());
for (Iterator iter1 = cls.getStudents().iterator(); iter1.hasNext();) {
Student student = (Student)iter1.next();
System.out.println(student.getName());
}
}
}catch(Exception e) {
e.printStackTrace();
}finally {
HibernateUtils.closeSession(session);
}
}
}

[/code]