title: How can I make an iBatis parameter mapping for a query with multiple series of various paramaters?
body: <p>I need to map a sql statement of this general form:</p>
  
  <pre><code>SELECT ... 
  FROM x, y, z
  WHERE ( x.id = #x1# OR x.id = #x2# OR ... ) 
    AND ( y.id = #y1# OR y.id = #y2# OR ... )
    AND z.name = #name#;
  </code></pre>
  
  <p>So I have two lists of parameters and 1 string. I am wondering if something can be made from perhaps <a href="http://ibatis.apache.org/docs/dotnet/datamapper/ch03s09.html" rel="nofollow">iBatis dynamic SQL</a> or something. If I just could build my own <code>WHERE</code> clause and give it perhaps. Because somehow I want to use iBatis for mapping the result into Java objects...</p>
  
  <p>How would you do?</p>