title: How to set multiple parameters with one method on PreparedStatement
body: <p>Is it possible to set multiple parameters in a single method call of a <code>PreparedStatement</code>? I can't find an operation, using Java 1.6.</p>
  
  <p>Something like this:</p>
  
  <pre><code>// This query takes multiple input parameters
  PreparedStatement ps = conn.prepareStatement("INSERT INTO MY_TABLE (COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5) VALUES (?, ?, ?, ?, ?)");
  
  // I would like to set all at once
  ps.setMultipleParameters("USERNAME", 789, new Date(), 9999L, null);
  </code></pre>
  
  <p>I am looking for a way to ease writing integration tests, since I can copy the parameters list and just paste in the test.</p>