Oracle addBatch()用法实例详解

Connection connection =getConnection();

connection .setAutoCommit( false );

PreparedStatement statement = connection .prepareStatement( "INSERT INTO TABLEX VALUES(?, ?)" ); 

//记录1

statement.setInt(1, 1);

statement.setString(2, "Cujo" );

statement.addBatch(); 

//记录2

statement.setInt(1, 2);

statement.setString(2, "Fred" );

statement.addBatch(); 

//记录3

statement.setInt(1, 3);

statement.setString(2, "Mark" );

statement.addBatch(); 

//批量执行上面3条语句.

int [] counts = statement.executeBatch(); 

// Commit it 到(DB)里面