The group of update statements that are sent to a database to be executed as a single unit called batch in java.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | 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.
