Please note that the contents of this offline web site may be out of date. To access the most recent documentation visit the online version .
Note that links that point to online resources are green in color and will open in a new window.
We would love it if you could give us feedback about this material by filling this form (You have to be online to fill it)

Summary: Inherited Constants | Methods | Inherited Methods | [Expand All]

Added in API level 1

public interface

RowSet

implements ResultSet

javax.sql.RowSet

Class Overview

An interface which provides means to access data which persists on a database. It extends the functionality of ResultSet into a form that it can be used as a JavaBean component, suited for a visual programming environment.

RowSet provides getters and setters for properties relating to the general database environment together with the getters and setters for distinct data values which constitute the row set. The RowSet class supports JavaBean events so that other components in an application can be informed when changes happen such as changes in data values.

RowSet is a facility implemented on top of the remainder of the JDBC API. It may be connected , maintaining a connection to the database throughout its lifecycle. The changes made on a disconnected RowSet on the other hand can be persisted only establishing a new connection with the database each time.

Disconnected RowSets make use of RowSetReaders to populate the RowSet with data, possibly from a non-relational database source. They may also use RowSetWriters to send data back to the underlying data store. There is considerable freedom in the way that RowSetReaders and RowSetWriters may be implemented to retrieve and store data.

Summary

[Expand]

Inherited Constants

From interface java.sql.ResultSet

int	CLOSE_CURSORS_AT_COMMIT	A constant used to indicate that a `ResultSet` object must be closed when the method `Connection.commit` is invoked.
int	CONCUR_READ_ONLY	A constant used to indicate the concurrency mode for a `ResultSet` object that cannot be updated.
int	CONCUR_UPDATABLE	A constant used to indicate the concurrency mode for a `ResultSet` object that can be updated.
int	FETCH_FORWARD	A constant used to indicate processing of the rows of a `ResultSet` in the forward direction, first to last.
int	FETCH_REVERSE	A constant used to indicate processing of the rows of a `ResultSet` in the reverse direction, last to first.
int	FETCH_UNKNOWN	A constant used to indicate that the order of processing of the rows of a `ResultSet` is unknown.
int	HOLD_CURSORS_OVER_COMMIT	A constant used to indicate that a `ResultSet` object must not be closed when the method `Connection.commit` is invoked.
int	TYPE_FORWARD_ONLY	A constant used to indicate a `ResultSet` object whose cursor can only move forward.
int	TYPE_SCROLL_INSENSITIVE	A constant used to indicate a `ResultSet` object which is scrollable but is insensitive to changes made by others.
int	TYPE_SCROLL_SENSITIVE	A constant used to indicate a `ResultSet` object which is scrollable and sensitive to changes made by others.

