Thanks. It seems though that there are more facets to it, like XML which is particularly interesting for RESTful services.
Fred
On Thu, Jul 2, 2009 at 14:49, meindert
<meindert@...> wrote:
You can only have one input Object. For simple parameters
I use a Map object;
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);
In you sqlmap you can revere to these parameters like #id# and
#description#, or $id$ and $description$ if you want to do a literary
replacement.
From: Fred Janon [mailto:fjanon@...]
Sent: 02 July 2009 05:59 AM
To: user-java@...
Subject: queryForObject/queryForList where is the documentation for the
"Object parameter"?
Sorry for the basic question:
how to write a query with mutiple parameters? I am reading the iBatis in Action
book, browsing the distribution, the wiki, the Javadoc and I can't find
documentation or examples for the different forms of the parameter for queryForObject
or queryForList
java.util.List queryForList(java.lang.String id,
java.lang.Object parameterObject,
int skip,
int max)
throws java.sql.SQLException
Executes a mapped SQL SELECT
statement that returns data to populate a number of result objects within a
certain range.
The parameter object is generally used to supply
the input data for the WHERE clause parameter(s) of the SELECT statement.
Parameters:
id - The name of the statement to execute.
parameterObject - The parameter object (e.g. JavaBean,
Map, XML etc.). <<< Where in the doc or the book is that described
in more details?
How do I pass several
parameters to queryForList like for example name, beginsearchdate,
beginlastdate?
I see details for the resultMap, nothing but only exmaples with one input
parameter. I started looking in the code, but it's taking too much time now...
Thanks
Fred
Checked by
AVG - www.avg.com
Version: 8.5.375 / Virus Database: 270.13.1/2211 - Release Date: 06/30/09
11:37:00
