org.rimudb.storedproc
Class StoredProcedure

java.lang.Object
  extended by org.rimudb.storedproc.StoredProcedure

public class StoredProcedure
extends java.lang.Object

Author:
Simon Ritchie

Field Summary
static int NONE
           
 
Constructor Summary
StoredProcedure(Database database, java.lang.String procedureName)
           
 
Method Summary
 void addINOUTParameter(java.lang.String name, int sqlType, java.lang.Object value)
           
 void addINParameter(java.lang.String name, java.lang.Object value)
          Add parameters to the StoredProcedure.
 void addOUTParameter(java.lang.String name, int sqlType)
           
 void clearParameters()
          Clear the parameters
 java.util.List execute(boolean autoCommit)
           
 AbstractStoredProcParameter getParameter(java.lang.String parameterName)
           
 java.lang.Object getParameterValue(java.lang.String parameterName)
          Return a parameter value.
 java.lang.Object getReturnParameterValue()
          Return the return parameter.
 int getReturnType()
           
 boolean hasReturnValue()
           
 java.util.List processResultSet(java.sql.ResultSet rs)
           
 void setReturnType(int returnType)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

NONE

public static final int NONE
See Also:
Constant Field Values
Constructor Detail

StoredProcedure

public StoredProcedure(Database database,
                       java.lang.String procedureName)
Method Detail

addINParameter

public void addINParameter(java.lang.String name,
                           java.lang.Object value)
Add parameters to the StoredProcedure.

Parameters:
name -
value -

addOUTParameter

public void addOUTParameter(java.lang.String name,
                            int sqlType)

addINOUTParameter

public void addINOUTParameter(java.lang.String name,
                              int sqlType,
                              java.lang.Object value)

execute

public java.util.List execute(boolean autoCommit)
                       throws RimuDBException
Throws:
RimuDBException

setReturnType

public void setReturnType(int returnType)

getReturnType

public int getReturnType()

hasReturnValue

public boolean hasReturnValue()

processResultSet

public java.util.List processResultSet(java.sql.ResultSet rs)
                                throws java.sql.SQLException,
                                       RimuDBException
Throws:
java.sql.SQLException
RimuDBException

clearParameters

public void clearParameters()
Clear the parameters


getParameter

public AbstractStoredProcParameter getParameter(java.lang.String parameterName)
Parameters:
parameterName - String
Returns:
AbstractStoredProcParameter

getReturnParameterValue

public java.lang.Object getReturnParameterValue()
Return the return parameter.

Returns:
AbstractStoredProcParameter

getParameterValue

public java.lang.Object getParameterValue(java.lang.String parameterName)
Return a parameter value.

Parameters:
parameterName - String
Returns:
Object


Copyright © 2008-2011 Simon Ritchie. All Rights Reserved.