Batch Updates

BatchUpdates

import java.sql.*;
class BatchUpdates
{
public static void main(String[] args) throws Exception
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
Statement stmt=con.createStatement();
String s1="insert into emp3 values(1,'rahul')";
String s2="insert into emp3 values(2,'arun')";
String s3="insert into emp3 values(3,'pavan')";
String s4="insert into emp3 values(4,'gopi')";
String s5="insert into emp3 values(2,'arun')";
String s6="insert into emp3 values(2,'arun')";
stmt.addBatch(s1);
stmt.addBatch(s2);
stmt.addBatch(s3);
stmt.addBatch(s4);
stmt.addBatch(s5);
stmt.addBatch(s6);
int a[]=stmt.executeBatch();
for(int i=0;i<=a.length;i++) { System.out.println("no of rows inserted:------->"+a[i]);
}
}
}