File Doc Category Size Date Package
ResultSet.java API Doc Android 1.5 API 75745 Wed May 06 22:41:06 BST 2009 java.sql

ResultSet

public interface ResultSet

An interface for an object which represents a database table entry, returned as the result of the query to the database.

{@code ResultSet}s have a cursor which points to the current data table row. When the {@code ResultSet} is created, the cursor's location is one position ahead of the first row. To move the cursor to the first and consecutive rows, use the {@code next} method. The {@code next} method returns {@code true} as long as there are more rows in the {@code ResultSet}, otherwise it returns {@code false}.

The default type of {@code ResultSet} can not be updated and its cursor can only advance forward through the rows of data. This means that it is only possible to read through it once. However, other kinds of {@code ResultSet} are implemented: an updatable type and also types where the cursor can be scrolled forward and backward through the rows of data. How such a {@code ResultSet} is created is demonstrated in the following example:

{@code Connection con;}

{@code Statement aStatement = con.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE,}{@code ResultSet.CONCUR_UPDATABLE );}

{@code ResultSet theResultSet = theStatement.executeQuery("SELECT price, quantity FROM STOCKTABLE");}

{@code // theResultSet is both scrollable and updatable}

The {@code ResultSet} interface provides a series of methods for retrieving data from columns in the current row, such as {@code getDate} and {@code getFloat}. The columns are retrieved either by their index number (starting at 1) or by their name - there are separate methods for both techniques of column addressing. The column names are case insensitive. If several columns have the same name, then the getter methods use the first matching column. This means that if column names are used, it is not possible to guarantee that the name will retrieve data from the intended column - for certainty it is better to use column indexes. Ideally the columns should be read left-to-right and read once only, since not all databases are optimized to handle other techniques of reading the data.

When reading data via the appropriate getter methods, the JDBC driver maps the SQL data retrieved from the database to the Java type implied by the method invoked by the application. The JDBC specification has a table for the mappings from SQL types to Java types.

There are also methods for writing data into the {@code ResultSet}, such as {@code updateInt} and {@code updateString}. The update methods can be used either to modify the data of an existing row or to insert new data rows into the {@code ResultSet} . Modification of existing data involves moving the cursor to the row which needs modification and then using the update methods to modify the data, followed by calling the {@code ResultSet.updateRow} method. For insertion of new rows, the cursor is first moved to a special row called the Insert Row, data is added using the update methods, followed by calling the {@code ResultSet.insertRow} method.

A {@code ResultSet} is closed if the statement which generated it closes, the statement is executed again, or the same statement's next {@code ResultSet} is retrieved (if the statement returned of multiple results).

since: Android 1.0

Fields Summary
public static final int
CLOSE_CURSORS_AT_COMMIT
A constant used to indicate that a {@code ResultSet} object must be closed when the method {@code Connection.commit} is invoked.
public static final int
HOLD_CURSORS_OVER_COMMIT
A constant used to indicate that a {@code ResultSet} object must not be closed when the method {@code Connection.commit} is invoked.
public static final int
CONCUR_READ_ONLY
A constant used to indicate the concurrency mode for a {@code ResultSet} object that cannot be updated.
public static final int
CONCUR_UPDATABLE
A constant used to indicate the concurrency mode for a {@code ResultSet} object that can be updated.
public static final int
FETCH_FORWARD
A constant used to indicate processing of the rows of a {@code ResultSet} in the forward direction, first to last.
public static final int
FETCH_REVERSE
A constant used to indicate processing of the rows of a {@code ResultSet} in the reverse direction, last to first.
public static final int
FETCH_UNKNOWN
A constant used to indicate that the order of processing of the rows of a {@code ResultSet} is unknown.
public static final int
TYPE_FORWARD_ONLY
A constant used to indicate a {@code ResultSet} object whose cursor can only move forward.
public static final int
TYPE_SCROLL_INSENSITIVE
A constant used to indicate a {@code ResultSet} object which is scrollable but is insensitive to changes made by others.
public static final int
TYPE_SCROLL_SENSITIVE
A constant used to indicate a {@code ResultSet} object which is scrollable and sensitive to changes made by others.
Constructors Summary
Methods Summary
public boolean absolute(int row)
Moves the cursor to a specified row number in the {@code ResultSet}.
param
row the index of the row starting at index 1. Index {@code -1} returns the last row.
return
{@code true} if the new cursor position is on the {@code ResultSet}, {@code false} otherwise.
throws
SQLException if a database error happens.
since
Android 1.0
public void afterLast()
Moves the cursor to the end of the {@code ResultSet}, after the last row.
throws
SQLException if a database error happens.
since
Android 1.0
public void beforeFirst()
Moves the cursor to the start of the {@code ResultSet}, before the first row.
throws
SQLException if a database error happens.
since
Android 1.0
public void cancelRowUpdates()
Cancels any updates made to the current row in the {@code ResultSet}.
throws
SQLException if a database error happens.
since
Android 1.0
public void clearWarnings()
Clears all warnings related to this {@code ResultSet}.
throws
SQLException if a database error happens.
since
Android 1.0
public void close()
Releases this {@code ResultSet}'s database and JDBC resources. You are strongly advised to use this method rather than relying on the release being done when the {@code ResultSet}'s finalize method is called during garbage collection process. Note that the {@code close()} method might take some time to complete since it is dependent on the behavior of the connection to the database and the database itself.
throws
SQLException if a database error happens.
since
Android 1.0
public void deleteRow()
Deletes the current row from the {@code ResultSet} and from the underlying database.
throws
SQLException if a database error happens.
since
Android 1.0
public int findColumn(java.lang.String columnName)
Gets the index number for a column in the {@code ResultSet} from the provided column name.
param
columnName the column name.
return
the column's index in the {@code ResultSet} identified by column name.
throws
SQLException if a database error happens.
since
Android 1.0
public boolean first()
Shifts the cursor position to the first row in the {@code ResultSet}.
return
{@code true} if the position is in a legitimate row, {@code false} if the {@code ResultSet} contains no rows.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Array getArray(int columnIndex)
Gets the content of a column specified by column index in the current row of this {@code ResultSet} as a {@code java.sql.Array}.
param
columnIndex the index of the column to read
return
a {@code java.sql.Array} with the data from the column.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Array getArray(java.lang.String colName)
Gets the value of a column specified by column name as a {@code java.sql.Array}.
param
colName the name of the column to read.
return
a {@code java.sql.Array} with the data from the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public java.io.InputStream getAsciiStream(int columnIndex)
Gets the value of a column specified by column index as an ASCII character stream.
param
columnIndex the index of the column to read.
return
an {@code InputStream} with the data from the column.
throws
SQLException if a database error happens.
since
Android 1.0
public java.io.InputStream getAsciiStream(java.lang.String columnName)
Gets the value of a column specified by column name as an ASCII character stream.
param
columnName the name of the column to read
return
an {@code InputStream} with the data from the column.
throws
SQLException if a database error happens.
since
Android 1.0
public java.math.BigDecimal getBigDecimal(int columnIndex)
Gets the value of a column specified by column index as a {@code java.math.BigDecimal}.
param
columnIndex the index of the column to read.
return
a {@code BigDecimal} with the value of the column.
throws
SQLException if a database error happens.
since
Android 1.0
public java.math.BigDecimal getBigDecimal(int columnIndex, int scale)
Gets the value of a column specified by column index as a {@code java.math.BigDecimal}.
deprecated
use {@link #getBigDecimal(int)} or {@link #getBigDecimal(String)}
param
columnIndex the index of the column to read.
param
scale the number of digits after the decimal point
return
a {@code BigDecimal} with the value of the column.
throws
SQLException if a database error happens.
since
Android 1.0
public java.math.BigDecimal getBigDecimal(java.lang.String columnName)
Gets the value of a column specified by column name, as a {@code java.math.BigDecimal}.
param
columnName the name of the column to read.
return
a BigDecimal with value of the column.
throws
SQLException if a database error happens.
since
Android 1.0
public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale)
Gets the value of a column specified by column name, as a {@code java.math.BigDecimal}.
deprecated
use {@link #getBigDecimal(int)} or {@link #getBigDecimal(String)}
param
columnName the name of the column to read.
param
scale the number of digits after the decimal point
return
a BigDecimal with value of the column.
throws
SQLException if a database error happens.
since
Android 1.0
public java.io.InputStream getBinaryStream(int columnIndex)
Gets the value of a column specified by column index as a binary stream.
This method can be used to read {@code LONGVARBINARY} values. All of the data in the {@code InputStream} should be read before getting data from any other column. A further call to a getter method will implicitly close the {@code InputStream}.
param
columnIndex the index of the column to read.
return
an {@code InputStream} with the data from the column. If the column value is SQL {@code NULL}, {@code null} is returned.
throws
SQLException if a database error happens.
since
Android 1.0
public java.io.InputStream getBinaryStream(java.lang.String columnName)
Gets the value of a column specified by column name as a binary stream.
This method can be used to read {@code LONGVARBINARY} values. All of the data in the {@code InputStream} should be read before getting data from any other column. A further call to a getter method will implicitly close the {@code InputStream}.
param
columnName the name of the column to read.
return
an {@code InputStream} with the data from the column if the column value is SQL {@code NULL}, {@code null} is returned.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Blob getBlob(int columnIndex)
Gets the value of a column specified by column index as a {@code java.sql.Blob} object.
param
columnIndex the index of the column to read.
return
a {@code java.sql.Blob} with the value of the column.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Blob getBlob(java.lang.String columnName)
Gets the value of a column specified by column name, as a {@code java.sql.Blob} object.
param
columnName the name of the column to read.
return
a {@code java.sql.Blob} with the value of the column.
throws
SQLException if a database error happens.
since
Android 1.0
public boolean getBoolean(int columnIndex)
Gets the value of a column specified by column index as a {@code boolean} .
param
columnIndex the index of the column to read.
return
a {@code boolean} value from the column. If the column is SQL {@code NULL}, {@code false} is returned.
throws
SQLException if a database error happens.
since
Android 1.0
public boolean getBoolean(java.lang.String columnName)
Gets the value of a column specified by column name, as a {@code boolean} .
param
columnName the name of the column to read.
return
a {@code boolean} value from the column. If the column is SQL {@code NULL}, {@code false} is returned.
throws
SQLException if a database error happens.
since
Android 1.0
public byte getByte(int columnIndex)
Gets the value of a column specified by column index as a {@code byte}.
param
columnIndex the index of the column to read.
return
a {@code byte} equal to the value of the column. 0 if the value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public byte getByte(java.lang.String columnName)
Gets the value of a column specified by column name as a {@code byte}.
param
columnName the name of the column to read.
return
a {@code byte} equal to the value of the column. 0 if the value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public byte[] getBytes(int columnIndex)
Gets the value of a column specified by column index as a byte array.
param
columnIndex the index of the column to read.
return
a byte array containing the value of the column. {@code null} if the column contains SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public byte[] getBytes(java.lang.String columnName)
Gets the value of a column specified by column name as a byte array.
param
columnName the name of the column to read.
return
a byte array containing the value of the column. {@code null} if the column contains SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.io.Reader getCharacterStream(int columnIndex)
Gets the value of a column specified by column index as a {@code java.io.Reader} object.
param
columnIndex the index of the column to read.
return
a {@code Reader} holding the value of the column. {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
see
java.io.Reader
since
Android 1.0
public java.io.Reader getCharacterStream(java.lang.String columnName)
Gets the value of a column specified by column name as a {@code java.io.Reader} object.
param
columnName the name of the column to read.
return
a {@code Reader} holding the value of the column. {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Clob getClob(int columnIndex)
Gets the value of a column specified by column index as a {@code java.sql.Clob}.
param
columnIndex the index of the column to read.
return
a {@code Clob} object representing the value in the column. {@code null} if the value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Clob getClob(java.lang.String colName)
Gets the value of a column specified by column name as a {@code java.sql.Clob}.
param
colName the name of the column to read.
return
a {@code Clob} object representing the value in the column. {@code null} if the value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public int getConcurrency()
Gets the concurrency mode of this {@code ResultSet}.
return
the concurrency mode - one of: {@code ResultSet.CONCUR_READ_ONLY} , {@code ResultSet.CONCUR_UPDATABLE}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.lang.String getCursorName()
Gets the name of the SQL cursor of this {@code ResultSet}.
return
the SQL cursor name.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Date getDate(int columnIndex)
Gets the value of a column specified by column index as a {@code java.sql.Date}.
param
columnIndex the index of the column to read.
return
a {@code java.sql.Date} matching the column value. {@code null} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Date getDate(int columnIndex, java.util.Calendar cal)
Gets the value of a column specified by column index as a {@code java.sql.Date}. This method uses a supplied calendar to compute the Date.
param
columnIndex the index of the column to read.
param
cal a {@code java.util.Calendar} to use in constructing the Date.
return
a {@code java.sql.Date} matching the column value. {@code null} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Date getDate(java.lang.String columnName)
Gets the value of a column specified by column name as a {@code java.sql.Date}.
param
columnName the name of the column to read.
return
a {@code java.sql.Date} matching the column value. {@code null} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Date getDate(java.lang.String columnName, java.util.Calendar cal)
Gets the value of a column specified by column name, as a {@code java.sql.Date} object.
param
columnName the name of the column to read.
param
cal {@code java.util.Calendar} to use in constructing the Date.
return
a {@code java.sql.Date} matching the column value. {@code null} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public double getDouble(int columnIndex)
Gets the value of a column specified by column index as a {@code double} value.
param
columnIndex the index of the column to read.
return
a {@code double} equal to the column value. {@code 0.0} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public double getDouble(java.lang.String columnName)
Gets the value of a column specified by column name as a {@code double} value.
param
columnName the name of the column to read.
return
a {@code double} equal to the column value. {@code 0.0} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public int getFetchDirection()
Gets the direction in which rows are fetched for this {@code ResultSet} object.
return
the fetch direction. Will be one of:

ResultSet.FETCH_FORWARD
ResultSet.FETCH_REVERSE

ResultSet.FETCH_UNKNOWN

throws
SQLException if a database error happens.
since
Android 1.0
public int getFetchSize()
Gets the fetch size (in number of rows) for this {@code ResultSet}.
return
the fetch size as an int
throws
SQLException if a database error happens.
since
Android 1.0
public float getFloat(int columnIndex)
Gets the value of a column specified by column index as a {@code float} value.
param
columnIndex the index of the column to read.
return
a {@code float} equal to the column value. {@code 0.0} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public float getFloat(java.lang.String columnName)
Gets the value of a column specified by column name as a {@code float} value.
param
columnName the name of the column to read.
return
a {@code float} equal to the column value. {@code 0.0} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public int getInt(int columnIndex)
Gets the value of a column specified by column index as an {@code int} value.
param
columnIndex the index of the column to read.
return
an {@code int} equal to the column value. {@code 0} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public int getInt(java.lang.String columnName)
Gets the value of a column specified by column name, as an {@code int} value.
param
columnName the name of the column to read.
return
an {@code int} equal to the column value. {@code 0} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public long getLong(int columnIndex)
Gets the value of a column specified by column index as a {@code long} value.
param
columnIndex the index of the column to read.
return
a {@code long} equal to the column value. {@code 0} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public long getLong(java.lang.String columnName)
Gets the value of a column specified by column name, as a {@code long} value.
param
columnName the name of the column to read.
return
a {@code long} equal to the column value. {@code 0} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.ResultSetMetaData getMetaData()
Gets the metadata for this {@code ResultSet}. This defines the number, types and properties of the columns in the {@code ResultSet}.
return
a {@code ResultSetMetaData} object with information about this {@code ResultSet}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.lang.Object getObject(int columnIndex)
Gets the value of a specified column as a Java {@code Object}. The type of the returned object will be the default according to the column's SQL type, following the JDBC specification for built-in types.
For SQL User Defined Types, if a column value is Structured or Distinct, this method behaves the same as a call to: {@code getObject(columnIndex,this.getStatement().getConnection().getTypeMap())}
param
columnIndex the index of the column to read.
return
an {@code Object} containing the value of the column. {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.lang.Object getObject(int columnIndex, java.util.Map map)
Gets the value of a column specified by column index as a Java {@code Object}.
The type of the Java object will be determined by the supplied Map to perform the mapping of SQL {@code Struct} or Distinct types into Java objects.
param
columnIndex the index of the column to read.
param
map a {@code java.util.Map} containing a mapping from SQL Type names to Java classes.
return
an {@code Object} containing the value of the column. {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.lang.Object getObject(java.lang.String columnName)
Gets the value of a specified column as a Java {@code Object}. The type of the returned object will be the default according to the column's SQL type, following the JDBC specification for built-in types.
For SQL User Defined Types, if a column value is structured or distinct, this method behaves the same as a call to: {@code getObject(columnIndex,this.getStatement().getConnection().getTypeMap())}
param
columnName the name of the column to read.
return
an {@code Object} containing the value of the column. {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.lang.Object getObject(java.lang.String columnName, java.util.Map map)
Gets the value of a column specified by column name as a Java {@code Object}.
The type of the Java object will be determined by the supplied Map to perform the mapping of SQL Struct or Distinct types into Java objects.
param
columnName the name of the column to read.
param
map a {@code java.util.Map} containing a mapping from SQL Type names to Java classes.
return
an {@code Object} containing the value of the column. {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Ref getRef(int columnIndex)
Gets the value of a column specified by column index as a Java {@code java.sql.Ref}.
param
columnIndex the index of the column to read.
return
a Ref representing the value of the SQL REF in the column
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Ref getRef(java.lang.String colName)
Gets the value of a column specified by column name as a Java {@code java.sql.Ref}.
param
colName the name of the column to read.
return
a Ref representing the value of the SQL {@code REF} in the column
throws
SQLException if a database error happens.
since
Android 1.0
public int getRow()
Gets the number of the current row in the {@code ResultSet}. Row numbers start at 1 for the first row.
return
the index number of the current row. {@code 0} is returned if there is no current row.
throws
SQLException if a database error happens.
since
Android 1.0
public short getShort(int columnIndex)
Gets the value of a column specified by column index as a short value.
param
columnIndex the index of the column to read.
return
a short value equal to the value of the column. {@code 0} if the value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public short getShort(java.lang.String columnName)
Gets the value of a column specified by column name, as a short value.
param
columnName the name of the column to read.
return
a short value equal to the value of the column. {@code 0} if the value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Statement getStatement()
Gets the statement that produced this {@code ResultSet}. If the {@code ResultSet} was not created by a statement (i.e. because it was returned from one of the {@link DatabaseMetaData} methods), {@code null} is returned.
return
the Statement which produced this {@code ResultSet}, or {@code null} if the {@code ResultSet} was not created by a Statement.
throws
SQLException if a database error happens.
since
Android 1.0
public java.lang.String getString(int columnIndex)
Gets the value of a column specified by column index as a String.
param
columnIndex the index of the column to read.
return
the String representing the value of the column, {@code null} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.lang.String getString(java.lang.String columnName)
Gets the value of a column specified by column name, as a String.
param
columnName the name of the column to read.
return
the String representing the value of the column, {@code null} if the column is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Time getTime(int columnIndex)
Gets the value of a column specified by column index as a {@code java.sql.Time} value.
param
columnIndex the index of the column to read.
return
a Time representing the column value, {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Time getTime(int columnIndex, java.util.Calendar cal)
Gets the value of a column specified by column index as a {@code java.sql.Time} value. The supplied {@code Calendar} is used to map the SQL {@code Time} value to a Java Time value.
param
columnIndex the index of the column to read.
param
cal a {@code Calendar} to use in creating the Java Time value.
return
a Time representing the column value, {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Time getTime(java.lang.String columnName)
Gets the value of a column specified by column name, as a {@code java.sql.Time} value.
param
columnName the name of the column to read.
return
the column value, {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Time getTime(java.lang.String columnName, java.util.Calendar cal)
Gets the value of a column specified by column index, as a {@code java.sql.Time} value. The supplied {@code Calendar} is used to map the SQL {@code Time} value to a Java Time value.
param
columnName the name of the column to read.
param
cal a {@code Calendar} to use in creating the Java time value.
return
a Time representing the column value, {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Timestamp getTimestamp(int columnIndex)
Gets the value of a column specified by column index as a {@code java.sql.Timestamp} value.
param
columnIndex the index of the column to read.
return
a timestamp representing the column value, {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal)
Gets the value of a column specified by column index, as a {@code java.sql.Timestamp} value. The supplied Calendar is used when mapping the SQL {@code Timestamp} value to a Java {@code Timestamp} value.
param
columnIndex the index of the column to read.
param
cal Calendar to use in creating the Java timestamp value.
return
a timestamp representing the column value, {@code null} if the column value is SQL NULL.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Timestamp getTimestamp(java.lang.String columnName)
Gets the value of a column specified by column name, as a {@code java.sql.Timestamp} value.
param
columnName the name of the column to read.
return
a timestamp representing the column value, {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar cal)
Gets the value of a column specified by column name, as a {@code java.sql.Timestamp} value. The supplied Calendar is used when mapping the SQL {@code Timestamp} value to a Java {@code Timestamp} value.
param
columnName the name of the column to read.
param
cal Calendar to use in creating the Java {@code Timestamp} value.
return
a timestamp representing the column value, {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public int getType()
Gets the type of the {@code ResultSet}.
return
The {@code ResultSet} type, one of:

{@code ResultSet.TYPE_FORWARD_ONLY}

{@code ResultSet.TYPE_SCROLL_INSENSITIVE}

{@code ResultSet.TYPE_SCROLL_SENSITIVE}

throws
SQLException if there is a database error.
since
Android 1.0
public java.net.URL getURL(int columnIndex)
Gets the value of a column specified by column index as a {@code java.net.URL}.
param
columnIndex the index of the column to read.
return
a URL. {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.net.URL getURL(java.lang.String columnName)
Gets the value of a column specified by column name as a {@code java.net.URL} object.
param
columnName the name of the column to read.
return
the column vaule as a URL. {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.io.InputStream getUnicodeStream(int columnIndex)
Gets the value of the column as an {@code InputStream} of unicode characters.
deprecated
Use {@link #getCharacterStream}.
param
columnIndex the index of the column to read.
return
an {@code InputStream} holding the value of the column. {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.io.InputStream getUnicodeStream(java.lang.String columnName)
Gets the value of the column as an {@code InputStream} of Unicode characters.
deprecated
Use {@link #getCharacterStream}
param
columnName the name of the column to read.
return
an {@code InputStream} holding the value of the column. {@code null} if the column value is SQL {@code NULL}.
throws
SQLException if a database error happens.
since
Android 1.0
public java.sql.SQLWarning getWarnings()
Gets the first warning generated by calls on this {@code ResultSet}. Subsequent warnings on this {@code ResultSet} are chained to the first one.
The warnings are cleared when a new Row is read from the {@code ResultSet}. The warnings returned by this method are only the warnings generated by {@code ResultSet} method calls - warnings generated by Statement methods are held by the Statement.

An {@code SQLException} is generated if this method is called on a closed {@code ResultSet}.
return
an SQLWarning which is the first warning for this {@code ResultSet}. {@code null} if there are no warnings.
throws
SQLException if a database error happens.
since
Android 1.0
public void insertRow()
Insert the insert row into the {@code ResultSet} and into the underlying database. The cursor must be set to the Insert Row before this method is invoked.
throws
SQLException if a database error happens. Particular cases include the cursor not being on the Insert Row or if any columns in the row do not have a value where the column is declared as not-nullable.
since
Android 1.0
public boolean isAfterLast()
Gets if the cursor is after the last row of the {@code ResultSet}.
return
{@code true} if the cursor is after the last row in the {@code ResultSet}, {@code false} if the cursor is at any other position in the {@code ResultSet}.
throws
SQLException if a database error happens.
since
Android 1.0
public boolean isBeforeFirst()
Gets if the cursor is before the first row of the {@code ResultSet}.
return
{@code true} if the cursor is before the first row in the {@code ResultSet}, {@code false} if the cursor is at any other position in the {@code ResultSet}.
throws
SQLException if a database error happens.
since
Android 1.0
public boolean isFirst()
Gets if the cursor is on the first row of the {@code ResultSet}.
return
{@code true} if the cursor is on the first row in the {@code ResultSet}, {@code false} if the cursor is at any other position in the {@code ResultSet}.
throws
SQLException if a database error happens.
since
Android 1.0
public boolean isLast()
Gets if the cursor is on the last row of the {@code ResultSet}
return
{@code true} if the cursor is on the last row in the {@code ResultSet}, {@code false} if the cursor is at any other position in the {@code ResultSet}.
throws
SQLException if a database error happens.
since
Android 1.0
public boolean last()
Shifts the cursor position to the last row of the {@code ResultSet}.
return
{@code true} if the new position is in a legitimate row, {@code false} if the {@code ResultSet} contains no rows.
throws
SQLException if there is a database error.
since
Android 1.0
public void moveToCurrentRow()
Moves the cursor to the remembered position, namely the row that was the current row before a call to {@code moveToInsertRow}. This only applies if the cursor is on the Insert Row.
throws
SQLException if a database error happens.
since
Android 1.0
public void moveToInsertRow()
Moves the cursor position to the Insert Row. The current position is remembered and the cursor is positioned at the Insert Row. The columns in the Insert Row should be filled in with the appropriate update methods, before calling {@code insertRow} to insert the new row into the database.
throws
SQLException if a database error happens.
since
Android 1.0
public boolean next()
Shifts the cursor position down one row in this {@code ResultSet} object.
Any input streams associated with the current row are closed and any warnings are cleared.
return
{@code true} if the updated cursor position is pointing to a valid row, {@code false} otherwise (i.e. when the cursor is after the last row in the {@code ResultSet}).
throws
SQLException if a database error happens.
since
Android 1.0
public boolean previous()
Relocates the cursor position to the preceding row in this {@code ResultSet}.
return
{@code true} if the new position is in a legitimate row, {@code false} if the cursor is now before the first row.
throws
SQLException if a database error happens.
since
Android 1.0
public void refreshRow()
Refreshes the current row with its most up to date value in the database. Must not be called when the cursor is on the Insert Row.
If any columns in the current row have been updated but the {@code updateRow} has not been called, then the updates are lost when this method is called.
throws
SQLException if a database error happens., including if the current row is the Insert row.
since
Android 1.0
public boolean relative(int rows)
Moves the cursor position up or down by a specified number of rows. If the new position is beyond the start row (or end row), the cursor position is set before the first row (or, respectively, after the last row).
param
rows a number of rows to move the cursor - may be positive or negative
return
{@code true} if the new cursor position is on a row, {@code false} otherwise
throws
SQLException if a database error happens.
since
Android 1.0
public boolean rowDeleted()
Indicates whether a row has been deleted. This method depends on whether the JDBC driver and database can detect deletions.
return
{@code true} if a row has been deleted and if deletions are detected, {@code false} otherwise.
throws
SQLException if a database error happens.
since
Android 1.0
public boolean rowInserted()
Indicates whether the current row has had an insertion operation. This method depends on whether the JDBC driver and database can detect insertions.
return
{@code true} if a row has been inserted and if insertions are detected, {@code false} otherwise.
throws
SQLException if a database error happens.
since
Android 1.0
public boolean rowUpdated()
Indicates whether the current row has been updated. This method depends on whether the JDBC driver and database can detect updates.
return
{@code true} if the current row has been updated and if updates can be detected, {@code false} otherwise.
throws
SQLException if a database error happens.
since
Android 1.0
public void setFetchDirection(int direction)
Indicates which direction (forward/reverse) will be used to process the rows of this {@code ResultSet} object. This is treated as a hint by the JDBC driver.
param
direction can be {@code ResultSet.FETCH_FORWARD}, {@code ResultSet.FETCH_REVERSE}, or {@code ResultSet.FETCH_UNKNOWN}
throws
SQLException if there is a database error.
since
Android 1.0
public void setFetchSize(int rows)
Indicates the number of rows to fetch from the database when extra rows are required for this {@code ResultSet}. This used as a hint to the JDBC driver.
param
rows the number of rows to fetch. {@code 0} implies that the JDBC driver can make its own decision about the fetch size. The number should not be greater than the maximum number of rows established by the statement that generated the {@code ResultSet}.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateArray(int columnIndex, java.sql.Array x)
Updates a column specified by a column index with a {@code java.sql.Array} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateArray(java.lang.String columnName, java.sql.Array x)
Updates a column specified by a column name with a {@code java.sql.Array} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length)
Updates a column specified by a column index with an ASCII stream value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
param
length the length of the data to write from the stream
throws
SQLException if a database error happens.
since
Android 1.0
public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length)
Updates a column specified by a column name with an Ascii stream value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
param
length the length of the data to write from the stream
throws
SQLException if a database error happens.
since
Android 1.0
public void updateBigDecimal(int columnIndex, java.math.BigDecimal x)
Updates a column specified by a column index with a {@code java.sql.BigDecimal} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x)
Updates a column specified by a column name with a {@code java.sql.BigDecimal} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
Updates a column specified by a column index with a binary stream value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
param
length the number of bytes to be read from the the stream.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length)
Updates a column specified by a column name with a binary stream value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
param
length he number of bytes to be read from the the stream.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateBlob(int columnIndex, java.sql.Blob x)
Updates a column specified by a column index with a {@code java.sql.Blob} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateBlob(java.lang.String columnName, java.sql.Blob x)
Updates a column specified by a column name with a {@code java.sql.Blob} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateBoolean(int columnIndex, boolean x)
Updates a column specified by a column index with a {@code boolean} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateBoolean(java.lang.String columnName, boolean x)
Updates a column specified by a column name with a {@code boolean} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateByte(int columnIndex, byte x)
Updates a column specified by a column index with a {@code byte} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateByte(java.lang.String columnName, byte x)
Updates a column specified by a column name with a {@code byte} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateBytes(int columnIndex, byte[] x)
Updates a column specified by a column index with a {@code byte} array value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateBytes(java.lang.String columnName, byte[] x)
Updates a column specified by a column name with a byte array value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateCharacterStream(int columnIndex, java.io.Reader x, int length)
Updates a column specified by a column index with a character stream value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
param
length the length of data to write from the stream
throws
SQLException if a database error happens.
since
Android 1.0
public void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length)
Updates a column specified by a column name with a character stream value.
param
columnName the name of the column to update.
param
reader the new value for the specified column.
param
length the length of data to write from the Reader
throws
SQLException if a database error happens.
since
Android 1.0
public void updateClob(int columnIndex, java.sql.Clob x)
Updates a column specified by a column index with a {@code java.sql.Clob} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateClob(java.lang.String columnName, java.sql.Clob x)
Updates a column specified by a column name with a {@code java.sql.Clob} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateDate(int columnIndex, java.sql.Date x)
Updates a column specified by a column index with a {@code java.sql.Date} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateDate(java.lang.String columnName, java.sql.Date x)
Updates a column specified by a column name with a {@code java.sql.Date} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateDouble(int columnIndex, double x)
Updates a column specified by a column index with a {@code double} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateDouble(java.lang.String columnName, double x)
Updates a column specified by a column name with a {@code double} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateFloat(int columnIndex, float x)
Updates a column specified by a column index with a {@code float} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateFloat(java.lang.String columnName, float x)
Updates a column specified by a column name with a {@code float} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateInt(int columnIndex, int x)
Updates a column specified by a column index with an {@code int} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateInt(java.lang.String columnName, int x)
Updates a column specified by a column name with an {@code int} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateLong(int columnIndex, long x)
Updates a column specified by a column index with a {@code long} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column..
throws
SQLException if a database error happens.
since
Android 1.0
public void updateLong(java.lang.String columnName, long x)
Updates a column specified by a column name with a {@code long} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateNull(int columnIndex)
Updates a column specified by a column index with a {@code null} value.
param
columnIndex the index of the column to update.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateNull(java.lang.String columnName)
Updates a column specified by a column name with a {@code null} value.
param
columnName the name of the column to update.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateObject(int columnIndex, java.lang.Object x)
Updates a column specified by a column index with an {@code Object} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateObject(int columnIndex, java.lang.Object x, int scale)
Updates a column specified by a column index with an {@code Object} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
param
scale for the types {@code java.sql.Types.DECIMAL} or {@code java.sql.Types.NUMERIC}, this specifies the number of digits after the decimal point.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateObject(java.lang.String columnName, java.lang.Object x)
Updates a column specified by a column name with an {@code Object} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateObject(java.lang.String columnName, java.lang.Object x, int scale)
Updates a column specified by a column name with an {@code Object} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
param
scale for the types {@code java.sql.Types.DECIMAL} or {@code java.sql.Types.NUMERIC}, this specifies the number of digits after the decimal point.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateRef(int columnIndex, java.sql.Ref x)
Updates a column specified by a column index with a {@code java.sql.Ref} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateRef(java.lang.String columnName, java.sql.Ref x)
Updates a column specified by a column name with a {@code java.sql.Ref} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateRow()
Updates the database with the new contents of the current row of this {@code ResultSet} object.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateShort(int columnIndex, short x)
Updates a column specified by a column index with a {@code short} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateShort(java.lang.String columnName, short x)
Updates a column specified by a column name with a {@code short} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateString(int columnIndex, java.lang.String x)
Updates a column specified by a column index with a {@code String} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateString(java.lang.String columnName, java.lang.String x)
Updates a column specified by a column name with a {@code String} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateTime(int columnIndex, java.sql.Time x)
Updates a column specified by a column index with a {@code Time} value.
param
columnIndex the index of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateTime(java.lang.String columnName, java.sql.Time x)
Updates a column specified by a column name with a {@code Time} value.
param
columnName the name of the column to update.
param
x the new value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateTimestamp(int columnIndex, java.sql.Timestamp x)
Updates a column specified by a column index with a {@code Timestamp} value.
param
columnIndex the index of the column to update.
param
x the new timestamp value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x)
Updates a column specified by column name with a {@code Timestamp} value.
param
columnName the name of the column to update.
param
x the new timestamp value for the specified column.
throws
SQLException if a database error happens.
since
Android 1.0
public boolean wasNull()
Determines whether the last column read from this {@code ResultSet} contained SQL {@code NULL}.
return
{@code {@code true} if the last column contained SQL {@code NULL}, {@code false} otherwise
throws
SQLException if a database error happens.
since
Android 1.0