Spring Framework

org.springframework.jdbc.core.simple
Interface SimpleJdbcOperations

All Known Implementing Classes:
SimpleJdbcTemplate

Deprecated. since Spring 3.1 in favor of JdbcOperations and NamedParameterJdbcOperations. The JdbcTemplate and NamedParameterJdbcTemplate now provide all the functionality of the SimpleJdbcTemplate.

@Deprecated
public interface SimpleJdbcOperations

JDBC operations interface usable on Java 5 and above, exposing a set of common JDBC operations, whose interface is simplified through the use of varargs and autoboxing.

Since:
2.0
Author:
Rod Johnson, Rob Harrop, Thomas Risberg
See Also:
NamedParameterJdbcTemplate, SimpleJdbcTemplate, JdbcOperations

Method Summary
 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.
 

Method Detail

getJdbcOperations

JdbcOperations getJdbcOperations()
Deprecated. 
Expose the classic Spring JdbcTemplate to allow invocation of less commonly used methods.


getNamedParameterJdbcOperations

NamedParameterJdbcOperations getNamedParameterJdbcOperations()
Deprecated. 
Expose the Spring NamedParameterJdbcTemplate to allow invocation of less commonly used methods.


queryForInt

int queryForInt(java.lang.String sql,
                java.util.Map<java.lang.String,?> args)
                throws DataAccessException
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.

Parameters:
sql - the SQL query to run.
args - the map containing the arguments for the query
Throws:
DataAccessException

queryForInt

int queryForInt(java.lang.String sql,
                SqlParameterSource args)
                throws DataAccessException
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.

Parameters:
sql - the SQL query to run.
args - the SqlParameterSource containing the arguments for the query.
Throws:
DataAccessException

queryForInt

int queryForInt(java.lang.String sql,
                java.lang.Object... args)
                throws DataAccessException
Deprecated. 
Query for an int passing in a SQL query using the standard '?' placeholders for parameters and a variable number of arguments.

Parameters:
sql - the SQL query to run.
args - the variable number of arguments for the query
Throws:
DataAccessException

queryForLong

long queryForLong(java.lang.String sql,
                  java.util.Map<java.lang.String,?> args)
                  throws DataAccessException
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.

Parameters:
sql - the SQL query to run.
args - the map containing the arguments for the query
Throws:
DataAccessException

queryForLong

long queryForLong(java.lang.String sql,
                  SqlParameterSource args)
                  throws DataAccessException
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.

Parameters:
sql - the SQL query to run.
args - the SqlParameterSource containing the arguments for the query
Throws:
DataAccessException

queryForLong

long queryForLong(java.lang.String sql,
                  java.lang.Object... args)
                  throws DataAccessException
Deprecated. 
Query for an long passing in a SQL query using the standard '?' placeholders for parameters and a variable number of arguments.

Parameters:
sql - the SQL query to run.
args - the variable number of arguments for the query
Throws:
DataAccessException

queryForObject

<T> T queryForObject(java.lang.String sql,
                     java.lang.Class<T> requiredType,
                     java.util.Map<java.lang.String,?> args)
                 throws DataAccessException
Deprecated. 
Query for an object of type T identified by the supplied @Class. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
requiredType - the required type of the return value
args - the map containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, Class), JdbcOperations.queryForObject(String, Object[], Class)

queryForObject

<T> T queryForObject(java.lang.String sql,
                     java.lang.Class<T> requiredType,
                     SqlParameterSource args)
                 throws DataAccessException
Deprecated. 
Query for an object of type T identified by the supplied @Class. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
requiredType - the required type of the return value
args - the SqlParameterSource containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, Class), JdbcOperations.queryForObject(String, Object[], Class)

queryForObject

<T> T queryForObject(java.lang.String sql,
                     java.lang.Class<T> requiredType,
                     java.lang.Object... args)
                 throws DataAccessException
Deprecated. 
Query for an object of type T identified by the supplied @Class. Uses sql with the standard '?' placeholders for parameters

Parameters:
sql - the SQL query to run
requiredType - the required type of the return value
args - the variable number of arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, Class), JdbcOperations.queryForObject(String, Object[], Class)

queryForObject

<T> T queryForObject(java.lang.String sql,
                     RowMapper<T> rm,
                     java.util.Map<java.lang.String,?> args)
                 throws DataAccessException
Deprecated. 
Query for an object of type T using the supplied RowMapper to the query results to the object. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
rm - the @RowMapper to use for result mapping
args - the map containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

queryForObject

@Deprecated
<T> T queryForObject(java.lang.String sql,
                                ParameterizedRowMapper<T> rm,
                                java.util.Map<java.lang.String,?> args)
                 throws DataAccessException
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.

