|
||||||||||
| 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 | |||||||||