ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "srividhya umashanker" <srividh...@gmail.com>
Subject ArrayList as parameter
Date Sat, 19 Mar 2005 09:33:12 GMT
ArrayList
----------------
List list = new ArrayList();
list.add("123");
list.add("A");

queryForList("emp" ,list);

<select id="emp" resultClass="java.util.ArrayList"
parameterClass="java.util.ArrayList">
   SELECT employee_name  FROM employee
   WHERE  employee_id= ? and grade=?
 </select>

How to apply the iterate tag to get the following query

   SELECT employee_name  FROM employee   WHERE  employee_id= 123 and
grade='A'



Mime
View raw message