ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "meindert" <meind...@eduflex.com>
Subject RE: Multiple parameters in sqlmap parameters.
Date Wed, 03 Jun 2009 07:00:26 GMT
Use a map as parameterClass.
As larry said, the GRD (Get R' Done) approach to do this:

Map<String, Object> param = new HashMap<String, Object>(); 
param.put("id", yourInt);
param.put("description", yourString);

-----Original Message-----
From: NathanM [mailto:nathan.mellor@infdig.com] 
Sent: 01 June 2009 11:45 PM
To: user-java@ibatis.apache.org
Subject: Multiple parameters in sqlmap parameters.

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

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#

One complex type:

<parameterMap id="insert-product-param" class="Product">
  <parameter property="description" />
  <parameter property="id"/>

<statement id="insertProduct" parameterMap="insert-product-param">
  insert into PRODUCT (PRD_DESCRIPTION, PRD_ID) values (?,?);

One complex type inline:
<statement id="insertProduct" parameterClass="Product">
  values (#id:int#, #description:VarChar#)

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?

View this message in context:
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.339 / Virus Database: 270.12.51/2151 - Release Date: 06/02/09

View raw message