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
close method	Closes the ResultSet to release the memory resources associated with it.
getBlobInputStream method	Returns an InputStream for long binary types, including file-based long binarys.
getBoolean method	Returns a boolean value.
getBytes method	Returns a byte array.
getClobReader method	Returns a Reader.
getDate method	Returns a java.util.Date.
getDecimalNumber method	Returns a DecimalNumber.
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 the ResultSetMetadata containing the meta data for the ResultSet.
getSize method	Get the actual size of a result set column.
getString method	Returns a String value.
getUUIDValue method	Returns a UUIDValue value.
isNull method	Tests if the value at the specified column number is null.
next method	Fetches the next row of data in the ResultSet.
previous method	Fetches the previous row of data in the ResultSet.

Remarks

A ResultSet is generated by executing a PreparedStatement with a SQL SELECT statement using the execute or executeQuery methods.

The following example demonstrates how to execute a new PreparedStatement, fetch a row with the ResultSet, 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