Tutusfunny

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.