ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Stahl <jest...@earthlink.net>
Subject Re: Multiple parameters in sqlmap parameters.
Date Mon, 01 Jun 2009 21:57:40 GMT
Actually, the easiest way to handle the same thing is to put both 
parameters into a Map (HashMap works nicely), and pass the Map as the 
single parameter that iBATIS methods take.

Hope This Helps,

Jeff Stahl

NathanM wrote:
> Please excuse me if this turns out to be a dumb question. 
>
> Is it possible to do something simple like pass two int parameters into a
> statement?
>
> These are the examples I see in the manual:
>
> One simple type:
>
> <statement id="getProduct" parameterClass="System.Int32">
>   select * from PRODUCT where PRD_ID = #value#
> </statement>
>
> One complex type:
>
> <parameterMap id="insert-product-param" class="Product">
>   <parameter property="description" />
>   <parameter property="id"/>
> </parameterMap>
>
> <statement id="insertProduct" parameterMap="insert-product-param">
>   insert into PRODUCT (PRD_DESCRIPTION, PRD_ID) values (?,?);
> </statement>
>
> One complex type inline:
> <statement id="insertProduct" parameterClass="Product">
>   insert into PRODUCT (PRD_ID, PRD_DESCRIPTION)
>   values (#id:int#, #description:VarChar#)
> </statement>
>
> Is there any example for two simple types? Or do I need to come up with a
> class that has two int properties so I can pass int two ints?
>
>
> Nathan
>   

Mime
View raw message