title: Insert using PreparedStatement. How do I auto-increment the ID?
body: <p>I have a PreparedStatement such as:</p>
  
  <pre><code> PreparedStatement preparedStatement = connect.prepareStatement("INSERT into employee (id, time, name" + "(?,?,?)",Statement.RETURN_GENERATED_KEYS);
   ResultSet tableKeys = preparedStatement.getGeneratedKeys();
   preparedStatement.executeUpdate();
   tableKeys.next();
   int autoGeneratedID = tableKeys.getInt(1);
   preparedStatement.setInt(1,autoGeneratedID);
   preparedStatement.setTimestamp(2, new java.sql.Timestamp(new java.util.Date().getTime()));                           
   preparedStatement.setString(3, "Test");
   preparedStatement.executeUpdate();
  </code></pre>
  
  <p>As you can see, the Employee table has an auto-incremented ID. I need to basically add it in automatically using preparedStatement as well. Can someone tell me where I am going wrong and correct me? Right now it just gives me an error related to Statement.</p>