ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: how to define multiple input parameters in select statement
Date Mon, 11 Jul 2005 22:36:45 GMT
Start by glancing at the docs, then come back if you still have questions.

Larry

On 7/11/05, Ashish Kulkarni <kulkarni_ash1312@yahoo.com> wrote:
> Hello
> If my sql statement is "select * from abc where a = ?"
> then i define in my xml file as below
> <select id="getPOData" resultClass="DataBean"
>                 parameterClass="java.math.BigDecimal">
>   SELECT * from abc where a = #value#>
> </select>
> In my java program i do
> List list  = sqlMap.queryForList("getPOData",
> bigDecimal);
> 
> Q1 If i have multiple parameters in select statement
> how do i define,
> for example my sql statement will be
> select * from abc where a =? and b =? and c=?
> 
> Ashish
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>

Mime
View raw message