org.springframework.jdbc.core.simple
Class SimpleJdbcTemplate

java.lang.Object
  org.springframework.jdbc.core.simple.SimpleJdbcTemplate

All Implemented Interfaces:

SimpleJdbcOperations

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

@Deprecated
public class SimpleJdbcTemplate
extends Object
implements SimpleJdbcOperations

Java-5-based convenience wrapper for the classic Spring JdbcTemplate, taking advantage of varargs and autoboxing, and exposing only the most commonly required operations in order to simplify JdbcTemplate usage.

Use the getJdbcOperations() method (or a straight JdbcTemplate) if you need to invoke less commonly used template methods. This includes any methods specifying SQL types, methods using less commonly used callbacks such as RowCallbackHandler, updates with PreparedStatementSetters rather than argument arrays, and stored procedures as well as batch operations.

Since:

2.0

Author:

Rod Johnson, Rob Harrop, Juergen Hoeller, Thomas Risberg

See Also:

ParameterizedRowMapper, SimpleJdbcDaoSupport, JdbcTemplate

Constructor Summary

SimpleJdbcTemplate(DataSource dataSource)
Deprecated. Create a new SimpleJdbcTemplate for the given DataSource.

SimpleJdbcTemplate(JdbcOperations classicJdbcTemplate)
Deprecated. Create a new SimpleJdbcTemplate for the given classic Spring JdbcTemplate.

SimpleJdbcTemplate(NamedParameterJdbcOperations namedParameterJdbcTemplate)
Deprecated. Create a new SimpleJdbcTemplate for the given Spring NamedParameterJdbcTemplate.