Public Methods
abstract void	addRowSetListener ( RowSetListener theListener) Registers the supplied `RowSetListener` with this `RowSet` .
abstract void	clearParameters () Clears the parameters previously set for this `RowSet` .
abstract void	execute () Fetches data for this `RowSet` from the database.
abstract String	getCommand () Gets the `RowSet` 's command property.
abstract String	getDataSourceName () Gets the ODBC Data Source Name property associated with this `RowSet` .
abstract boolean	getEscapeProcessing () Reports if escape processing is enabled for this `RowSet` .
abstract int	getMaxFieldSize () Gets the maximum number of bytes that can be returned for column values which are of type `BINARY` , `VARBINARY` , `LONGVARBINARYBINARY` , `CHAR` , `VARCHAR` , or `LONGVARCHAR` .
abstract int	getMaxRows () Gets the maximum number of rows for this `RowSet` .
abstract String	getPassword () Gets the value of the password property for this `RowSet` .
abstract int	getQueryTimeout () Gets the timeout for the driver when a query operation is executed.
abstract int	getTransactionIsolation () Gets the transaction isolation level property set for this `RowSet` .
abstract Map < String , Class <?>>	getTypeMap () Gets the custom mapping of SQL User-Defined Types (UDTs) and Java classes for this `RowSet` , if applicable.
abstract String	getUrl () Gets the URL property value for this `RowSet` .
abstract String	getUsername () Gets the value of the `username` property for this `RowSet` .
abstract boolean	isReadOnly () Indicates if this `RowSet` is read-only.
abstract void	removeRowSetListener ( RowSetListener theListener) Removes a specified `RowSetListener` object from the set of listeners which will be notified of events by this `RowSet` .
abstract void	setArray (int parameterIndex, Array theArray) Sets the specified `ARRAY` parameter in the `RowSet` command with the supplied `java.sql.Array` value.
abstract void	setAsciiStream (int parameterIndex, InputStream theInputStream, int length) Sets the value of the specified parameter in the `RowSet` command with the ASCII data in the supplied `java.io.InputStream` value.
abstract void	setAsciiStream ( String parameterName, InputStream theInputStream, int length) Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value.
abstract void	setAsciiStream ( String parameterName, InputStream theInputStream) Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value.
abstract void	setAsciiStream (int parameterIndex, InputStream theInputStream) Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value.
abstract void	setBigDecimal (int parameterIndex, BigDecimal theBigDecimal) Sets the value of the specified SQL `NUMERIC` parameter in the `RowSet` command with the data in the supplied `java.math.BigDecimal` value.
abstract void	setBigDecimal ( String parameterName, BigDecimal theBigDecimal) Sets the value of the specified SQL NUMERIC parameter in the RowSet command with the data in the supplied java.math.BigDecimal value.
abstract void	setBinaryStream (int parameterIndex, InputStream theInputStream) Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value.
abstract void	setBinaryStream ( String parameterName, InputStream theInputStream) Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value.
abstract void	setBinaryStream (int parameterIndex, InputStream theInputStream, int length) Sets the value of the specified parameter in the `RowSet` command to the binary data in the supplied input stream.
abstract void	setBinaryStream ( String parameterName, InputStream theInputStream, int length) Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value.
abstract void	setBlob (int parameterIndex, InputStream theInputStream, long length) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream.
abstract void	setBlob (int parameterIndex, InputStream theInputStream) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream.
abstract void	setBlob ( String parameterName, InputStream theInputStream, long length) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream.
abstract void	setBlob ( String parameterName, InputStream theInputStream) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream.
abstract void	setBlob ( String parameterName, Blob theBlob) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Blob.
abstract void	setBlob (int parameterIndex, Blob theBlob) Sets the value of the specified parameter in the `RowSet` command to the supplied `Blob` value.
abstract void	setBoolean ( String parameterName, boolean theBoolean) Sets the value of the specified parameter in the RowSet command to the supplied boolean.
abstract void	setBoolean (int parameterIndex, boolean theBoolean) Sets the value of the specified parameter in the `RowSet` command to the supplied boolean.
abstract void	setByte (int parameterIndex, byte theByte) Sets the value of the specified parameter in the `RowSet` command to the supplied byte value.
abstract void	setByte ( String parameterName, byte theByte) Sets the value of the specified parameter in the RowSet command to the supplied byte value.
abstract void	setBytes (int parameterIndex, byte[] theByteArray) Sets the value of the specified parameter in the `RowSet` command to the supplied byte array value.
abstract void	setBytes ( String parameterName, byte[] theByteArray) Sets the value of the specified parameter in the RowSet command to the supplied byte array value.
abstract void	setCharacterStream ( String parameterName, Reader theReader, int length) Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
abstract void	setCharacterStream ( String parameterName, Reader theReader) Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
abstract void	setCharacterStream (int parameterIndex, Reader theReader) Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
abstract void	setCharacterStream (int parameterIndex, Reader theReader, int length) Sets the value of the specified parameter in the `RowSet` command to the sequence of Unicode characters carried by the supplied `java.io.Reader` .
abstract void	setClob (int parameterIndex, Reader theReader, long length) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setClob ( String parameterName, Reader theReader, long length) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setClob (int parameterIndex, Clob theClob) Sets the value of the specified parameter in the `RowSet` command with the value of a supplied `java.sql.Clob` .
abstract void	setClob (int parameterIndex, Reader theReader) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setClob ( String parameterName, Clob theClob) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Clob.
abstract void	setClob ( String parameterName, Reader theReader) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setCommand ( String cmd) Sets the Command property for this `RowSet` - the command is an SQL query which runs when the `execute` method is invoked.
abstract void	setConcurrency (int concurrency) Sets the concurrency property of this `RowSet` .
abstract void	setDataSourceName ( String name) Sets the database name property for the `RowSet` .
abstract void	setDate (int parameterIndex, Date theDate, Calendar theCalendar) Sets the value of the specified parameter in the `RowSet` command with the value of a supplied `java.sql.Date` , where the conversion of the date to an SQL `DATE` value is calculated using a supplied `Calendar` .
abstract void	setDate (int parameterIndex, Date theDate) Sets the value of the specified parameter in the `RowSet` command with the value of a supplied `java.sql.Date` .
abstract void	setDate ( String parameterName, Date theDate, Calendar theCalendar) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date, where the conversion of the Date to an SQL DATE value is calculated using a supplied Calendar.
abstract void	setDate ( String parameterName, Date theDate) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date, where the conversion of the Date to an SQL DATE value is calculated using a supplied Calendar.
abstract void	setDouble (int parameterIndex, double theDouble) Sets the value of the specified parameter in the `RowSet` command with the supplied `double` .
abstract void	setDouble ( String parameterName, double theDouble) Sets the value of the specified parameter in the RowSet command with the supplied double.
abstract void	setEscapeProcessing (boolean enable) Sets the escape processing status for this `RowSet` .
abstract void	setFloat (int parameterIndex, float theFloat) Sets the value of the specified parameter in the `RowSet` command with the supplied `float` .
abstract void	setFloat ( String parameterName, float theFloat) Sets the value of the specified parameter in the RowSet command with the supplied float.
abstract void	setInt (int parameterIndex, int theInteger) Sets the value of the specified parameter in the `RowSet` command with the supplied `integer` .
abstract void	setInt ( String parameterName, int theInteger) Sets the value of the specified parameter in the RowSet command with the supplied integer.
abstract void	setLong (int parameterIndex, long theLong) Sets the value of the specified parameter in the `RowSet` command with the supplied `long` .
abstract void	setLong ( String parameterName, long theLong) Sets the value of the specified parameter in the RowSet command with the supplied long.
abstract void	setMaxFieldSize (int max) Sets the maximum number of bytes which can be returned for a column value where the column type is one of `BINARY` , `VARBINARY` , `LONGVARBINARYBINARY` , `CHAR` , `VARCHAR` , or `LONGVARCHAR` .
abstract void	setMaxRows (int max) Sets the maximum number of rows which can be held by the `RowSet` .
abstract void	setNCharacterStream (int parameterIndex, Reader theReader) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setNCharacterStream ( String parameterName, Reader theReader) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setNCharacterStream ( String parameterName, Reader theReader, long length) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setNCharacterStream (int parameterIndex, Reader theReader, long length) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setNClob ( String parameterName, Reader theReader, long length) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setNClob ( String parameterName, NClob theNClob) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.NClob.
abstract void	setNClob (int parameterIndex, Reader theReader) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setNClob ( String parameterName, Reader theReader) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setNClob (int parameterIndex, NClob theNClob) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.NClob.
abstract void	setNClob (int parameterIndex, Reader theReader, long length) Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
abstract void	setNString ( String parameterName, String theNString) Sets the value of the specified parameter in the RowSet command to the supplied NString.
abstract void	setNString (int parameterIndex, String theNString) Sets the value of the specified parameter in the RowSet command to the supplied NString
abstract void	setNull ( String parameterName, int sqlType) Sets the value of the specified parameter in the RowSet command to SQL NULL.
abstract void	setNull ( String parameterName, int sqlType, String typeName) Sets the value of the specified parameter in the RowSet command to SQL NULL.
abstract void	setNull (int parameterIndex, int sqlType, String typeName) Sets the value of the specified parameter in the `RowSet` command to SQL `NULL` .
abstract void	setNull (int parameterIndex, int sqlType) Sets the value of the specified parameter in the `RowSet` command to SQL `NULL` .
abstract void	setObject ( String parameterName, Object theObject) Sets the value of the specified parameter in the RowSet command to a supplied Java object.
abstract void	setObject ( String parameterName, Object theObject, int targetSqlType) Sets the value of the specified parameter in the RowSet command to a supplied Java object.
abstract void	setObject ( String parameterName, Object theObject, int targetSqlType, int scale) Sets the value of the specified parameter in the RowSet command to a supplied Java object.
abstract void	setObject (int parameterIndex, Object theObject, int targetSqlType, int scale) Sets the value of the specified parameter in the `RowSet` command to a supplied Java object.
abstract void	setObject (int parameterIndex, Object theObject) Sets the value of the specified parameter in the `RowSet` command to a supplied Java object.
abstract void	setObject (int parameterIndex, Object theObject, int targetSqlType) Sets the value of the specified parameter in the `RowSet` command to a supplied Java object.
abstract void	setPassword ( String password) Sets the database Password for this `RowSet` .
abstract void	setQueryTimeout (int seconds) Gets the timeout for the driver when a query operation is executed.
abstract void	setReadOnly (boolean readOnly) Sets whether the `RowSet` is read-only or updatable.
abstract void	setRef (int parameterIndex, Ref theRef) Sets the value of the specified parameter in the `RowSet` command to a supplied `java.sql.Ref` .
abstract void	setRowId (int parameterIndex, RowId theRowId) Sets the value of the specified parameter in the RowSet command to the supplied RowId
abstract void	setRowId ( String parameterName, RowId theRowId) Sets the value of the specified parameter in the RowSet command to the supplied RowId.
abstract void	setSQLXML ( String parameterName, SQLXML theSQLXML) Sets the value of the specified parameter in the RowSet command to the supplied SQLXML.
abstract void	setSQLXML (int parameterIndex, SQLXML theSQLXML) Sets the value of the specified parameter in the RowSet command to the supplied SQLXML
abstract void	setShort (int parameterIndex, short theShort) Sets the value of the specified parameter in the `RowSet` command to a supplied `short integer` .
abstract void	setShort ( String parameterName, short theShort) Sets the value of the specified parameter in the RowSet command to a supplied short integer.
abstract void	setString (int parameterIndex, String theString) Sets the value of the specified parameter in the `RowSet` command to a supplied `String` .
abstract void	setString ( String parameterName, String theString) Sets the value of the specified parameter in the RowSet command to a supplied String.
abstract void	setTime (int parameterIndex, Time theTime) Sets the value of the specified parameter in the `RowSet` command to a supplied `java.sql.Time` , converting it to an SQL `TIME` value using the system default `Calendar` .
abstract void	setTime ( String parameterName, Time theTime, Calendar theCalendar) Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting to an SQL TIME value using a supplied Calendar.
abstract void	setTime (int parameterIndex, Time theTime, Calendar theCalendar) Sets the value of the specified parameter in the `RowSet` command to a supplied `java.sql.Time` , converting it to an SQL `TIME` value using a supplied `Calendar` .
abstract void	setTime ( String parameterName, Time theTime) Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting to an SQL TIME value using a supplied Calendar.
abstract void	setTimestamp (int parameterIndex, Timestamp theTimestamp, Calendar theCalendar) Sets the value of the specified parameter in the `RowSet` command to a supplied `java.sql.Timestamp` , converting it to an SQL `TIMESTAMP` value using a supplied `Calendar` .
abstract void	setTimestamp ( String parameterName, Timestamp theTimestamp, Calendar theCalendar) Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using a supplied Calendar.
abstract void	setTimestamp ( String parameterName, Timestamp theTimestamp) Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using the system default `Calendar` .
abstract void	setTimestamp (int parameterIndex, Timestamp theTimestamp) Sets the value of the specified parameter in the `RowSet` command to a supplied `java.sql.Timestamp` , converting it to an SQL `TIMESTAMP` value using the system default `Calendar` .
abstract void	setTransactionIsolation (int level) Sets the target instance's transaction isolation level to one of a discrete set of possible values.
abstract void	setType (int type) Sets the type of this `RowSet` .
abstract void	>)">setTypeMap ( Map < String , Class <?>> theTypeMap) Sets the mapping of SQL User Defined Types (UDTs) to Java classes.
abstract void	setURL (int parameterIndex, URL theURL) Sets the URL used by this RowSet to access the database via a `DriverManager` .
abstract void	setUrl ( String theURL) Sets the URL used by this `RowSet` to access the database via a `DriverManager` .
abstract void	setUsername ( String theUsername) Sets the `Username` property for the `RowSet` , used to authenticate a connection to the database.

