⚙️ Batch Processing

? Quick Overview

Batch processing in Advance Java allows executing multiple database operations together as a single unit. It significantly improves performance by reducing database round-trips and is widely used in bulk inserts, updates, and deletes.

? Key Concepts

• Execute multiple SQL statements in one request
• Improves performance for large datasets
• Commonly used with JDBC
• Reduces network and database overhead

? Syntax / Theory

In JDBC, batch processing is achieved using addBatch() and executeBatch(). Statements are collected and sent to the database together instead of one by one.

// Example of JDBC batch insert operation
Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/testdb","root","password");

PreparedStatement ps = con.prepareStatement(
"INSERT INTO student(name, age) VALUES(?, ?)");

ps.setString(1, "Amit");
ps.setInt(2, 22);
ps.addBatch();

ps.setString(1, "Neha");
ps.setInt(2, 21);
ps.addBatch();

ps.executeBatch();
con.close();