SQLServerResultSet Members

Article
03/16/2009

The following tables list the members that are exposed by the SQLServerResultSet class.

Constructors

None.

Fields

Name	Description
CONCUR_SS_OPTIMISTIC_CC	Used to specify a SQL Server read/write optimistic concurrency type with no row locks.
CONCUR_SS_OPTIMISTIC_CCVAL	Used to specify a SQL Server read/write optimistic concurrency type with no row locks.
CONCUR_SS_SCROLL_LOCKS	Used to specify a SQL Server read/write optimistic concurrency type with row locks.
TYPE_SS_DIRECT_FORWARD_ONLY	Used to specify a SQL Server fast forward-only, read-only cursor type.
TYPE_SS_SCROLL_DYNAMIC	Used to specify a SQL Server dynamic cursor type.
TYPE_SS_SCROLL_KEYSET	Used to specify a SQL Server keyset cursor type.
TYPE_SS_SCROLL_STATIC	Used to specify a SQL Server static cursor type.
TYPE_SS_SERVER_CURSOR_FORWARD_ONLY	Used to specify a SQL Server fast forward-only, read-only cursor type.

Inherited Fields

Class inherited from:	Description
java.sql.ResultSet	CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Methods

Name	Description
absolute	Moves the cursor to the specified row in this SQLServerResultSet object.
afterLast	Moves the cursor to after the last row of this SQLServerResultSet object.
beforeFirst	Moves the cursor to before the first row of this SQLServerResultSet object.
cancelRowUpdates	Cancels the updates made to the current row in this SQLServerResultSet object.
clearWarnings	Clears all warnings reported on this SQLServerResultSet object.
close	Releases this SQLServerResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
deleteRow	Deletes the current row from thisSQLServerResultSet object and from the underlying database.
finalize	Explicitly closes this SQLServerResultSet object.
findColumn	Retrieves the index of the first matching column for the specified column name in this SQLServerResultSet object.
first	Moves the cursor to the first row of this SQLServerResultSet object.
getArray	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as an Array object.
getAsciiStream	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a stream of ASCII characters.
getBigDecimal	Retrieves the value of the designated column index in the current row of this SQLServerResultSet object as a java.math.BigDecimal.
getBinaryStream	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a binary stream of uninterpreted bytes.
getBlob	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a Blob object in the Java programming language.
getBoolean	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a boolean in the Java programming language.
getByte	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a byte in the Java programming language.
getBytes	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a byte array in the Java programming language.
getCharacterStream	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a java.io.Reader object.
getClob	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a Clob object in the Java programming language.
getConcurrency	Retrieves the concurrency mode of this SQLServerResultSet object.
getCursorName	Retrieves the name of the SQL cursor used by this SQLServerResultSet object.
getDate	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a java.sql.Date object in the Java programming language.
getDouble	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a double in the Java programming language.
getFetchDirection	Retrieves the fetch direction for this SQLServerResultSet object.
getFetchSize	Retrieves the fetch size for this SQLServerResultSet object.
getFloat	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a float in the Java programming language.
getHoldability	Retrieves the holdability of this SQLServerResultSet object.
getInt	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as an int in the Java programming language.
getLong	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a long in the Java programming language.
getMetaData	Retrieves the number, types, and properties of this SQLServerResultSet object's columns.
getNCharacterStream	Retrieves the value of the designated column in the current row of the SQLServerResultSet object as a Reader object.
getNClob	Retrieves the value of the designated column in the current row of the SQLServerResultSetobject as an NClob object in the Java programming language.
getNString	Retrieves the value of the designated column in the current row of the SQLServerResultSet object as a String in the Java programming language.
getObject	Gets the value of the designated column in the current row of this SQLServerResultSet object as an object in the Java programming language.
getRef	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a Ref object in the Java programming language.
getRow	Retrieves the current row number.
getShort	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a short in the Java programming language.
getStatement	Retrieves the SQLServerStatement object that produced this SQLServerResultSet object.
getString	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a String in the Java programming language.
getSQLXML	Retrieves the value of the designated column in the current row of the SQLServerResultSet object as a SQLXML object.
getTime	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a java.sql.Time object in the Java programming language.
getTimestamp	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a java.sql.Timestamp object in the Java programming language.
getType	Retrieves the cursor type of this SQLServerResultSet object.
getUnicodeStream	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a stream of Unicode characters.
getURL	Retrieves the value of the designated column in the current row of this SQLServerResultSet object as a URL object.
getWarnings	Retrieves the first warning reported by calls on this SQLServerResultSet object.
insertRow	Inserts the contents of the insert row into this SQLServerResultSet object and into the database.
isAfterLast	Retrieves whether the cursor is after the last row in this SQLServerResultSet object.
isBeforeFirst	Retrieves whether the cursor is before the first row in this SQLServerResultSet object.
isClosed	Indicates whether this SQLServerResultSet object has been closed.
isFirst	Retrieves whether the cursor is on the first row of this SQLServerResultSet object.
isLast	Retrieves whether the cursor is on the last row of this SQLServerResultSet object.
last	Moves the cursor to the last row in this SQLServerResultSet object.
moveToCurrentRow	Moves the cursor to the remembered cursor position, usually the current row.
moveToInsertRow	Moves the cursor to the insert row.
next	Moves the cursor down one row from its current position.
previous	Moves the cursor to the previous row in this SQLServerResultSet object.
refreshRow	Refreshes the current row with its most recent value in the database.
relative	Moves the cursor the given amount of rows, relative to the current row, in either a positive or a negative direction.
rowDeleted	Retrieves whether a row has been deleted.
rowInserted	Retrieves whether the current row has had an insertion.
rowUpdated	Retrieves whether the current row has been updated.
setFetchDirection	Gives a hint as to the direction in which the rows in this SQLServerResultSet object will be processed.
setFetchSize	Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this SQLServerResultSet object.
updateArray	Updates the designated column with an Array object.
updateAsciiStream	Updates the designated column with an ASCII stream value.
updateBigDecimal	Updates the designated column with a BigDecimal object.
updateBinaryStream	Updates the designated column with a binary stream value.
updateBlob	Updates the designated column with a java.sql.Blob value.
updateBoolean	Updates the designated column with a boolean value.
updateByte	Updates the designated column with a byte value.
updateBytes	Updates the designated column with an array of byte values.
updateCharacterStream	Updates the designated column with a character stream value.
updateClob	Updates the designated column with a java.sql.Clob value.
updateDate	Updates the designated column with a date value.
updateDouble	Updates the designated column with a double value.
updateFloat	Updates the designated column with a float value.
updateInt	Updates the designated column with an int value.
updateLong	Updates the designated column with a long value.
updateNCharacterStream	Updates the designated column with a character stream value.
updateNClob	Updates the designated column with the specified object value.
updateNString	Updates the designated column with a String value.
updateNull	Updates the designated column with a null value.
updateObject	Updates the designated column with an Object value.
updateRef	Updates the designated column with a java.sql.Ref value.
updateRow	Updates the underlying database with the new contents of the current row of this SQLServerResultSet object.
updateShort	Updates the designated column with a short value.
updateString	Updates the designated column with a String value.
updateSQLXML	Updates the designated column with a SQLXML value.
updateTime	Updates the designated column with a time value.
updateTimestamp	Updates the designated column with a timestamp value.
wasNull	Verifies whether the last value read was a null value.

Inherited Methods

Class inherited from:	Methods
java.lang.Object	clone, equals, getClass, hashCode, notify, notifyAll, toString, wait
java.sql.Wrapper	isWrapperFor, unwrap

SQLServerResultSet Members

Constructors

Fields

Inherited Fields

Methods

Inherited Methods

See Also

Reference

Additional resources