<select id="queryId" resultClass="ResultClass" parameterClass="list">
    SELECT ...
    WHERE key IN
    <iterate open="(" close=")" conjunction=",">
        #list[]#
    </iterate>
</select>