SQLServerResultSet Members

 

DownloadDownload JDBC Driver

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

None.

NameDescription
CONCUR_SS_OPTIMISTIC_CCUsed to specify a SQL Server read/write optimistic concurrency type with no row locks.
CONCUR_SS_OPTIMISTIC_CCVALUsed to specify a SQL Server read/write optimistic concurrency type with no row locks.
CONCUR_SS_SCROLL_LOCKSUsed to specify a SQL Server read/write optimistic concurrency type with row locks.
TYPE_SS_DIRECT_FORWARD_ONLYUsed to specify a SQL Server fast forward-only, read-only cursor type.
TYPE_SS_SCROLL_DYNAMICUsed to specify a SQL Server dynamic cursor type.
TYPE_SS_SCROLL_KEYSETUsed to specify a SQL Server keyset cursor type.
TYPE_SS_SCROLL_STATICUsed to specify a SQL Server static cursor type.
TYPE_SS_SERVER_CURSOR_FORWARD_ONLYUsed to specify a SQL Server fast forward-only, read-only cursor type.
Class inherited from:Description
java.sql.ResultSetCLOSE_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
NameDescription
absoluteMoves the cursor to the specified row in this SQLServerResultSet object.
afterLastMoves the cursor to after the last row of this SQLServerResultSet object.
beforeFirstMoves the cursor to before the first row of this SQLServerResultSet object.
cancelRowUpdatesCancels the updates made to the current row in this SQLServerResultSet object.
clearWarningsClears all warnings reported on this SQLServerResultSet object.
closeReleases this SQLServerResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
deleteRowDeletes the current row from thisSQLServerResultSet object and from the underlying database.
finalizeExplicitly closes this SQLServerResultSet object.
findColumnRetrieves the index of the first matching column for the specified column name in this SQLServerResultSet object.
firstMoves the cursor to the first row of this SQLServerResultSet object.
getArrayRetrieves the value of the designated column in the current row of this SQLServerResultSet object as an Array object.
getAsciiStreamRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a stream of ASCII characters.
getBigDecimalRetrieves the value of the designated column index in the current row of this SQLServerResultSet object as a java.math.BigDecimal.
getBinaryStreamRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a binary stream of uninterpreted bytes.
getBlobRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a Blob object in the Java programming language.
getBooleanRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a boolean in the Java programming language.
getByteRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a byte in the Java programming language.
getBytesRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a byte array in the Java programming language.
getCharacterStreamRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a java.io.Reader object.
getClobRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a Clob object in the Java programming language.
getConcurrencyRetrieves the concurrency mode of this SQLServerResultSet object.
getCursorNameRetrieves the name of the SQL cursor used by this SQLServerResultSet object.
getDateRetrieves 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.
getDateTimeOffsetRetrieves the value of the specified column as aDateTimeOffset Class object.
getDoubleRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a double in the Java programming language.
getFetchDirectionRetrieves the fetch direction for this SQLServerResultSet object.
getFetchSizeRetrieves the fetch size for this SQLServerResultSet object.
getFloatRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a float in the Java programming language.
getHoldabilityRetrieves the holdability of this SQLServerResultSet object.
getIntRetrieves the value of the designated column in the current row of this SQLServerResultSet object as an int in the Java programming language.
getLongRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a long in the Java programming language.
getMetaDataRetrieves the number, types, and properties of this SQLServerResultSet object's columns.
getNCharacterStreamRetrieves the value of the designated column in the current row of the SQLServerResultSet object as a Reader object.
getNClobRetrieves the value of the designated column in the current row of the SQLServerResultSetobject as an NClob object in the Java programming language.
getNStringRetrieves the value of the designated column in the current row of the SQLServerResultSet object as a String in the Java programming language.
getObjectGets the value of the designated column in the current row of this SQLServerResultSet object as an object in the Java programming language.
getRefRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a Ref object in the Java programming language.
getRowRetrieves the current row number.
getShortRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a short in the Java programming language.
getStatementRetrieves the SQLServerStatement object that produced this SQLServerResultSet object.
getStringRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a String in the Java programming language.
getSQLXMLRetrieves the value of the designated column in the current row of the SQLServerResultSet object as a SQLXML object.
getTimeRetrieves 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.
getTimestampRetrieves 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.
getTypeRetrieves the cursor type of this SQLServerResultSet object.
getUnicodeStreamRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a stream of Unicode characters.
getURLRetrieves the value of the designated column in the current row of this SQLServerResultSet object as a URL object.
getWarningsRetrieves the first warning reported by calls on this SQLServerResultSet object.
insertRowInserts the contents of the insert row into this SQLServerResultSet object and into the database.
isAfterLastRetrieves whether the cursor is after the last row in this SQLServerResultSet object.
isBeforeFirstRetrieves whether the cursor is before the first row in this SQLServerResultSet object.
isClosedIndicates whether this SQLServerResultSet object has been closed.
isFirstRetrieves whether the cursor is on the first row of this SQLServerResultSet object.
isLastRetrieves whether the cursor is on the last row of this SQLServerResultSet object.
lastMoves the cursor to the last row in this SQLServerResultSet object.
moveToCurrentRowMoves the cursor to the remembered cursor position, usually the current row.
moveToInsertRowMoves the cursor to the insert row.
nextMoves the cursor down one row from its current position.
previousMoves the cursor to the previous row in this SQLServerResultSet object.
refreshRowRefreshes the current row with its most recent value in the database.
relativeMoves the cursor the given amount of rows, relative to the current row, in either a positive or a negative direction.
rowDeletedRetrieves whether a row has been deleted.
rowInsertedRetrieves whether the current row has had an insertion.
rowUpdatedRetrieves whether the current row has been updated.
setFetchDirectionGives a hint as to the direction in which the rows in this SQLServerResultSet object will be processed.
setFetchSizeGives 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.
updateArrayUpdates the designated column with an Array object.
updateAsciiStreamUpdates the designated column with an ASCII stream value.
updateBigDecimalUpdates the designated column with a BigDecimal object.
updateBinaryStreamUpdates the designated column with a binary stream value.
updateBlobUpdates the designated column with a java.sql.Blob value.
updateBooleanUpdates the designated column with a boolean value.
updateByteUpdates the designated column with a byte value.
updateBytesUpdates the designated column with an array of byte values.
updateCharacterStreamUpdates the designated column with a character stream value.
updateClobUpdates the designated column with a java.sql.Clob value.
updateDateUpdates the designated column with a date value.
updateDateTimeOffsetUpdates a DateTimeOffset Class column.
updateDoubleUpdates the designated column with a double value.
updateFloatUpdates the designated column with a float value.
updateIntUpdates the designated column with an int value.
updateLongUpdates the designated column with a long value.
updateNCharacterStreamUpdates the designated column with a character stream value.
updateNClobUpdates the designated column with the specified object value.
updateNStringUpdates the designated column with a String value.
updateNullUpdates the designated column with a null value.
updateObjectUpdates the designated column with an Object value.
updateRefUpdates the designated column with a java.sql.Ref value.
updateRowUpdates the underlying database with the new contents of the current row of this SQLServerResultSet object.
updateShortUpdates the designated column with a short value.
updateStringUpdates the designated column with a String value.
updateSQLXMLUpdates the designated column with a SQLXML value.
updateTimeUpdates the designated column with a time value.
updateTimestampUpdates the designated column with a timestamp value.
wasNullVerifies whether the last value read was a null value.
Class inherited from:Methods
java.lang.Objectclone, equals, getClass, hashCode, notify, notifyAll, toString, wait
java.sql.WrapperisWrapperFor, unwrap

SQLServerResultSet Class

Community Additions

ADD
Show: