| org.jaffa.persistence.engines.jdbcengine.IStoredProcedure
All known Subclasses: org.jaffa.persistence.domainobjects.VoucherStoredProcedure,
| IStoredProcedure | | public interface IStoredProcedure extends IPersistent(Code) | | This is the interface for a StoredProcedure.
|
| Field Summary | |
| final public static int | BOTH
| | final public static int | IN
| | final public static int | OUT
|
| Method Summary | |
| public int[] | getParamDirections()
The implementing class should return an array of integers signifying the directions (input, output or input/output)
for each of the parameter returned in the getParameters() method. | | public String[] | getParamSqlTypes()
The implementing class should return an array of Strings signifying the SQL type
for each of the parameter returned in the getParameters() method.
eg. | | public String[] | getParameters()
The implementing class should return an array of field names,
which correspond to the parameters of the StoredProcedure. | | public String | prepareCall()
The implementing class will return a String having the call to the StoredProcedure.
For eg. |
| BOTH | | final public static int BOTH(Code) | | A static for denoting an INPUT/OUTPUT parameter of a StoredProcedure
|
| IN | | final public static int IN(Code) | | A static for denoting an INPUT parameter of a StoredProcedure
|
| OUT | | final public static int OUT(Code) | | A static for denoting an OUTPUT parameter of a StoredProcedure
|
| getParamDirections | | public int[] getParamDirections()(Code) | | The implementing class should return an array of integers signifying the directions (input, output or input/output)
for each of the parameter returned in the getParameters() method.
An array of integers signifying the directions of the parameters. |
| getParamSqlTypes | | public String[] getParamSqlTypes()(Code) | | The implementing class should return an array of Strings signifying the SQL type
for each of the parameter returned in the getParameters() method.
eg. VARCHAR, BOOLEAN etc. etc. These should be the same as those defined in the mapping files
An array of Strings signifying the SQL type of the parameters. |
| getParameters | | public String[] getParameters()(Code) | | The implementing class should return an array of field names,
which correspond to the parameters of the StoredProcedure.
The implementing class should provide Getters/Setters for these fields.
An array of parameters to the StoredProcedure. |
| prepareCall | | public String prepareCall()(Code) | | The implementing class will return a String having the call to the StoredProcedure.
For eg. To invoke the 'ke_vcpkg1.getvoucher' StoredProcedure, which takes 3 parameters, this method
will return the string "{call ke_vcpkg1.getvoucher(?,?,?)}".
a String having the call to the StoredProcedure. |
|
|