org.springframework.jdbc.core
Class PreparedStatementCreatorFactory

java.lang.Object
  org.springframework.jdbc.core.PreparedStatementCreatorFactory

public class PreparedStatementCreatorFactory

extends java.lang.Object

Helper class that can efficiently create multiple PreparedStatementCreator objects with different parameters based on a SQL statement and a single set of parameter declarations.

Version:

$Id: PreparedStatementCreatorFactory.java,v 1.9 2004/03/18 02:46:08 trisberg Exp $

Author:

Rod Johnson

Constructor Summary

PreparedStatementCreatorFactory(java.lang.String sql)
Create a new factory.

PreparedStatementCreatorFactory(java.lang.String sql, int[] types)
Create a new factory with the given SQL and JDBC types.

PreparedStatementCreatorFactory(java.lang.String sql, java.util.List declaredParameters)
Create a new factory with the given SQL and parameters.

Method Summary

void	addParameter(SqlParameter param) Add a new declared parameter.
PreparedStatementCreator	newPreparedStatementCreator(java.util.List params) Return a new PreparedStatementCreator instance given this parameters.
PreparedStatementCreator	newPreparedStatementCreator(java.lang.Object[] params) Return a new PreparedStatementCreator given these parameters.
void	setResultSetType(int resultSetType) Set whether to use prepared statements that return a specific type of ResultSet.
void	setUpdatableResults(boolean updatableResults) Set whether to use prepared statements capable of returning updatable ResultSets.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PreparedStatementCreatorFactory

public PreparedStatementCreatorFactory(java.lang.String sql)

Create a new factory. Will need to add parameters via the addParameter() method or have no parameters.

PreparedStatementCreatorFactory

public PreparedStatementCreatorFactory(java.lang.String sql,
                                       int[] types)

Create a new factory with the given SQL and JDBC types.

Parameters:

sql - SQL to execute

types - int array of JDBC types

PreparedStatementCreatorFactory

public PreparedStatementCreatorFactory(java.lang.String sql,
                                       java.util.List declaredParameters)

Create a new factory with the given SQL and parameters.

Parameters:

sql - SQL

declaredParameters - list of SqlParameter objects

See Also:

SqlParameter

Method Detail

addParameter

public void addParameter(SqlParameter param)

Add a new declared parameter. Order of parameter addition is significant.

setResultSetType

public void setResultSetType(int resultSetType)

Set whether to use prepared statements that return a specific type of ResultSet.

Parameters:

resultSetType - the ResultSet type

See Also:

ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.TYPE_SCROLL_SENSITIVE

setUpdatableResults

public void setUpdatableResults(boolean updatableResults)

Set whether to use prepared statements capable of returning updatable ResultSets.

newPreparedStatementCreator

public PreparedStatementCreator newPreparedStatementCreator(java.lang.Object[] params)

Return a new PreparedStatementCreator given these parameters.

Parameters:

params - parameter array. May be null.

newPreparedStatementCreator

public PreparedStatementCreator newPreparedStatementCreator(java.util.List params)

Return a new PreparedStatementCreator instance given this parameters.

Parameters:

params - List of parameters. May be null.