Query for an object of type T using the supplied ParameterizedRowMapper to the query results to the object. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
rm - the @ParameterizedRowMapper to use for result mapping
args - the map containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

queryForObject

<T> T queryForObject(java.lang.String sql,
                     RowMapper<T> rm,
                     SqlParameterSource args)
                 throws DataAccessException
Deprecated. 
Query for an object of type T using the supplied RowMapper to the query results to the object. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
rm - the @RowMapper to use for result mapping
args - the SqlParameterSource containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

queryForObject

@Deprecated
<T> T queryForObject(java.lang.String sql,
                                ParameterizedRowMapper<T> rm,
                                SqlParameterSource args)
                 throws DataAccessException
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.

Query for an object of type T using the supplied ParameterizedRowMapper to the query results to the object. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
rm - the @ParameterizedRowMapper to use for result mapping
args - the SqlParameterSource containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

queryForObject

<T> T queryForObject(java.lang.String sql,
                     RowMapper<T> rm,
                     java.lang.Object... args)
                 throws DataAccessException
Deprecated. 
Query for an object of type T using the supplied RowMapper to the query results to the object. Uses sql with the standard '?' placeholders for parameters

Parameters:
sql - the SQL query to run
rm - the @RowMapper to use for result mapping
args - the variable number of arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

queryForObject

@Deprecated
<T> T queryForObject(java.lang.String sql,
                                ParameterizedRowMapper<T> rm,
                                java.lang.Object... args)
                 throws DataAccessException
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.

Query for an object of type T using the supplied ParameterizedRowMapper to the query results to the object. Uses sql with the standard '?' placeholders for parameters

Parameters:
sql - the SQL query to run
rm - the @ParameterizedRowMapper to use for result mapping
args - the variable number of arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

query

<T> java.util.List<T> query(java.lang.String sql,
                            RowMapper<T> rm,
                            java.util.Map<java.lang.String,?> args)
                        throws DataAccessException
Deprecated. 
Query for a 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 NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
rm - the @RowMapper to use for result mapping
args - the map containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

query

@Deprecated
<T> java.util.List<T> query(java.lang.String sql,
                                       ParameterizedRowMapper<T> rm,
                                       java.util.Map<java.lang.String,?> args)
                        throws DataAccessException
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.

Query for a 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 NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
rm - the @ParameterizedRowMapper to use for result mapping
args - the map containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

query

<T> java.util.List<T> query(java.lang.String sql,
                            RowMapper<T> rm,
                            SqlParameterSource args)
                        throws DataAccessException
Deprecated. 
Query for a 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 NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
rm - the @RowMapper to use for result mapping
args - the SqlParameterSource containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

query

@Deprecated
<T> java.util.List<T> query(java.lang.String sql,
                                       ParameterizedRowMapper<T> rm,
                                       SqlParameterSource args)
                        throws DataAccessException
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.

Query for a 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 NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
rm - the @ParameterizedRowMapper to use for result mapping
args - the SqlParameterSource containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

query

<T> java.util.List<T> query(java.lang.String sql,
                            RowMapper<T> rm,
                            java.lang.Object... args)
                        throws DataAccessException
Deprecated. 
Query for a List of Objects of type T using the supplied RowMapper to the query results to the object. Uses sql with the standard '?' placeholders for parameters

Parameters:
sql - the SQL query to run
rm - the @RowMapper to use for result mapping
args - the variable number of arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

query

@Deprecated
<T> java.util.List<T> query(java.lang.String sql,
                                       ParameterizedRowMapper<T> rm,
                                       java.lang.Object... args)
                        throws DataAccessException
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.

Query for a List of Objects of type T using the supplied ParameterizedRowMapper to the query results to the object. Uses sql with the standard '?' placeholders for parameters

Parameters:
sql - the SQL query to run
rm - the @ParameterizedRowMapper to use for result mapping
args - the variable number of arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForObject(String, org.springframework.jdbc.core.RowMapper), JdbcOperations.queryForObject(String, Object[], org.springframework.jdbc.core.RowMapper)

queryForMap

java.util.Map<java.lang.String,java.lang.Object> queryForMap(java.lang.String sql,
                                                             java.util.Map<java.lang.String,?> args)
                                                             throws DataAccessException
Deprecated. 
Execute the supplied query with the supplied arguments.

The query is expected to be a single row query; the result row will be mapped to a Map (one entry for each column, using the column name as the key). Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
args - the map containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForMap(String), JdbcOperations.queryForMap(String, Object[])

queryForMap

java.util.Map<java.lang.String,java.lang.Object> queryForMap(java.lang.String sql,
                                                             SqlParameterSource args)
                                                             throws DataAccessException
Deprecated. 
Execute the supplied query with the supplied arguments.

