SqlServerCallableStatement

classin packageklyn.databases.sql.sqlserver

public class SqlServerCallableStatement extends SqlServerPreparedStatement implements CallableStatement

SqlServerPreparedStatement

└ SqlServerCallableStatement

All Implemented Interfaces: CallableStatement

SQL Server callable statement for stored procedures.

import klyn.databases.sql.sqlserver

call = connection.callable("{ CALL sp_who }")
call.execute()

Properties

Modifier and Type	Member	Description
public readonly property	outParameters `outParameters as SortedMap<Int, Int>`	Registered output SQL types.
public readonly property	outValues `outValues as SortedMap<Int, Object>`	Values from the last successful execution.

Inherited Properties

propertyInherited Properties from SqlServerPreparedStatement: parameterInfo, parameterMetadata, parameters, sql

propertyInherited Properties from Statement: batchSize, closeOnCompletion, closed, concurrency, connection, cursorName, escapeProcessing, fetchDirection, fetchSize, generatedKeys, holdability, largeMaxRows, maxFieldSize, maxRows, poolable, queryTimeoutSeconds, resultSetType, warning

Methods

Modifier and Type	Member	Description
public override	addBatch `addBatch()`	Queues one input-only call.
public override	addBatch `addBatch(sql as String)`	Queues SQL on this statement, not a discarded temporary.
public override	execute `execute() as Boolean`	Executes and captures outputs.
public override	execute `execute(sql as String) as Boolean`	Executes replacement callable SQL.
public override	executeQuery `executeQuery(sql as String) as ResultSet`	Executes replacement callable SQL.
public override	executeUpdate `executeUpdate(sql as String) as Int`	Executes replacement callable SQL.
public	getBoolean `getBoolean(index as Int) as Boolean`	Reads a boolean, returning false for SQL NULL.
public	getByte `getByte(index as Int) as SByte`	Reads SByte, returning zero for SQL NULL.
public	getDateTime `getDateTime(index as Int) as DateTime`	Reads a date/time, returning null for SQL NULL.
public	getDouble `getDouble(index as Int) as Double`	Reads Double, returning zero for SQL NULL.
public	getFloat `getFloat(index as Int) as Float`	Reads Float, returning zero for SQL NULL.
public	getInt `getInt(index as Int) as Int`	Reads Int, returning zero for SQL NULL.
public	getLong `getLong(index as Int) as Long`	Reads Long, returning zero for SQL NULL.
public	getObject `getObject(index as Int) as Object`	Reads a produced slot, updating wasNull.
public	getShort `getShort(index as Int) as Short`	Reads Short, returning zero for SQL NULL.
public	getString `getString(index as Int) as String`	Reads text, returning null for SQL NULL.
public	out `out(index as Int, sqlType as Int, scale as Int = 0) as CallableStatement`	Registers an output slot; bind the same slot to supply an INOUT value.
public override	query `query() as ResultSet`	Executes the call and captures outputs.
public	registerOutParameter `registerOutParameter(index as Int, sqlType as Int, scale as Int = 0) as CallableStatement`	Registers an OUT slot.
public override	update `update() as Long`	Executes the call and returns its update count.
public	wasNull `wasNull() as Boolean`	Describes the last successful getter.

Inherited Methods

methodInherited Methods from SqlServerPreparedStatement: addBatch, clearParameters, execute, execute, executeQuery, executeUpdate, query, set, setBoolean, setDouble, setInt, setLong, setNull, setString, update

methodInherited Methods from CallableStatement: getBoolean, getDouble, getInt, getLong, getObject, getString, out, registerOutParameter, wasNull

methodInherited Methods from Statement: addBatch, clearBatch, clearWarnings, execute, executeBatch, executeQuery, executeUpdate, getResultSet

methodInherited Methods from AutoClosable: close