Batch Program in Java JDBC

The group of update statements that are sent to a database to be executed as a single unit called batch in java.

import java.sql.*;
public class Batch{

	public static void main(String[] args)
	{
		Connection con=null;

    try{

        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql://localhost/vbank","root","");    
		Statement st1=con.createStatement( );		
		String SQL1="insert into account (accno,bal) values('A0008',2500) ";

		String SQL2="insert into account (accno,bal) values('A0009',1500) ";

		String SQL3="update account set bal=1300 where accno='A0006' ";

		String SQL4="delete from account where accno='A0005' ";

		st1.addBatch(SQL1);
		st1.addBatch(SQL2);
		st1.addBatch(SQL3);
		st1.addBatch(SQL4);

		int[ ] status= st1.executeBatch( );

		for(int i=0;i<status.length;i++)
		{
		   System.out.println( status[ i ] );
		 }

		}
        catch (Exception e) 
         {
			System.out.println(e);
	     }
	}
	}

I have attached the video tutorial below it will help you  to do this  step by step.

Batch Program in Java JDBC

Share

Watch on