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(java.lang.String sql,
java.util.List<java.lang.Object[]> batchArgs)
Deprecated.
Execute a batch using the supplied SQL statement with the batch of supplied arguments.
|
int[] |
batchUpdate(java.lang.String sql,
java.util.List<java.lang.Object[]> batchArgs,
int[] argTypes)
Deprecated.
Execute a batch using the supplied SQL statement with the batch of supplied arguments.
|
int[] |
batchUpdate(java.lang.String sql,
java.util.Map<java.lang.String,?>[] batchValues)
Deprecated.
Executes a batch using the supplied SQL statement with the batch of supplied arguments.
|
int[] |
batchUpdate(java.lang.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> java.util.List<T> |
query(java.lang.String sql,
ParameterizedRowMapper<T> rm,
java.util.Map<java.lang.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> java.util.List<T> |
query(java.lang.String sql,
ParameterizedRowMapper<T> rm,
java.lang.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> java.util.List<T> |
query(java.lang.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> java.util.List<T> |
query(java.lang.String sql,
RowMapper<T> rm,
java.util.Map<java.lang.String,?> args)
Deprecated.
Query for a
List of Objects of type T using
the supplied RowMapper to the query results to the object. |
<T> java.util.List<T> |
query(java.lang.String sql,
RowMapper<T> rm,
java.lang.Object... args)
Deprecated.
Query for a
List of Objects of type T using
the supplied RowMapper to the query results to the object. |
<T> java.util.List<T> |
query(java.lang.String sql,
RowMapper<T> rm,
SqlParameterSource args)
Deprecated.
Query for a
List of Objects of type T using
the supplied RowMapper to the query results to the object. |
int |
queryForInt(java.lang.String sql,
java.util.Map<java.lang.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(java.lang.String sql,
java.lang.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(java.lang.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. |
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
queryForList(java.lang.String sql,
java.util.Map<java.lang.String,?> args)
Deprecated.
Execute the supplied query with the supplied arguments.
|
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
queryForList(java.lang.String sql,
java.lang.Object... args)
Deprecated.
Execute the supplied query with the (optional) supplied arguments.
|
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
queryForList(java.lang.String sql,
SqlParameterSource args)
Deprecated.
Execute the supplied query with the supplied arguments.
|
long |
queryForLong(java.lang.String sql,
java.util.Map<java.lang.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(java.lang.String sql,
java.lang.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(java.lang.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. |
java.util.Map<java.lang.String,java.lang.Object> |
queryForMap(java.lang.String sql,
java.util.Map<java.lang.String,?> args)
Deprecated.
Execute the supplied query with the supplied arguments.
|
java.util.Map<java.lang.String,java.lang.Object> |
queryForMap(java.lang.String sql,
java.lang.Object... args)
Deprecated.
Execute the supplied query with the (optional) supplied arguments.
|
java.util.Map<java.lang.String,java.lang.Object> |
queryForMap(java.lang.String sql,
SqlParameterSource args)
Deprecated.
Execute the supplied query with the supplied arguments.
|
<T> T |
queryForObject(java.lang.String sql,
java.lang.Class<T> requiredType,
java.util.Map<java.lang.String,?> args)
Deprecated.
Query for an object of type
T identified by the supplied @Class. |
<T> T |
queryForObject(java.lang.String sql,
java.lang.Class<T> requiredType,
java.lang.Object... args)
Deprecated.
Query for an object of type
T identified by the supplied @Class. |
<T> T |
queryForObject(java.lang.String sql,
java.lang.Class<T> requiredType,
SqlParameterSource args)
Deprecated.
Query for an object of type
T identified by the supplied @Class. |
<T> T |
queryForObject(java.lang.String sql,
ParameterizedRowMapper<T> rm,
java.util.Map<java.lang.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(java.lang.String sql,
ParameterizedRowMapper<T> rm,
java.lang.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(java.lang.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(java.lang.String sql,
RowMapper<T> rm,
java.util.Map<java.lang.String,?> args)
Deprecated.
Query for an object of type
T using the supplied
RowMapper to the query results to the object. |
<T> T |
queryForObject(java.lang.String sql,
RowMapper<T> rm,
java.lang.Object... args)
Deprecated.
Query for an object of type
T using the supplied
RowMapper to the query results to the object. |
<T> T |
queryForObject(java.lang.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(java.lang.String sql,
java.util.Map<java.lang.String,?> args)
Deprecated.
Execute the supplied SQL statement with (optional) supplied arguments.
|
int |
update(java.lang.String sql,
java.lang.Object... args)
Deprecated.
Execute the supplied SQL statement with supplied arguments.
|
int |
update(java.lang.String sql,
SqlParameterSource args)
Deprecated.
Execute the supplied SQL statement with supplied arguments.
|
JdbcOperations getJdbcOperations()
NamedParameterJdbcOperations getNamedParameterJdbcOperations()
int queryForInt(java.lang.String sql,
java.util.Map<java.lang.String,?> args)
throws 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 queryDataAccessExceptionint queryForInt(java.lang.String sql,
SqlParameterSource args)
throws 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.DataAccessExceptionint queryForInt(java.lang.String sql,
java.lang.Object... args)
throws 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 queryDataAccessExceptionlong queryForLong(java.lang.String sql,
java.util.Map<java.lang.String,?> args)
throws 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 queryDataAccessExceptionlong queryForLong(java.lang.String sql,
SqlParameterSource args)
throws 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 queryDataAccessExceptionlong queryForLong(java.lang.String sql,
java.lang.Object... args)
throws 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 queryDataAccessException<T> T queryForObject(java.lang.String sql,
java.lang.Class<T> requiredType,
java.util.Map<java.lang.String,?> args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, Class),
JdbcOperations.queryForObject(String, Object[], Class)<T> T queryForObject(java.lang.String sql,
java.lang.Class<T> requiredType,
SqlParameterSource args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, Class),
JdbcOperations.queryForObject(String, Object[], Class)<T> T queryForObject(java.lang.String sql,
java.lang.Class<T> requiredType,
java.lang.Object... args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, Class),
JdbcOperations.queryForObject(String, Object[], Class)<T> T queryForObject(java.lang.String sql,
RowMapper<T> rm,
java.util.Map<java.lang.String,?> args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated
<T> T queryForObject(java.lang.String sql,
ParameterizedRowMapper<T> rm,
java.util.Map<java.lang.String,?> args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)<T> T queryForObject(java.lang.String sql,
RowMapper<T> rm,
SqlParameterSource args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated
<T> T queryForObject(java.lang.String sql,
ParameterizedRowMapper<T> rm,
SqlParameterSource args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)<T> T queryForObject(java.lang.String sql,
RowMapper<T> rm,
java.lang.Object... args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated
<T> T queryForObject(java.lang.String sql,
ParameterizedRowMapper<T> rm,
java.lang.Object... args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)<T> java.util.List<T> query(java.lang.String sql,
RowMapper<T> rm,
java.util.Map<java.lang.String,?> args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated
<T> java.util.List<T> query(java.lang.String sql,
ParameterizedRowMapper<T> rm,
java.util.Map<java.lang.String,?> args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)<T> java.util.List<T> query(java.lang.String sql,
RowMapper<T> rm,
SqlParameterSource args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated
<T> java.util.List<T> query(java.lang.String sql,
ParameterizedRowMapper<T> rm,
SqlParameterSource args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)<T> java.util.List<T> query(java.lang.String sql,
RowMapper<T> rm,
java.lang.Object... args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)@Deprecated
<T> java.util.List<T> query(java.lang.String sql,
ParameterizedRowMapper<T> rm,
java.lang.Object... args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper),
JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)java.util.Map<java.lang.String,java.lang.Object> queryForMap(java.lang.String sql,
java.util.Map<java.lang.String,?> args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForMap(String),
JdbcOperations.queryForMap(String, Object[])java.util.Map<java.lang.String,java.lang.Object> queryForMap(java.lang.String sql,
SqlParameterSource args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForMap(String),
JdbcOperations.queryForMap(String, Object[])java.util.Map<java.lang.String,java.lang.Object> queryForMap(java.lang.String sql,
java.lang.Object... args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForMap(String),
JdbcOperations.queryForMap(String, Object[])java.util.List<java.util.Map<java.lang.String,java.lang.Object>> queryForList(java.lang.String sql,
java.util.Map<java.lang.String,?> args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForList(String),
JdbcOperations.queryForList(String, Object[])java.util.List<java.util.Map<java.lang.String,java.lang.Object>> queryForList(java.lang.String sql,
SqlParameterSource args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForList(String),
JdbcOperations.queryForList(String, Object[])java.util.List<java.util.Map<java.lang.String,java.lang.Object>> queryForList(java.lang.String sql,
java.lang.Object... args)
throws 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 queryDataAccessExceptionJdbcOperations.queryForList(String),
JdbcOperations.queryForList(String, Object[])int update(java.lang.String sql,
java.util.Map<java.lang.String,?> args)
throws DataAccessException
NamedParameterJdbcTemplatesql - the SQL statement to executeargs - the map containing the arguments for the queryDataAccessExceptionNamedParameterJdbcOperations.update(String, Map)int update(java.lang.String sql,
SqlParameterSource args)
throws DataAccessException
NamedParameterJdbcTemplatesql - the SQL statement to executeargs - the SqlParameterSource containing the arguments for the statementDataAccessExceptionNamedParameterJdbcOperations.update(String, SqlParameterSource)int update(java.lang.String sql,
java.lang.Object... args)
throws DataAccessException
sql - the SQL statement to executeargs - the variable number of arguments for the queryDataAccessExceptionJdbcOperations.update(String),
JdbcOperations.update(String, Object[])int[] batchUpdate(java.lang.String sql,
java.util.Map<java.lang.String,?>[] batchValues)
sql - the SQL statement to executebatchValues - the array of Maps containing the batch of arguments for the queryint[] batchUpdate(java.lang.String sql,
SqlParameterSource[] batchArgs)
sql - the SQL statement to executebatchArgs - the array of SqlParameterSource containing the batch of arguments for the queryint[] batchUpdate(java.lang.String sql,
java.util.List<java.lang.Object[]> batchArgs)
sql - the SQL statement to executebatchArgs - the List of Object arrays containing the batch of arguments for the queryint[] batchUpdate(java.lang.String sql,
java.util.List<java.lang.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)