If you inserted a record into a database table and you have an auto-incremented ID which you passed in as null, and to continue further you want the Id that was set for that record in the database?
You can pass in the column names that you want in the ResultSet as a part of the PrepareStatement as shown in the below code snippet,
Example:String generatedId[] = { "book_id" };
String insertRecordBook = "insert into books(book_id,book_name) values(?,?)";
Connection connection = DriverManager.getConnection(url,userName,password);|
PreparedStatement transaction = connection.prepareStatement(insertRecordBook,generatedId);
transaction.setObject(1, null);
transaction.setString(2, bookName);
transaction.executeUpdate();
ResultSet resultSet = transaction.getGeneratedKeys();
while(resultSet.next()) {
bookId = resultSet.getInt(1);
System.out.println("book_Id:" + bookId);
}
Get the Auto-generated ID using Java JDBC
-
Have Questions? Post them here!
More Posts related to Java,
- Create a Zip file using Java Code programmatically
- Eclipse : A java Runtime Environment (JRE) or Java Development kit (JDK) must be available
- How to Sort a LinkedList in Java
- Loading class com.mysql.jdbc.Driver. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver
- How to declare and initialize Array in Java Programming
- [Fix] java: integer number too large compilation error
- Java JDBC Connection with MySQL Driver in VS Code + Troubleshooting
- Reading .xls and .xlsx Excel file using Apache POI Java Library
- IntelliJ: Error: Could not find or load main class, java.lang.ClassNotFoundException
- How to get Client IP address using Java Code Example
- Truncate table using Java JDBC Example
- Struts 2 : There is no Action mapped for namespace [/] and action name [form] associated with context path [/proj]
- How to get file path in Idea IntelliJ IDE
- Java Generics explained with simple definition and examples
- Java SE 8 Update 301 available with various bug fixes and security improvements
- Java: Collect Stream as ArrayList or LinkedList
- Java JDBC Connection with PostgreSQL Driver Example
- How to check if Java main thread is alive
- How to fix Java nio NoSuchFileException wile reading a file
- Java 8+ get Day of the Week Examples with LocalDateTime, DateTime, ZonalDateTime and Instant classes
- Ways to Convert Integer or int to Long in Java
- [Java] How to throws Exception using Functional Interface and Lambda code
- [Fix] Spring Boot: mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
- Java: The value of the local variable string is not used
- Java JDBC: Insert Java 8 LocalDate and Time using PreparedStatement
More Posts:
- INSTALL_FAILED_INSUFFICIENT_STORAGE Android Error - Android
- Setting up RSS feeds notifications within Outlook - HowTos
- Fix SharePoint 2019 installation error This product requires Visual C++ Redistributable Package for Visual Studio 2017 - SharePoint
- Fix zsh: permission denied: script.sh - zsh
- How to change the tab color on Microsoft Excel on Mac - MacOS
- Fix - sudo: systemctl: command not found - Ubuntu
- Permanently set $PATH variable in Mac Zsh shell - MacOS
- [Android Studio] How to locate code for activity_main.xml - Android-Studio
