In this Tutorial, we will take a look at how to do Batch Update using Java JDBC PreparedStatement,
Table: studentsCREATE TABLE `students` (
`student_id` int NOT NULL AUTO_INCREMENT,
`student_name` varchar(45) NOT NULL,
`student_dob` datetime NOT NULL,
`student_address` varchar(45) NOT NULL,
PRIMARY KEY (`student_id`);
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.time.LocalDate;
Java Code Example:
public class JDBCBatchUpdateExample {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String url ="jdbc:mysql://localhost:3306/my_uat";
String userName="root";
String password ="root123";
String batchInsertQuery ="insert into students values(?,?,?,?)";
Connection connection = DriverManager.getConnection(url,userName,password);
PreparedStatement preparedStatement = connection.prepareStatement(batchInsertQuery);
preparedStatement.setObject(1, null);
preparedStatement.setObject(2, "Harry");
preparedStatement.setObject(3, LocalDate.of(1997, 01, 03));
preparedStatement.setObject(4, "London");
preparedStatement.addBatch();
preparedStatement.setObject(1, null);
preparedStatement.setObject(2, "Ron");
preparedStatement.setObject(3, LocalDate.of(1999, 03, 19));
preparedStatement.setObject(4, "Paris");
preparedStatement.addBatch();
preparedStatement.setObject(1, null);
preparedStatement.setObject(2, "Hermione");
preparedStatement.setObject(3, LocalDate.of(1995, 02, 14));
preparedStatement.setObject(4, "Paris");
preparedStatement.addBatch();
int[] resultSet = preparedStatement.executeBatch();
for(int result: resultSet) {
System.out.println("Result: " +result);
}
}
}
Make sure to add the records to the batch or else nothing will get executed.
Also a common mistake if you do preparedstatement.addBatch() at the end of each record only the last record will get written.
Result:
Have Questions? Post them here!
- Error: Can not find the tag library descriptor for
- Create a Database Table using JDBC PreparedStatement
- Java JDBC Select Multiple Records from table as List using PreparedStatement
- Java Jackson with Maven Example
- [fix] Java JDBC ConnectException: Connection refused
- Spring Boot: Transactions Management with JDBCTemplate Example
- Java Get Current Date for a Specific Time Zone
- What are the 8 Primitive Data Types in Java
- Java JDBC: Insert Java 8 LocalDate and Time using PreparedStatement
- Maven Eclipse (M2e) No archetypes currently available
- How to Sort a LinkedList in Java
- [Fatal Error] XML The markup in the document following the root element must be well-formed.
- Split a String in Java with Examples
- Struts 2 : There is no Action mapped for namespace [/] and action name [form] associated with context path [/proj]
- Truncate table using Java JDBC Example
- Java: Generate random numbers within a range
- Parse XML file in Java using DOM Parser
- How to get Client IP address using Java Code Example
- JDBCTemplate Querying Examples with Spring Boot 3
- [Java Threads] Should we extend Thread Class or implement Runnable interface
- String Boot + Redis - SET and GET String Commands Examples
- Setting up Spring Boot 3 + Maven + MySQL + JDBC Example
- Spring Boot: JdbcTemplate Update Query With Parameters Example
- Java Split String by Spaces
- Unbound classpath container: JRE System Library [JavaSE-1.7]
- How to turn off CR LF CRLF in Notepad++ - NotepadPlusPlus
- [fix] Docker Desktop App not starting on Mac (macOS) - Docker
- Java JDBC with Join Queries Example - Java
- Safari Full Screen Shortcut using Keyboard [macOS] - MacOS
- Simple Struts 2 Tutorial in eclipse with tomcat 7 server - Java
- Hyperlink in html (anchor tag) without a underline - Html
- How to Update Microsoft Teams to the latest Version - Teams
- Ways to Show Git Logs in better way using pretty formatting - Git