Package | Description |
---|---|
org.springframework.jdbc.core |
Provides the core JDBC framework, based on JdbcTemplate
and its associated callback interfaces and helper objects.
|
org.springframework.jdbc.core.metadata |
Context metadata abstraction for the configuration and execution
of table inserts and stored procedure calls.
|
org.springframework.jdbc.core.namedparam |
JdbcTemplate variant with named parameter support.
|
org.springframework.jdbc.core.simple |
Simplification layer for table inserts and stored procedure calls.
|
org.springframework.jdbc.object |
The classes in this package represent RDBMS queries, updates,
and stored procedures as threadsafe, reusable objects.
|
Modifier and Type | Class and Description |
---|---|
class |
ResultSetSupportingSqlParameter
Common base class for ResultSet-supporting SqlParameters like
SqlOutParameter and SqlReturnResultSet . |
class |
SqlInOutParameter
Subclass of
SqlOutParameter to represent an INOUT parameter. |
class |
SqlOutParameter
Subclass of
SqlParameter to represent an output parameter. |
class |
SqlParameterValue
Object to represent an SQL parameter value, including parameter meta-data
such as the SQL type and the scale for numeric values.
|
class |
SqlReturnResultSet
Represents a returned
ResultSet from a stored procedure call. |
class |
SqlReturnUpdateCount
Represents a returned update count from a stored procedure call.
|
Modifier and Type | Method and Description |
---|---|
static List<SqlParameter> |
SqlParameter.sqlTypesToAnonymousParameterList(int... types)
Convert a list of JDBC types, as defined in
java.sql.Types ,
to a List of SqlParameter objects as used in this package. |
Modifier and Type | Method and Description |
---|---|
void |
PreparedStatementCreatorFactory.addParameter(SqlParameter param)
Add a new declared parameter.
|
void |
CallableStatementCreatorFactory.addParameter(SqlParameter param)
Add a new declared parameter.
|
static void |
StatementCreatorUtils.setParameterValue(PreparedStatement ps,
int paramIndex,
SqlParameter param,
Object inValue)
Set the value for a parameter.
|
Modifier and Type | Method and Description |
---|---|
Map<String,Object> |
JdbcTemplate.call(CallableStatementCreator csc,
List<SqlParameter> declaredParameters) |
Map<String,Object> |
JdbcOperations.call(CallableStatementCreator csc,
List<SqlParameter> declaredParameters)
Execute an SQL call using a CallableStatementCreator to provide SQL and
any required parameters.
|
protected Map<String,Object> |
JdbcTemplate.extractOutputParameters(CallableStatement cs,
List<SqlParameter> parameters)
Extract output parameters from the completed stored procedure.
|
protected Map<String,Object> |
JdbcTemplate.extractReturnedResults(CallableStatement cs,
List<SqlParameter> updateCountParameters,
List<SqlParameter> resultSetParameters,
int updateCount)
Extract returned ResultSets from the completed stored procedure.
|
protected Map<String,Object> |
JdbcTemplate.extractReturnedResults(CallableStatement cs,
List<SqlParameter> updateCountParameters,
List<SqlParameter> resultSetParameters,
int updateCount)
Extract returned ResultSets from the completed stored procedure.
|
Constructor and Description |
---|
SqlParameter(SqlParameter otherParam)
Copy constructor.
|
SqlParameterValue(SqlParameter declaredParam,
Object value)
Create a new SqlParameterValue based on the given SqlParameter declaration.
|
Constructor and Description |
---|
CallableStatementCreatorFactory(String callString,
List<SqlParameter> declaredParameters)
Create a new factory with the given SQL and the given parameters.
|
PreparedStatementCreatorFactory(String sql,
List<SqlParameter> declaredParameters)
Create a new factory with the given SQL and parameters.
|
Modifier and Type | Method and Description |
---|---|
SqlParameter |
GenericCallMetaDataProvider.createDefaultInOutParameter(String parameterName,
CallParameterMetaData meta) |
SqlParameter |
CallMetaDataProvider.createDefaultInOutParameter(String parameterName,
CallParameterMetaData meta)
Create a default in/out parameter based on the provided meta-data.
|
SqlParameter |
GenericCallMetaDataProvider.createDefaultInParameter(String parameterName,
CallParameterMetaData meta) |
SqlParameter |
CallMetaDataProvider.createDefaultInParameter(String parameterName,
CallParameterMetaData meta)
Create a default in parameter based on the provided meta-data.
|
SqlParameter |
GenericCallMetaDataProvider.createDefaultOutParameter(String parameterName,
CallParameterMetaData meta) |
SqlParameter |
CallMetaDataProvider.createDefaultOutParameter(String parameterName,
CallParameterMetaData meta)
Create a default out parameter based on the provided meta-data.
|
SqlParameter |
OracleCallMetaDataProvider.createDefaultOutParameter(String parameterName,
CallParameterMetaData meta) |
SqlParameter |
PostgresCallMetaDataProvider.createDefaultOutParameter(String parameterName,
CallParameterMetaData meta) |
SqlParameter |
CallMetaDataContext.createReturnResultSetParameter(String parameterName,
RowMapper<?> rowMapper)
Create a ReturnResultSetParameter/SqlOutParameter depending on the support provided
by the JDBC driver used for the database in use.
|
Modifier and Type | Method and Description |
---|---|
List<SqlParameter> |
CallMetaDataContext.getCallParameters()
Get the List of SqlParameter objects to be used in call execution.
|
protected List<SqlParameter> |
CallMetaDataContext.reconcileParameters(List<SqlParameter> parameters)
Reconcile the provided parameters with available meta-data and add new ones where appropriate.
|
Modifier and Type | Method and Description |
---|---|
protected String |
CallMetaDataContext.createParameterBinding(SqlParameter parameter)
Build the parameter binding fragment.
|
Modifier and Type | Method and Description |
---|---|
void |
CallMetaDataContext.processParameters(List<SqlParameter> parameters)
Process the list of parameters provided, and if procedure column meta-data is used,
the parameters will be matched against the meta-data information and any missing
ones will be automatically included.
|
protected List<SqlParameter> |
CallMetaDataContext.reconcileParameters(List<SqlParameter> parameters)
Reconcile the provided parameters with available meta-data and add new ones where appropriate.
|
Modifier and Type | Method and Description |
---|---|
static List<SqlParameter> |
NamedParameterUtils.buildSqlParameterList(ParsedSql parsedSql,
SqlParameterSource paramSource)
Convert parameter declarations from an SqlParameterSource to a corresponding List of SqlParameters.
|
Modifier and Type | Method and Description |
---|---|
static Object[] |
NamedParameterUtils.buildValueArray(ParsedSql parsedSql,
SqlParameterSource paramSource,
List<SqlParameter> declaredParams)
Convert a Map of named parameter values to a corresponding array.
|
Modifier and Type | Method and Description |
---|---|
protected List<SqlParameter> |
AbstractJdbcCall.getCallParameters()
Get a List of all the call parameters to be used for call.
|
Modifier and Type | Method and Description |
---|---|
void |
AbstractJdbcCall.addDeclaredParameter(SqlParameter parameter)
Add a declared parameter to the list of parameters for the call.
|
SimpleJdbcCallOperations |
SimpleJdbcCallOperations.declareParameters(SqlParameter... sqlParameters)
Specify one or more parameters if desired.
|
SimpleJdbcCall |
SimpleJdbcCall.declareParameters(SqlParameter... sqlParameters) |
Modifier and Type | Method and Description |
---|---|
protected List<SqlParameter> |
RdbmsOperation.getDeclaredParameters()
Return a list of the declared
SqlParameter objects. |
Modifier and Type | Method and Description |
---|---|
void |
StoredProcedure.declareParameter(SqlParameter param)
Declare a parameter.
|
void |
RdbmsOperation.declareParameter(SqlParameter param)
Declare a parameter for this operation.
|
void |
RdbmsOperation.setParameters(SqlParameter... parameters)
Add one or more declared parameters.
|