package in.bench.resources.mysql.db.example;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class BatchUpdateUsingJDBCStatement {

	public static void main(String[] args) {

		// variables
		Connection connection = null;
		Statement statement = null;

		// Step 1: Loading or registering MySQL JDBC driver class
		try {
			Class.forName("com.mysql.jdbc.Driver");
		}
		catch(ClassNotFoundException cnfex) {
			System.out.println("Problem in loading MySQL JDBC driver");
			cnfex.printStackTrace();
		}

		// Step 2: Opening database connection
		try {

			// Step 2.A: Create and get connection using DriverManager
			connection = DriverManager.getConnection(
          "jdbc:mysql://localhost:3306/PLAYER_INFO", "root", "root@123"); 

			// Start of JDBC transaction
			connection.setAutoCommit(false);

			// Step 2.B: Creating JDBC Statement
			statement = connection.createStatement();

			// create SQL query to update PLAYER info
			String sqlUpdateQuery_1 =
                    "UPDATE PLAYER SET AGE = 46 WHERE PLAYER_ID = 2";

			// add to batch for execution
			statement.addBatch(sqlUpdateQuery_1);

			// again create SQL query to update another PLAYER info
			String sqlUpdateQuery_2 =
                       "UPDATE PLAYER SET AGE = 35 WHERE PLAYER_ID = 3";

			// add to batch for execution
			statement.addBatch(sqlUpdateQuery_2);

			// again create SQL query to update another PLAYER info
			String sqlUpdateQuery_3 =
   "UPDATE PLAYER SET NAME = 'Graeme Craig Smith' WHERE PLAYER_ID = 6";

			// add to batch for execution
			statement.addBatch(sqlUpdateQuery_3);

			// Step 2.C: Executing SQL and retrieve data into ResultSet
			statement.executeBatch();

			// End of JDBC transaction
			connection.commit();

			System.out.println("
                  All PLAYER info updation is successful");
		}
		catch(SQLException sqlex){
			sqlex.printStackTrace();
		}
		finally {

			// Step 3: Closing database connection
			try {
				if(null != connection) {

					// cleanup resources, once after processing
					statement.close();

					// and then finally close connection
					connection.close();
				}
			}
			catch (SQLException sqlex) {
				sqlex.printStackTrace();
			}
		}
	}
}

All PLAYER info updation is successful