Interface BatchPreparedStatementSetter

public interface BatchPreparedStatementSetter

Callback interface used by the JdbcTemplate class. This interface sets values on a a PreparedStatement provided by the JdbcTemplate class for each of a number of updates in a batch using the same SQL. Implementations are responsible for setting any necessary parameters. SQL with placeholders will already have been supplied. Implementations do not need to concern themselves with SQLExceptions that may be thrown from operations they attempt. The JdbcTemplate class will catch and handle SQLExceptions appropriately.

March 2, 2003
$Id:,v 1.1 2003/04/23 20:55:22 johnsonr Exp $
Rod Johnson

Method Summary
 int getBatchSize()
          Return the size of the batch
 void setValues(java.sql.PreparedStatement ps, int i)
          Set values on the given PreparedStatement

Method Detail


public void setValues(java.sql.PreparedStatement ps,
                      int i)
               throws java.sql.SQLException
Set values on the given PreparedStatement
ps - PreparedStatement we'll invoke setter methods on
i - index of the statement we're issuing in the batch, from 0
java.sql.SQLException - there is no need to catch SQLExceptions that may be thrown in the implementation of this method. The JdbcTemplate class will handle them.


public int getBatchSize()
Return the size of the batch

Rod Johnson and Spring contributors 2001-2003.