title: Reading dates from file and updating table of database using Java
body: <p>I'm trying out some code. I want to read dates from a file in <code>DD-MMM-YYYY</code>, <code>DD-MMM-YYYY</code>, <code>DD-MMM-YYYY</code> format and update DB table using query </p>
  
  <pre><code>UPDATE CAL_TABLE 
     SET HOLIDAY_SIGN = 'N' 
   WHERE CALENDAR_DATE IN ('01-Jan-2013', '02-Jan-2013', '03-Jan-2013');
  </code></pre>
  
  <ol>
  <li><p>So, what should be the format of my input file from where I read dates. Currently I am having <code>txt</code> and <code>csv</code> files and I can read dates and save them into a string array.</p></li>
  <li><p>Is it a good idea to put that <code>update</code> statement into a stored procedure and send array as an input parameter? </p></li>
  </ol>
  
  <p>Which will perform faster <code>update</code> statement or the stored procedure? I am using JDBC connection.</p>