ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 李明 <square1...@gmail.com>
Subject Re: How to pass more than one query parameter?
Date Wed, 27 Jun 2007 16:50:03 GMT
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.
> -----------------------------------------------------------------------------------------------------------------------
>


Mime
View raw message