title: PreparedStatements or callableStatements
body: <p>I tried to understand the difference between <code>PreparedStatements</code> &amp; <code>CallableStatements</code> and I couldn't get it. so please can anyone convert following <code>sql</code> Query to <code>CallableStatement</code>. I know how to convert Statement into a <code>PreparedStatement</code> but having problems with <code>CallableStatements</code>.</p>
  
  <p>as a <code>java.sql.Statement</code></p>
  
  <pre><code>SELECT * FROM Customer WHERE customerId = 'C001'
  </code></pre>
  
  <p>as a <code>java.sql.PreparedStatement</code></p>
  
  <pre><code>SELECT * FROM Customer WHERE customerId = ? //set customerId using preparedStatement.setString(1,"C001")
  </code></pre>
  
  <p>How to write this same query in <code>CallableStatements</code></p>
  
  <p>Thanks in advance!</p>