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 Map<Int, Int>:`	No summary.
public readonly property	outValues `outValues as Map<Int, Object>:`	No summary.

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

Properties inherited from CallableStatement: outParameters, outValues

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

Properties inherited 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	execute `execute() as Boolean throws SQLException:`	Configures or executes a SQL statement.
public override	execute `execute(sql as String) as Boolean throws SQLException:`	Configures or executes a SQL statement.
public override	executeQuery `executeQuery(sql as String) as ResultSet throws SQLException:`	Configures or executes a SQL statement.
public override	executeUpdate `executeUpdate(sql as String) as Int throws SQLException:`	Configures or executes a SQL statement.
public	getBoolean `getBoolean(parameterIndex as Int) as Boolean throws SQLException:`	Configures or executes a SQL statement.
public	getByte `getByte(parameterIndex as Int) as SByte throws SQLException:`	Configures or executes a SQL statement.
public	getDateTime `getDateTime(parameterIndex as Int) as DateTime throws SQLException:`	Configures or executes a SQL statement.
public	getDouble `getDouble(parameterIndex as Int) as Double throws SQLException:`	Configures or executes a SQL statement.
public	getFloat `getFloat(parameterIndex as Int) as Float throws SQLException:`	Configures or executes a SQL statement.
public	getInt `getInt(parameterIndex as Int) as Int throws SQLException:`	Configures or executes a SQL statement.
public	getLong `getLong(parameterIndex as Int) as Long throws SQLException:`	Configures or executes a SQL statement.
public	getObject `getObject(parameterIndex as Int) as Object throws SQLException:`	Configures or executes a SQL statement.
public	getShort `getShort(parameterIndex as Int) as Short throws SQLException:`	Configures or executes a SQL statement.
public	getString `getString(parameterIndex as Int) as String throws SQLException:`	Configures or executes a SQL statement.
public	out `out(index as Int, sqlType as Int, scale as Int = 0) as CallableStatement throws SQLException:`	Configures or executes a SQL statement.
public override	query `query() as ResultSet throws SQLException:`	Configures or executes a SQL statement.
public	registerOutParameter `registerOutParameter(parameterIndex as Int, sqlType as Int, scale as Int = 0) as CallableStatement throws SQLException:`	Configures or executes a SQL statement.
public override	update `update() as Long throws SQLException:`	Configures or executes a SQL statement.
public	wasNull `wasNull() as Boolean throws SQLException:`	Configures or executes a SQL statement.

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

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

Methods inherited from PreparedStatement: clearParameters, execute, query, set, setBoolean, setDouble, setInt, setLong, setNull, setString, update

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

Methods inherited from AutoClosable: close