[Expand]

Inherited Methods

From interface java.lang.AutoCloseable

From interface java.sql.ResultSet

abstract boolean	absolute (int row) Moves the cursor to a specified row number in the `ResultSet` .
abstract void	afterLast () Moves the cursor to the end of the `ResultSet` , after the last row.
abstract void	beforeFirst () Moves the cursor to the start of the `ResultSet` , before the first row.
abstract void	cancelRowUpdates () Cancels any updates made to the current row in the `ResultSet` .
abstract void	clearWarnings () Clears all warnings related to this `ResultSet` .
abstract void	close () Releases this `ResultSet` 's database and JDBC resources.
abstract void	deleteRow () Deletes the current row from the `ResultSet` and from the underlying database.
abstract int	findColumn ( String columnName) Gets the index number for a column in the `ResultSet` from the provided column name.
abstract boolean	first () Shifts the cursor position to the first row in the `ResultSet` .
abstract Array	getArray (int columnIndex) Gets the content of a column specified by column index in the current row of this `ResultSet` as a `java.sql.Array` .
abstract Array	getArray ( String colName) Gets the value of a column specified by column name as a `java.sql.Array` .
abstract InputStream	getAsciiStream (int columnIndex) Gets the value of a column specified by column index as an ASCII character stream.
abstract InputStream	getAsciiStream ( String columnName) Gets the value of a column specified by column name as an ASCII character stream.
abstract BigDecimal	getBigDecimal ( String columnName) Gets the value of a column specified by column name, as a `java.math.BigDecimal` .
abstract BigDecimal	getBigDecimal (int columnIndex, int scale) This method was deprecated in API level 1. Use `getBigDecimal(int)` or `getBigDecimal(String)` instead.
abstract BigDecimal	getBigDecimal (int columnIndex) Gets the value of a column specified by column index as a `java.math.BigDecimal` .
abstract BigDecimal	getBigDecimal ( String columnName, int scale) This method was deprecated in API level 1. Use `getBigDecimal(int)` or `getBigDecimal(String)` instead.
abstract InputStream	getBinaryStream (int columnIndex) Gets the value of a column specified by column index as a binary stream.
abstract InputStream	getBinaryStream ( String columnName) Gets the value of a column specified by column name as a binary stream.
abstract Blob	getBlob ( String columnName) Gets the value of a column specified by column name, as a `java.sql.Blob` object.
abstract Blob	getBlob (int columnIndex) Gets the value of a column specified by column index as a `java.sql.Blob` object.
abstract boolean	getBoolean (int columnIndex) Gets the value of a column specified by column index as a `boolean` .
abstract boolean	getBoolean ( String columnName) Gets the value of a column specified by column name, as a `boolean` .
abstract byte	getByte ( String columnName) Gets the value of a column specified by column name as a `byte` .
abstract byte	getByte (int columnIndex) Gets the value of a column specified by column index as a `byte` .
abstract byte[]	getBytes (int columnIndex) Gets the value of a column specified by column index as a byte array.
abstract byte[]	getBytes ( String columnName) Gets the value of a column specified by column name as a byte array.
abstract Reader	getCharacterStream ( String columnName) Gets the value of a column specified by column name as a `java.io.Reader` object.
abstract Reader	getCharacterStream (int columnIndex) Gets the value of a column specified by column index as a `java.io.Reader` object.
abstract Clob	getClob (int columnIndex) Gets the value of a column specified by column index as a `java.sql.Clob` .
abstract Clob	getClob ( String colName) Gets the value of a column specified by column name as a `java.sql.Clob` .
abstract int	getConcurrency () Gets the concurrency mode of this `ResultSet` .
abstract String	getCursorName () Gets the name of the SQL cursor of this `ResultSet` .
abstract Date	getDate (int columnIndex, Calendar cal) Gets the value of a column specified by column index as a `java.sql.Date` .
abstract Date	getDate (int columnIndex) Gets the value of a column specified by column index as a `java.sql.Date` .
abstract Date	getDate ( String columnName, Calendar cal) Gets the value of a column specified by column name, as a `java.sql.Date` object.
abstract Date	getDate ( String columnName) Gets the value of a column specified by column name as a `java.sql.Date` .
abstract double	getDouble ( String columnName) Gets the value of a column specified by column name as a `double` value.
abstract double	getDouble (int columnIndex) Gets the value of a column specified by column index as a `double` value.
abstract int	getFetchDirection () Gets the direction in which rows are fetched for this `ResultSet` object.
abstract int	getFetchSize () Gets the fetch size (in number of rows) for this `ResultSet` .
abstract float	getFloat (int columnIndex) Gets the value of a column specified by column index as a `float` value.
abstract float	getFloat ( String columnName) Gets the value of a column specified by column name as a `float` value.
abstract int	getHoldability () Returns the holdability of this result set: `HOLD_CURSORS_OVER_COMMIT` or `CLOSE_CURSORS_AT_COMMIT` .
abstract int	getInt ( String columnName) Gets the value of a column specified by column name, as an `int` value.
abstract int	getInt (int columnIndex) Gets the value of a column specified by column index as an `int` value.
abstract long	getLong ( String columnName) Gets the value of a column specified by column name, as a `long` value.
abstract long	getLong (int columnIndex) Gets the value of a column specified by column index as a `long` value.
abstract ResultSetMetaData	getMetaData () Gets the metadata for this `ResultSet` .
abstract Reader	getNCharacterStream (int columnIndex) Returns a `Reader` corresponding to the value at the 1-based `columnIndex` .
abstract Reader	getNCharacterStream ( String columnLabel) Returns a `Reader` corresponding to the value in the named column.
abstract NClob	getNClob ( String columnLabel) Returns an `NClob` corresponding to the value in the named column.
abstract NClob	getNClob (int columnIndex) Returns an `NClob` corresponding to the value at the 1-based `columnIndex` .
abstract String	getNString ( String columnLabel) Returns a `String` corresponding to the value in the named column.
abstract String	getNString (int columnIndex) Returns a `String` corresponding to the value at the 1-based `columnIndex` .
abstract Object	>)">getObject ( String columnName, Map < String , Class <?>> map) Gets the value of a column specified by column name as a Java `Object` .
abstract Object	>)">getObject (int columnIndex, Map < String , Class <?>> map) Gets the value of a column specified by column index as a Java `Object` .
abstract Object	getObject ( String columnName) Gets the value of a specified column as a Java `Object` .
abstract Object	getObject (int columnIndex) Gets the value of a specified column as a Java `Object` .
abstract Ref	getRef ( String colName) Gets the value of a column specified by column name as a Java `java.sql.Ref` .
abstract Ref	getRef (int columnIndex) Gets the value of a column specified by column index as a Java `java.sql.Ref` .
abstract int	getRow () Gets the number of the current row in the `ResultSet` .
abstract RowId	getRowId ( String columnLabel) Returns a `RowId` corresponding to the SQL ROWID at the named column.
abstract RowId	getRowId (int columnIndex) Returns a `RowId` corresponding to the SQL ROWID at the 1-based `columnIndex` .
abstract SQLXML	getSQLXML ( String columnLabel) Returns an `SQLXML` corresponding to the value in the named column.
abstract SQLXML	getSQLXML (int columnIndex) Returns an `SQLXML` corresponding to the value at the 1-based `columnIndex` .
abstract short	getShort ( String columnName) Gets the value of a column specified by column name, as a short value.
abstract short	getShort (int columnIndex) Gets the value of a column specified by column index as a short value.
abstract Statement	getStatement () Gets the statement that produced this `ResultSet` .
abstract String	getString (int columnIndex) Gets the value of a column specified by column index as a String.
abstract String	getString ( String columnName) Gets the value of a column specified by column name, as a String.
abstract Time	getTime ( String columnName, Calendar cal) Gets the value of a column specified by column index, as a `java.sql.Time` value.
abstract Time	getTime ( String columnName) Gets the value of a column specified by column name, as a `java.sql.Time` value.
abstract Time	getTime (int columnIndex, Calendar cal) Gets the value of a column specified by column index as a `java.sql.Time` value.
abstract Time	getTime (int columnIndex) Gets the value of a column specified by column index as a `java.sql.Time` value.
abstract Timestamp	getTimestamp (int columnIndex, Calendar cal) Gets the value of a column specified by column index, as a `java.sql.Timestamp` value.
abstract Timestamp	getTimestamp ( String columnName) Gets the value of a column specified by column name, as a `java.sql.Timestamp` value.
abstract Timestamp	getTimestamp ( String columnName, Calendar cal) Gets the value of a column specified by column name, as a `java.sql.Timestamp` value.
abstract Timestamp	getTimestamp (int columnIndex) Gets the value of a column specified by column index as a `java.sql.Timestamp` value.
abstract int	getType () Gets the type of the `ResultSet` .
abstract URL	getURL (int columnIndex) Gets the value of a column specified by column index as a `java.net.URL` .
abstract URL	getURL ( String columnName) Gets the value of a column specified by column name as a `java.net.URL` object.
abstract InputStream	getUnicodeStream (int columnIndex) This method was deprecated in API level 1. Use `getCharacterStream(int)` instead.
abstract InputStream	getUnicodeStream ( String columnName) This method was deprecated in API level 1. Use `getCharacterStream(int)` instead.
abstract SQLWarning	getWarnings () Gets the first warning generated by calls on this `ResultSet` .
abstract void	insertRow () Insert the insert row into the `ResultSet` and into the underlying database.
abstract boolean	isAfterLast () Gets if the cursor is after the last row of the `ResultSet` .
abstract boolean	isBeforeFirst () Gets if the cursor is before the first row of the `ResultSet` .
abstract boolean	isClosed () Returns true if this result set has been closed, false otherwise.
abstract boolean	isFirst () Gets if the cursor is on the first row of the `ResultSet` .
abstract boolean	isLast () Gets if the cursor is on the last row of the `ResultSet`
abstract boolean	last () Shifts the cursor position to the last row of the `ResultSet` .
abstract void	moveToCurrentRow () Moves the cursor to the remembered position, namely the row that was the current row before a call to `moveToInsertRow` .
abstract void	moveToInsertRow () Moves the cursor position to the Insert Row.
abstract boolean	next () Shifts the cursor position down one row in this `ResultSet` object.
abstract boolean	previous () Relocates the cursor position to the preceding row in this `ResultSet` .
abstract void	refreshRow () Refreshes the current row with its most up to date value in the database.
abstract boolean	relative (int rows) Moves the cursor position up or down by a specified number of rows.
abstract boolean	rowDeleted () Indicates whether a row has been deleted.
abstract boolean	rowInserted () Indicates whether the current row has had an insertion operation.
abstract boolean	rowUpdated () Indicates whether the current row has been updated.
abstract void	setFetchDirection (int direction) Indicates which direction (forward/reverse) will be used to process the rows of this `ResultSet` object.
abstract void	setFetchSize (int rows) Indicates the number of rows to fetch from the database when extra rows are required for this `ResultSet` .
abstract void	updateArray (int columnIndex, Array x) Updates a column specified by a column index with a `java.sql.Array` value.
abstract void	updateArray ( String columnName, Array x) Updates a column specified by a column name with a `java.sql.Array` value.
abstract void	updateAsciiStream ( String columnName, InputStream x, int length) Updates a column specified by a column name with an Ascii stream value.
abstract void	updateAsciiStream (int columnIndex, InputStream x, long length) Updates the value at the 1-based `columnIndex` .
abstract void	updateAsciiStream ( String columnLabel, InputStream x, long length) Updates the value in the named column.
abstract void	updateAsciiStream ( String columnLabel, InputStream x) Updates the value in the named column.
abstract void	updateAsciiStream (int columnIndex, InputStream x) Updates the value at the 1-based `columnIndex` .
abstract void	updateAsciiStream (int columnIndex, InputStream x, int length) Updates a column specified by a column index with an ASCII stream value.
abstract void	updateBigDecimal (int columnIndex, BigDecimal x) Updates a column specified by a column index with a `java.sql.BigDecimal` value.
abstract void	updateBigDecimal ( String columnName, BigDecimal x) Updates a column specified by a column name with a `java.sql.BigDecimal` value.
abstract void	updateBinaryStream (int columnIndex, InputStream x) Updates the value at the 1-based `columnIndex` .
abstract void	updateBinaryStream (int columnIndex, InputStream x, long length) Updates the value at the 1-based `columnIndex` .
abstract void	updateBinaryStream ( String columnLabel, InputStream x, long length) Updates the value in the named column.
abstract void	updateBinaryStream (int columnIndex, InputStream x, int length) Updates a column specified by a column index with a binary stream value.
abstract void	updateBinaryStream ( String columnLabel, InputStream x) Updates the value in the named column.
abstract void	updateBinaryStream ( String columnName, InputStream x, int length) Updates a column specified by a column name with a binary stream value.
abstract void	updateBlob (int columnIndex, Blob x) Updates a column specified by a column index with a `java.sql.Blob` value.
abstract void	updateBlob ( String columnLabel, InputStream inputStream) Updates the value in the named column.
abstract void	updateBlob ( String columnLabel, InputStream inputStream, long length) Updates the value in the named column.
abstract void	updateBlob (int columnIndex, InputStream inputStream) Updates the value at the 1-based `columnIndex` .
abstract void	updateBlob (int columnIndex, InputStream inputStream, long length) Updates the value at the 1-based `columnIndex` .
abstract void	updateBlob ( String columnName, Blob x) Updates a column specified by a column name with a `java.sql.Blob` value.
abstract void	updateBoolean (int columnIndex, boolean x) Updates a column specified by a column index with a `boolean` value.
abstract void	updateBoolean ( String columnName, boolean x) Updates a column specified by a column name with a `boolean` value.
abstract void	updateByte ( String columnName, byte x) Updates a column specified by a column name with a `byte` value.
abstract void	updateByte (int columnIndex, byte x) Updates a column specified by a column index with a `byte` value.
abstract void	updateBytes (int columnIndex, byte[] x) Updates a column specified by a column index with a `byte` array value.
abstract void	updateBytes ( String columnName, byte[] x) Updates a column specified by a column name with a byte array value.
abstract void	updateCharacterStream ( String columnLabel, Reader reader) Updates the value in the named column.
abstract void	updateCharacterStream ( String columnName, Reader reader, int length) Updates a column specified by a column name with a character stream value.
abstract void	updateCharacterStream (int columnIndex, Reader x, long length) Updates the value at the 1-based `columnIndex` .
abstract void	updateCharacterStream ( String columnLabel, Reader reader, long length) Updates the value in the named column.
abstract void	updateCharacterStream (int columnIndex, Reader x) Updates the value at the 1-based `columnIndex` .
abstract void	updateCharacterStream (int columnIndex, Reader x, int length) Updates a column specified by a column index with a character stream value.
abstract void	updateClob ( String columnLabel, Reader reader) Updates the value in the named column.
abstract void	updateClob (int columnIndex, Clob x) Updates a column specified by a column index with a `java.sql.Clob` value.
abstract void	updateClob ( String columnLabel, Reader reader, long length) Updates the value in the named column.
abstract void	updateClob (int columnIndex, Reader reader, long length) Updates the value at the 1-based `columnIndex` .
abstract void	updateClob (int columnIndex, Reader reader) Updates the value at the 1-based `columnIndex` .
abstract void	updateClob ( String columnName, Clob x) Updates a column specified by a column name with a `java.sql.Clob` value.
abstract void	updateDate ( String columnName, Date x) Updates a column specified by a column name with a `java.sql.Date` value.
abstract void	updateDate (int columnIndex, Date x) Updates a column specified by a column index with a `java.sql.Date` value.
abstract void	updateDouble ( String columnName, double x) Updates a column specified by a column name with a `double` value.
abstract void	updateDouble (int columnIndex, double x) Updates a column specified by a column index with a `double` value.
abstract void	updateFloat ( String columnName, float x) Updates a column specified by a column name with a `float` value.
abstract void	updateFloat (int columnIndex, float x) Updates a column specified by a column index with a `float` value.
abstract void	updateInt ( String columnName, int x) Updates a column specified by a column name with an `int` value.
abstract void	updateInt (int columnIndex, int x) Updates a column specified by a column index with an `int` value.
abstract void	updateLong ( String columnName, long x) Updates a column specified by a column name with a `long` value.
abstract void	updateLong (int columnIndex, long x) Updates a column specified by a column index with a `long` value.
abstract void	updateNCharacterStream ( String columnLabel, Reader reader) Updates the value in the named column.
abstract void	updateNCharacterStream (int columnIndex, Reader x) Updates the value at the 1-based `columnIndex` .
abstract void	updateNCharacterStream ( String columnLabel, Reader reader, long length) Updates the value in the named column.
abstract void	updateNCharacterStream (int columnIndex, Reader x, long length) Updates the value at the 1-based `columnIndex` .
abstract void	updateNClob (int columnIndex, NClob nClob) Updates the value at the 1-based `columnIndex` .
abstract void	updateNClob ( String columnLabel, NClob nClob) Updates the value in the named column.
abstract void	updateNClob ( String columnLabel, Reader reader) Updates the value in the named column.
abstract void	updateNClob (int columnIndex, Reader reader) Updates the value at the 1-based `columnIndex` .
abstract void	updateNClob (int columnIndex, Reader reader, long length) Updates the value at the 1-based `columnIndex` .
abstract void	updateNClob ( String columnLabel, Reader reader, long length) Updates the value in the named column.
abstract void	updateNString ( String columnLabel, String nString) Updates the value in the named column.
abstract void	updateNString (int columnIndex, String nString) Updates the value at the 1-based `columnIndex` .
abstract void	updateNull ( String columnName) Updates a column specified by a column name with a `null` value.
abstract void	updateNull (int columnIndex) Updates a column specified by a column index with a `null` value.
abstract void	updateObject (int columnIndex, Object x) Updates a column specified by a column index with an `Object` value.
abstract void	updateObject (int columnIndex, Object x, int scale) Updates a column specified by a column index with an `Object` value.
abstract void	updateObject ( String columnName, Object x, int scale) Updates a column specified by a column name with an `Object` value.
abstract void	updateObject ( String columnName, Object x) Updates a column specified by a column name with an `Object` value.
abstract void	updateRef (int columnIndex, Ref x) Updates a column specified by a column index with a `java.sql.Ref` value.
abstract void	updateRef ( String columnName, Ref x) Updates a column specified by a column name with a `java.sql.Ref` value.
abstract void	updateRow () Updates the database with the new contents of the current row of this `ResultSet` object.
abstract void	updateRowId ( String columnLabel, RowId value) Updates the value in the named column.
abstract void	updateRowId (int columnIndex, RowId value) Updates the value at the 1-based `columnIndex` .
abstract void	updateSQLXML (int columnIndex, SQLXML xmlObject) Updates the value at the 1-based `columnIndex` .
abstract void	updateSQLXML ( String columnLabel, SQLXML xmlObject) Updates the value in the named column.
abstract void	updateShort (int columnIndex, short x) Updates a column specified by a column index with a `short` value.
abstract void	updateShort ( String columnName, short x) Updates a column specified by a column name with a `short` value.
abstract void	updateString (int columnIndex, String x) Updates a column specified by a column index with a `String` value.
abstract void	updateString ( String columnName, String x) Updates a column specified by a column name with a `String` value.
abstract void	updateTime (int columnIndex, Time x) Updates a column specified by a column index with a `Time` value.
abstract void	updateTime ( String columnName, Time x) Updates a column specified by a column name with a `Time` value.
abstract void	updateTimestamp (int columnIndex, Timestamp x) Updates a column specified by a column index with a `Timestamp` value.
abstract void	updateTimestamp ( String columnName, Timestamp x) Updates a column specified by column name with a `Timestamp` value.
abstract boolean	wasNull () Determines whether the last column read from this `ResultSet` contained SQL `NULL` .

