8.5.1 List of the methods in the ResultSet interface

Organization of this subsection

(1) Main functions of the ResultSet interface
(2) Methods in the ResultSet interface that are supported by HADB
(3) Required package name and class name

(1) Main functions of the ResultSet interface

The ResultSet interface provides the following main functions:

Movement of the cursor within a result set in units of rows
Return of results data
Notification of whether the retrieval result is the null value

(2) Methods in the ResultSet interface that are supported by HADB

The following table lists and describes the methods in the ResultSet interface that are supported by HADB.

Table 8‒14: Methods in the ResultSet interface
No.	Method in the ResultSet interface	Function
1	`absolute(int` `row)`	Moves the cursor to a specified row in the `ResultSet` object.
2	`afterLast()`	Moves the cursor to the location immediately following the last row in the `ResultSet` object.
3	`beforeFirst()`	Moves the cursor to the location immediately preceding the first row in the `ResultSet` object.
4	`clearWarnings()`	Clears all warnings concerning this `ResultSet` object that have been reported.
5	`close()`	Closes the cursor that has been opened for the `ResultSet` object and releases JDBC resources.
6	`findColumn(String` `columnName)`	Returns the column number corresponding to a specified column name.
7	`first()`	Moves the cursor to the first row in the `ResultSet` object.
8	`getAsciiStream(int` `columnIndex)`	Acquires in a `java.io.InputStream` object the value in a specified column in the current row of the `ResultSet` object.
9	`getAsciiStream(String` `columnName)`
10	`getBigDecimal(int` `columnIndex)`	Acquires in a `java.math.BigDecimal` object the value in a specified column in the current row of the `ResultSet` object.
11	`getBigDecimal(String` `columnName)`
12	`getBinaryStream(int` `columnIndex)`	Acquires in a `java.io.InputStream` object the value in a specified column in the current row of the `ResultSet` object.
13	`getBinaryStream(String` `columnName)`
14	`getBoolean(int` `columnIndex)`	Acquires as `boolean` in the Java programming language the value in a specified column in the current row of the `ResultSet` object.
15	`getBoolean(String` `columnName)`
16	`getByte(int` `columnIndex)`	Acquires as `byte` in the Java programming language the value in a specified column in the current row of the `ResultSet` object.
17	`getByte(String` `columnName)`
18	`getBytes(int` `columnIndex)`	Acquires as a `byte` array in the Java programming language the value in a specified column in the current row of the `ResultSet` object.
19	`getBytes(String` `columnName)`
20	`getCharacterStream(int` `columnIndex)`	Acquires in a `java.io.Reader` object the value in a specified column in the current row of the `ResultSet` object.
21	`getCharacterStream(String` `columnName)`
22	`getConcurrency()`	Acquires this `ResultSet` object's concurrent processing mode.
23	`getCursorName()`	Acquires the name of the SQL cursor used by this `ResultSet` object.
24	`getDate(int` `columnIndex)`	Acquires in a `java.sql.Date` object the value in a specified column in the current row of the `ResultSet` object.
25	`getDate(int` `columnIndex,` `Calendar` `cal)`
26	`getDate(String` `columnName)`
27	`getDate(String` `columnName,` `Calendar` `cal)`
28	`getDouble(int` `columnIndex)`	Acquires as `double` in the Java programming language the value in a specified column in the current row of the `ResultSet` object.
29	`getDouble(String` `columnName)`
30	`getFetchDirection()`	Acquires this `ResultSet` object's fetch direction.
31	`getFetchSize()`	Acquires this `ResultSet` object's fetch size.
32	`getFloat(int` `columnIndex`)	Acquires as `float` in the Java programming language the value in a specified column in the current row of the `ResultSet` object.
33	`getFloat(String` `columnName)`
34	`getHoldability()`	Acquires a value indicating the status of the holding functionality for this `ResultSet` object.
35	`getInt(int` `columnIndex)`	Acquires as `int` in the Java programming language the value in a specified column in the current row of the `ResultSet` object.
36	`getInt(String` `columnName)`
37	`getLong(int` `columnIndex)`	Acquires as `long` in the Java programming language the value in a specified column in the current row of the `ResultSet` object.
38	`getLong(String` `columnName)`
39	`getMetaData()`	Acquires this `ResultSet` object's meta information.
40	`getObject(int` `columnIndex)`	Acquires as `Object` in the Java programming language the value in a specified column in the current row of the `ResultSet` object.
41	`getObject(String` `columnName)`
42	`getObject(int` `columnIndex,Class<T>` `type)`	Acquires the value for a specified column in the current row of the `ResultSet` object, and converts it to a Java data type.
43	`getObject(String` `columnLabel,Class<T>` `type)`
44	`getRow()`	Acquires the current row number.
45	`getShort(int` `columnIndex)`	Acquires as `short` in the Java programming language the value in a specified column in the current row of the `ResultSet` object.
46	`getShort(String` `columnName)`
47	`getStatement()`	Acquires the `Statement` object that created this `ResultSet` object.
48	`getString(int` `columnIndex)`	Acquires as `String` in the Java programming language the value in a specified column in the current row of the `ResultSet` object.
49	`getString(String` `columnName)`
50	`getTime(int` `columnIndex)`	Acquires in a `java.sql.Time` object the value in a specified column in the current row of the `ResultSet` object.
51	`getTime(int` `columnIndex,` `Calendar` `cal)`
52	`getTime(String` `columnName)`
53	`getTime(String` `columnName,` `Calendar` `cal)`
54	`getTimestamp(int` `columnIndex)`	Acquires in a `java.sql.Timestamp` object the value in a specified column in the current row of the `ResultSet` object.
55	`getTimestamp(int` `columnIndex,` `Calendar` `cal)`
56	`getTimestamp(String` `columnName)`
57	`getTimestamp(String` `columnName,` `Calendar` `cal)`
58	`getType()`	Returns the `ResultSet` object's type.
59	`getWarnings()`	Acquires the first warning reported by a call related to this `ResultSet` object.
60	`isAfterLast()`	Acquires a value indicating whether the cursor is located after the last row in the `ResultSet` object.
61	`isBeforeFirst()`	Acquires a value indicating whether the cursor is located before the first row in the `ResultSet` object.
62	`isClosed()`	Acquires a value indicating whether this `ResultSet` object is closed.
63	`isFirst()`	Acquires a value indicating whether the cursor is located on the first row in the `ResultSet` object.
64	`isLast()`	Acquires a value indicating whether the cursor is located on the last row in the `ResultSet` object.
65	`last()`	Moves the cursor to the last row of the `ResultSet` object.
66	`next()`	Moves the cursor to the next row.
67	`previous()`	Moves the cursor to the immediately preceding row.
68	`relative(int` `rows)`	Moves the cursor.
69	`setFetchDirection(int` `direction)`	Specifies the fetch direction for the `ResultSet` object.
70	`setFetchSize(int` `rows)`	Specifies the fetch size (number of rows to be fetched) when the `ResultSet` object is retrieved.
71	`wasNull()`	Returns a value indicating whether the last column value acquired is the null value.

Important: HADB does not support methods that are not listed in this table. If an unsupported method is executed, an SQLException might be thrown.

To Page Top

(3) Required package name and class name

The package and class names required in order to use the ResultSet interface are as follows:

Package name: com.hitachi.hadb.jdbc
Class name: AdbResultSet

To Page Top