Interface BatchPreparedStatementSetter

public interface BatchPreparedStatementSetter

Callback interface used by the JdbcTemplate class.

This interface sets values on 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.3 2004/03/18 02:46:08 trisberg Exp $
Rod Johnson
See Also:
JdbcTemplate.batchUpdate(String, BatchPreparedStatementSetter)

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, starting 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.

Copyright (C) 2003-2004 The Spring Framework Project.