Re: [Fwd: How to pass a parameter to collection property?]

[Jeff Butler]

Here's how to do it with a map:

 

Map map = new HashMap();

map.put("parameterY", parameterY);

map.put("parameterX", parameterX);

List results = sqlMap.queryForList("getProductsByCatId", map);

 

 

<select id="getProductsByCatId" parameterClass="java.util.Map" resultMap="get-product-result">
select * from PRODUCT where PRD_CAT_ID = #parameterY# and PRD_PRICE = #parameterX#
</select>
 

You could also do it with a POJO as your parameter class (which is preferred) - the properties in the select statement correspond to properties in your POJO.

 

Jeff Butler

 

On 12/2/05, Jozef Hribik <[EMAIL PROTECTED]> wrote:

I would like to pass an additional parameter to filter a collection property.
I will use an example from iBATIS-SqlMaps-2.pdf, page 27.
 
How can i select a category with products with certain price specified by parameterX?
 
<resultMap id="get-category-result" class="com.ibatis.example.Category">
<result property="id" column="CAT_ID"/>
<result property="description" column="CAT_DESCRIPTION"/>
<result property="productList" column="CAT_ID" select="getProductsByCatId"/>
</resultMap>

<statement id="getProductsByCatId" parameterClass="int" resultMap="get-product-result">
select * from PRODUCT where PRD_CAT_ID = #value# and PRD_PRICE = #parameterX#
</statement>

Thanks
Jozef