Hibernate fetch = join

本文详细解析了在数据库设计中一对多关系的XML代码表示,并通过实例展示了如何通过Hibernate进行对象获取与操作。重点讨论了fetch策略在条件查询中的应用以及lazy属性对joinfetch的影响。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

1. TUser与TOrder 一对多关系

xml代码
<class name="TUser" table="t_user" catalog="test">
<id name="id" type="java.lang.Long">
<column name="id" />
<generator class="native" />
</id>
<property name="userName" type="java.lang.String">
<column name="user_name" />
</property>

<set name="orders" inverse="true" cascade="all-delete-orphan" fetch="join" lazy="false">
<key column="USER_ID"></key>
<one-to-many class="TOrder"/>
</set>
</class>

<class name="TOrder" table="t_order" catalog="test">
<id name="id" type="java.lang.Long">
<column name="id" />
<generator class="native" />
</id>
<property name="orderName" type="java.lang.String">
<column name="ORDER_NAME" length="20" />
</property>
<many-to-one name="user" class="TUser" >
<column name="USER_ID"></column>
</many-to-one>
</class>



2. 测试

(1) List list = session.createQuery("from TUser").list();

(2) List list = session.createQuery("from TUser where id=3 ").list();

(3) TUser u = (TUser)session.get(TUser.class, new Long(3));



3. 结论:

(1) fetch策略用于定义 get/load一个对象时,如何获取非lazy的对象/集合。

该定义在条件查询中无效。

(2) lazy=true 或false对join fetch没有任何影响, 均会使用左外连接。
<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd "> <!-- Generated 2015-4-10 11:00:59 by Hibernate Tools 4.0.0 --> <hibernate-mapping> <class name="com.xtest.models.EntityLayout" table="EntityLayout"> <id name="elSid" type="string"> <column name="el_sid" length="36"/> <generator class="org.hibernate.id.UUIDGenerator" /> </id> <many-to-one name="entityTables" class="com.xtest.models.EntityTables" fetch="select"> <column name="el_et_sid" length="36" /> </many-to-one> <property name="elName" type="string"> <column name="el_name" not-null="true" /> </property> <property name="elGroupName" type="string"> <column name="el_group_name" /> </property> <property name="elType" type="int"> <column name="el_type" not-null="true" /> </property> <property name="elStatusSid" type="string"> <column name="el_status_sid" /> </property> <property name="elDesc" type="string"> <column name="el_desc" /> </property> <set fetch="select" inverse="true" lazy="true" name="entityComposites" order-by="ecSortNo" sort="unsorted" table="EntityComposite"> <key> <column length="36" name="ec_el_sid"/> </key> <one-to-many class="com.xtest.models.EntityComposite"/> </set> <set fetch="select" inverse="true" lazy="true" name="entityLists" order-by="eldSortNo" sort="unsorted" table="EntityList"> <key> <column length="36" name="eld_el_sid"/> </key> <one-to-many class="com.xtest.models.EntityList"/> </set> <set fetch="select" inverse="true" lazy="true" name="entityForms" order-by="efdSortNo" sort="unsorted" table="EntityForm"> <key> <column length="36" name="efd_el_sid"/> </key> <one-to-many class="com.xtest.models.EntityForm"/> </set> <set fetch="select" inverse="true" lazy="true" name="entityTreeviews" order-by="etvSort" sort="unsorted" table="EntityTreeview"> <key> <column length="36" name="etv_el_sid"/> </key> <one-to-many class="com.xtest.models.EntityTreeview"/> </set> <set fetch="select" inverse="true" lazy="true" name="entityTreeviewCMenus" order-by="etvmName" sort="unsorted" table="EntityTreeviewCMenus"> <key> <column length="36" name="etvm_el_sid"/> </key> <one-to-many class="com.xtest.models.EntityTreeviewCMenus"/> </set> </class> </hibernate-mapping> 你看一下和这个有关系嘛
07-30
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值