Batch Processing in JDBC

 Batch Processing in JDBC

Code::

for explanation watch video :

package com.jdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

public class OracleConn {

public static void main(String[] args) {

try (Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "system", "tiger");

Statement st = con.createStatement()) {

// add queries to batch ..these queries can belong to same db table or different

// db tables but must be non-select Queries

st.addBatch("INSERT INTO STUDENT VALUES(4444,'david',55.77,'france')");

st.addBatch("UPDATE  STUDENT SET AVG=AVG+10 WHERE SNO=2");

st.addBatch("DELETE FROM STUDENT WHERE SNO=1");

// execute the batch

int result[] = st.executeBatch();

// find sum of the records that are effected

int sum = 0;

for (int i = 0; i < result.length; ++i)

sum = sum + result[i];

System.out.println("Total no.of records that effected::" + sum);

} catch (SQLException se) {

se.printStackTrace();

} catch (Exception e) {

e.printStackTrace();

}

}

}