How to write a query with "or" statements in iBATIS?

Question

I want to get data using a dynamic query or statement using iBATIS.

For example

select * from USERS where ID=1 or ID=12 or ID= 3 or ID=27.....

and I want to pass set of IDs as a List Object.

Answer 1

You cam use IN statement

<select id="selectKeys" parameterType="list"
        resultMap="selectKeysResultMap">
        SELECT COL1,COL2
        FROM
        TABLE1
        WHERE COL1 IN
        <foreach item="item" index="index" collection="list" open="("
            separator="," close=")">
            #{item}
        </foreach>
    </select>