| 
 | ||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.springframework.jdbc.core.PreparedStatementCreatorFactory
public class PreparedStatementCreatorFactory
Helper class that efficiently creates multiple PreparedStatementCreator
 objects with different parameters based on a SQL statement and a single
 set of parameter declarations.
| Constructor Summary | |
|---|---|
| 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 declaredParameters)Create a new factory with the given SQL and parameters. | |
| Method Summary | |
|---|---|
|  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. | 
| Methods inherited from class java.lang.Object | 
|---|
| clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait | 
| Constructor Detail | 
|---|
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 types
public PreparedStatementCreatorFactory(String sql,
                                       List declaredParameters)
sql - SQLdeclaredParameters - list of SqlParameter objectsSqlParameter| Method Detail | 
|---|
public 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)| 
 | ||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||