|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
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. |
|
|
SimpleJdbcTemplate.query(String sql,
ParameterizedRowMapper<T> rm,
SqlParameterSource args)
|
|
|
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. |
|
|
SimpleJdbcTemplate.queryForObject(String sql,
Class<T> requiredType,
SqlParameterSource args)
|
|
|
SimpleJdbcOperations.queryForObject(String sql,
Class<T> requiredType,
SqlParameterSource args)
Query for an object of type T identified by the supplied @Class . |
|
|
SimpleJdbcTemplate.queryForObject(String sql,
ParameterizedRowMapper<T> rm,
SqlParameterSource args)
|
|
|
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. |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |