ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Balwinder Sodhi <balwinder.so...@gmail.com>
Subject Select query
Date Mon, 03 Oct 2005 04:33:38 GMT
Hello,

My requirement is to place a query like:

SELECT a, b, c FROM my_table WHERE a IN (some_list)

in the SQLMap. Now this 'some_list' can be an instance of
java.util.List or java.util.Collection etc. I am not able to figure
out how can I configure such a query.

Can this be done by using some construct like:

<!-- Assuming myResult etc. is defined -->
<select id="getMyData" resultMap="myResult" parameterClass="what_to_put_here?">
SELECT a, b, c FROM my_table WHERE a IN (#what_to_put_here?#)
</select>

Any help will be greatly appreciated.

Regards,
Balwinder

Mime
View raw message