Share via

SQLServerResultSet Members

  • Article

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

See Also

Reference

SQLServerResultSet Class