The Spring Framework

## Uses of Interface
org.springframework.jdbc.core.namedparam.SqlParameterSource

Packages that use SqlParameterSource
org.springframework.jdbc.core.metadata: Context metadata abstraction for the configuration and execution of a stored procedure call.
org.springframework.jdbc.core.namedparam: JdbcTemplate variant with named parameter support.
org.springframework.jdbc.core.simple: Simplification layer over JdbcTemplate for Java 5 and above.

Uses of SqlParameterSource in org.springframework.jdbc.core.metadata

Methods in org.springframework.jdbc.core.metadata with parameters of type SqlParameterSource
`Map<String,Object>` `CallMetaDataContext.matchInParameterValuesWithCallParameters(SqlParameterSource parameterSource)` Match input parameter values with the parameters declared to be used in the call.
`List<Object>` `TableMetaDataContext.matchInParameterValuesWithInsertColumns(SqlParameterSource parameterSource)` Match the provided column names and values with the list of columns used.

Uses of SqlParameterSource in org.springframework.jdbc.core.namedparam

Classes in org.springframework.jdbc.core.namedparam that implement SqlParameterSource
`class` `AbstractSqlParameterSource` Abstract base class for `SqlParameterSource` implementations.
`class` `BeanPropertySqlParameterSource` `SqlParameterSource` implementation that obtains parameter values from bean properties of a given JavaBean object.
`class` `MapSqlParameterSource` `SqlParameterSource` implementation that holds a given Map of parameters.

Methods in org.springframework.jdbc.core.namedparam that return SqlParameterSource
`static SqlParameterSource[]` `SqlParameterSourceUtils.createBatch(Map[] valueMaps)` Create an array of MapSqlParameterSource objects populated with data from the values passed in.
`static SqlParameterSource[]` `SqlParameterSourceUtils.createBatch(Object[] beans)` Create an array of BeanPropertySqlParameterSource objects populated with data from the values passed in.

