ResultSet interface

Provides methods to traverse a table by row, and access the column data.

Syntax

public interface ResultSet

Members

All members of ResultSet interface, including all inherited members.

Name	Description
afterLast method [Android]	Moves the cursor after the last row.
beforeFirst method [Android]	Moves the cursor before the first row.
close method	Closes the ResultSet object to release the memory resources associated with it.
first method [Android]	Moves the cursor to the first row.
getBlobInputStream method	Returns an InputStream object for long binary types, including file-based long binaries.
getBoolean method	Returns a boolean value.
getBytes method	Returns a byte array.
getClobReader method	Returns a Reader object.
getDate method	Returns a java.util.Date object.
getDecimalNumber method	Returns a DecimalNumber object.
getDouble method	Returns a double value based on the column number.
getFloat method	Returns a float value.
getInt method	Returns an integer value.
getLong method	Returns a long integer value.
getOrdinal method	Returns the (base-one) ordinal for the value represented by a String.
getResultSetMetadata method	Returns a ResultSetMetadata object that contains the metadata for the ResultSet object.
getRowCount method [Android]	Gets the number of rows in the table.
getSize method	Gets the actual size of a result set column.
getString method	Returns a String value.
getUUIDValue method	Returns a UUIDValue object.
isNull method	Tests if the value at the specified column number is null.
last method [Android]	Moves the cursor to the last row.
next method	Fetches the next row of data in the ResultSet object.
previous method	Fetches the previous row of data in the ResultSet object.
relative method [Android]	Moves the cursor by an offset of rows from the current cursor position.

Remarks

A ResultSet object is generated when the execute or executeQuery method is called on a PreparedStatement object with a SQL SELECT statement.

The following example demonstrates how to fetch a row in the ResultSet object, and access data from a specified column:

// Define a new SQL SELECT statement.
String sql_string = "SELECT column1, column2 FROM SampleTable";

// Create a new PreparedStatement from an existing connection.
PreparedStatement ps = conn.prepareStatement(sql_string);

// Create a new ResultSet to contain the query results of the SQL statement.
ResultSet rs = ps.executeQuery();

// Check if the PreparedStatement contains a ResultSet.
if (ps.hasResultSet()) {
     // Retrieve the column1 value from the first row using getString.
     String row1_col1 = rs.getString(1);
     // Get the next row in the table.
     if (rs.next) {
          // Retrieve the value of column1 from the second row.
          String row2_col1 = rs.getString(1);
     }
}

rs.close();
ps.close();

ResultSet interface

Syntax

Members

Remarks

See also