com.sankhya.util

Class ProcedureCaller

java.lang.Object

com.sankhya.util.ProcedureCaller

public class ProcedureCaller
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	DB_PARAM_DATE
static java.lang.String	DB_PARAM_NUMDEC
static java.lang.String	DB_PARAM_NUMINT
static java.lang.String	DB_PARAM_TEXT

Constructor Summary

Constructors

Constructor and Description
ProcedureCaller(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
void	addDBInputParameter(java.sql.Connection c, java.lang.String type, int row, java.lang.String name, java.lang.Object value)
void	addDBInputParameter(java.sql.Connection c, java.lang.String type, java.lang.String name, java.lang.Object value)
void	addInputParameter(java.lang.Object p)
void	addOutputParameter(int type, java.lang.String name)
void	execute(java.sql.Connection c)
java.lang.String	getExecutionID()
java.lang.Object	result(java.lang.String paramName)
java.math.BigDecimal	resultAsBigDecimal(java.lang.String paramName)
java.sql.ResultSet	resultAsResultSet(java.lang.String paramName)
java.lang.String	resultAsString(java.lang.String paramName)
java.sql.Timestamp	resultAsTimestamp(java.lang.String paramName)

Methods inherited from class java.lang.Object

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

Field Detail

DB_PARAM_TEXT

public static final java.lang.String DB_PARAM_TEXT

See Also:

Constant Field Values

DB_PARAM_NUMINT

public static final java.lang.String DB_PARAM_NUMINT

See Also:

Constant Field Values

DB_PARAM_NUMDEC

public static final java.lang.String DB_PARAM_NUMDEC

See Also:

Constant Field Values

DB_PARAM_DATE

public static final java.lang.String DB_PARAM_DATE

See Also:

Constant Field Values

Constructor Detail

ProcedureCaller

public ProcedureCaller(java.lang.String name)

Method Detail

addOutputParameter

public void addOutputParameter(int type,
                               java.lang.String name)

addDBInputParameter

public void addDBInputParameter(java.sql.Connection c,
                                java.lang.String type,
                                java.lang.String name,
                                java.lang.Object value)
                         throws java.lang.Exception

Throws:

java.lang.Exception

addDBInputParameter

public void addDBInputParameter(java.sql.Connection c,
                                java.lang.String type,
                                int row,
                                java.lang.String name,
                                java.lang.Object value)
                         throws java.lang.Exception

Throws:

java.lang.Exception

addInputParameter

public void addInputParameter(java.lang.Object p)

result

public java.lang.Object result(java.lang.String paramName)

resultAsString

public java.lang.String resultAsString(java.lang.String paramName)

resultAsBigDecimal

public java.math.BigDecimal resultAsBigDecimal(java.lang.String paramName)

resultAsTimestamp

public java.sql.Timestamp resultAsTimestamp(java.lang.String paramName)

resultAsResultSet

public java.sql.ResultSet resultAsResultSet(java.lang.String paramName)

execute

public void execute(java.sql.Connection c)
             throws java.lang.Exception

Throws:

java.lang.Exception

getExecutionID

public java.lang.String getExecutionID()