Document Details

CommendableLightYear

Uploaded by CommendableLightYear

Tata Consultancy Services

Tags

java programming database JDBC ResultSet

Summary

This document provides detailed information about ResultSet methods in Java programming, useful for developers working with databases using JDBC. The document discusses a wide array of methods related to data retrieval, insertion, updates, and cursor manipulation with ResultSet objects.

Full Transcript

# ResultSetFMs ## ResultSet Fields and Methods | Return Type | Method Signature | Method Definition | |---|---|---| | `<T> T` | `getObject(String columnLabel, Class<T> type)` | Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL ty...

# ResultSetFMs ## ResultSet Fields and Methods | Return Type | Method Signature | Method Definition | |---|---|---| | `<T> T` | `getObject(String columnLabel, Class<T> type)` | Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported. | | `<T> T` | `getObject(int columnIndex, Class<T> type)` | Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported. | | `Array` | `getArray(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language. | | `Array` | `getArray(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language. | | `BigDecimal` | `getBigDecimal(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision. | | `BigDecimal` | `getBigDecimal(String columnLabel, int scale)` | Deprecated. | | `BigDecimal` | `getBigDecimal(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision. | | `BigDecimal` | `getBigDecimal(int columnIndex, int scale)` | Deprecated. | | `Blob` | `getBlob(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language. | | `Blob` | `getBlob(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language. | | `Clob` | `getClob(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language. | | `Clob` | `getClob(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language. | | `Date` | `getDate(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language. | | `Date` | `getDate(String columnLabel, Calendar cal)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language. | | `Date` | `getDate(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language. | | `Date` | `getDate(int columnIndex, Calendar cal)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language. | | `InputStream` | `getAsciiStream(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. | | `InputStream` | `getAsciiStream(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. | | `InputStream` | `getBinaryStream(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes. | | `InputStream` | `getBinaryStream(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes. | | `InputStream` | `getUnicodeStream(String columnLabel)` | use getCharacterStream instead | | `InputStream` | `getUnicodeStream(int columnIndex)` | use getCharacterStream in place of getUnicodeStream | | `NClob` | `getNClob(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language. | | `NClob` | `getNClob(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language. | | `Object` | `getObject(String columnLabel)` | Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. | | `Object` | `getObject(String columnLabel, Map<String, Class<?>> map)` | Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. | | `Object` | `getObject(int columnIndex)` | Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. | | `Object` | `getObject(int columnIndex, Map<String, Class<?>> map)` | Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. | | `Reader` | `getCharacterStream(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. | | `Reader` | `getCharacterStream(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. | | `Reader` | `getNCharacterStream(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. | | `Reader` | `getNCharacterStream(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. | | `Ref` | `getRef(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language. | | `Ref` | `getRef(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language. | | `ResultSetMetaData` | `getMetaData()` | Retrieves the number, types and properties of this ResultSet object's columns. | | `RowId` | `getRowId(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Rowld object in the Java programming language. | | `RowId` | `getRowId(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Rowld object in the Java programming language. | | `SQLWarning` | `getWarnings()` | Retrieves the first warning reported by calls on this ResultSet object. | | `SQLXML` | `getSQLXML(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language. | | `SQLXML` | `getSQLXML(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language. | | `Statement` | `getStatement()` | Retrieves the Statement object that produced this ResultSet object. | | `String` | `getCursorName()` | Retrieves the name of the SQL cursor used by this ResultSet object. | | `String` | `getNString(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. | | `String` | `getNString(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. | | `String` | `getString(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. | | `String` | `getString(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. | | `Time` | `getTime(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language. | | `Time` | `getTime(String columnLabel, Calendar cal)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language. | | `Time` | `getTime(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language. | | `Time` | `getTime(int columnIndex, Calendar cal)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language. | | `Timestamp` | `getTimestamp(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. | | `Timestamp` | `getTimestamp(String columnLabel, Calendar cal)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. | | `Timestamp` | `getTimestamp(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. | | `Timestamp` | `getTimestamp(int columnIndex, Calendar cal)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. | | `URL` | `getURL(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language. | | `URL` | `getURL(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language. | | `boolean` | `absolute(int row)` | Moves the cursor to the given row number in this ResultSet object. | | `boolean` | `first()` | Moves the cursor to the first row in this ResultSet object. | | `boolean` | `getBoolean(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language. | | `boolean` | `getBoolean(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language. | | `boolean` | `isAfterLast()` | Retrieves whether the cursor is after the last row in this ResultSet object. | | `boolean` | `isBeforeFirst()` | Retrieves whether the cursor is before the first row in this ResultSet object. | | `boolean` | `isClosed()` | Retrieves whether this ResultSet object has been closed. | | `boolean` | `isFirst()` | Retrieves whether the cursor is on the first row of this ResultSet object. | | `boolean` | `isLast()` | Retrieves whether the cursor is on the last row of this ResultSet object. | | `boolean` | `last()` | Moves the cursor to the last row in this ResultSet object. | | `boolean` | `next()` | Moves the cursor forward one row from its current position. | | `boolean` | `previous()` | Moves the cursor to the previous row in this ResultSet object. | | `boolean` | `relative(int rows)` | Moves the cursor a relative number of rows, either positive or negative. | | `boolean` | `rowDeleted()` | Retrieves whether a row has been deleted. | | `boolean` | `rowInserted()` | Retrieves whether the current row has had an insertion. | | `boolean` | `rowUpdated()` | Retrieves whether the current row has been updated. | | `boolean` | `wasNull()` | Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language. | | `byte` | `getByte(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language. | | `byte` | `getByte(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language. | | `byte[]` | `getBytes(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. | | `byte[]` | `getBytes(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. | | `default void` | `updateObject(String columnLabel, Object x, SQLType targetSqlType)` | Updates the designated column with an Object value. | | `default void` | `updateObject(String columnLabel, Object x, SQLType targetSqlType, int scaleÓrLength)` | Updates the designated column with an Object value. | | `default void` | `updateObject(int columnIndex, Object x, SQLType targetSqlType)` | Updates the designated column with an Object value. | | `default void` | `updateObject(int columnIndex, Object x, SQLType targetSqlType, int scaleOrLength)` | Updates the designated column with an Object value. | | `double` | `getDouble(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language. | | `double` | `getDouble(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language. | | `float` | `getFloat(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language. | | `float` | `getFloat(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language. | | `int` | `findColumn(String columnLabel)` | Maps the given ResultSet column label to its ResultSet column index. | | `int` | `getConcurrency()` | Retrieves the concurrency mode of this ResultSet object. | | `int` | `getFetchDirection()` | Retrieves the fetch direction for this ResultSet object. | | `int` | `getFetchSize()` | Retrieves the fetch size for this ResultSet object. | | `int` | `getHoldability()` | Retrieves the holdability of this ResultSet object | | `int` | `getInt(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language. | | `int` | `getInt(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language. | | `int` | `getRow()` | Retrieves the current row number. | | `int` | `getType()` | Retrieves the type of this ResultSet object. | | `long` | `getLong(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language. | | `long` | `getLong(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language. | | `short` | `getShort(String columnLabel)` | Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language. | | `short` | `getShort(int columnIndex)` | Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language. | | `void` | `afterLast()` | Moves the cursor to the end of this ResultSet object, just after the last row. | | `void` | `beforeFirst()` | Moves the cursor to the front of this ResultSet object, just before the first row. | | `void` | `cancelRowUpdates()` | Cancels the updates made to the current row in this ResultSet object. | | `void` | `clearWarnings()` | Clears all warnings reported on this ResultSet object. | | `void` | `close()` | Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. | | `void` | `deleteRow()` | Deletes the current row from this ResultSet object and from the underlying database. | | `void` | `insertRow()` | Inserts the contents of the insert row into this ResultSet object and into the database. | | `void` | `moveToCurrentRow()` | Moves the cursor to the remembered cursor position, usually the current row. | | `void` | `moveToInsertRow()` | Moves the cursor to the insert row. | | `void` | `refreshRow()` | Refreshes the current row with its most recent value in the database. | | `void` | `setFetchDirection(int direction)` | Gives a hint as to the direction in which the rows in this ResultSet object will be processed. | | `void` | `setFetchSize(int rows)` | 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 ResultSet object. | | `void` | `updateArray(String columnLabel, Array x)` | Updates the designated column with a java.sql.Array value. | | `void` | `updateArray(int columnIndex, Array x)` | Updates the designated column with a java.sql.Array value. | | `void` | `updateAsciiStream(String columnLabel, InputStream x)` | Updates the designated column with an ascii stream value. | | `void` | `updateAsciiStream(String columnLabel, InputStream x, int length)` | Updates the designated column with an ascii stream value, which will have the specified number of bytes. | | `void` | `updateAsciiStream(String columnLabel, InputStream x, long length)` | Updates the designated column with an ascii stream value, which will have the specified number of bytes. | | `void` | `updateAsciiStream(int columnIndex, InputStream x)` | Updates the designated column with an ascii stream value. | | `void` | `updateAsciiStream(int columnIndex, InputStream x, int length)` | Updates the designated column with an ascii stream value, which will have the specified number of bytes. | | `void` | `updateAsciiStream(int columnIndex, InputStream x, long length)` | Updates the designated column with an ascii stream value, which will have the specified number of bytes. | | `void` | `updateBigDecimal(String columnLabel, BigDecimal x)` | Updates the designated column with a java.sql.BigDecimal value. | | `void` | `updateBigDecimal(int columnIndex, BigDecimal x)` | Updates the designated column with a java.math.BigDecimal value. | | `void` | `updateBinaryStream(String columnLabel, InputStream x)` | Updates the designated column with a binary stream value. | | `void` | `updateBinaryStream(String columnLabel, InputStream x, int length)` | Updates the designated column with a binary stream value, which will have the specified number of bytes. | | `void` | `updateBinaryStream(String columnLabel, InputStream x, long length)` | Updates the designated column with a binary stream value, which will have the specified number of bytes. | | `void` | `updateBinaryStream(int columnIndex, InputStream x)` | Updates the designated column with a binary stream value. | | `void` | `updateBinaryStream(int columnIndex, InputStream x, int length)` | Updates the designated column with a binary stream value, which will have the specified number of bytes. | | `void` | `updateBinaryStream(int columnIndex, InputStream x, long length)` | Updates the designated column with a binary stream value, which will have the specified number of bytes. | | `void` | `updateBlob(String columnLabel, Blob x)` | Updates the designated column with a java.sql.Blob value. | | `void` | `updateBlob(String columnLabel, InputStream inputStream)` | Updates the designated column using the given input stream.| | `void` | `updateBlob(String columnLabel, InputStream inputStream, long length)` | Updates the designated column using the given input stream, which will have the specified number of bytes. | | `void` | `updateBlob(int columnIndex, Blob x)` | Updates the designated column with a java.sql.Blob value. | | `void` | `updateBlob(int columnIndex, InputStream inputStream)` | Updates the designated column using the given input stream.| | `void` | `updateBlob(int columnIndex, InputStream inputStream, long length)` | Updates the designated column using the given input stream, which will have the specified number of bytes. | | `void` | `updateBoolean(String columnLabel, boolean x)` | Updates the designated column with a boolean value. | | `void` | `updateBoolean(int columnIndex, boolean x)` | Updates the designated column with a boolean value. | | `void` | `updateByte(String columnLabel, byte x)` | Updates the designated column with a byte value. | | `void` | `updateByte(int columnIndex, byte x)` | Updates the designated column with a byte value. | | `void` | `updateBytes(String columnLabel, byte[] x)` | Updates the designated column with a byte array value. | | `void` | `updateBytes(int columnIndex, byte[] x)` | Updates the designated column with a byte array value. | | `void` | `updateCharacterStream(String columnLabel, Reader reader)` | Updates the designated column with a character stream value. | | `void` | `updateCharacterStream(String columnLabel, Reader reader, int length)` | Updates the designated column with a character stream value, which will have the specified number of bytes. | | `void` | `updateCharacterStream(String columnLabel, Reader reader, long length)` | Updates the designated column with a character stream value, which will have the specified number of bytes. | | `void` | `updateCharacterStream(int columnIndex, Reader x)` | Updates the designated column with a character stream value. | | `void` | `updateCharacterStream(int columnIndex, Reader x, int length)` | Updates the designated column with a character stream value, which will have the specified number of bytes. | | `void` | `updateCharacterStream(int columnIndex, Reader x, long length)` | Updates the designated column with a character stream value, which will have the specified number of bytes. | | `void` | `updateClob(String columnLabel, Clob x)` | Updates the designated column with a java.sql.Clob value. | | `void` | `updateClob(String columnLabel, Reader reader)` | Updates the designated column using the given Reader object.| | `void` | `updateClob(String columnLabel, Reader reader, long length)` | Updates the designated column using the given Reader object, which is the given number of characters long. | | `void` | `updateClob(int columnIndex, Clob x)` | Updates the designated column with a java.sql.Clob value. | | `void` | `updateClob(int columnIndex, Reader reader)` | Updates the designated column using the given Reader object.| | `void` | `updateClob(int columnIndex, Reader reader, long length)` | Updates the designated column using the given Reader object, which is the given number of characters long. | | `void` | `updateDate(String columnLabel, Date x)` | Updates the designated column with a java.sql.Date value. | | `void` | `updateDate(int columnIndex, Date x)` | Updates the designated column with a java.sql.Date value. | | `void` | `updateDouble(String columnLabel, double x)` | Updates the designated column with a double value. | | `void` | `updateDouble(int columnIndex, double x)` | Updates the designated column with a double value. | | `void` | `updateFloat(String columnLabel, float x)` | Updates the designated column with a float value. | | `void` | `updateFloat(int columnIndex, float x)` | Updates the designated column with a float value. | | `void` | `updateInt(String columnLabel, int x)` | Updates the designated column with an int value. | | `void` | `updateInt(int columnIndex, int x)` | Updates the designated column with an int value. | | `void` | `updateLong(String columnLabel, long x)` | Updates the designated column with a long value. | | `void` | `updateLong(int columnIndex, long x)` | Updates the designated column with a long value. | | `void` | `updateNCharacterStream(String columnLabel, Reader reader)` | Updates the designated column with a character stream value. | | `void` | `updateNCharacterStream(String columnLabel, Reader reader, int length)` | Updates the designated column with a character stream value, which will have the specified number of bytes. | | `void` | `updateNCharacterStream(String columnLabel, Reader reader, long length)` | Updates the designated column with a character stream value, which will have the specified number of bytes. | | `void` | `updateNCharacterStream(int columnIndex, Reader x)` | Updates the designated column with a character stream value. | | `void` | `updateNCharacterStream(int columnIndex, Reader x, int length)` | Updates the designated column with a character stream value, which will have the specified number of bytes. | | `void` | `updateNCharacterStream(int columnIndex, Reader x, long length)` | Updates the designated column with a character stream value, which will have the specified number of bytes. | | `void` | `updateNClob(String columnLabel, NClob nClob)` | Updates the designated column with a java.sql.NClob value. | | `void` | `updateNClob(String columnLabel, Reader reader)` | Updates the designated column using the given Reader object.| | `void` | `updateNClob(String columnLabel, Reader reader, long length)` | Updates the designated column using the given Reader object, which is the given number of characters long. | | `void` | `updateNClob(int columnIndex, NClob nClob)` | Updates the designated column with a java.sql.NClob value. | | `void` | `updateNClob(int columnIndex, Reader reader)` | Updates the designated column using the given Reader The data will be read from the stream as needed until end-of-stream is reached. | | `void` | `updateNClob(int columnIndex, Reader reader, long length)` | Updates the designated column using the given Reader object, which is the given number of characters long. | | `void` | `updateNString(String columnLabel, String nString)` | Updates the designated column with a String value. | | `void` | `updateNString(int columnIndex, String nString)` | Updates the designated column with a String value. | | `void` | `updateNull(String columnLabel)` | Updates the designated column with a null value. | | `void` | `updateNull(int columnIndex)` | Updates the designated column with a null value. | | `void` | `updateObject(String columnLabel, Object x)` | Updates the designated column with an Object value. | | `void` | `updateObject(String columnLabel, Object x, int scaleOrLength)` | Updates the designated column with an Object value. | | `void` | `updateObject(int columnIndex, Object x)` | Updates the designated column with an Object value. | | `void` | `updateObject(int columnIndex, Object x, int scaleOrLength)` | Updates the designated column with an Object value. | | `void` | `updateRef(String columnLabel, Ref x)` | Updates the designated column with a java.sql.Ref value. | | `void` | `updateRef(int columnIndex, Ref x)` | Updates the designated column with a java.sql.Ref value. | | `void` | `updateRow()` | Updates the underlying database with the new contents of the current row of this ResultSet object. | | `void` | `updateRowId(String columnLabel, Rowld x)` | Updates the designated column with a Rowld value. | | `void` | `updateRowId(int columnIndex, Rowld x)` | Updates the designated column with a Rowld value. | | `void` | `updateSQLXML(String columnLabel, SQLXML xmlObject)` | Updates the designated column with a java.sql.SQLXML value. | | `void` | `updateSQLXML(int columnIndex, SQLXML xmlObject)` | Updates the designated column with a java.sql.SQLXML value. | | `void` | `updateShort(String columnLabel, short x)` | Updates the designated column with a short value. | | `void` | `updateShort(int columnIndex, short x)` | Updates the designated column with a short value. | | `void` | `updateString(String columnLabel, String x)` | Updates the designated column with a String value. | | `void` | `updateString(int columnIndex, String x)` | Updates the designated column with a String value. | | `void` | `updateTime(String columnLabel, Time x)` | Updates the designated column with a java.sql.Time value. | | `void` | `updateTime(int columnIndex, Time x)` | Updates the designated column with a java.sql.Time value. | | `void` | `updateTimestamp(String columnLabel, Timestamp x)` | Updates the designated column with a java.sql.Timestamp value. | | `void` | `updateTimestamp(int columnIndex, Timestamp x)` | Updates the designated column with a java.sql.Timestamp value. | | `void` | `updateTimestamp(String columnLabel, Timestamp x, Calendar cal)` | Updates the designated column with a java.sql.Timestamp object in the Java programming language. | | `void` | `updateTimestamp(int columnIndex, Timestamp x, Calendar cal)` | Updates the designated column with a java.sql.Timestamp object in the Java programming language.| | `void` | `updateTimestamp(String columnLabel, Timestamp x) ` | Updates the designated column with a java.sql.Timestamp object in the Java programming language.| | `void` | `updateTimestamp(int columnIndex, Timestamp x)` | Updates the designated column with a java.sql.Timestamp object in the Java programming language.| | `void` | `updateTimestamp(String columnLabel, Timestamp x, Calendar cal)` | Updates the designated column with a java.sql.Timestamp object in the Java programming language.| | `void` | `updateTimestamp(int columnIndex, Timestamp x, Calendar cal)` | Updates the designated column with a java.sql.Timestamp object in the Java programming language.| | `void` | `updateURL(String columnLabel, URL x)` | Updates the designated column with a java.net.URL object in the Java programming language. | | `void` | `updateURL(int columnIndex, URL x)` | Updates the designated column with a java.net.URL object in the Java programming language. | | `void` | `updateXXX(String columnLabel, XXX x)` | Updates the designated column with a XXX value. | | `void` | `updateXXX(int columnIndex, XXX x)` | Updates the designated column with a XXX value. | ## ResultSet Constants | Constant Field | Field Definition | |---|---| | `static int CLOSE_CURSORS_AT_COMMIT` | The constant indicating that open `ResultSet` objects with this holdability will be closed when the current transaction is committed. | | `static int CONCUR_READ_ONLY` | The constant indicating the concurrency mode for a `ResultSet` object that may NOT be updated. | | `static int CONCUR_UPDATABLE` | The constant indicating the concurrency mode for a `ResultSet` object that may be updated. | | `static int FETCH_FORWARD` | The constant indicating that the rows in a result set will be processed in a forward direction; first-to-last. | | `static int FETCH_REVERSE` | The constant indicating that the rows in a result set will be processed in a reverse direction; last-to-first. | | `static int FETCH_UNKNOWN` | The constant indicating that the order in which rows in a result set will be processed is unknown. | | `static int HOLD_CURSORS_OVER_COMMIT` | The constant indicating that open `ResultSet` objects with this holdability will remain open when the current transaction is committed. | | `static int TYPE_FORWARD_ONLY` | The constant indicating the type for a `ResultSet` object whose cursor may move only forward. | | `static int TYPE_SCROLL_INSENSITIVE` | The constant indicating the type for a `ResultSet` object that is scrollable but generally not sensitive to changes to the data that underlies the `ResultSet`. | | `static int TYPE_SCROLL_SENSITIVE` | The constant indicating the type for a `ResultSet` object that is scrollable and generally sensitive to changes to the data that underlies the `ResultSet`. |

Use Quizgecko on...
Browser
Browser