org.springframework.jdbc.core.simple.SimpleJdbcOperations |
Known Indirect Subclasses |
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.
Public Methods | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Execute a batch using the supplied SQL statement with the batch of supplied arguments.
| |||||||||||
Execute a batch using the supplied SQL statement with the batch of supplied arguments.
| |||||||||||
Executes a batch using the supplied SQL statement with the batch of supplied arguments.
| |||||||||||
Execute a batch using the supplied SQL statement with the batch of supplied arguments.
| |||||||||||
Expose the classic Spring JdbcTemplate to allow invocation of less
commonly used methods.
| |||||||||||
Expose the Spring NamedParameterJdbcTemplate to allow invocation of less
commonly used methods.
| |||||||||||
This method is 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.
| |||||||||||
This method is 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.
| |||||||||||
This method is 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
int passing in a SQL query
using the named parameter support provided by the
NamedParameterJdbcTemplate
and a SqlParameterSource containing the arguments. | |||||||||||
Query for an
int passing in a SQL query
using the named parameter support provided by the
NamedParameterJdbcTemplate
and a map containing the arguments. | |||||||||||
Query for an
int passing in a SQL query
using the standard '?' placeholders for parameters
and a variable number of arguments. | |||||||||||
Execute the supplied query with the supplied arguments.
| |||||||||||
Execute the supplied query with the supplied arguments.
| |||||||||||
Execute the supplied query with the (optional) supplied arguments.
| |||||||||||
Query for an
long passing in a SQL query
using the named parameter support provided by the
NamedParameterJdbcTemplate
and a SqlParameterSource containing the arguments. | |||||||||||
Query for an
long passing in a SQL query
using the named parameter support provided by the
NamedParameterJdbcTemplate
and a map containing the arguments. | |||||||||||
Query for an
long passing in a SQL query
using the standard '?' placeholders for parameters
and a variable number of arguments. | |||||||||||
Execute the supplied query with the (optional) supplied arguments.
| |||||||||||
Execute the supplied query with the supplied arguments.
| |||||||||||
Execute the supplied query with the supplied arguments.
| |||||||||||
Query for an object of type
T identified by the supplied @Class . | |||||||||||
Query for an object of type
T using the supplied
RowMapper to the query results to the object. | |||||||||||
Query for an object of type
T using the supplied
RowMapper to the query results to the object. | |||||||||||
Query for an object of type
T identified by the supplied @Class . | |||||||||||
Query for an object of type
T identified by the supplied @Class . | |||||||||||
This method is 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.
| |||||||||||
This method is 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.
| |||||||||||
This method is 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
RowMapper to the query results to the object. | |||||||||||
Execute the supplied SQL statement with (optional) supplied arguments.
| |||||||||||
Execute the supplied SQL statement with supplied arguments.
| |||||||||||
Execute the supplied SQL statement with supplied arguments.
|
Execute a batch using the supplied SQL statement with the batch of supplied arguments. Uses sql with the named parameter support.
sql | the SQL statement to execute |
---|---|
batchArgs | the array of SqlParameterSource containing the batch of arguments for the query |
Execute a batch using the supplied SQL statement with the batch of supplied arguments. Uses sql with the standard '?' placeholders for 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 ) |
Executes a batch using the supplied SQL statement with the batch of supplied arguments. Uses sql with the named parameter support.
sql | the SQL statement to execute |
---|---|
batchValues | the array of Maps containing the batch of arguments for the query |
Execute a batch using the supplied SQL statement with the batch of supplied arguments. Uses sql with the standard '?' placeholders for parameters
sql | the SQL statement to execute |
---|---|
batchArgs | the List of Object arrays containing the batch of arguments for the query |
Expose the classic Spring JdbcTemplate to allow invocation of less commonly used methods.
Expose the Spring NamedParameterJdbcTemplate to allow invocation of less commonly used methods.
This method is 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
sql | the SQL query to run |
---|---|
rm | the @ParameterizedRowMapper to use for result mapping |
args | the variable number of arguments for the query |
DataAccessException |
---|
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
sql | the SQL query to run |
---|---|
rm | the @RowMapper to use for result mapping |
args | the SqlParameterSource containing the arguments for the query |
DataAccessException |
---|
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
sql | the SQL query to run |
---|---|
rm | the @RowMapper to use for result mapping |
args | the map containing the arguments for the query |
DataAccessException |
---|
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
sql | the SQL query to run |
---|---|
rm | the @RowMapper to use for result mapping |
args | the variable number of arguments for the query |
DataAccessException |
---|
This method is 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
sql | the SQL query to run |
---|---|
rm | the @ParameterizedRowMapper to use for result mapping |
args | the map containing the arguments for the query |
DataAccessException |
---|
This method is 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
sql | the SQL query to run |
---|---|
rm | the @ParameterizedRowMapper to use for result mapping |
args | the SqlParameterSource containing the arguments for the query |
DataAccessException |
---|
Query for an 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.
|
DataAccessException |
---|
Query for an 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 query |
DataAccessException |
---|
Query for an 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 query |
DataAccessException |
---|
Execute the supplied query with the supplied arguments.
Each element in the returned List
is constructed as a Map
as described in queryForMap(String, Object...)
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplate
sql | the SQL query to run |
---|---|
args | the SqlParameterSource containing the arguments for the query |
DataAccessException |
---|
Execute the supplied query with the supplied arguments.
Each element in the returned List
is constructed as a Map
as described in queryForMap(String, Object...)
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplate
sql | the SQL query to run |
---|---|
args | the map containing the arguments for the query |
DataAccessException |
---|
Execute the supplied query with the (optional) supplied arguments.
Each element in the returned List
is constructed as a Map
as described in queryForMap(String, Object...)
Uses sql with the standard '?' placeholders for parameters
sql | the SQL query to run |
---|---|
args | the variable number of arguments for the query |
DataAccessException |
---|
Query for an 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 query
|
DataAccessException |
---|
Query for an 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 query |
DataAccessException |
---|
Query for an 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 query |
DataAccessException |
---|
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
sql | the SQL query to run |
---|---|
args | the variable number of arguments for the query |
DataAccessException |
---|
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 MapNamedParameterJdbcTemplate
sql | the SQL query to run |
---|---|
args | the SqlParameterSource containing the arguments for the query |
DataAccessException |
---|
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 MapNamedParameterJdbcTemplate
sql | the SQL query to run |
---|---|
args | the map containing the arguments for the query |
DataAccessException |
---|
Query for an object of type T
identified by the supplied @Class
.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplate
sql | the SQL query to run |
---|---|
requiredType | the required type of the return value |
args | the map containing the arguments for the query |
DataAccessException |
---|
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
sql | the SQL query to run |
---|---|
rm | the @RowMapper to use for result mapping |
args | the variable number of arguments for the query |
DataAccessException |
---|
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
sql | the SQL query to run |
---|---|
rm | the @RowMapper to use for result mapping |
args | the SqlParameterSource containing the arguments for the query |
DataAccessException |
---|
Query for an object of type T
identified by the supplied @Class
.
Uses sql with the standard '?' placeholders for parameters
sql | the SQL query to run |
---|---|
requiredType | the required type of the return value |
args | the variable number of arguments for the query |
DataAccessException |
---|
Query for an object of type T
identified by the supplied @Class
.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplate
sql | the SQL query to run |
---|---|
requiredType | the required type of the return value |
args | the SqlParameterSource containing the arguments for the query |
DataAccessException |
---|
This method is 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
sql | the SQL query to run |
---|---|
rm | the @ParameterizedRowMapper to use for result mapping |
args | the SqlParameterSource containing the arguments for the query |
DataAccessException |
---|
This method is 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
sql | the SQL query to run |
---|---|
rm | the @ParameterizedRowMapper to use for result mapping |
args | the variable number of arguments for the query |
DataAccessException |
---|
This method is 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
sql | the SQL query to run |
---|---|
rm | the @ParameterizedRowMapper to use for result mapping |
args | the map containing the arguments for the query |
DataAccessException |
---|
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
sql | the SQL query to run |
---|---|
rm | the @RowMapper to use for result mapping |
args | the map containing the arguments for the query |
DataAccessException |
---|
Execute the supplied SQL statement with (optional) supplied arguments.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplate
sql | the SQL statement to execute |
---|---|
args | the map containing the arguments for the query |
DataAccessException |
---|
Execute the supplied SQL statement with supplied arguments. Uses sql with the standard '?' placeholders for parameters
sql | the SQL statement to execute |
---|---|
args | the variable number of arguments for the query |
DataAccessException |
---|
Execute the supplied SQL statement with supplied arguments.
Uses sql with the named parameter support provided by the
NamedParameterJdbcTemplate
sql | the SQL statement to execute |
---|---|
args | the SqlParameterSource containing the arguments for the statement |
DataAccessException |
---|