JdbcOperations and
NamedParameterJdbcOperations. The JdbcTemplate and
NamedParameterJdbcTemplate now provide all the functionality of the SimpleJdbcTemplate.@Deprecated public interface SimpleJdbcOperations
NamedParameterJdbcTemplate,
SimpleJdbcTemplate,
JdbcOperations| Modifier and Type | Method and Description |
|---|---|
int[] |
batchUpdate(String sql,
List<Object[]> batchArgs)
Deprecated.
Execute a batch using the supplied SQL statement with the batch of supplied arguments.
|
int[] |
batchUpdate(String sql,
List<Object[]> batchArgs,
int[] argTypes)
Deprecated.
Execute a batch using the supplied SQL statement with the batch of supplied arguments.
|
int[] |
batchUpdate(String sql,
Map<String,?>[] batchValues)
Deprecated.
Executes a batch using the supplied SQL statement with the batch of supplied arguments.
|
int[] |
batchUpdate(String sql,
SqlParameterSource[] batchArgs)
Deprecated.
Execute a batch using the supplied SQL statement with the batch of supplied arguments.
|
JdbcOperations |
getJdbcOperations()
Deprecated.
Expose the classic Spring JdbcTemplate to allow invocation of less
commonly used methods.
|
NamedParameterJdbcOperations |
getNamedParameterJdbcOperations()
Deprecated.
Expose the Spring NamedParameterJdbcTemplate to allow invocation of less
commonly used methods.
|
<T> List<T> |
query(String sql,
ParameterizedRowMapper<T> rm,
Map<String,?> args)
Deprecated.
as of Spring 3.0: Use the method using the newly genericized RowMapper interface
instead since the RowMapper and ParameterizedRowMapper interfaces are equivalent now.
|
<T> List<T> |
query(String sql,
ParameterizedRowMapper<T> rm,
Object... args)
Deprecated.
as of Spring 3.0: Use the method using the newly genericized RowMapper interface
instead since the RowMapper and ParameterizedRowMapper interfaces are equivalent now.
|
<T> List<T> |
query(String sql,
ParameterizedRowMapper<T> rm,
SqlParameterSource args)
Deprecated.
as of Spring 3.0: Use the method using the newly genericized RowMapper interface
instead since the RowMapper and ParameterizedRowMapper interfaces are equivalent now.
|
<T> List<T> |
query(String sql,
RowMapper<T> rm,
Map<String,?> args)
Deprecated.
|
<T> List<T> |
query(String sql,
RowMapper<T> rm,
Object... args)
Deprecated.
|
<T> List<T> |
query(String sql,
RowMapper<T> rm,
SqlParameterSource args)
Deprecated.
|
int |
queryForInt(String sql,
Map<String,?> args)
Deprecated.
Query for an
int passing in a SQL query
using the named parameter support provided by the
NamedParameterJdbcTemplate
and a map containing the arguments. |
int |
queryForInt(String sql,
Object... args)
Deprecated.
Query for an
int passing in a SQL query
using the standard '?' placeholders for parameters
and a variable number of arguments. |
int |
queryForInt(String sql,
SqlParameterSource args)
Deprecated.
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>> |
queryForList(String sql,
Map<String,?> args)
Deprecated.
Execute the supplied query with the supplied arguments.
|
List<Map<String,Object>> |
queryForList(String sql,
Object... args)
Deprecated.
Execute the supplied query with the (optional) supplied arguments.
|
List<Map<String,Object>> |
queryForList(String sql,
SqlParameterSource args)
Deprecated.
Execute the supplied query with the supplied arguments.
|
long |
queryForLong(String sql,
Map<String,?> args)
Deprecated.
Query for an
long passing in a SQL query
using the named parameter support provided by the
NamedParameterJdbcTemplate
and a map containing the arguments. |
long |
queryForLong(String sql,
Object... args)
Deprecated.
Query for an
long passing in a SQL query
using the standard '?' placeholders for parameters
and a variable number of arguments. |
long |
queryForLong(String sql,
SqlParameterSource args)
Deprecated.
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> |
queryForMap(String sql,
Map<String,?> args)
Deprecated.
Execute the supplied query with the supplied arguments.
|
Map<String,Object> |
queryForMap(String sql,
Object... args)
Deprecated.
Execute the supplied query with the (optional) supplied arguments.
|
Map<String,Object> |
queryForMap(String sql,
SqlParameterSource args)
Deprecated.
Execute the supplied query with the supplied arguments.
|
<T> T |
queryForObject(String sql,
Class<T> requiredType,
Map<String,?> args)
Deprecated.
Query for an object of type
T identified by the supplied @Class. |
<T> T |
queryForObject(String sql,
Class<T> requiredType,
Object... args)
Deprecated.
Query for an object of type
T identified by the supplied @Class. |
<T> T |
queryForObject(String sql,
Class<T> requiredType,
SqlParameterSource args)
Deprecated.
Query for an object of type
T identified by the supplied @Class. |
<T> T |
queryForObject(String sql,
ParameterizedRowMapper<T> rm,
Map<String,?> args)
Deprecated.
as of Spring 3.0: Use the method using the newly genericized RowMapper interface
instead since the RowMapper and ParameterizedRowMapper interfaces are equivalent now.
|
<T> T |
queryForObject(String sql,
ParameterizedRowMapper<T> rm,
Object... args)
Deprecated.
as of Spring 3.0: Use the method using the newly genericized RowMapper interface
instead since the RowMapper and ParameterizedRowMapper interfaces are equivalent now.
|
<T> T |
queryForObject(String sql,
ParameterizedRowMapper<T> rm,
SqlParameterSource args)
Deprecated.
as of Spring 3.0: Use the method using the newly genericized RowMapper interface
instead since the RowMapper and ParameterizedRowMapper interfaces are equivalent now.
|
<T> T |
queryForObject(String sql,
RowMapper<T> rm,
Map<String,?> args)
Deprecated.
Query for an object of type
T using the supplied
RowMapper to the query results to the object. |
<T> T |
queryForObject(String sql,
RowMapper<T> rm,
Object... args)
Deprecated.
Query for an object of type
T using the supplied
RowMapper to the query results to the object. |
<T> T |
queryForObject(String sql,
RowMapper<T> rm,
SqlParameterSource args)
Deprecated.
Query for an object of type
T using the supplied
RowMapper to the query results to the object. |
int |
update(String sql,
Map<String,?> args)
Deprecated.
Execute the supplied SQL statement with (optional) supplied arguments.
|
int |
update(String sql,
Object... args)
Deprecated.
Execute the supplied SQL statement with supplied arguments.
|
int |
update(String sql,
SqlParameterSource args)
Deprecated.
Execute the supplied SQL statement with supplied arguments.
|
JdbcOperations getJdbcOperations()
NamedParameterJdbcOperations getNamedParameterJdbcOperations()
int queryForInt(String sql, Map<String,?> args) throws org.springframework.dao.DataAccessException
int passing in a SQL query
using the named parameter support provided by the
NamedParameterJdbcTemplate
and a map containing the arguments.sql - the SQL query to run.args - the map containing the arguments for the queryorg.springframework.dao.DataAccessExceptionint queryForInt(String sql, SqlParameterSource args) throws org.springframework.dao.DataAccessException
int passing in a SQL query
using the named parameter support provided by the
NamedParameterJdbcTemplate
and a SqlParameterSource containing the arguments.sql - the SQL query to run.args - the SqlParameterSource containing the arguments for the query.org.springframework.dao.DataAccessExceptionint queryForInt(String sql, Object... args) throws org.springframework.dao.DataAccessException
int passing in a SQL query
using the standard '?' placeholders for parameters
and a variable number of arguments.sql - the SQL query to run.args - the variable number of arguments for the queryorg.springframework.dao.DataAccessExceptionlong queryForLong(String sql, Map<String,?> args) throws org.springframework.dao.DataAccessException
long passing in a SQL query
using the named parameter support provided by the
NamedParameterJdbcTemplate
and a map containing the arguments.sql - the SQL query to run.args - the map containing the arguments for the queryorg.springframework.dao.DataAccessExceptionlong queryForLong(String sql, SqlParameterSource args) throws org.springframework.dao.DataAccessException
long passing in a SQL query
using the named parameter support provided by the
NamedParameterJdbcTemplate
and a SqlParameterSource containing the arguments.sql - the SQL query to run.args - the SqlParameterSource containing the arguments for the queryorg.springframework.dao.DataAccessExceptionlong queryForLong(String sql, Object... args) throws org.springframework.dao.DataAccessException
long passing in a SQL query
using the standard '?' placeholders for parameters
and a variable number of arguments.sql - the SQL query to run.args - the variable number of arguments for the queryorg.springframework.dao.DataAccessException<T> T queryForObject(String sql, Class<T> requiredType, Map<String,?> args) throws org.springframework.dao.DataAccessException
T identified by the supplied @Class.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplatesql - the SQL query to runrequiredType - the required type of the return valueargs - the map containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, Class),
JdbcOperations.queryForObject(String, Object[], Class)<T> T queryForObject(String sql, Class<T> requiredType, SqlParameterSource args) throws org.springframework.dao.DataAccessException
T identified by the supplied @Class.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplatesql - the SQL query to runrequiredType - the required type of the return valueargs - the SqlParameterSource containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, Class),
JdbcOperations.queryForObject(String, Object[], Class)<T> T queryForObject(String sql, Class<T> requiredType, Object... args) throws org.springframework.dao.DataAccessException
T identified by the supplied @Class.
Uses sql with the standard '?' placeholders for parameterssql - the SQL query to runrequiredType - the required type of the return valueargs - the variable number of arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, Class),
JdbcOperations.queryForObject(String, Object[], Class)<T> T queryForObject(String sql, RowMapper<T> rm, Map<String,?> args) throws org.springframework.dao.DataAccessException
T using the supplied
RowMapper to the query results to the object.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplatesql - the SQL query to runrm - the @RowMapper to use for result mappingargs - the map containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated <T> T queryForObject(String sql, ParameterizedRowMapper<T> rm, Map<String,?> args) throws org.springframework.dao.DataAccessException
T using the supplied
ParameterizedRowMapper to the query results to the object.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplatesql - the SQL query to runrm - the @ParameterizedRowMapper to use for result mappingargs - the map containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)<T> T queryForObject(String sql, RowMapper<T> rm, SqlParameterSource args) throws org.springframework.dao.DataAccessException
T using the supplied
RowMapper to the query results to the object.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplatesql - the SQL query to runrm - the @RowMapper to use for result mappingargs - the SqlParameterSource containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated <T> T queryForObject(String sql, ParameterizedRowMapper<T> rm, SqlParameterSource args) throws org.springframework.dao.DataAccessException
T using the supplied
ParameterizedRowMapper to the query results to the object.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplatesql - the SQL query to runrm - the @ParameterizedRowMapper to use for result mappingargs - the SqlParameterSource containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)<T> T queryForObject(String sql, RowMapper<T> rm, Object... args) throws org.springframework.dao.DataAccessException
T using the supplied
RowMapper to the query results to the object.
Uses sql with the standard '?' placeholders for parameterssql - the SQL query to runrm - the @RowMapper to use for result mappingargs - the variable number of arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated <T> T queryForObject(String sql, ParameterizedRowMapper<T> rm, Object... args) throws org.springframework.dao.DataAccessException
T using the supplied
ParameterizedRowMapper to the query results to the object.
Uses sql with the standard '?' placeholders for parameterssql - the SQL query to runrm - the @ParameterizedRowMapper to use for result mappingargs - the variable number of arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)<T> List<T> query(String sql, RowMapper<T> rm, Map<String,?> args) throws org.springframework.dao.DataAccessException
List of Objects of type T using
the supplied RowMapper to the query results to the object.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplatesql - the SQL query to runrm - the @RowMapper to use for result mappingargs - the map containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated <T> List<T> query(String sql, ParameterizedRowMapper<T> rm, Map<String,?> args) throws org.springframework.dao.DataAccessException
List of Objects of type T using
the supplied ParameterizedRowMapper to the query results to the object.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplatesql - the SQL query to runrm - the @ParameterizedRowMapper to use for result mappingargs - the map containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)<T> List<T> query(String sql, RowMapper<T> rm, SqlParameterSource args) throws org.springframework.dao.DataAccessException
List of Objects of type T using
the supplied RowMapper to the query results to the object.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplatesql - the SQL query to runrm - the @RowMapper to use for result mappingargs - the SqlParameterSource containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated <T> List<T> query(String sql, ParameterizedRowMapper<T> rm, SqlParameterSource args) throws org.springframework.dao.DataAccessException
List of Objects of type T using
the supplied ParameterizedRowMapper to the query results to the object.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplatesql - the SQL query to runrm - the @ParameterizedRowMapper to use for result mappingargs - the SqlParameterSource containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)<T> List<T> query(String sql, RowMapper<T> rm, Object... args) throws org.springframework.dao.DataAccessException
List of Objects of type T using
the supplied RowMapper to the query results to the object.
Uses sql with the standard '?' placeholders for parameterssql - the SQL query to runrm - the @RowMapper to use for result mappingargs - the variable number of arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated <T> List<T> query(String sql, ParameterizedRowMapper<T> rm, Object... args) throws org.springframework.dao.DataAccessException
List of Objects of type T using
the supplied ParameterizedRowMapper to the query results to the object.
Uses sql with the standard '?' placeholders for parameterssql - the SQL query to runrm - the @ParameterizedRowMapper to use for result mappingargs - the variable number of arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)Map<String,Object> queryForMap(String sql, Map<String,?> args) throws org.springframework.dao.DataAccessException
The query is expected to be a single row query; the result row will be
mapped to a MapNamedParameterJdbcTemplate
sql - the SQL query to runargs - the map containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForMap(String),
JdbcOperations.queryForMap(String, Object[])Map<String,Object> queryForMap(String sql, SqlParameterSource args) throws org.springframework.dao.DataAccessException
The query is expected to be a single row query; the result row will be
mapped to a MapNamedParameterJdbcTemplate
sql - the SQL query to runargs - the SqlParameterSource containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForMap(String),
JdbcOperations.queryForMap(String, Object[])Map<String,Object> queryForMap(String sql, Object... args) throws org.springframework.dao.DataAccessException
The query is expected to be a single row query; the result row will be
mapped to a Map
sql - the SQL query to runargs - the variable number of arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForMap(String),
JdbcOperations.queryForMap(String, Object[])List<Map<String,Object>> queryForList(String sql, Map<String,?> args) throws org.springframework.dao.DataAccessException
Each element in the returned List is constructed as a Map
as described in queryForMap(java.lang.String, java.util.Map<java.lang.String, ?>)
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplate
sql - the SQL query to runargs - the map containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForList(String),
JdbcOperations.queryForList(String, Object[])List<Map<String,Object>> queryForList(String sql, SqlParameterSource args) throws org.springframework.dao.DataAccessException
Each element in the returned List is constructed as a Map
as described in queryForMap(java.lang.String, java.util.Map<java.lang.String, ?>)
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplate
sql - the SQL query to runargs - the SqlParameterSource containing the arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForList(String),
JdbcOperations.queryForList(String, Object[])List<Map<String,Object>> queryForList(String sql, Object... args) throws org.springframework.dao.DataAccessException
Each element in the returned List is constructed as a Map
as described in queryForMap(java.lang.String, java.util.Map<java.lang.String, ?>)
Uses sql with the standard '?' placeholders for parameters
sql - the SQL query to runargs - the variable number of arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.queryForList(String),
JdbcOperations.queryForList(String, Object[])int update(String sql, Map<String,?> args) throws org.springframework.dao.DataAccessException
NamedParameterJdbcTemplatesql - the SQL statement to executeargs - the map containing the arguments for the queryorg.springframework.dao.DataAccessExceptionNamedParameterJdbcOperations.update(String, Map)int update(String sql, SqlParameterSource args) throws org.springframework.dao.DataAccessException
NamedParameterJdbcTemplatesql - the SQL statement to executeargs - the SqlParameterSource containing the arguments for the statementorg.springframework.dao.DataAccessExceptionNamedParameterJdbcOperations.update(String, SqlParameterSource)int update(String sql, Object... args) throws org.springframework.dao.DataAccessException
sql - the SQL statement to executeargs - the variable number of arguments for the queryorg.springframework.dao.DataAccessExceptionJdbcOperations.update(String),
JdbcOperations.update(String, Object[])int[] batchUpdate(String sql, Map<String,?>[] batchValues)
sql - the SQL statement to executebatchValues - the array of Maps containing the batch of arguments for the queryint[] batchUpdate(String sql, SqlParameterSource[] batchArgs)
sql - the SQL statement to executebatchArgs - the array of SqlParameterSource containing the batch of arguments for the queryint[] batchUpdate(String sql, List<Object[]> batchArgs)
sql - the SQL statement to executebatchArgs - the List of Object arrays containing the batch of arguments for the queryint[] batchUpdate(String sql, List<Object[]> batchArgs, int[] argTypes)
sql - the SQL statement to execute.batchArgs - the List of Object arrays containing the batch of arguments for the queryargTypes - SQL types of the arguments
(constants from java.sql.Types)