Method Summary

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.
<T> List<T>	query(String sql, ParameterizedRowMapper<T> rm, Object... args) Deprecated.
<T> List<T>	query(String sql, ParameterizedRowMapper<T> rm, SqlParameterSource args) Deprecated.
<T> List<T>	query(String sql, RowMapper<T> rm, Map<String,?> args) Deprecated. Query for a List of Objects of type T using the supplied RowMapper to the query results to the object.
<T> List<T>	query(String sql, RowMapper<T> rm, Object... args) Deprecated. Query for a List of Objects of type T using the supplied RowMapper to the query results to the object.
<T> List<T>	query(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(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.
<T> T	queryForObject(String sql, ParameterizedRowMapper<T> rm, Object... args) Deprecated.
<T> T	queryForObject(String sql, ParameterizedRowMapper<T> rm, SqlParameterSource args) Deprecated.
<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.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SimpleJdbcTemplate

public SimpleJdbcTemplate(DataSource dataSource)

Deprecated.

Create a new SimpleJdbcTemplate for the given DataSource.

Creates a classic Spring JdbcTemplate and wraps it.

Parameters:

dataSource - the JDBC DataSource to access

SimpleJdbcTemplate

public SimpleJdbcTemplate(JdbcOperations classicJdbcTemplate)

Deprecated.

Create a new SimpleJdbcTemplate for the given classic Spring JdbcTemplate.

Parameters:

classicJdbcTemplate - the classic Spring JdbcTemplate to wrap

SimpleJdbcTemplate

public SimpleJdbcTemplate(NamedParameterJdbcOperations namedParameterJdbcTemplate)

Deprecated.

Create a new SimpleJdbcTemplate for the given Spring NamedParameterJdbcTemplate.

Parameters:

namedParameterJdbcTemplate - the Spring NamedParameterJdbcTemplate to wrap

Method Detail

getJdbcOperations

public JdbcOperations getJdbcOperations()

Deprecated.

Expose the classic Spring JdbcTemplate to allow invocation of less commonly used methods.

Specified by:

getJdbcOperations in interface SimpleJdbcOperations

getNamedParameterJdbcOperations

public NamedParameterJdbcOperations getNamedParameterJdbcOperations()

Deprecated.

Expose the Spring NamedParameterJdbcTemplate to allow invocation of less commonly used methods.

Specified by:

getNamedParameterJdbcOperations in interface SimpleJdbcOperations

queryForInt

public int queryForInt(String sql,
                       Map<String,?> args)
                throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Query for an int passing in a SQL query using the named parameter support provided by the NamedParameterJdbcTemplate and a map containing the arguments.

Specified by:

queryForInt in interface SimpleJdbcOperations

Parameters:

sql - the SQL query to run.

args - the map containing the arguments for the query

Throws:

DataAccessException

queryForInt

public int queryForInt(String sql,
                       SqlParameterSource args)
                throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Query for an int passing in a SQL query using the named parameter support provided by the NamedParameterJdbcTemplate and a SqlParameterSource containing the arguments.

Specified by:

queryForInt in interface SimpleJdbcOperations

Parameters:

sql - the SQL query to run.

args - the SqlParameterSource containing the arguments for the query.

Throws:

DataAccessException

queryForInt

public int queryForInt(String sql,
                       Object... args)
                throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Query for an int passing in a SQL query using the standard '?' placeholders for parameters and a variable number of arguments.

Specified by:

queryForInt in interface SimpleJdbcOperations

Parameters:

sql - the SQL query to run.

args - the variable number of arguments for the query

Throws:

DataAccessException

queryForLong

public long queryForLong(String sql,
                         Map<String,?> args)
                  throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Query for an long passing in a SQL query using the named parameter support provided by the NamedParameterJdbcTemplate and a map containing the arguments.

Specified by:

queryForLong in interface SimpleJdbcOperations

Parameters:

sql - the SQL query to run.

args - the map containing the arguments for the query

Throws:

DataAccessException

queryForLong

public long queryForLong(String sql,
                         SqlParameterSource args)
                  throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Query for an long passing in a SQL query using the named parameter support provided by the NamedParameterJdbcTemplate and a SqlParameterSource containing the arguments.

Specified by:

queryForLong in interface SimpleJdbcOperations

Parameters:

sql - the SQL query to run.

args - the SqlParameterSource containing the arguments for the query

Throws:

DataAccessException

queryForLong

public long queryForLong(String sql,
                         Object... args)
                  throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Query for an long passing in a SQL query using the standard '?' placeholders for parameters and a variable number of arguments.

Specified by:

queryForLong in interface SimpleJdbcOperations

Parameters:

sql - the SQL query to run.

args - the variable number of arguments for the query

Throws:

DataAccessException

queryForObject

public <T> T queryForObject(String sql,
                            Class<T> requiredType,
                            Map<String,?> args)
                 throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Query for an object of type T identified by the supplied @Class. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Specified by:

queryForObject in interface SimpleJdbcOperations

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

public <T> T queryForObject(String sql,
                            Class<T> requiredType,
                            SqlParameterSource args)
                 throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Query for an object of type T identified by the supplied @Class. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Specified by:

queryForObject in interface SimpleJdbcOperations

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

public <T> T queryForObject(String sql,
                            Class<T> requiredType,
                            Object... args)
                 throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Query for an object of type T identified by the supplied @Class. Uses sql with the standard '?' placeholders for parameters

Specified by:

queryForObject in interface SimpleJdbcOperations

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

public <T> T queryForObject(String sql,
                            RowMapper<T> rm,
                            Map<String,?> args)
                 throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

queryForObject in interface SimpleJdbcOperations

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
public <T> T queryForObject(String sql,
                                       ParameterizedRowMapper<T> rm,
                                       Map<String,?> args)
                 throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

queryForObject in interface SimpleJdbcOperations

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

public <T> T queryForObject(String sql,
                            RowMapper<T> rm,
                            SqlParameterSource args)
                 throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

queryForObject in interface SimpleJdbcOperations

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
public <T> T queryForObject(String sql,
                                       ParameterizedRowMapper<T> rm,
                                       SqlParameterSource args)
                 throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

queryForObject in interface SimpleJdbcOperations

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

public <T> T queryForObject(String sql,
                            RowMapper<T> rm,
                            Object... args)
                 throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

queryForObject in interface SimpleJdbcOperations

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

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

queryForObject in interface SimpleJdbcOperations

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

public <T> List<T> query(String sql,
                         RowMapper<T> rm,
                         Map<String,?> args)
              throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

query in interface SimpleJdbcOperations

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
public <T> List<T> query(String sql,
                                    ParameterizedRowMapper<T> rm,
                                    Map<String,?> args)
              throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

query in interface SimpleJdbcOperations

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

public <T> List<T> query(String sql,
                         RowMapper<T> rm,
                         SqlParameterSource args)
              throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

query in interface SimpleJdbcOperations

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
public <T> List<T> query(String sql,
                                    ParameterizedRowMapper<T> rm,
                                    SqlParameterSource args)
              throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

query in interface SimpleJdbcOperations

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

public <T> List<T> query(String sql,
                         RowMapper<T> rm,
                         Object... args)
              throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

query in interface SimpleJdbcOperations

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
public <T> List<T> query(String sql,
                                    ParameterizedRowMapper<T> rm,
                                    Object... args)
              throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

query in interface SimpleJdbcOperations

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

public Map<String,Object> queryForMap(String sql,
                                      Map<String,?> args)
                               throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

queryForMap in interface SimpleJdbcOperations

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

public Map<String,Object> queryForMap(String sql,
                                      SqlParameterSource args)
                               throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

queryForMap in interface SimpleJdbcOperations

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

public Map<String,Object> queryForMap(String sql,
                                      Object... args)
                               throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

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

Specified by:

queryForMap in interface SimpleJdbcOperations

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

public List<Map<String,Object>> queryForList(String sql,
                                             Map<String,?> args)
                                      throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Execute the supplied query with the supplied arguments.

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

Specified by:

queryForList in interface SimpleJdbcOperations

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

public List<Map<String,Object>> queryForList(String sql,
                                             SqlParameterSource args)
                                      throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Execute the supplied query with the supplied arguments.

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

Specified by:

queryForList in interface SimpleJdbcOperations

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

public List<Map<String,Object>> queryForList(String sql,
                                             Object... args)
                                      throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Execute the supplied query with the (optional) supplied arguments.

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

Specified by:

queryForList in interface SimpleJdbcOperations

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

public int update(String sql,
                  Map<String,?> args)
           throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Execute the supplied SQL statement with (optional) supplied arguments. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Specified by:

update in interface SimpleJdbcOperations

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

public int update(String sql,
                  SqlParameterSource args)
           throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Execute the supplied SQL statement with supplied arguments. Uses sql with the named parameter support provided by the NamedParameterJdbcTemplate

Specified by:

update in interface SimpleJdbcOperations

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

public int update(String sql,
                  Object... args)
           throws DataAccessException

Deprecated.

Description copied from interface: SimpleJdbcOperations

Execute the supplied SQL statement with supplied arguments. Uses sql with the standard '?' placeholders for parameters

Specified by:

update in interface SimpleJdbcOperations

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

public int[] batchUpdate(String sql,
                         List<Object[]> batchArgs)

Deprecated.

Description copied from interface: SimpleJdbcOperations

Execute a batch using the supplied SQL statement with the batch of supplied arguments. Uses sql with the standard '?' placeholders for parameters

Specified by:

batchUpdate in interface SimpleJdbcOperations

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

public int[] batchUpdate(String sql,
                         List<Object[]> batchArgs,
                         int[] argTypes)

Deprecated.

Description copied from interface: SimpleJdbcOperations

Execute a batch using the supplied SQL statement with the batch of supplied arguments. Uses sql with the standard '?' placeholders for parameters

Specified by:

batchUpdate in interface SimpleJdbcOperations

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

batchUpdate

public int[] batchUpdate(String sql,
                         Map<String,?>[] batchValues)

Deprecated.

Description copied from interface: SimpleJdbcOperations

Executes a batch using the supplied SQL statement with the batch of supplied arguments. Uses sql with the named parameter support.

Specified by:

batchUpdate in interface SimpleJdbcOperations

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

public int[] batchUpdate(String sql,
                         SqlParameterSource[] batchArgs)

Deprecated.

Description copied from interface: SimpleJdbcOperations

Execute a batch using the supplied SQL statement with the batch of supplied arguments. Uses sql with the named parameter support.

Specified by:

batchUpdate in interface SimpleJdbcOperations

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