sirius.db.jdbc

Class SQLCall

java.lang.Object

sirius.db.jdbc.SQLCall

public class SQLCall
extends Object

Represents a flexible way of executing parameterized SQL calls without thinking too much about resource management.

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	SQLCall(Database ds, String fun, Integer returnType)

Method Summary

Modifier and Type	Method and Description
SQLCall	addInParam(Object value) Adds an in parameter.
SQLCall	addOutParam(String parameter, int type) Adds an out parameter.
SQLCall	call() Invokes the call
sirius.kernel.commons.Value	getReturnValue() Returns the return value of the function call
sirius.kernel.commons.Value	getValue(String key) Returns the named out parameter
protected void	readBackParameters(CallableStatement stmt)
String	toString()
protected void	writeParameters(CallableStatement stmt)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

SQLCall

protected SQLCall(Database ds,
                  String fun,
                  Integer returnType)

Method Detail

addInParam

public SQLCall addInParam(Object value)

Adds an in parameter.

Parameters:

value - the value to pass in

Returns:

the call itself to iterate fluent calls

addOutParam

public SQLCall addOutParam(String parameter,
                           int type)

Adds an out parameter.

Parameters:

parameter - the name of the parameter

type - the SQL type (Types) of the parameter

Returns:

the call itself to iterate fluent calls

call

public SQLCall call()
             throws SQLException

Invokes the call

Returns:

the call itself to iterate fluent calls in order to read the result

Throws:

SQLException - in case of a database error

writeParameters

protected void writeParameters(CallableStatement stmt)
                        throws SQLException

Throws:

SQLException

readBackParameters

protected void readBackParameters(CallableStatement stmt)
                           throws SQLException

Throws:

SQLException

getReturnValue

public sirius.kernel.commons.Value getReturnValue()

Returns the return value of the function call

Returns:

the return value wrapped as Value

getValue

public sirius.kernel.commons.Value getValue(String key)

Returns the named out parameter

Parameters:

key - the parameter to return

Returns:

the value of the given out parameter wrapped as Value

toString

public String toString()

Overrides:

toString in class Object