title: How to delete rows with updateBatch if I had a list and a single value for parameters?
body: <p>I have a list, which contains some name data:</p>
  
  <pre><code>List&lt;String&gt; names; //not null, already with values
  </code></pre>
  
  <p>And I have a single integer, which contains the ID of the created names:</p>
  
  <pre><code>Integer creatorId = 47;
  </code></pre>
  
  <p>And finally, I have the delete sql, which is like:</p>
  
  <pre><code>String deleteSql = "DELETE FROM persons WHERE person_name = ? and creator_id = ?";
  </code></pre>
  
  <p>The point here, is to use the <code>updateBatch</code> method from Spring, and <strong>DO NOT USE</strong> <code>in</code> clause in the delete sql for person_name-s, and <strong>avoid</strong> <code>for</code> loops.</p>
  
  <p>Is there a way, to use some batch methods here?
  Thank you!</p>