title: Will PreparedStatement without bind variable affect performance?
body: <p>Does performance will be less if I will not use bind variables in prepared statements.</p>
  
  <p>Consider the example below:</p>
  
  <pre><code>String selectSQL = "SELECT USER_ID, USERNAME FROM DBUSER WHERE USER_ID = '101'";
  PreparedStatement preparedStatement =     dbConnection.prepareStatement(selectSQL);
  </code></pre>
  
  <p>below one is preferable I know.
  it prevents sql injection </p>
  
  <pre><code>String selectSQL = "SELECT USER_ID, USERNAME FROM DBUSER WHERE USER_ID = ?";
  </code></pre>
  
  <p>this question asked because one of my project in all the queries  they have  hard coded string literals even they are using prepared statements.</p>