From interface java.sql.Wrapper

Public Methods

public abstract void addRowSetListener ( RowSetListener theListener)

Added in API level 1

Registers the supplied RowSetListener with this RowSet . Once registered, the RowSetListener is notified of events generated by the RowSet .

Parameters

theListener	an object which implements the `rowSetListener` interface.

public abstract void clearParameters ()

Added in API level 1

Clears the parameters previously set for this RowSet .

The RowSet object retains its value until either a new value for a parameter is set or its value is actively reset. clearParameters provides a facility to clear the values for all parameters with one method call.

Throws

SQLException	if a problem occurs accessing the database.

public abstract void execute ()

Added in API level 1

Fetches data for this RowSet from the database. If successful, any existing data for the RowSet is discarded and its metadata is overwritten.

Data is retrieved connecting to the database and executing an according SQL statement. This requires some or all of the following properties to be set: URL, database name, user name, password, transaction isolation, type map; plus some or all of the properties: command, read only, maximum field size, maximum rows, escape processing, and query timeout.

The RowSet may use a RowSetReader to access the database it will then invoke the readData(RowSetInternal) method on the reader to fetch the data. When the new data is fetched all the listeners are notified to take appropriate measures.

Throws

SQLException	if a problem occurs accessing the database or if the properties needed to access the database have not been set.

