Batch Processing

add_batch.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class add_batch {
public static void main(String [] args) {
	try {
		Class.forName("oracle.jdbc.OracleDriver");
		System.out.println("Sucessfully loaded drivers");
		
		 Connection conn=DriverManager.getConnection
				("jdbc:oracle:thin:@//localhost:1521/orcl","hr","hr");
		System.out.println("Sucessfully Connected");
		
		Statement st =  conn.createStatement();
	    
		String SQL="INSERT INTO COMPANY_1 values(8,'NIIT') ";
		 st.addBatch(SQL);
		
		 SQL="INSERT INTO COMPANY_1 values(9,'TATA MOTORS') ";
		 st.addBatch(SQL);
		
		SQL="INSERT INTO COMPANY_1 values(10,'Mahindra') ";
		 st.addBatch(SQL);
		 st.executeBatch();
		
		System.out.println("Record ADDed");
		conn.close();
	}
		catch(Exception e){
		e.printStackTrace();	
		}
}
}

pre_batch.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class pre_batch {
	public static void main(String [] args) {
		try {
			Class.forName("oracle.jdbc.OracleDriver");
			System.out.println("Sucessfully loaded drivers");
			
			 Connection conn=DriverManager.getConnection
					("jdbc:oracle:thin:@//localhost:1521/orcl","hr","hr");
			System.out.println("Sucessfully Connected");
		
			String SQL ="INSERT INTO company_1 values(?,?)";
			PreparedStatement pstmt=conn.prepareStatement(SQL);
			pstmt.setString(1, "11");
			pstmt.setString(2, "Tata Tea");
			pstmt.addBatch();
			
			pstmt.setString(1, "12");
			pstmt.setString(2, "Jio");
			pstmt.addBatch();
			
			int[] count=pstmt.executeBatch();
			System.out.println("Record ADDed :"+count.length);
			conn.close();
		}
		catch(Exception e){
			e.printStackTrace();	
			}
	}

}