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:
Java JDBC Batch Update Example
-
Have Questions? Post them here!
More Posts related to Java,
- Drop table using Java JDBC Template
- Java - Check if array contains the value
- YAML Parser using Java Jackson Library Example
- Java Jackson ObjectMapper Class with Examples
- Get Client IP address from HTTP Response in Java
- How to Word-Warp Console logs in IntelliJ
- Exception in thread main java.lang.NoClassDefFoundError: package javaClass
- Setting Java_Home Environment variable on Windows Operating System
- Fix: Maven - Failed to execute goal - Compilation failure - Source/Target option 5 is no longer supported. Use 7 or later
- Java SE JDBC Select Statement Example
- How to extract Java Jar/War/Ear files in Linux
- java: unclosed string literal [Error]
- [Solution] Exception in thread main java.util.EmptyStackException
- Read YAML file Java Jackson Library
- What Java version is used for Minecraft 1.18
- [Java] How to throws Exception using Functional Interface and Lambda code
- [Program] How to read three different values using Scanner in Java
- Java 8 Predicate Functional Interface Examples
- Display Era details (AD BC) in Java Date using SimpleDateFormat
- Convert String Date to Date Object in Java
- Struts 2 Hello World Example in Eclipse
- Read a file using Java 8 Stream
- Java - How to set custom thread name?
- IntelliJ: Error: Could not find or load main class, java.lang.ClassNotFoundException
- java: ']' expected error [fixed]
More Posts:
- Android : IOException: Unable to open sync connection! - Android
- Force convert HTML text input to upper case - Html
- How to Disable Mac Terminal Bell Sound - MacOS
- Android Emulator Screenshot saved location - Android-Studio
- How to Adjust macOS System Font Size - MacOS
- Cmd command get current directory location - Windows
- CentOS Cannot find a valid baseurl for repo base7x86_64 yum - HowTos
- How to enable line numbers in Eclipse IDE - Eclipse