public abstract String getCommand ()

Added in API level 1

Gets the RowSet 's command property.

Returns

a string containing the RowSet 's command property. A command is a SQL statement which is executed to fetch required data into the RowSet .

public abstract String getDataSourceName ()

Added in API level 1

Gets the ODBC Data Source Name property associated with this RowSet . The database name can be used to find a DataSource which has been registered with a naming service - the DataSource can then be used to create a connection to the database.

Returns

the name of the database.

public abstract boolean getEscapeProcessing ()

Added in API level 1

Reports if escape processing is enabled for this RowSet . If escape processing is on, the driver performs a substitution of the escape syntax with the applicable code before sending an SQL command to the database. The default value for escape processing is true .

Returns

true if escape processing is enabled, false otherwise.

Throws

SQLException	if a problem occurs accessing the database.

public abstract int getMaxFieldSize ()

Added in API level 1

Gets the maximum number of bytes that can be returned for column values which are of type BINARY , VARBINARY , LONGVARBINARYBINARY , CHAR , VARCHAR , or LONGVARCHAR . Excess data is silently discarded if the number is exceeded.

Returns

the current maximum size in bytes. 0 implies no size limit.

Throws

SQLException	if a problem occurs accessing the database.

public abstract int getMaxRows ()

Added in API level 1

Gets the maximum number of rows for this RowSet . Excess rows are discarded silently if the limit is exceeded.

Returns

the previous maximum number of rows. 0 implies no row limit.

Throws

SQLException	if a problem occurs accessing the database.

public abstract String getPassword ()

Added in API level 1

Gets the value of the password property for this RowSet . This property is used when a connection to the database is established. Therefore it should be set prior to invoking the execute() method.

Returns

the value of the password property.

public abstract int getQueryTimeout ()

Added in API level 1

Gets the timeout for the driver when a query operation is executed. If a query takes longer than the timeout then a SQLException is thrown.

Returns

the timeout value in seconds.

Throws

SQLException	if an error occurs accessing the database.

public abstract int getTransactionIsolation ()

Added in API level 1

Gets the transaction isolation level property set for this RowSet . The transaction isolation level defines the policy implemented on the database for maintaining the data values consistent.

Returns

the current transaction isolation level. Must be one of:
- Connection.TRANSACTION_READ_UNCOMMITTED
- Connection.TRANSACTION_READ_COMMITTED
- Connection.TRANSACTION_REPEATABLE_READ
- Connection.TRANSACTION_SERIALIZABLE

public abstract Map < String , Class <?>> getTypeMap ()

