Batch Inserts to Oracle using Java

See the following example:

import java.sql.*;

public class ExamplePreparedStatementBatch {

public static void main(String[] args) {

Connection con = null;

try {

oracle.jdbc.pool.OracleDataSource ds = new oracle.jdbc.pool.OracleDataSource();

ds.setDriverType("thin");

ds.setServerName("localhost");

ds.setPortNumber(1521);

ds.setDatabaseName("XE");

ds.setUser("hr");

ds.setPassword("abcd");

con = ds.getConnection();

PreparedStatement ps = con

.prepareStatement("INSERT INTO contact (cnid, cnname)"

+ " VALUES (?, ?)");

ps.setInt(1, 10);

ps.setString(2, "X");

ps.addBatch();

ps.setInt(1, 11);

ps.setString(2, "X");

ps.addBatch();

ps.setInt(1, 12);

ps.setString(2, "X");

ps.addBatch();

ps.setInt(1, 13);

ps.setString(2, "X");

ps.addBatch();

int[] counts = ps.executeBatch();

int count = 0;

for (int i = 0; i <>

count += counts[i];

}

System.out.println("Total effected rows: " + count);

ps.close();

con.close();

} catch (Exception e) {

System.err.println("Exception: " + e.getMessage());

e.printStackTrace();

}

}

}