Package org.springframework.jdbc.core

Interface BatchPreparedStatementSetter

All Known Subinterfaces:

InterruptibleBatchPreparedStatementSetter

All Known Implementing Classes:

AbstractInterruptibleBatchPreparedStatementSetter

public interface BatchPreparedStatementSetter

Batch update 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.

Since:

March 2, 2003

Author:

Rod Johnson

See Also:

• JdbcTemplate.batchUpdate(String, BatchPreparedStatementSetter)
• InterruptibleBatchPreparedStatementSetter

Method Summary

Modifier and Type	Method	Description
int	getBatchSize()	Return the size of the batch.
void	setValues(PreparedStatement ps, int i)	Set parameter values on the given PreparedStatement.

Method Details

setValues

void setValues(PreparedStatement ps,
 int i)
        throws SQLException

Set parameter values on the given PreparedStatement.

Parameters:

ps - the PreparedStatement to invoke setter methods on

i - index of the statement we're issuing in the batch, starting from 0

Throws:

SQLException - if an SQLException is encountered (i.e. there is no need to catch SQLException)

getBatchSize

int getBatchSize()

Return the size of the batch.

Returns:

the number of statements in the batch