ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Kulkarni <kulkarni_ash1...@yahoo.com>
Subject how to define multiple input parameters in select statement
Date Mon, 11 Jul 2005 22:23:59 GMT
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