Added in API level 1

Gets the custom mapping of SQL User-Defined Types (UDTs) and Java classes for this RowSet , if applicable.

Returns

the custom mappings of SQL types to Java classes.

Throws

SQLException	if an error occurs accessing the database.

public abstract String getUrl ()

Added in API level 1

Gets the URL property value for this RowSet . If there is no DataSource object specified, the RowSet uses the URL to establish a connection to the database. The default value for the URL is null .

Returns

a String holding the value of the URL property.

Throws

SQLException	if an error occurs accessing the database.

public abstract String getUsername ()

Added in API level 1

Gets the value of the username property for this RowSet . The username is used when establishing a connection to the database and should be set before the execute method is invoked.

Returns

a String holding the value of the username property.

public abstract boolean isReadOnly ()

Added in API level 1

Indicates if this RowSet is read-only.

Returns

true if this RowSet is read-only, false if it is updatable.

public abstract void removeRowSetListener ( RowSetListener theListener)

Added in API level 1

Removes a specified RowSetListener object from the set of listeners which will be notified of events by this RowSet .

Parameters

theListener	the `RowSetListener` to remove from the set of listeners for this `RowSet` .

public abstract void setArray (int parameterIndex, Array theArray)

Added in API level 1

Sets the specified ARRAY parameter in the RowSet command with the supplied java.sql.Array value.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theArray	the `Array` data value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setAsciiStream (int parameterIndex, InputStream theInputStream, int length)

Added in API level 1

Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theInputStream	the ASCII data value to which the parameter is set.
length	the length of the data in bytes.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setAsciiStream ( String parameterName, InputStream theInputStream, int length)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.

Parameters

parameterName	the name for parameter
theInputStream	an InputStream containing the ASCII data to set into the parameter value
length	the length of the data in bytes

Throws

SQLException	if an error occurs accessing the database.

public abstract void setAsciiStream ( String parameterName, InputStream theInputStream)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.

Parameters

parameterName	the name for parameter
theInputStream	an InputStream containing the ASCII data to set into the parameter value

Throws

SQLException	if an error occurs accessing the database.

public abstract void setAsciiStream (int parameterIndex, InputStream theInputStream)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theInputStream	an InputStream containing the ASCII data to set into the parameter value

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBigDecimal (int parameterIndex, BigDecimal theBigDecimal)

Added in API level 1

Sets the value of the specified SQL NUMERIC parameter in the RowSet command with the data in the supplied java.math.BigDecimal value.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theBigDecimal	the big decimal value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBigDecimal ( String parameterName, BigDecimal theBigDecimal)

Added in API level 9

Sets the value of the specified SQL NUMERIC parameter in the RowSet command with the data in the supplied java.math.BigDecimal value.

Parameters

parameterName	the name for parameter
theBigDecimal	the BigDecimal containing the value

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBinaryStream (int parameterIndex, InputStream theInputStream)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theInputStream	an InputStream containing the binary data to set into the parameter value

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBinaryStream ( String parameterName, InputStream theInputStream)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.

Parameters

parameterName	the name for parameter
theInputStream	an InputStream containing the binary data to set into the parameter value

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBinaryStream (int parameterIndex, InputStream theInputStream, int length)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to the binary data in the supplied input stream. Data is read from the input stream until end-of-file is reached.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theInputStream	the binary data stream to which the parameter is set.
length	the length of the data in bytes.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBinaryStream ( String parameterName, InputStream theInputStream, int length)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.

Parameters

parameterName	the name for parameter
theInputStream	an InputStream containing the binary data to set into the parameter value
length	the length of the data in bytes

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBlob (int parameterIndex, InputStream theInputStream, long length)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theInputStream	an InputStream containing the binary data to set into the parameter value
length	the length of the data in bytes

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBlob (int parameterIndex, InputStream theInputStream)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theInputStream	an InputStream containing the binary data to set into the parameter value

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBlob ( String parameterName, InputStream theInputStream, long length)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.

Parameters

parameterName	the name for parameter
theInputStream	an InputStream containing the binary data to set into the parameter value
length	the length of the data in bytes

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBlob ( String parameterName, InputStream theInputStream)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.

Parameters

parameterName	the name for parameter
theInputStream	an InputStream containing the binary data to set into the parameter value

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBlob ( String parameterName, Blob theBlob)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Blob.

Parameters

parameterName	the name for parameter
theBlob	the Blob value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBlob (int parameterIndex, Blob theBlob)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to the supplied Blob value.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theBlob	the `Blob` value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBoolean ( String parameterName, boolean theBoolean)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the supplied boolean.

Parameters

parameterName	name for parameter
theBoolean	the boolean value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBoolean (int parameterIndex, boolean theBoolean)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to the supplied boolean.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theBoolean	the `boolean` value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setByte (int parameterIndex, byte theByte)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to the supplied byte value.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theByte	the `byte` value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setByte ( String parameterName, byte theByte)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the supplied byte value.

Parameters

parameterName	name for parameter
theByte	the byte value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBytes (int parameterIndex, byte[] theByteArray)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to the supplied byte array value.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theByteArray	the `Array` of `bytes` to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setBytes ( String parameterName, byte[] theByteArray)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the supplied byte array value.

Parameters

parameterName	name for parameter
theByteArray	the array of bytes to set into the parameter.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setCharacterStream ( String parameterName, Reader theReader, int length)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.

Parameters

parameterName	name for parameter
theReader	the Reader which contains the Unicode data to set into the parameter
length	the length of the data in the Reader in characters

Throws

SQLException	if an error occurs accessing the database.

public abstract void setCharacterStream ( String parameterName, Reader theReader)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.

Parameters

parameterName	name for parameter
theReader	the Reader which contains the Unicode data to set into the parameter

Throws

SQLException	if an error occurs accessing the database.

public abstract void setCharacterStream (int parameterIndex, Reader theReader)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theReader	the Reader which contains the Unicode data to set into the parameter

Throws

SQLException	if an error occurs accessing the database.

public abstract void setCharacterStream (int parameterIndex, Reader theReader, int length)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theReader	the `Reader` which contains the Unicode data to set the parameter.
length	the length of the data in the `Reader` in characters.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setClob (int parameterIndex, Reader theReader, long length)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theReader	the Reader which contains the Unicode data to set into the parameter
length	the length of the data in the Reader in characters

Throws

SQLException	if an error occurs accessing the database.

public abstract void setClob ( String parameterName, Reader theReader, long length)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterName	name for parameter
theReader	the Reader which contains the Unicode data to set into the parameter
length	the length of the data in the Reader in characters

Throws

SQLException	if an error occurs accessing the database.

public abstract void setClob (int parameterIndex, Clob theClob)

Added in API level 1

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Clob .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theClob	the `Clob` value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setClob (int parameterIndex, Reader theReader)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theReader	the Reader which contains the Unicode data to set into the parameter

Throws

SQLException	if an error occurs accessing the database.

public abstract void setClob ( String parameterName, Clob theClob)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Clob.

Parameters

parameterName	name for parameter
theClob	the specific Clob object

Throws

SQLException	if an error occurs accessing the database.

public abstract void setClob ( String parameterName, Reader theReader)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterName	name for parameter
theReader	the Reader which contains the Unicode data to set into the parameter

Throws

SQLException	if an error occurs accessing the database.

public abstract void setCommand ( String cmd)

Added in API level 1

Sets the Command property for this RowSet - the command is an SQL query which runs when the execute method is invoked. This property is optional for databases that do not support commands.

Parameters

cmd	the SQL query. Can be `null` .

Throws

SQLException	if an error occurs accessing the database.

public abstract void setConcurrency (int concurrency)

Added in API level 1

Sets the concurrency property of this RowSet . The default value is ResultSet.CONCUR_READ_ONLY .

Parameters

concurrency	the concurrency value. One of: `ResultSet.CONCUR_READ_ONLY` `ResultSet.CONCUR_UPDATABLE`

Throws

SQLException	if an error occurs accessing the database.

public abstract void setDataSourceName ( String name)

Added in API level 1

Sets the database name property for the RowSet .

