title: Difference between Statement and PreparedStatement
body: <p>The Prepared Statement is a slightly more powerful version of a Statement, and should always be at least as quick and easy to handle as a Statement.<br />
  The Prepared Statement may be parametrized</p>
  <p>Most relational databases handles a JDBC / SQL query in four steps:</p>
  <ol>
  <li>Parse the incoming SQL query</li>
  <li>Compile the SQL query</li>
  <li>Plan/optimize the data acquisition path</li>
  <li>Execute the optimized query / acquire and return data</li>
  </ol>
  <p>A Statement will always proceed through the four steps above for each SQL query sent to the database. A Prepared Statement pre-executes steps (1) - (3) in the execution process above. Thus, when creating a Prepared Statement some pre-optimization is performed immediately. The effect is to lessen the load on the database engine at execution time.</p>
  <p>Now my question is this:</p>
  <p>&quot;Is there any other advantage of using Prepared Statement?&quot;</p>