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 |
BeanPropertyRowMapper<T>
RowMapper implementation that converts a row into a new instance
of the specified mapped target class. |
class |
ColumnMapRowMapper
RowMapper implementation that creates a java.util.Map
for each row, representing all columns as key-value pairs: one
entry for each column, with the column name as key. |
class |
DataClassRowMapper<T>
RowMapper implementation that converts a row into a new instance
of the specified mapped target class. |
class |
SingleColumnRowMapper<T>
RowMapper implementation that converts a single column into a single
result value per row. |
Modifier and Type | Method and Description |
---|---|
protected RowMapper<Map<String,Object>> |
JdbcTemplate.getColumnMapRowMapper()
Create a new RowMapper for reading columns as key-value pairs.
|
RowMapper<?> |
ResultSetSupportingSqlParameter.getRowMapper()
Return the RowMapper held by this parameter, if any.
|
protected <T> RowMapper<T> |
JdbcTemplate.getSingleColumnRowMapper(Class<T> requiredType)
Create a new RowMapper for reading result objects from a single column.
|
Modifier and Type | Method and Description |
---|---|
<T> List<T> |
JdbcOperations.query(PreparedStatementCreator psc,
RowMapper<T> rowMapper)
Query using a prepared statement, mapping each row to a result object
via a RowMapper.
|
<T> List<T> |
JdbcTemplate.query(PreparedStatementCreator psc,
RowMapper<T> rowMapper) |
<T> List<T> |
JdbcOperations.query(String sql,
Object[] args,
int[] argTypes,
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 result object
via a RowMapper.
|
<T> List<T> |
JdbcTemplate.query(String sql,
Object[] args,
int[] argTypes,
RowMapper<T> rowMapper) |
<T> List<T> |
JdbcOperations.query(String sql,
Object[] args,
RowMapper<T> rowMapper)
Deprecated.
as of 5.3, in favor of
JdbcOperations.query(String, RowMapper, Object...) |
<T> List<T> |
JdbcTemplate.query(String sql,
Object[] args,
RowMapper<T> rowMapper)
Deprecated.
|
<T> List<T> |
JdbcOperations.query(String sql,
PreparedStatementSetter pss,
RowMapper<T> rowMapper)
Query given SQL to create a prepared statement from SQL and a
PreparedStatementSetter implementation that knows how to bind values
to the query, mapping each row to a result object via a RowMapper.
|
<T> List<T> |
JdbcTemplate.query(String sql,
PreparedStatementSetter pss,
RowMapper<T> rowMapper) |
<T> List<T> |
JdbcOperations.query(String sql,
RowMapper<T> rowMapper)
Execute a query given static SQL, mapping each row to a result object
via a RowMapper.
|
<T> List<T> |
JdbcTemplate.query(String sql,
RowMapper<T> rowMapper) |
<T> List<T> |
JdbcOperations.query(String sql,
RowMapper<T> rowMapper,
Object... args)
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 result object
via a RowMapper.
|
<T> List<T> |
JdbcTemplate.query(String sql,
RowMapper<T> rowMapper,
Object... args) |
<T> T |
JdbcOperations.queryForObject(String sql,
Object[] args,
int[] argTypes,
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
result object via a RowMapper.
|
<T> T |
JdbcTemplate.queryForObject(String sql,
Object[] args,
int[] argTypes,
RowMapper<T> rowMapper) |
<T> T |
JdbcOperations.queryForObject(String sql,
Object[] args,
RowMapper<T> rowMapper)
Deprecated.
as of 5.3, in favor of
JdbcOperations.queryForObject(String, RowMapper, Object...) |
<T> T |
JdbcTemplate.queryForObject(String sql,
Object[] args,
RowMapper<T> rowMapper)
Deprecated.
|
<T> T |
JdbcOperations.queryForObject(String sql,
RowMapper<T> rowMapper)
Execute a query given static SQL, mapping a single result row to a
result object via a RowMapper.
|
<T> T |
JdbcTemplate.queryForObject(String sql,
RowMapper<T> rowMapper) |
<T> T |
JdbcOperations.queryForObject(String sql,
RowMapper<T> rowMapper,
Object... args)
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
result object via a RowMapper.
|
<T> T |
JdbcTemplate.queryForObject(String sql,
RowMapper<T> rowMapper,
Object... args) |
<T> Stream<T> |
JdbcTemplate.queryForStream(PreparedStatementCreator psc,
PreparedStatementSetter pss,
RowMapper<T> rowMapper)
Query using a prepared statement, allowing for a PreparedStatementCreator
and a PreparedStatementSetter.
|
<T> Stream<T> |
JdbcOperations.queryForStream(PreparedStatementCreator psc,
RowMapper<T> rowMapper)
Query using a prepared statement, mapping each row to a result object
via a RowMapper, and turning it into an iterable and closeable Stream.
|
<T> Stream<T> |
JdbcTemplate.queryForStream(PreparedStatementCreator psc,
RowMapper<T> rowMapper) |
<T> Stream<T> |
JdbcOperations.queryForStream(String sql,
PreparedStatementSetter pss,
RowMapper<T> rowMapper)
Query given SQL to create a prepared statement from SQL and a
PreparedStatementSetter implementation that knows how to bind values
to the query, mapping each row to a result object via a RowMapper,
and turning it into an iterable and closeable Stream.
|
<T> Stream<T> |
JdbcTemplate.queryForStream(String sql,
PreparedStatementSetter pss,
RowMapper<T> rowMapper) |
<T> Stream<T> |
JdbcOperations.queryForStream(String sql,
RowMapper<T> rowMapper)
Execute a query given static SQL, mapping each row to a result object
via a RowMapper, and turning it into an iterable and closeable Stream.
|
<T> Stream<T> |
JdbcTemplate.queryForStream(String sql,
RowMapper<T> rowMapper) |
<T> Stream<T> |
JdbcOperations.queryForStream(String sql,
RowMapper<T> rowMapper,
Object... args)
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 result object
via a RowMapper, and turning it into an iterable and closeable Stream.
|
<T> Stream<T> |
JdbcTemplate.queryForStream(String sql,
RowMapper<T> rowMapper,
Object... args) |
Constructor and Description |
---|
ResultSetSupportingSqlParameter(String name,
int sqlType,
RowMapper<?> rm)
Create a new ResultSetSupportingSqlParameter.
|
RowMapperResultSetExtractor(RowMapper<T> rowMapper)
Create a new RowMapperResultSetExtractor.
|
RowMapperResultSetExtractor(RowMapper<T> rowMapper,
int rowsExpected)
Create a new RowMapperResultSetExtractor.
|
SqlInOutParameter(String name,
int sqlType,
RowMapper<?> rm)
Create a new SqlInOutParameter.
|
SqlOutParameter(String name,
int sqlType,
RowMapper<?> rm)
Create a new SqlOutParameter.
|
SqlReturnResultSet(String name,
RowMapper<?> mapper)
Create a new instance of the
SqlReturnResultSet class. |
Modifier and Type | Method and Description |
---|---|
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 |
---|---|
<T> List<T> |
NamedParameterJdbcTemplate.query(String sql,
Map<String,?> paramMap,
RowMapper<T> rowMapper) |
<T> List<T> |
NamedParameterJdbcOperations.query(String sql,
Map<String,?> paramMap,
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> List<T> |
NamedParameterJdbcTemplate.query(String sql,
RowMapper<T> rowMapper) |
<T> List<T> |
NamedParameterJdbcOperations.query(String sql,
RowMapper<T> rowMapper)
Query given SQL to create a prepared statement from SQL,
mapping each row to a Java object via a RowMapper.
|
<T> List<T> |
NamedParameterJdbcTemplate.query(String sql,
SqlParameterSource paramSource,
RowMapper<T> rowMapper) |
<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> T |
NamedParameterJdbcTemplate.queryForObject(String sql,
Map<String,?> paramMap,
RowMapper<T> rowMapper) |
<T> T |
NamedParameterJdbcOperations.queryForObject(String sql,
Map<String,?> paramMap,
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> T |
NamedParameterJdbcTemplate.queryForObject(String sql,
SqlParameterSource paramSource,
RowMapper<T> rowMapper) |
<T> T |
NamedParameterJdbcOperations.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> Stream<T> |
NamedParameterJdbcTemplate.queryForStream(String sql,
Map<String,?> paramMap,
RowMapper<T> rowMapper) |
<T> Stream<T> |
NamedParameterJdbcOperations.queryForStream(String sql,
Map<String,?> paramMap,
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) |
<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.
|
Modifier and Type | Method and Description |
---|---|
void |
AbstractJdbcCall.addDeclaredRowMapper(String parameterName,
RowMapper<?> rowMapper)
Add a
RowMapper for the specified parameter or column. |
SimpleJdbcCall |
SimpleJdbcCall.returningResultSet(String parameterName,
RowMapper<?> rowMapper) |
SimpleJdbcCallOperations |
SimpleJdbcCallOperations.returningResultSet(String parameterName,
RowMapper<?> rowMapper)
Used to specify when a ResultSet is returned by the stored procedure and you want it
mapped by a
RowMapper . |
Modifier and Type | Class and Description |
---|---|
protected class |
MappingSqlQueryWithParameters.RowMapperImpl
Implementation of RowMapper that calls the enclosing
class's
mapRow method for each row. |
protected class |
UpdatableSqlQuery.RowMapperImpl
Implementation of RowMapper that calls the enclosing
class's
updateRow() method for each row. |
Modifier and Type | Method and Description |
---|---|
protected RowMapper<T> |
UpdatableSqlQuery.newRowMapper(Object[] parameters,
Map<?,?> context)
Implementation of the superclass template method.
|
protected RowMapper<T> |
MappingSqlQueryWithParameters.newRowMapper(Object[] parameters,
Map<?,?> context)
Implementation of protected abstract method.
|
protected RowMapper<T> |
GenericSqlQuery.newRowMapper(Object[] parameters,
Map<?,?> context) |
protected abstract RowMapper<T> |
SqlQuery.newRowMapper(Object[] parameters,
Map<?,?> context)
Subclasses must implement this method to extract an object per row, to be
returned by the
execute method as an aggregated List . |
Modifier and Type | Method and Description |
---|---|
void |
GenericSqlQuery.setRowMapper(RowMapper<T> rowMapper)
Set a specific
RowMapper instance to use for this query. |
Modifier and Type | Method and Description |
---|---|
void |
GenericSqlQuery.setRowMapperClass(Class<? extends RowMapper> rowMapperClass)
|