You can use HashMap.like this.
Map map = new HashMap();
map.put("userId", id);
map.put("userName", name);
sqlMapClient.queryForObject("queryById", map);
<select id="queryById" .... >
SELECT * FROM yourtable WHERE userid=#userId# and
username=#userName#
</select>
Hi,
How to pass more than one query parameter to iBatis
statement? I know one way, creating some Object with all the
parameters and pass that object to iBatis. But I don’t want to create
the object for just two parameters. Can I pass array to iBatis query
as a list of parameters? Can any one help me on this?
** **
** **
**Thanks & Regards**
**----------------------------------**
**Sreenivasulu N****allapati**
DISCLAIMER:
-----------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and
intended for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its
affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily
reflect the opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and / or publication of
this message without the prior written consent of the author of this
e-mail is strictly prohibited. If you have
received this email in error please delete it and notify the sender
immediately. Before opening any mail and
attachments please check them for viruses and defect.
-----------------------------------------------------------------------------------------------------------------------