The database name can be used to find a DataSource which has been registered with a naming service - the DataSource can then be used to create a connection to the database.

Parameters

name	the database name.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setDate (int parameterIndex, Date theDate, Calendar theCalendar)

Added in API level 1

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date , where the conversion of the date to an SQL DATE value is calculated using a supplied Calendar .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theDate	the date to which the parameter is set.
theCalendar	the `Calendar` to use in converting the Date to an SQL `DATE` value.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setDate (int parameterIndex, Date theDate)

Added in API level 1

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theDate	the date value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setDate ( String parameterName, Date theDate, Calendar theCalendar)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date, where the conversion of the Date to an SQL DATE value is calculated using a supplied Calendar.

Parameters

parameterName	name for parameter
theDate	the Date to use
theCalendar	the Calendar to use in converting the Date to an SQL DATE value

Throws

SQLException	if an error occurs accessing the database.

public abstract void setDate ( String parameterName, Date theDate)

Added in API level 9

Parameters

parameterName	name for parameter
theDate	the Date to use

Throws

SQLException	if an error occurs accessing the database.

public abstract void setDouble (int parameterIndex, double theDouble)

Added in API level 1

Sets the value of the specified parameter in the RowSet command with the supplied double .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theDouble	the `double` value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setDouble ( String parameterName, double theDouble)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the supplied double.

Parameters

parameterName	name for parameter
theDouble	the double value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setEscapeProcessing (boolean enable)

Added in API level 1

Sets the escape processing status for this RowSet . If escape processing is on, the driver performs a substitution of the escape syntax with the applicable code before sending an SQL command to the database. The default value for escape processing is true .

Parameters

enable	`true` to enable escape processing, `false` to turn it off.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setFloat (int parameterIndex, float theFloat)

Added in API level 1

Sets the value of the specified parameter in the RowSet command with the supplied float .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theFloat	the `float` value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setFloat ( String parameterName, float theFloat)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the supplied float.

Parameters

parameterName	name for parameter
theFloat	the float value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setInt (int parameterIndex, int theInteger)

Added in API level 1

Sets the value of the specified parameter in the RowSet command with the supplied integer .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theInteger	the `integer` value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setInt ( String parameterName, int theInteger)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the supplied integer.

Parameters

parameterName	name for parameter
theInteger	the integer value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setLong (int parameterIndex, long theLong)

Added in API level 1

Sets the value of the specified parameter in the RowSet command with the supplied long .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theLong	the `long` value value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setLong ( String parameterName, long theLong)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the supplied long.

Parameters

parameterName	name for parameter
theLong	the long value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setMaxFieldSize (int max)

Added in API level 1

Sets the maximum number of bytes which can be returned for a column value where the column type is one of BINARY , VARBINARY , LONGVARBINARYBINARY , CHAR , VARCHAR , or LONGVARCHAR . Data which exceeds this limit is silently discarded. For portability, a value greater than 256 is recommended.

Parameters

max	the maximum size of the returned column value in bytes. 0 implies no size limit.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setMaxRows (int max)

Added in API level 1

Sets the maximum number of rows which can be held by the RowSet . Any additional rows are silently discarded.

Parameters

max	the maximum number of rows which can be held in the `RowSet` . 0 means no limit.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNCharacterStream (int parameterIndex, Reader theReader)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theReader	the Reader which contains the Unicode data to set into the parameter

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNCharacterStream ( String parameterName, Reader theReader)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterName	name for parameter
theReader	the Reader which contains the Unicode data to set into the parameter

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNCharacterStream ( String parameterName, Reader theReader, long length)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterName	name for parameter
theReader	the Reader which contains the Unicode data to set into the parameter
length	the length of the data in the Reader in characters

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNCharacterStream (int parameterIndex, Reader theReader, long length)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theReader	the Reader which contains the Unicode data to set into the parameter
length	the length of the data in the Reader in characters

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNClob ( String parameterName, Reader theReader, long length)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterName	name for parameter
theReader	the Reader which contains the Unicode data to set into the parameter
length	the length of the data in the Reader in characters

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNClob ( String parameterName, NClob theNClob)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.NClob.

Parameters

parameterName	name for parameter
theNClob	the NClob value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNClob (int parameterIndex, Reader theReader)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theReader	the Reader which contains the Unicode data to set into the parameter

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNClob ( String parameterName, Reader theReader)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterName	name for parameter
theReader	the Reader which contains the Unicode data to set into the parameter

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNClob (int parameterIndex, NClob theNClob)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.NClob.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theNClob	the NClob value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNClob (int parameterIndex, Reader theReader, long length)

Added in API level 9

Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theReader	the Reader which contains the Unicode data to set into the parameter
length	the length of the data in the Reader in characters

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNString ( String parameterName, String theNString)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the supplied NString.

Parameters

parameterName	name for parameter
theNString	the NString value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNString (int parameterIndex, String theNString)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the supplied NString

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theNString	the NString value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNull ( String parameterName, int sqlType)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to SQL NULL. This form of the setNull method should be used for User Defined Types and REF parameters.

Parameters

parameterName	name for parameter
sqlType	the type of the parameter, as defined by java.sql.Types.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNull ( String parameterName, int sqlType, String typeName)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to SQL NULL. This form of the setNull method should be used for User Defined Types and REF parameters.

Parameters

parameterName	name for parameter
sqlType	the type of the parameter, as defined by java.sql.Types.
typeName	the fully qualified name of an SQL User Defined Type or the name of the SQL structured type referenced by a REF type. Ignored if the sqlType is not a UDT or REF type.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNull (int parameterIndex, int sqlType, String typeName)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to SQL NULL . This form of the setNull method should be used for User Defined Types and REF parameters.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
sqlType	the type of the parameter, as defined by `java.sql.Types` .
typeName	the fully qualified name of an SQL user defined type or the name of the SQL structured type referenced by a `REF` type. Ignored if the sqlType is not a UDT or REF type.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setNull (int parameterIndex, int sqlType)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to SQL NULL .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
sqlType	the type of the parameter, as defined by `java.sql.Types` .

Throws

SQLException	if an error occurs accessing the database.

public abstract void setObject ( String parameterName, Object theObject)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to a supplied Java object.

Parameters

parameterName	name for parameter
theObject	the Java object containing the data value.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setObject ( String parameterName, Object theObject, int targetSqlType)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to a supplied Java object.

Parameters

parameterName	name for parameter
theObject	the Java object containing the data value.
targetSqlType	the SQL type to send to the database, as defined in java.sql.Types.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setObject ( String parameterName, Object theObject, int targetSqlType, int scale)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to a supplied Java object.

Parameters

parameterName	name for parameter
theObject	the Java object containing the data value.
targetSqlType	the SQL type to send to the database, as defined in java.sql.Types.
scale	the number of digits after the decimal point, for java.sql.Types.DECIMAL and java.sql.Types.NUMERIC types. Ignored for all other types.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setObject (int parameterIndex, Object theObject, int targetSqlType, int scale)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to a supplied Java object.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theObject	the Java object containing the data value.
targetSqlType	the SQL type to send to the database, as defined in `java.sql.Types` .
scale	the number of digits after the decimal point, for `java.sql.Types.DECIMAL` and `java.sql.Types.NUMERIC` types. Ignored for all other types.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setObject (int parameterIndex, Object theObject)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to a supplied Java object.

The JDBC specification provides a standard mapping for Java objects to SQL data types. Database specific types can be mapped by JDBC driver specific Java types.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theObject	the Java object containing the data value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setObject (int parameterIndex, Object theObject, int targetSqlType)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to a supplied Java object.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theObject	the Java object containing the data value.
targetSqlType	the SQL type to send to the database, as defined in `java.sql.Types` .

Throws

SQLException	if an error occurs accessing the database.

public abstract void setPassword ( String password)

Added in API level 1

Sets the database Password for this RowSet . This property is used when a connection to the database is established. Therefore it should be set prior to invoking the execute() method.

Parameters

password	a `String` holding the password.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setQueryTimeout (int seconds)

Added in API level 1

Gets the timeout for the driver when a query operation is executed. If a query takes longer than the timeout, a SQLException is thrown.

