title: setting null to parameter in select sql statement
body: <p>I need help as I am struggling to assign null as a parameter to the select statement in my java program.</p>
  
  <p>my script read values from the csv file and then selects the parameter based on the index provided. However, the values are sometime empty string e.g. (1,,3) so from index 1 it will pick the empty string and tries to set it as parameter in sql statement, this doesn't achieve the results I am looking for. </p>
  
  <p>and as we know that sql handle null values in select statement with below syntax:
  e.g. 
  select * from tablename where a IS NULL.</p>
  
  <p>What is the best to set the value as null with below scenario:</p>
  
  <pre><code>select * from tableName where abc=? 
  stmt2.setString(1, csvVal.get(index));
  </code></pre>