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
If my sql statement is "select * from abc where a = ?"
then i define in my xml file as below
<select id="getPOData" resultClass="DataBean"
  SELECT * from abc where a = #value#>
In my java program i do
List list  = sqlMap.queryForList("getPOData",

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=?


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

View raw message