OdbcResultSet

classin packageklyn.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