The query is expected to be a single row query; the result row will be mapped to a Map (one entry for each column, using the column name as the key). Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
args - the SqlParameterSource containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForMap(String), JdbcOperations.queryForMap(String, Object[])

queryForMap

java.util.Map<java.lang.String,java.lang.Object> queryForMap(java.lang.String sql,
                                                             java.lang.Object... args)
                                                             throws DataAccessException
Deprecated. 
Execute the supplied query with the (optional) supplied arguments.

The query is expected to be a single row query; the result row will be mapped to a Map (one entry for each column, using the column name as the key). Uses sql with the standard '?' placeholders for parameters

Parameters:
sql - the SQL query to run
args - the variable number of arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForMap(String), JdbcOperations.queryForMap(String, Object[])

queryForList

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
Deprecated. 
Execute the supplied query with the supplied arguments.

Each element in the returned List is constructed as a Map as described in queryForMap(java.lang.String, java.util.Map) Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
args - the map containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForList(String), JdbcOperations.queryForList(String, Object[])

queryForList

java.util.List<java.util.Map<java.lang.String,java.lang.Object>> queryForList(java.lang.String sql,
                                                                              SqlParameterSource args)
                                                                              throws DataAccessException
Deprecated. 
Execute the supplied query with the supplied arguments.

Each element in the returned List is constructed as a Map as described in queryForMap(java.lang.String, java.util.Map) Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL query to run
args - the SqlParameterSource containing the arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForList(String), JdbcOperations.queryForList(String, Object[])

queryForList

java.util.List<java.util.Map<java.lang.String,java.lang.Object>> queryForList(java.lang.String sql,
                                                                              java.lang.Object... args)
                                                                              throws DataAccessException
Deprecated. 
Execute the supplied query with the (optional) supplied arguments.

Each element in the returned List is constructed as a Map as described in queryForMap(java.lang.String, java.util.Map) Uses sql with the standard '?' placeholders for parameters

Parameters:
sql - the SQL query to run
args - the variable number of arguments for the query
Throws:
DataAccessException
See Also:
JdbcOperations.queryForList(String), JdbcOperations.queryForList(String, Object[])

update

int update(java.lang.String sql,
           java.util.Map<java.lang.String,?> args)
           throws DataAccessException
Deprecated. 
Execute the supplied SQL statement with (optional) supplied arguments. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL statement to execute
args - the map containing the arguments for the query
Returns:
the numbers of rows affected by the update
Throws:
DataAccessException
See Also:
NamedParameterJdbcOperations.update(String, Map)

update

int update(java.lang.String sql,
           SqlParameterSource args)
           throws DataAccessException
Deprecated. 
Execute the supplied SQL statement with supplied arguments. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Parameters:
sql - the SQL statement to execute
args - the SqlParameterSource containing the arguments for the statement
Returns:
the numbers of rows affected by the update
Throws:
DataAccessException
See Also:
NamedParameterJdbcOperations.update(String, SqlParameterSource)

update

int update(java.lang.String sql,
           java.lang.Object... args)
           throws DataAccessException
Deprecated. 
Execute the supplied SQL statement with supplied arguments. Uses sql with the standard '?' placeholders for parameters

Parameters:
sql - the SQL statement to execute
args - the variable number of arguments for the query
Returns:
the numbers of rows affected by the update
Throws:
DataAccessException
See Also:
JdbcOperations.update(String), JdbcOperations.update(String, Object[])

batchUpdate

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. Uses sql with the named parameter support.

Parameters:
sql - the SQL statement to execute
batchValues - the array of Maps containing the batch of arguments for the query
Returns:
an array containing the numbers of rows affected by each update in the batch

batchUpdate

int[] batchUpdate(java.lang.String sql,
                  SqlParameterSource[] batchArgs)
Deprecated. 
Execute a batch using the supplied SQL statement with the batch of supplied arguments. Uses sql with the named parameter support.

Parameters:
sql - the SQL statement to execute
batchArgs - the array of SqlParameterSource containing the batch of arguments for the query
Returns:
an array containing the numbers of rows affected by each update in the batch

batchUpdate

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. Uses sql with the standard '?' placeholders for parameters

Parameters:
sql - the SQL statement to execute
batchArgs - the List of Object arrays containing the batch of arguments for the query
Returns:
an array containing the numbers of rows affected by each update in the batch

batchUpdate

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. Uses sql with the standard '?' placeholders for parameters

Parameters:
sql - the SQL statement to execute.
batchArgs - the List of Object arrays containing the batch of arguments for the query
argTypes - SQL types of the arguments (constants from java.sql.Types)
Returns:
an array containing the numbers of rows affected by each update in the batch

Spring Framework