SQLServerResultSet Members
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. |
| getDateTimeOffset | Retrieves the value of the specified column as aDateTimeOffset Class object. |
| 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 SQLServerResultSet object 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. |
| updateDateTimeOffset | Updates a DateTimeOffset Class column. |
| 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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for