Is there a way to retrieve the autoincrement ID from a prepared statement

by

Yes. See here. Section 7.1.9. Change your code to:

String sql = "INSERT INTO table (column1, column2) values(?, ?)";
stmt = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);


stmt.executeUpdate();
if(returnLastInsertId) {
   ResultSet rs = stmt.getGeneratedKeys();
    rs.next();
   auto_id = rs.getInt(1);
}

More Related Contents:

  1. Java: Insert multiple rows into MySQL with PreparedStatement
  2. Using “like” wildcard in prepared statement
  3. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  4. right syntax to use near ‘?’
  5. preparedStatement syntax error
  6. mysql prepared statement error: MySQLSyntaxErrorException
  7. How to use prepared statement for select query in Java?
  8. JavaEE, Jboss, Empty string somewhere [closed]
  9. Getting data from mysql [closed]
  10. Connect Java to a MySQL database
  11. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  12. How can I get the SQL of a PreparedStatement?
  13. Can we connect remote MySQL database in Android using JDBC? [closed]
  14. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  15. “EEE MMM dd HH:mm:ss ZZZ yyyy” date format to java.sql.Date
  16. JDBC MySql connection pooling practices to avoid exhausted connection pool
  17. Docker: Combine multiple images
  18. The server time zone value ‘AEST’ is unrecognized or represents more than one time zone
  19. How does Java’s PreparedStatement work?
  20. Passing parameters to a JDBC PreparedStatement
  21. Enum in Hibernate, persisting as an enum
  22. Error “A JNI error has occurred. Please check your installation and try again in Eclipse x86 Windows 8.1”
  23. Invalid syntax error “type= MyISAM” in DDL generated by Hibernate
  24. scatter plot in jfreechart from database
  25. Converting mysql table to spark dataset is very slow compared to same from csv file
  26. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. How to setup Hibernate to read/write to different datasources?
  29. JDBC MySQL connection using Unix Socket
  30. Getting last record from mysql

Leave a Comment