SqlServerCallableStatement
class in package klyn.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.

Inherited Properties
property Inherited Properties from SqlServerPreparedStatement: parameterInfo, parameterMetadata, parameters, sql
property Inherited Properties from CallableStatement: outParameters, outValues
property Inherited Properties from PreparedStatement: parameterInfo, parameterMetadata, parameters, sql
property Inherited 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 | 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.

Inherited Methods
method Inherited Methods from SqlServerPreparedStatement: clearParameters, execute, execute, executeQuery, executeUpdate, query, set, setBoolean, setDouble, setInt, setLong, setNull, setString, update
method Inherited Methods from CallableStatement: getBoolean, getDouble, getInt, getLong, getObject, getString, out, registerOutParameter, wasNull
method Inherited Methods from PreparedStatement: clearParameters, execute, query, set, setBoolean, setDouble, setInt, setLong, setNull, setString, update
method Inherited Methods from Statement: addBatch, clearBatch, clearWarnings, execute, executeBatch, executeQuery, executeUpdate, getResultSet
method Inherited Methods from AutoClosable: close