Uses of Class
org.springframework.jdbc.core.SqlParameter
Package
Description
Provides the core JDBC framework, based on JdbcTemplate
and its associated callback interfaces and helper objects.
Context metadata abstraction for the configuration and execution
of table inserts and stored procedure calls.
JdbcTemplate variant with named parameter support.
Simplification layer for table inserts and stored procedure calls.
The classes in this package represent RDBMS queries, updates, and stored
procedures as threadsafe, reusable objects.
-
Uses of SqlParameter in org.springframework.jdbc.core
Modifier and TypeClassDescriptionclass
Common base class for ResultSet-supporting SqlParameters likeSqlOutParameter
andSqlReturnResultSet
.class
Subclass ofSqlOutParameter
to represent an INOUT parameter.class
Subclass ofSqlParameter
to represent an output parameter.class
Object to represent an SQL parameter value, including parameter meta-data such as the SQL type and the scale for numeric values.class
Represents a returnedResultSet
from a stored procedure call.class
Represents a returned update count from a stored procedure call.Modifier and TypeMethodDescriptionstatic List<SqlParameter>
SqlParameter.sqlTypesToAnonymousParameterList
(int... types) Convert a list of JDBC types, as defined injava.sql.Types
, to a List of SqlParameter objects as used in this package.Modifier and TypeMethodDescriptionvoid
CallableStatementCreatorFactory.addParameter
(SqlParameter param) Add a new declared parameter.void
PreparedStatementCreatorFactory.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 TypeMethodDescriptionJdbcOperations.call
(CallableStatementCreator csc, List<SqlParameter> declaredParameters) Execute an SQL call using a CallableStatementCreator to provide SQL and any required parameters.JdbcTemplate.call
(CallableStatementCreator csc, List<SqlParameter> declaredParameters) JdbcTemplate.extractOutputParameters
(CallableStatement cs, List<SqlParameter> parameters) Extract output parameters from the completed stored procedure.JdbcTemplate.extractReturnedResults
(CallableStatement cs, List<SqlParameter> updateCountParameters, List<SqlParameter> resultSetParameters, int updateCount) Extract returned ResultSets from the completed stored procedure.ModifierConstructorDescriptionSqlParameter
(SqlParameter otherParam) Copy constructor.SqlParameterValue
(SqlParameter declaredParam, Object value) Create a new SqlParameterValue based on the given SqlParameter declaration.ModifierConstructorDescriptionCallableStatementCreatorFactory
(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. -
Uses of SqlParameter in org.springframework.jdbc.core.metadata
Modifier and TypeMethodDescriptionCallMetaDataProvider.createDefaultInOutParameter
(String parameterName, CallParameterMetaData meta) Create a default in/out parameter based on the provided meta-data.GenericCallMetaDataProvider.createDefaultInOutParameter
(String parameterName, CallParameterMetaData meta) CallMetaDataProvider.createDefaultInParameter
(String parameterName, CallParameterMetaData meta) Create a default in parameter based on the provided meta-data.GenericCallMetaDataProvider.createDefaultInParameter
(String parameterName, CallParameterMetaData meta) CallMetaDataProvider.createDefaultOutParameter
(String parameterName, CallParameterMetaData meta) Create a default out parameter based on the provided meta-data.GenericCallMetaDataProvider.createDefaultOutParameter
(String parameterName, CallParameterMetaData meta) OracleCallMetaDataProvider.createDefaultOutParameter
(String parameterName, CallParameterMetaData meta) PostgresCallMetaDataProvider.createDefaultOutParameter
(String parameterName, CallParameterMetaData meta) 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 TypeMethodDescriptionCallMetaDataContext.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 TypeMethodDescriptionprotected String
CallMetaDataContext.createParameterBinding
(SqlParameter parameter) Build the parameter binding fragment.Modifier and TypeMethodDescriptionvoid
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. -
Uses of SqlParameter in org.springframework.jdbc.core.namedparam
Modifier and TypeMethodDescriptionstatic List<SqlParameter>
NamedParameterUtils.buildSqlParameterList
(ParsedSql parsedSql, SqlParameterSource paramSource) Convert parameter declarations from an SqlParameterSource to a corresponding List of SqlParameters.Modifier and TypeMethodDescriptionstatic Object[]
NamedParameterUtils.buildValueArray
(ParsedSql parsedSql, SqlParameterSource paramSource, List<SqlParameter> declaredParams) Convert a Map of named parameter values to a corresponding array. -
Uses of SqlParameter in org.springframework.jdbc.core.simple
Modifier and TypeMethodDescriptionprotected List<SqlParameter>
AbstractJdbcCall.getCallParameters()
Get a List of all the call parameters to be used for call.Modifier and TypeMethodDescriptionvoid
AbstractJdbcCall.addDeclaredParameter
(SqlParameter parameter) Add a declared parameter to the list of parameters for the call.SimpleJdbcCall.declareParameters
(SqlParameter... sqlParameters) SimpleJdbcCallOperations.declareParameters
(SqlParameter... sqlParameters) Specify one or more parameters if desired. -
Uses of SqlParameter in org.springframework.jdbc.object
Modifier and TypeMethodDescriptionprotected List<SqlParameter>
RdbmsOperation.getDeclaredParameters()
Return a list of the declaredSqlParameter
objects.Modifier and TypeMethodDescriptionvoid
RdbmsOperation.declareParameter
(SqlParameter param) Declare a parameter for this operation.void
StoredProcedure.declareParameter
(SqlParameter param) Declare a parameter.void
RdbmsOperation.setParameters
(SqlParameter... parameters) Add one or more declared parameters.