//jdbc program for BatchUpdate using prepared Statement
/*BatchUpdate: inserting multiple records in a single program*/
import java.sql.*;
import java.util.*;
import java.io.*;
public class BatchUpdateEx2 {
public static void main(String s[]) throws Exception {
Driver d= (Driver) ( Class.forName(
"com.mysql.jdbc.Driver").newInstance());
Properties p=new Properties ();
p.put("user","root");
p.put("password","admin");
Connection con=d.connect("jdbc:mysql://localhost:3306/test",p);
//st.addBatch("insert into emp(empno,ename,sal,deptno) values(102,'Ashwini',4000,30)");
PreparedStatement ps= con.prepareStatement("insert into emp(empno,ename,sal,deptno) values(?,?,?,?)");
ps.setInt(1,204);
ps.setString(2, "santosh");
ps.setDouble(3,1000);
ps.setInt(4,10);
ps.addBatch();
ps.setInt(1,205);
ps.setString(2, "rakesh");
ps.setDouble(3,3000);
ps.setInt(4,5);
ps.addBatch();
try {
int counts[]= ps.executeBatch();
System.out.println("Batch Executed Successfully");
for (int i=0;i<counts.length;i++){
System.out.println("Number of records effected by statement"+(i+1)+": "+counts[i]);
}//for
}//try
catch(BatchUpdateException e){
System.out.println("Batch terminated with an abnormal condition");
int[] counts=e.getUpdateCounts();
System.out.println("Batch terminated at statement"+ (counts.length+1));
for (int i=0;i<counts.length;i++) {
System.out.println("Number of records effected by the statement"+ (i+1)+": "+counts[i]);
}//for
}//catch
con.close();
}//main
}//class
/*BatchUpdate: inserting multiple records in a single program*/
import java.sql.*;
import java.util.*;
import java.io.*;
public class BatchUpdateEx2 {
public static void main(String s[]) throws Exception {
Driver d= (Driver) ( Class.forName(
"com.mysql.jdbc.Driver").newInstance());
Properties p=new Properties ();
p.put("user","root");
p.put("password","admin");
Connection con=d.connect("jdbc:mysql://localhost:3306/test",p);
//st.addBatch("insert into emp(empno,ename,sal,deptno) values(102,'Ashwini',4000,30)");
PreparedStatement ps= con.prepareStatement("insert into emp(empno,ename,sal,deptno) values(?,?,?,?)");
ps.setInt(1,204);
ps.setString(2, "santosh");
ps.setDouble(3,1000);
ps.setInt(4,10);
ps.addBatch();
ps.setInt(1,205);
ps.setString(2, "rakesh");
ps.setDouble(3,3000);
ps.setInt(4,5);
ps.addBatch();
try {
int counts[]= ps.executeBatch();
System.out.println("Batch Executed Successfully");
for (int i=0;i<counts.length;i++){
System.out.println("Number of records effected by statement"+(i+1)+": "+counts[i]);
}//for
}//try
catch(BatchUpdateException e){
System.out.println("Batch terminated with an abnormal condition");
int[] counts=e.getUpdateCounts();
System.out.println("Batch terminated at statement"+ (counts.length+1));
for (int i=0;i<counts.length;i++) {
System.out.println("Number of records effected by the statement"+ (i+1)+": "+counts[i]);
}//for
}//catch
con.close();
}//main
}//class
No comments:
Post a Comment