org.springframework.jdbc.core

public Interface PreparedStatementCreator

Known Direct Implementers

org.springframework.jdbc.core.PreparedStatementCreatorFactory.PreparedStatementCreatorImpl, org.springframework.jdbc.core.JdbcTemplate.SimplePreparedStatementCreator

Annotations

@FunctionalInterface

Imports

java.sql.Connection, .PreparedStatement, .SQLException

One of the two central callback interfaces used by the JdbcTemplate class. This interface creates a PreparedStatement given a connection, provided by the JdbcTemplate class. Implementations are responsible for providing SQL and any necessary parameters.

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.

A PreparedStatementCreator should also implement the SqlProvider interface if it is able to provide the SQL it uses for PreparedStatement creation. This allows for better contextual information in case of exceptions.

Author: Rod Johnson
See Also: JdbcTemplate#execute(PreparedStatementCreator, PreparedStatementCallback), JdbcTemplate#query(PreparedStatementCreator, RowCallbackHandler), JdbcTemplate#update(PreparedStatementCreator), SqlProvider

Method Summary

Modifier and Type	Method and Description
public PreparedStatement	Returns: a prepared statement createPreparedStatement(Connection the connection used to create statement con) Create a statement in this connection.

Method Detail

createPreparedStatement	back to summary
public PreparedStatement createPreparedStatement(Connection con) throws SQLException Create a statement in this connection. Allows implementations to use PreparedStatements. The JdbcTemplate will close the created statement. Parameters con:Connection the connection used to create statement Returns:PreparedStatement a prepared statement Exceptions SQLException: there is no need to catch SQLExceptions that may be thrown in the implementation of this method. The JdbcTemplate class will handle them.

createPreparedStatement

back to summary

public PreparedStatement createPreparedStatement(Connection con) throws SQLException

Create a statement in this connection. Allows implementations to use PreparedStatements. The JdbcTemplate will close the created statement.

Parameters

con:Connection: the connection used to create statement

Returns:PreparedStatement

a prepared statement

Exceptions

SQLException:: there is no need to catch SQLExceptions that may be thrown in the implementation of this method. The JdbcTemplate class will handle them.