CallableStatement

interfacein packageklyn.databases.sql

public interface CallableStatement extends PreparedStatement:

└ CallableStatement

Stored-procedure statement contract.

Output parameters are declared with out(...) and then read with typed getXxx(...) methods.

import klyn.databases.sql

call = connection.callable("{ call refresh_score(?, ?) }")
call.setInt(1, 42).out(2, Types.INTEGER)

Properties

Modifier and Type	Member	Description
public readonly property	outParameters `outParameters as Map<Int, Int>`	Declared output parameters (`index -> sqlType`).
public readonly property	outValues `outValues as Map<Int, Object>`	Output values produced by the driver.

Properties inherited from PreparedStatement: parameterInfo, parameterMetadata, parameters, sql

Methods

Modifier and Type	Member	Description
public	getBoolean `getBoolean(index as Int) as Boolean throws SQLException`	Reads one output parameter as `Boolean`.
public	getDouble `getDouble(index as Int) as Double throws SQLException`	Reads one output parameter as `Double`.
public	getInt `getInt(index as Int) as Int throws SQLException`	Reads one output parameter as `Int`.
public	getLong `getLong(index as Int) as Long throws SQLException`	Reads one output parameter as `Long`.
public	getObject `getObject(index as Int) as Object throws SQLException`	Reads one output parameter as an object.
public	getString `getString(index as Int) as String throws SQLException`	Reads one output parameter as text.
public	out `out(index as Int, sqlType as Int, scale as Int = 0) as CallableStatement throws SQLException`	Declares one output parameter.
public	registerOutParameter `registerOutParameter(index as Int, sqlType as Int, scale as Int = 0) as CallableStatement throws SQLException`	Compatibility alias of `out(.
public	wasNull `wasNull() as Boolean throws SQLException`	True when the last `getXxx(.

Methods inherited from AutoClosable: close