Muokkaa

Jaa


SQLServerResultSet Members

Download JDBC driver

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

SQLServerResultSet Class