commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adkins Kendall <Kendall.Adk...@HCAhealthcare.com>
Subject Batch Update
Date Tue, 02 Mar 2004 15:10:56 GMT
Has any consideration been given to adding batch update capability?  For
instance, the following method could be added to the QueryRunner class:

/**
 * Execute a batch of SQL INSERT, UPDATE, or DELETE queries.
 * 
 * @param conn The connection to use to run the query.
 * @param sql The SQL to execute.
 * @param params An array of query replacement parameters.
 * @return The number of rows updated per statement.
 * @throws SQLException
 */
public int[] batchUpdate(Connection conn, String sql, Object[][] params)
	throws SQLException {
	PreparedStatement stmt = null;
	int[] rows = null;
	try {
		stmt = this.prepareStatement(conn, sql);
		
		for(int i = 0; i < params.length; i++) {
			this.fillStatement(stmt, params[i]);
			stmt.addBatch();
		}
		rows = stmt.executeBatch();
	} catch (SQLException e) {
		this.rethrow(e, sql, params);
	} finally {
		DbUtils.close(stmt);
	}
	return rows;
}


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org


Mime
View raw message