Methods in org.springframework.jdbc.core.namedparam with parameters of type SqlParameterSource
`static int[]` `NamedParameterUtils.buildSqlTypeArray(ParsedSql parsedSql, SqlParameterSource paramSource)` Convert a Map of parameter types to a corresponding int array.
`static Object[]` `NamedParameterUtils.buildValueArray(ParsedSql parsedSql, SqlParameterSource paramSource, List declaredParams)` Convert a Map of named parameter values to a corresponding array.
`Object` `NamedParameterJdbcTemplate.execute(String sql, SqlParameterSource paramSource, PreparedStatementCallback action)`
`Object` `NamedParameterJdbcOperations.execute(String sql, SqlParameterSource paramSource, PreparedStatementCallback action)` Execute a JDBC data access operation, implemented as callback action working on a JDBC PreparedStatement.
`static Map` `SqlParameterSourceUtils.extractCaseInsensitiveParameterNames(SqlParameterSource parameterSource)` Create a Map of case insensitive parameter names together with the original name.
`protected PreparedStatementCreator` `NamedParameterJdbcTemplate.getPreparedStatementCreator(String sql, SqlParameterSource paramSource)` Build a PreparedStatementCreator based on the given SQL and named parameters.
`static Object` `SqlParameterSourceUtils.getTypedValue(SqlParameterSource source, String parameterName)` Create a wrapped value if parameter has type information, plain object if not.
`Object` `NamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, ResultSetExtractor rse)`
`Object` `NamedParameterJdbcOperations.query(String sql, SqlParameterSource paramSource, ResultSetExtractor rse)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, reading the ResultSet with a ResultSetExtractor.
`void` `NamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, RowCallbackHandler rch)`
`void` `NamedParameterJdbcOperations.query(String sql, SqlParameterSource paramSource, RowCallbackHandler rch)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, reading the ResultSet on a per-row basis with a RowCallbackHandler.
`List` `NamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, RowMapper rowMapper)`
`List` `NamedParameterJdbcOperations.query(String sql, SqlParameterSource paramSource, RowMapper rowMapper)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, mapping each row to a Java object via a RowMapper.
`int` `NamedParameterJdbcTemplate.queryForInt(String sql, SqlParameterSource paramSource)`
`int` `NamedParameterJdbcOperations.queryForInt(String sql, SqlParameterSource paramSource)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, resulting in an int value.
`List` `NamedParameterJdbcTemplate.queryForList(String sql, SqlParameterSource paramSource)`
`List` `NamedParameterJdbcOperations.queryForList(String sql, SqlParameterSource paramSource)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result list.
`List` `NamedParameterJdbcTemplate.queryForList(String sql, SqlParameterSource paramSource, Class elementType)`
`List` `NamedParameterJdbcOperations.queryForList(String sql, SqlParameterSource paramSource, Class elementType)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result list.
`long` `NamedParameterJdbcTemplate.queryForLong(String sql, SqlParameterSource paramSource)`
`long` `NamedParameterJdbcOperations.queryForLong(String sql, SqlParameterSource paramSource)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, resulting in a long value.
`Map` `NamedParameterJdbcTemplate.queryForMap(String sql, SqlParameterSource paramSource)`
`Map` `NamedParameterJdbcOperations.queryForMap(String sql, SqlParameterSource paramSource)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result Map.
`Object` `NamedParameterJdbcTemplate.queryForObject(String sql, SqlParameterSource paramSource, Class requiredType)`
`Object` `NamedParameterJdbcOperations.queryForObject(String sql, SqlParameterSource paramSource, Class requiredType)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result object.
`Object` `NamedParameterJdbcTemplate.queryForObject(String sql, SqlParameterSource paramSource, RowMapper rowMapper)`
`Object` `NamedParameterJdbcOperations.queryForObject(String sql, SqlParameterSource paramSource, RowMapper rowMapper)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, mapping a single result row to a Java object via a RowMapper.
`SqlRowSet` `NamedParameterJdbcTemplate.queryForRowSet(String sql, SqlParameterSource paramSource)`
`SqlRowSet` `NamedParameterJdbcOperations.queryForRowSet(String sql, SqlParameterSource paramSource)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a SqlRowSet.
`static String` `NamedParameterUtils.substituteNamedParameters(ParsedSql parsedSql, SqlParameterSource paramSource)` Parse the SQL statement and locate any placeholders or named parameters.
`static String` `NamedParameterUtils.substituteNamedParameters(String sql, SqlParameterSource paramSource)` Parse the SQL statement and locate any placeholders or named parameters.
`int` `NamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource)`
`int` `NamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource)` Issue an update via a prepared statement, binding the given arguments.
`int` `NamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder)`
`int` `NamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder)` Issue an update via a prepared statement, binding the given arguments, returning generated keys.
`int` `NamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder, String[] keyColumnNames)`
`int` `NamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder, String[] keyColumnNames)` Issue an update via a prepared statement, binding the given arguments, returning generated keys.

Uses of SqlParameterSource in org.springframework.jdbc.core.simple

Methods in org.springframework.jdbc.core.simple with parameters of type SqlParameterSource
`int[]` `SimpleJdbcTemplate.batchUpdate(String sql, SqlParameterSource[] batchArgs)`
`int[]` `SimpleJdbcOperations.batchUpdate(String sql, SqlParameterSource[] batchArgs)` Execute a batch using the supplied SQL statement with the batch of supplied arguments.
`protected Map<String,Object>` `AbstractJdbcCall.doExecute(SqlParameterSource parameterSource)` Method that provides execution of the call using the passed in `SqlParameterSource`
`protected int` `AbstractJdbcInsert.doExecute(SqlParameterSource parameterSource)` Method that provides execution of the insert using the passed in `SqlParameterSource`
`protected Number` `AbstractJdbcInsert.doExecuteAndReturnKey(SqlParameterSource parameterSource)` Method that provides execution of the insert using the passed in `SqlParameterSource` and returning a generated key
`protected KeyHolder` `AbstractJdbcInsert.doExecuteAndReturnKeyHolder(SqlParameterSource parameterSource)` Method that provides execution of the insert using the passed in `SqlParameterSource` and returning all generated keys
`protected int[]` `AbstractJdbcInsert.doExecuteBatch(SqlParameterSource[] batch)` Method that provides execution of a batch insert using the passed in array of `SqlParameterSource`
`Map<String,Object>` `SimpleJdbcCallOperations.execute(SqlParameterSource args)` Execute the stored procedure and return a map of output params, keyed by name as in parameter declarations..
`int` `SimpleJdbcInsert.execute(SqlParameterSource parameterSource)`
`Map<String,Object>` `SimpleJdbcCall.execute(SqlParameterSource parameterSource)`
`int` `SimpleJdbcInsertOperations.execute(SqlParameterSource parameterSource)` Execute the insert using the values passed in.
`Number` `SimpleJdbcInsert.executeAndReturnKey(SqlParameterSource parameterSource)`
`Number` `SimpleJdbcInsertOperations.executeAndReturnKey(SqlParameterSource parameterSource)` Execute the insert using the values passed in and return the generated key.
`KeyHolder` `SimpleJdbcInsert.executeAndReturnKeyHolder(SqlParameterSource parameterSource)`
`KeyHolder` `SimpleJdbcInsertOperations.executeAndReturnKeyHolder(SqlParameterSource parameterSource)` Execute the insert using the values passed in and return the generated keys.
`int[]` `SimpleJdbcInsert.executeBatch(SqlParameterSource[] batch)`
`int[]` `SimpleJdbcInsertOperations.executeBatch(SqlParameterSource[] batch)` Execute a batch insert using the batch of values passed in.
`protected Map<String,Object>` `AbstractJdbcCall.matchInParameterValuesWithCallParameters(SqlParameterSource parameterSource)` Match the provided in parameter values with registered parameters and parameters defined via metadata processing.
`protected List<Object>` `AbstractJdbcInsert.matchInParameterValuesWithInsertColumns(SqlParameterSource parameterSource)` Match the provided in parameter values with regitered parameters and parameters defined via metedata processing.

`

