Uses of Interface
org.springframework.jdbc.core.namedparam.SqlParameterSource
Packages that use SqlParameterSource
Package
Description
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.
-
Uses of SqlParameterSource in org.springframework.jdbc.core.metadata
Methods in org.springframework.jdbc.core.metadata with parameters of type SqlParameterSourceModifier and TypeMethodDescriptionCallMetaDataContext.matchInParameterValuesWithCallParameters(SqlParameterSource parameterSource) Match input parameter values with the parameters declared to be used in the call.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 SqlParameterSourceModifier and TypeClassDescriptionclassAbstract base class forSqlParameterSourceimplementations.classSqlParameterSourceimplementation that obtains parameter values from bean properties of a given JavaBean object.classA simple empty implementation of theSqlParameterSourceinterface.classSqlParameterSourceimplementation that holds a given Map of parameters.Methods in org.springframework.jdbc.core.namedparam that return SqlParameterSourceModifier and TypeMethodDescriptionstatic SqlParameterSource[]SqlParameterSourceUtils.createBatch(Object... candidates) Create an array ofSqlParameterSourceobjects populated with data from the values passed in (either aMapor a bean object).static SqlParameterSource[]SqlParameterSourceUtils.createBatch(Collection<?> candidates) Create an array ofSqlParameterSourceobjects populated with data from the values passed in (either aMapor a bean object).static SqlParameterSource[]SqlParameterSourceUtils.createBatch(Map<String, ?>[] valueMaps) Create an array ofMapSqlParameterSourceobjects populated with data from the values passed in.Methods in org.springframework.jdbc.core.namedparam with parameters of type SqlParameterSourceModifier and TypeMethodDescriptionint[]NamedParameterJdbcOperations.batchUpdate(String sql, SqlParameterSource[] batchArgs) Execute a batch using the supplied SQL statement with the batch of supplied arguments.int[]NamedParameterJdbcTemplate.batchUpdate(String sql, SqlParameterSource[] batchArgs) static List<SqlParameter>NamedParameterUtils.buildSqlParameterList(ParsedSql parsedSql, SqlParameterSource paramSource) Convert parameter declarations from an SqlParameterSource to a corresponding List of SqlParameters.static int[]NamedParameterUtils.buildSqlTypeArray(ParsedSql parsedSql, SqlParameterSource paramSource) Convert parameter types from an SqlParameterSource into a corresponding int array.static Object[]NamedParameterUtils.buildValueArray(ParsedSql parsedSql, SqlParameterSource paramSource, List<SqlParameter> declaredParams) Convert a Map of named parameter values to a corresponding array.<T> TNamedParameterJdbcOperations.execute(String sql, SqlParameterSource paramSource, PreparedStatementCallback<T> action) Execute a JDBC data access operation, implemented as callback action working on a JDBC PreparedStatement.<T> TNamedParameterJdbcTemplate.execute(String sql, SqlParameterSource paramSource, PreparedStatementCallback<T> action) SqlParameterSourceUtils.extractCaseInsensitiveParameterNames(SqlParameterSource parameterSource) Create a Map of case insensitive parameter names together with the original name.protected PreparedStatementCreatorNamedParameterJdbcTemplate.getPreparedStatementCreator(String sql, SqlParameterSource paramSource) Build aPreparedStatementCreatorbased on the given SQL and named parameters.protected PreparedStatementCreatorNamedParameterJdbcTemplate.getPreparedStatementCreator(String sql, SqlParameterSource paramSource, Consumer<PreparedStatementCreatorFactory> customizer) Build aPreparedStatementCreatorbased on the given SQL and named parameters.protected PreparedStatementCreatorFactoryNamedParameterJdbcTemplate.getPreparedStatementCreatorFactory(ParsedSql parsedSql, SqlParameterSource paramSource) Build aPreparedStatementCreatorFactorybased on the given SQL and named parameters.static ObjectSqlParameterSourceUtils.getTypedValue(SqlParameterSource source, String parameterName) Create a wrapped value if parameter has type information, plain object if not.<T> TNamedParameterJdbcOperations.query(String sql, SqlParameterSource paramSource, ResultSetExtractor<T> 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.voidNamedParameterJdbcOperations.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.<T> List<T>NamedParameterJdbcOperations.query(String sql, SqlParameterSource paramSource, RowMapper<T> 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.<T> TNamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, ResultSetExtractor<T> rse) voidNamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, RowCallbackHandler rch) <T> List<T>NamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, RowMapper<T> rowMapper) 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.<T> List<T>NamedParameterJdbcOperations.queryForList(String sql, SqlParameterSource paramSource, Class<T> 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.NamedParameterJdbcTemplate.queryForList(String sql, SqlParameterSource paramSource) <T> List<T>NamedParameterJdbcTemplate.queryForList(String sql, SqlParameterSource paramSource, Class<T> elementType) 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.NamedParameterJdbcTemplate.queryForMap(String sql, SqlParameterSource paramSource) <T> TNamedParameterJdbcOperations.queryForObject(String sql, SqlParameterSource paramSource, Class<T> 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.<T> TNamedParameterJdbcOperations.queryForObject(String sql, SqlParameterSource paramSource, RowMapper<T> 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.<T> TNamedParameterJdbcTemplate.queryForObject(String sql, SqlParameterSource paramSource, Class<T> requiredType) <T> TNamedParameterJdbcTemplate.queryForObject(String sql, SqlParameterSource paramSource, RowMapper<T> rowMapper) 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 an SqlRowSet.NamedParameterJdbcTemplate.queryForRowSet(String sql, SqlParameterSource paramSource) <T> Stream<T>NamedParameterJdbcOperations.queryForStream(String sql, SqlParameterSource paramSource, RowMapper<T> 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, and turning it into an iterable and closeable Stream.<T> Stream<T>NamedParameterJdbcTemplate.queryForStream(String sql, SqlParameterSource paramSource, RowMapper<T> rowMapper) static StringNamedParameterUtils.substituteNamedParameters(String sql, SqlParameterSource paramSource) Parse the SQL statement and locate any placeholders or named parameters.static StringNamedParameterUtils.substituteNamedParameters(ParsedSql parsedSql, SqlParameterSource paramSource) Parse the SQL statement and locate any placeholders or named parameters.intNamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource) Issue an update via a prepared statement, binding the given arguments.intNamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder) Issue an update via a prepared statement, binding the given arguments, returning generated keys.intNamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder, String[] keyColumnNames) Issue an update via a prepared statement, binding the given arguments, returning generated keys.intNamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource) intNamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder) intNamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder, String[] keyColumnNames) -
Uses of SqlParameterSource in org.springframework.jdbc.core.simple
Methods in org.springframework.jdbc.core.simple with parameters of type SqlParameterSourceModifier and TypeMethodDescriptionAbstractJdbcCall.doExecute(SqlParameterSource parameterSource) Delegate method that executes the call using the passed-inSqlParameterSource.protected intAbstractJdbcInsert.doExecute(SqlParameterSource parameterSource) Delegate method that executes the insert using the passed-inSqlParameterSource.protected NumberAbstractJdbcInsert.doExecuteAndReturnKey(SqlParameterSource parameterSource) Method that provides execution of the insert using the passed-inSqlParameterSourceand returning a generated key.protected KeyHolderAbstractJdbcInsert.doExecuteAndReturnKeyHolder(SqlParameterSource parameterSource) Method that provides execution of the insert using the passed-inSqlParameterSourceand returning all generated keys.protected int[]AbstractJdbcInsert.doExecuteBatch(SqlParameterSource... batch) Delegate method that executes a batch insert using the passed-inSqlParameterSources.SimpleJdbcCall.execute(SqlParameterSource parameterSource) SimpleJdbcCallOperations.execute(SqlParameterSource args) Execute the stored procedure and return a map of output params, keyed by name as in parameter declarations.intSimpleJdbcInsert.execute(SqlParameterSource parameterSource) intSimpleJdbcInsertOperations.execute(SqlParameterSource parameterSource) Execute the insert using the values passed in.SimpleJdbcInsert.executeAndReturnKey(SqlParameterSource parameterSource) SimpleJdbcInsertOperations.executeAndReturnKey(SqlParameterSource parameterSource) Execute the insert using the values passed in and return the generated key.SimpleJdbcInsert.executeAndReturnKeyHolder(SqlParameterSource parameterSource) 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.<T> TSimpleJdbcCall.executeFunction(Class<T> returnType, SqlParameterSource args) <T> TSimpleJdbcCallOperations.executeFunction(Class<T> returnType, SqlParameterSource args) Execute the stored function and return the results obtained as an Object of the specified return type.<T> TSimpleJdbcCall.executeObject(Class<T> returnType, SqlParameterSource args) <T> TSimpleJdbcCallOperations.executeObject(Class<T> returnType, SqlParameterSource args) Execute the stored procedure and return the single out parameter as an Object of the specified return type.AbstractJdbcCall.matchInParameterValuesWithCallParameters(SqlParameterSource parameterSource) Match the provided in parameter values with registered parameters and parameters defined via meta-data processing.AbstractJdbcInsert.matchInParameterValuesWithInsertColumns(SqlParameterSource parameterSource) Match the provided in parameter values with registered parameters and parameters defined via meta-data processing.