Ibatis一对多的延迟加载应用
我们的应用之中有一个一对多的情况 :
?
一个批发产品对应3条批发价格信息
?
于是model 结构 ;?
?
public class ProductVo implements Serializable { private List<WholesaleRange> wholeRageList; //价格信息集合 public List<WholesaleRange> getWholeRageList() { return wholeRageList; } public void setWholeRageList(List<WholesaleRange> wholeRageList) { this.wholeRageList = wholeRageList; }}
?
如何查询批发信息的时候直接带出附加的价格信息集合呢 ?
?
SQLMAP 如下构建:
?
<typeAlias alias="wholesaleprd" type="com.woyo.business.wholesale.domain.model.ProductVo" /> <resultMap id="wholesalePriceRageMap" > <result column="id" property="id" jdbcType="VARCHAR" /> <result column="title" property="title" jdbcType="VARCHAR" /> <result column="is_mixed_batch" property="mixedBatch" nullValue="0" /> <result column="id" property="wholeRageList" select="getWholeRageList"/> </resultMap><select id="getWholeRageList" resultparameterresultMap="wholesalePriceRageMap" parameterClass="long"> SELECT w.id as id ,w.title as title, p.id as prdId,p.product_name AS prdName ,p.count - w.order_amount AS balance_amount , p.price AS price, p.image_url AS imageUrl, w.supplier_name, w.supplier_tel, w.wholesale_amount, w.wholesale_price, w.team_price, w.team_save, w.order_amount, w.team_amount ,w.is_mixed_batch FROM wholesale w left join product p on w.product_id = p.id where w.id = #value# </select>
?
?
这样, 查询出的对象, Ibatis 会用延迟加载的策略来得到 wholeRageList?
?
?