`<T> List<T>`

`

`SimpleJdbcTemplate.query(String sql, ParameterizedRowMapper<T> rm, SqlParameterSource args)`

`

`<T> List<T>`

`

`SimpleJdbcOperations.query(String sql, ParameterizedRowMapper<T> rm, SqlParameterSource args)`
Query for a `List` of `Objects` of type `T` using the supplied `ParameterizedRowMapper` to the query results to the object.

`int` `SimpleJdbcTemplate.queryForInt(String sql, SqlParameterSource args)`
`int` `SimpleJdbcOperations.queryForInt(String sql, SqlParameterSource args)` Query for an `int` passing in a SQL query using the named parameter support provided by the `NamedParameterJdbcTemplate` and a `SqlParameterSource` containing the arguments.
`List<Map<String,Object>>` `SimpleJdbcTemplate.queryForList(String sql, SqlParameterSource args)`
`List<Map<String,Object>>` `SimpleJdbcOperations.queryForList(String sql, SqlParameterSource args)` Execute the supplied query with the supplied arguments.
`long` `SimpleJdbcTemplate.queryForLong(String sql, SqlParameterSource args)`
`long` `SimpleJdbcOperations.queryForLong(String sql, SqlParameterSource args)` Query for an `long` passing in a SQL query using the named parameter support provided by the `NamedParameterJdbcTemplate` and a `SqlParameterSource` containing the arguments.
`Map<String,Object>` `SimpleJdbcTemplate.queryForMap(String sql, SqlParameterSource args)`
`Map<String,Object>` `SimpleJdbcOperations.queryForMap(String sql, SqlParameterSource args)` Execute the supplied query with the supplied arguments.

`

`<T> T`

`

`SimpleJdbcTemplate.queryForObject(String sql, Class<T> requiredType, SqlParameterSource args)`

`

`<T> T`

`

`SimpleJdbcOperations.queryForObject(String sql, Class<T> requiredType, SqlParameterSource args)`
Query for an object of type `T` identified by the supplied @`Class`.

`

`<T> T`

`

`SimpleJdbcTemplate.queryForObject(String sql, ParameterizedRowMapper<T> rm, SqlParameterSource args)`

`

`<T> T`

`

`SimpleJdbcOperations.queryForObject(String sql, ParameterizedRowMapper<T> rm, SqlParameterSource args)`
Query for an object of type `T` using the supplied `ParameterizedRowMapper` to the query results to the object.

`int` `SimpleJdbcTemplate.update(String sql, SqlParameterSource args)`
`int` `SimpleJdbcOperations.update(String sql, SqlParameterSource args)` Execute the supplied SQL statement with supplied arguments.

The Spring Framework

Copyright © 2002-2008 The Spring Framework.