public class PreparedStatementCreatorFactory extends Object
PreparedStatementCreator
objects with different parameters based on a SQL statement and a single
set of parameter declarations.| Constructor and Description |
|---|
PreparedStatementCreatorFactory(String sql)
Create a new factory.
|
PreparedStatementCreatorFactory(String sql,
int[] types)
Create a new factory with the given SQL and JDBC types.
|
PreparedStatementCreatorFactory(String sql,
List<SqlParameter> declaredParameters)
Create a new factory with the given SQL and parameters.
|
| Modifier and Type | Method and Description |
|---|---|
void |
addParameter(SqlParameter param)
Add a new declared parameter.
|
PreparedStatementCreator |
newPreparedStatementCreator(List<?> params)
Return a new PreparedStatementCreator for the given parameters.
|
PreparedStatementCreator |
newPreparedStatementCreator(Object[] params)
Return a new PreparedStatementCreator for the given parameters.
|
PreparedStatementCreator |
newPreparedStatementCreator(String sqlToUse,
Object[] params)
Return a new PreparedStatementCreator for the given parameters.
|
PreparedStatementSetter |
newPreparedStatementSetter(List<?> params)
Return a new PreparedStatementSetter for the given parameters.
|
PreparedStatementSetter |
newPreparedStatementSetter(Object[] params)
Return a new PreparedStatementSetter for the given parameters.
|
void |
setGeneratedKeysColumnNames(String[] names)
Set the column names of the auto-generated keys.
|
void |
setNativeJdbcExtractor(NativeJdbcExtractor nativeJdbcExtractor)
Specify the NativeJdbcExtractor to use for unwrapping PreparedStatements, if any.
|
void |
setResultSetType(int resultSetType)
Set whether to use prepared statements that return a specific type of ResultSet.
|
void |
setReturnGeneratedKeys(boolean returnGeneratedKeys)
Set whether prepared statements should be capable of returning auto-generated keys.
|
void |
setUpdatableResults(boolean updatableResults)
Set whether to use prepared statements capable of returning updatable ResultSets.
|
public PreparedStatementCreatorFactory(String sql)
addParameter(org.springframework.jdbc.core.SqlParameter) method or have no parameters.public PreparedStatementCreatorFactory(String sql, int[] types)
sql - SQL to executetypes - int array of JDBC typespublic PreparedStatementCreatorFactory(String sql, List<SqlParameter> declaredParameters)
sql - SQLdeclaredParameters - list of SqlParameter objectsSqlParameterpublic void addParameter(SqlParameter param)
Order of parameter addition is significant.
param - the parameter to add to the list of declared parameterspublic void setResultSetType(int resultSetType)
resultSetType - the ResultSet typeResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.TYPE_SCROLL_SENSITIVEpublic void setUpdatableResults(boolean updatableResults)
public void setReturnGeneratedKeys(boolean returnGeneratedKeys)
public void setGeneratedKeysColumnNames(String[] names)
public void setNativeJdbcExtractor(NativeJdbcExtractor nativeJdbcExtractor)
public PreparedStatementSetter newPreparedStatementSetter(List<?> params)
params - list of parameters (may be null)public PreparedStatementSetter newPreparedStatementSetter(Object[] params)
params - the parameter array (may be null)public PreparedStatementCreator newPreparedStatementCreator(List<?> params)
params - list of parameters (may be null)public PreparedStatementCreator newPreparedStatementCreator(Object[] params)
params - the parameter array (may be null)public PreparedStatementCreator newPreparedStatementCreator(String sqlToUse, Object[] params)
sqlToUse - the actual SQL statement to use (if different from
the factory's, for example because of named parameter expanding)params - the parameter array (may be null)