Parameters

seconds	the number of seconds for the timeout.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setReadOnly (boolean readOnly)

Added in API level 1

Sets whether the RowSet is read-only or updatable.

Parameters

readOnly	`true` to set the `RowSet` to read-only state, `false` to allow updates.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setRef (int parameterIndex, Ref theRef)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Ref . This is sent to the database as an SQL REF value.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theRef	the value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setRowId (int parameterIndex, RowId theRowId)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the supplied RowId

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theRowId	the RowId value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setRowId ( String parameterName, RowId theRowId)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the supplied RowId.

Parameters

parameterName	name for parameter
theRowId	the RowId value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setSQLXML ( String parameterName, SQLXML theSQLXML)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the supplied SQLXML.

Parameters

parameterName	name for parameter
theSQLXML	the SQLXML value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setSQLXML (int parameterIndex, SQLXML theSQLXML)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to the supplied SQLXML

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theSQLXML	the SQLXML value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setShort (int parameterIndex, short theShort)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to a supplied short integer .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theShort	the value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setShort ( String parameterName, short theShort)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to a supplied short integer.

Parameters

parameterName	name for parameter
theShort	the short value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setString (int parameterIndex, String theString)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to a supplied String . The string is placed into the database as a VARCHAR or LONGVARCHAR SQL value, depending on the database limits for the length of VARCHAR values.

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theString	the value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setString ( String parameterName, String theString)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to a supplied String. The String is placed into the database as a VARCHAR or LONGVARCHAR SQL value, depending on the database limits for the length of VARCHAR values.

Parameters

parameterName	name for parameter

Throws

SQLException	if an error occurs accessing the database.

public abstract void setTime (int parameterIndex, Time theTime)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time , converting it to an SQL TIME value using the system default Calendar .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theTime	the value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setTime ( String parameterName, Time theTime, Calendar theCalendar)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting to an SQL TIME value using a supplied Calendar.

Parameters

parameterName	name for parameter
theTime	the Time value to set
theCalendar	the Calendar to use in the conversion operation

Throws

SQLException	if an error occurs accessing the database.

public abstract void setTime (int parameterIndex, Time theTime, Calendar theCalendar)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time , converting it to an SQL TIME value using a supplied Calendar .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theTime	the value to which the parameter is set.
theCalendar	the `Calendar` to use in the conversion operation.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setTime ( String parameterName, Time theTime)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting to an SQL TIME value using a supplied Calendar.

Parameters

parameterName	name for parameter
theTime	the Time value to set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setTimestamp (int parameterIndex, Timestamp theTimestamp, Calendar theCalendar)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp , converting it to an SQL TIMESTAMP value using a supplied Calendar .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theTimestamp	the value to which the parameter is set.
theCalendar	the `Calendar` to use in the conversion operation

Throws

SQLException	if an error occurs accessing the database.

public abstract void setTimestamp ( String parameterName, Timestamp theTimestamp, Calendar theCalendar)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using a supplied Calendar.

Parameters

parameterName	name for parameter
theTimestamp	the value to which the parameter is set
theCalendar	the Calendar to use in the conversion operation

Throws

SQLException	if an error occurs accessing the database.

public abstract void setTimestamp ( String parameterName, Timestamp theTimestamp)

Added in API level 9

Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using the system default Calendar .

Parameters

parameterName	name for parameter
theTimestamp	the value to which the parameter is set

Throws

SQLException	if an error occurs accessing the database.

public abstract void setTimestamp (int parameterIndex, Timestamp theTimestamp)

Added in API level 1

Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp , converting it to an SQL TIMESTAMP value using the system default Calendar .

Parameters

parameterIndex	the index of the parameter to set; the first parameter's index is 1.
theTimestamp	the value to which the parameter is set.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setTransactionIsolation (int level)

Added in API level 1

Sets the target instance's transaction isolation level to one of a discrete set of possible values. The transaction isolation level defines the policy implemented on the database for maintaining the data values consistent.

Keep in mind that setting a transaction isolation level has no effect unless your driver and DBMS support it.

Parameters

level	the transaction isolation level. One of: `Connection.TRANSACTION_READ_UNCOMMITTED` `Connection.TRANSACTION_READ_COMMITTED` `Connection.TRANSACTION_REPEATABLE_READ` `Connection.TRANSACTION_SERIALIZABLE`

Throws

SQLException	if an error occurs accessing the database.

public abstract void setType (int type)

Added in API level 1

Sets the type of this RowSet . By default, the type is non-scrollable.

Parameters

type	the type for the `RowSet` . One of: `ResultSet.TYPE_FORWARD_ONLY` `ResultSet.TYPE_SCROLL_INSENSITIVE` `ResultSet.TYPE_SCROLL_SENSITIVE`

Throws

SQLException	if an error occurs accessing the database.

>)">

public abstract void setTypeMap ( Map < String , Class <?>> theTypeMap)

Added in API level 1

Sets the mapping of SQL User Defined Types (UDTs) to Java classes. The Java classes must all implement the SQLData interface.

Parameters

theTypeMap	the names of SQL UDTs and the Java classes to which they are mapped.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setURL (int parameterIndex, URL theURL)

Added in API level 9

Sets the URL used by this RowSet to access the database via a DriverManager . The URL is optional - an alternative is to use a Data Source Name to create a connection.

Parameters

parameterIndex	index of the parameter to set, where the first parameter has index = 1.
theURL	a java.net.URL containing the URL for the database.

Throws

SQLException	if an error occurs accessing the database.

public abstract void setUrl ( String theURL)

Added in API level 1

Sets the URL used by this RowSet to access the database via a DriverManager . The URL is optional - an alternative is to use a database name to create a connection.

Parameters

theURL	the URL for the database. Can be `null` .

Throws

SQLException	if an error occurs accessing the database.

public abstract void setUsername ( String theUsername)

Added in API level 1

Sets the Username property for the RowSet , used to authenticate a connection to the database.

Parameters

theUsername	the new user name for this row set.

Throws

SQLException	if an error occurs accessing the database.

Results

Interfaces

Classes

RowSet

Class Overview

See Also

Summary

Public Methods

public abstract void addRowSetListener ( RowSetListener theListener)

Parameters

public abstract void clearParameters ()

Throws

public abstract void execute ()

Throws

See Also

public abstract String getCommand ()

Returns

public abstract String getDataSourceName ()

Returns

public abstract boolean getEscapeProcessing ()

Returns

Throws

public abstract int getMaxFieldSize ()

Returns

Throws

public abstract int getMaxRows ()

Returns

Throws

public abstract String getPassword ()

Returns

public abstract int getQueryTimeout ()

Returns

Throws

public abstract int getTransactionIsolation ()

Returns

See Also

public abstract Map < String , Class <?>> getTypeMap ()

Returns

Throws

public abstract String getUrl ()

Returns

Throws

public abstract String getUsername ()

Returns

public abstract boolean isReadOnly ()

Returns

public abstract void removeRowSetListener ( RowSetListener theListener)

Parameters

public abstract void setArray (int parameterIndex, Array theArray)

Parameters

Throws

public abstract void setAsciiStream (int parameterIndex, InputStream theInputStream, int length)

Parameters

Throws

public abstract void setAsciiStream ( String parameterName, InputStream theInputStream, int length)

Parameters

Throws

public abstract void setAsciiStream ( String parameterName, InputStream theInputStream)

Parameters

Throws

public abstract void setAsciiStream (int parameterIndex, InputStream theInputStream)

Parameters

Throws

public abstract void setBigDecimal (int parameterIndex, BigDecimal theBigDecimal)

Parameters

Throws

public abstract void setBigDecimal ( String parameterName, BigDecimal theBigDecimal)

Parameters

Throws

public abstract void setBinaryStream (int parameterIndex, InputStream theInputStream)

Parameters

Throws

public abstract void setBinaryStream ( String parameterName, InputStream theInputStream)

Parameters

Throws

public abstract void setBinaryStream (int parameterIndex, InputStream theInputStream, int length)

Parameters

Throws

public abstract void setBinaryStream ( String parameterName, InputStream theInputStream, int length)

Parameters