MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]

by

Wouldn’t you just change:

numero = stmt.executeUpdate(query);

to:

numero = stmt.executeUpdate(query, Statement.RETURN_GENERATED_KEYS);

Take a look at the documentation for the JDBC Statement interface.

Update: Apparently there is a lot of confusion about this answer, but my guess is that the people that are confused are not reading it in the context of the question that was asked. If you take the code that the OP provided in his question and replace the single line (line 6) that I am suggesting, everything will work. The numero variable is completely irrelevant and its value is never read after it is set.

More Related Contents:

  1. Connect Java to a MySQL database
  2. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  3. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  4. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  5. Can we connect remote MySQL database in Android using JDBC? [closed]
  6. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  7. Cannot issue data manipulation statements with executeQuery()
  8. Handling MySQL datetimes and timestamps in Java
  9. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  10. JDBC MySql connection pooling practices to avoid exhausted connection pool
  11. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  12. right syntax to use near ‘?’
  13. Running a .sql script using MySQL with JDBC
  14. Java JDBC Access denied for user [closed]
  15. Passing parameters to a JDBC PreparedStatement
  16. JDBC character encoding
  17. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  18. JDBC returning MySQLSyntaxError Exception with correct statement
  19. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  20. MySQL connector error “The server time zone value Central European Time” [duplicate]
  21. com.mysql.jdbc.PacketTooBigException
  22. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server [duplicate]
  23. Should a database connection stay open all the time or only be opened when needed?
  24. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  25. Converting mysql table to spark dataset is very slow compared to same from csv file
  26. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  27. A persistent connection with JDBC to MySQL
  28. java.sql.SQLException: No database selected – why?
  29. JDBC MySQL connection using Unix Socket
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment