title: Java PreparedStatement retrieving last inserted ID
body: <p>This answer to this question done this way seems to be very difficult to find on the internet. Basically I am inserting values into a MySQL database using PreparedStatement. I use the PreparedStatement to escape the data to prevent SQL Injection attacks. The problem is, there is now way retreving those keys.</p>
  
  <pre><code>String query="Insert INTO Table_A(name, age) (?, ?)";
  //String query="Insert INTO Table_A(name, age) ('abc','123' )";//Doesn't escape
  PreparedStatement prest;
  prest = con.prepareStatement(query);
  prest.setString(1,"abc");
  prest.setInt(2,123);
  prest.executeUpdate();
  //prest.executeUpdate(query, PreparedStatement.RETURN_GENERATED_KEYS); Throws an error
  //prest.executeQuery(); Throws an error
  </code></pre>
  
  <p>So how can I escape input and use PreparedStatements in Java?</p>