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.