ResultSet Members

ResultSet Members

Interface Overview | This Package | All Packages

Methods
Name Description
clearWarnings() After this call getWarnings returns null until a new warning is reported for this ResultSet.
close() In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
findColumn(String) Map a Resultset column name to a ResultSet column index.
getAsciiStream(int) A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
getAsciiStream(String) A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
getBigDecimal(int, int) Get the value of a column in the current row as a java.lang.BigDecimal object.
getBigDecimal(String, int) Get the value of a column in the current row as a java.lang.BigDecimal object.
getBinaryStream(int) A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.
getBinaryStream(String) A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.
getBoolean(int) Get the value of a column in the current row as a Java boolean.
getBoolean(String) Get the value of a column in the current row as a Java boolean.
getByte(int) Get the value of a column in the current row as a Java byte.
getByte(String) Get the value of a column in the current row as a Java byte.
getBytes(int) Get the value of a column in the current row as a Java byte array.
getBytes(String) Get the value of a column in the current row as a Java byte array.
getCursorName() Get the name of the SQL cursor used by this ResultSet.
getDate(int) Get the value of a column in the current row as a java.sql.Date object.
getDate(String) Get the value of a column in the current row as a java.sql.Date object.
getDouble(int) Get the value of a column in the current row as a Java double.
getDouble(String) Get the value of a column in the current row as a Java double.
getFloat(int) Get the value of a column in the current row as a Java float.
getFloat(String) Get the value of a column in the current row as a Java float.
getInt(int) Get the value of a column in the current row as a Java int.
getInt(String) Get the value of a column in the current row as a Java int.
getLong(int) Get the value of a column in the current row as a Java long.
getLong(String) Get the value of a column in the current row as a Java long.
getMetaData() The number, types and properties of a ResultSet's columns are provided by the getMetaData method.
getObject(int)

Get the value of a column in the current row as a Java object.

getObject(String)

Get the value of a column in the current row as a Java object.

getShort(int) Get the value of a column in the current row as a Java short.
getShort(String) Get the value of a column in the current row as a Java short.
getString(int) Get the value of a column in the current row as a Java String.
getString(String) Get the value of a column in the current row as a Java String.
getTime(int) Get the value of a column in the current row as a java.sql.Time object.
getTime(String) Get the value of a column in the current row as a java.sql.Time object.
getTimestamp(int) Get the value of a column in the current row as a java.sql.Timestamp object.
getTimestamp(String) Get the value of a column in the current row as a java.sql.Timestamp object.
getUnicodeStream(int) A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream.
getUnicodeStream(String) A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream.
getWarnings()

The first warning reported by calls on this ResultSet is returned.

next() A ResultSet is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.
wasNull() A column may have the value of SQL NULL; wasNull reports whether the last column read had this special value.