java.lang.Object | |||
↳ | org.springframework.jdbc.object.RdbmsOperation | ||
↳ | org.springframework.jdbc.object.SqlCall | ||
↳ | org.springframework.jdbc.object.StoredProcedure |
Known Direct Subclasses |
Superclass for object abstractions of RDBMS stored procedures.
This class is abstract and it is intended that subclasses will provide
a typed method for invocation that delegates to the supplied
execute(Object...)
method.
The inherited sql
property is the name of the stored
procedure in the RDBMS. Note that JDBC 3.0 introduces named parameters,
although the other features provided by this class are still necessary
in JDBC 3.0.
[Expand]
Inherited Fields | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
From class
org.springframework.jdbc.object.RdbmsOperation
|
Protected Constructors | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Allow use as a bean.
| |||||||||||
Create a new object wrapper for a stored procedure.
| |||||||||||
Create a new object wrapper for a stored procedure.
|
Public Methods | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Declare a parameter.
| |||||||||||
Execute the stored procedure.
| |||||||||||
Execute the stored procedure with the provided parameter values.
| |||||||||||
Execute the stored procedure.
|
Protected Methods | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
StoredProcedure parameter Maps are by default allowed to contain
additional entries that are not actually used as parameters.
|
[Expand]
Inherited Methods | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
From class
org.springframework.jdbc.object.SqlCall
| |||||||||||
From class
org.springframework.jdbc.object.RdbmsOperation
| |||||||||||
From class
java.lang.Object
| |||||||||||
From interface
org.springframework.beans.factory.InitializingBean
|
Allow use as a bean.
Create a new object wrapper for a stored procedure.
ds | DataSource to use throughout the lifetime of this object to obtain connections |
---|---|
name | name of the stored procedure in the database |
Create a new object wrapper for a stored procedure.
jdbcTemplate | JdbcTemplate which wraps DataSource |
---|---|
name | name of the stored procedure in the database |
Declare a parameter. Overridden method.
Parameters declared as SqlParameter
and SqlInOutParameter
will always be used to provide input values. In addition to this any parameter declared
as SqlOutParameter
where an non-null input value is provided will also be used
as an input paraneter.
Note: Calls to declareParameter must be made in the same order as
they appear in the database's stored procedure parameter list.
Names are purely used to help mapping.
param | parameter object |
---|
Execute the stored procedure. Subclasses should define a strongly typed execute method (with a meaningful name) that invokes this method, passing in a ParameterMapper that will populate the input map. This allows mapping database specific features since the ParameterMapper has access to the Connection object. The execute method is also responsible for extracting typed values from the output map. Subclass execute methods will often take domain objects as arguments and return values. Alternatively, they can return void.
inParamMapper | map of input parameters, keyed by name as in parameter
declarations. Output parameters need not (but can) be included in this map.
It is legal for map entries to be null , and this will produce the correct
behavior using a NULL argument to the stored procedure. |
---|
DataAccessException |
---|
Execute the stored procedure with the provided parameter values. This is a convenience method where the order of the passed in parameter values must match the order that the parameters where declared in.
inParams | variable number of input parameters. Output parameters should
not be included in this map.
It is legal for values to be null , and this will produce the
correct behavior using a NULL argument to the stored procedure. |
---|
Execute the stored procedure. Subclasses should define a strongly typed execute method (with a meaningful name) that invokes this method, populating the input map and extracting typed values from the output map. Subclass execute methods will often take domain objects as arguments and return values. Alternatively, they can return void.
inParams | map of input parameters, keyed by name as in parameter
declarations. Output parameters need not (but can) be included in this map.
It is legal for map entries to be null , and this will produce the
correct behavior using a NULL argument to the stored procedure. |
---|
DataAccessException |
---|
StoredProcedure parameter Maps are by default allowed to contain additional entries that are not actually used as parameters.