OdbcResultSet
class in package klyn.databases.sql.odbc

    public class OdbcResultSet implements ResultSet:

OdbcResultSet
All Implemented Interfaces: ResultSet

ODBC result set backed by a native ODBC statement cursor.

    import klyn.databases.sql

    # rows = DriverManager.connect("odbc://app").statement().executeQuery("select id, name from users")
    # while rows.next():
    #     print(rows.getInt("id"), rows.getString("name"))

Properties

Modifier and Type | Member | Description
--- | --- | ---
public readonly property | afterLast `afterLast as Boolean:` | True after the last row.
public readonly property | beforeFirst `beforeFirst as Boolean:` | True before the first row.
public readonly property | closed `closed as Boolean:` | True after the cursor has been closed.
public readonly property | concurrency `concurrency as ResultSetConcurrency:` | Result-set concurrency mode.
public property | fetchDirection `fetchDirection as FetchDirection:` | Preferred fetch direction.
public property | fetchSize `fetchSize as Int:` | Preferred fetch size.
public readonly property | holdability `holdability as ResultSetHoldability:` | Result-set holdability mode.
public readonly property | lastReadWasNull `lastReadWasNull as Boolean:` | True when the last read returned SQL NULL.
public readonly property | metadata `metadata as ResultSetMetaData:` | Result-set metadata.
public readonly property | resultSetType `resultSetType as ResultSetType:` | Cursor scrollability mode.
public readonly property | rowNumber `rowNumber as Int:` | Current 1-based row number.
public readonly property | statement `statement as Statement:` | Parent statement.
public readonly property | warning `warning as SQLWarning:` | Warning chain.

Properties inherited from ResultSet: afterLast, beforeFirst, closed, concurrency, fetchDirection, fetchSize, holdability, lastReadWasNull, metadata, resultSetType, rowNumber, statement, warning
Methods

Modifier and Type | Member | Description
--- | --- | ---
public | absolute `absolute(rowNumber as Int) as Boolean throws SQLException:` | Moves to an absolute row number.
public | clearWarnings `clearWarnings() as Void:` | Clears the warning chain.
public override | close `close() as Void:` | Closes the cursor.
public | first `first() as Boolean throws SQLException:` | Moves to the first row.
public | getBoolean `getBoolean(column as Object) as Boolean throws SQLException:` | Reads one column as `Boolean`.
public | getDateTime `getDateTime(column as Object) as DateTime throws SQLException:` | Reads one column as `DateTime`.
public | getDouble `getDouble(column as Object) as Double throws SQLException:` | Reads one column as `Double`.
public | getInt `getInt(column as Object) as Int throws SQLException:` | Reads one column as `Int`.
public | getLong `getLong(column as Object) as Long throws SQLException:` | Reads one column as `Long`.
public | getObject `getObject(column as Object) as Object throws SQLException:` | Reads one column as an object.
public | getString `getString(column as Object) as String throws SQLException:` | Reads one column as text.
public | last `last() as Boolean throws SQLException:` | Moves to the last row.
public | moveAfterLast `moveAfterLast() as Void throws SQLException:` | Moves after the last row.
public | moveBeforeFirst `moveBeforeFirst() as Void throws SQLException:` | Moves before the first row.
public | next `next() as Boolean throws SQLException:` | Moves to the next row.
public | previous `previous() as Boolean throws SQLException:` | Moves to the previous row.
public | relative `relative(offset as Int) as Boolean throws SQLException:` | Moves relative to the current row.
public | wasNull `wasNull() as Boolean throws SQLException:` | Returns true when the last typed read returned SQL NULL.

Methods inherited from ResultSet: absolute, clearWarnings, first, getBoolean, getDateTime, getDouble, getInt, getLong, getObject, getString, last, moveAfterLast, moveBeforeFirst, next, previous, relative, wasNull
Methods inherited from AutoClosable: close