Overview  Package   Class  Tree  Deprecated  Index  Help  Codase Click search sample or example code, search definition, search google 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

java.sql
Interface ResultSet

All Known Subinterfaces:
CachedRowSet sample code for javax.sql.rowset.CachedRowSet definition code for javax.sql.rowset.CachedRowSet , FilteredRowSet sample code for javax.sql.rowset.FilteredRowSet definition code for javax.sql.rowset.FilteredRowSet , JdbcRowSet sample code for javax.sql.rowset.JdbcRowSet definition code for javax.sql.rowset.JdbcRowSet , JoinRowSet sample code for javax.sql.rowset.JoinRowSet definition code for javax.sql.rowset.JoinRowSet , RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet , SyncResolver sample code for javax.sql.rowset.spi.SyncResolver definition code for javax.sql.rowset.spi.SyncResolver , WebRowSet sample code for javax.sql.rowset.WebRowSet definition code for javax.sql.rowset.WebRowSet 
public interface ResultSet

A table of data representing a database result set, which is usually generated by executing a statement that queries the database.

A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set.

A default ResultSet object is not updatable and has a cursor that moves forward only. Thus, you can iterate through it only once and only from the first row to the last row. It is possible to produce ResultSet objects that are scrollable and/or updatable. The following code fragment, in which con is a valid Connection object, illustrates how to make a result set that is scrollable and insensitive to updates by others, and that is updatable. See ResultSet fields for other options. 


       Statement stmt = con.createStatement(
                                      ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
       ResultSet rs = stmt.executeQuery("SELECT a, b FROM TABLE2");
       // rs will be scrollable, will not show changes made by others,
       // and will be updatable
The ResultSet interface provides getter methods (getBoolean, getLong, and so on) for retrieving column values from the current row. Values can be retrieved using either the index number of the column or the name of the column. In general, using the column index will be more efficient. Columns are numbered from 1. For maximum portability, result set columns within each row should be read in left-to-right order, and each column should be read only once.

For the getter methods, a JDBC driver attempts to convert the underlying data to the Java type specified in the getter method and returns a suitable Java value. The JDBC specification has a table showing the allowable mappings from SQL types to Java types that can be used by the ResultSet getter methods.

Column names used as input to getter methods are case insensitive. When a getter method is called with a column name and several columns have the same name, the value of the first matching column will be returned. The column name option is designed to be used when column names are used in the SQL query that generated the result set. For columns that are NOT explicitly named in the query, it is best to use column numbers. If column names are used, there is no way for the programmer to guarantee that they actually refer to the intended columns.

A set of updater methods were added to this interface in the JDBC 2.0 API (JDK 1.2). The comments regarding parameters to the getter methods also apply to parameters to the updater methods.

The updater methods may be used in two ways:

  1. to update a column value in the current row. In a scrollable ResultSet object, the cursor can be moved backwards and forwards, to an absolute position, or to a position relative to the current row. The following code fragment updates the NAME column in the fifth row of the ResultSet object rs and then uses the method updateRow to update the data source table from which rs was derived. 
    
       rs.absolute(5); // moves the cursor to the fifth row of rs
       rs.updateString("NAME", "AINSWORTH"); // updates the 
          // NAME column of row 5 to be AINSWORTH
       rs.updateRow(); // updates the row in the data source
  2. to insert column values into the insert row. An updatable ResultSet object has a special row associated with it that serves as a staging area for building a row to be inserted. The following code fragment moves the cursor to the insert row, builds a three-column row, and inserts it into rs and into the data source table using the method insertRow. 
    
       rs.moveToInsertRow(); // moves cursor to the insert row
       rs.updateString(1, "AINSWORTH"); // updates the 
          // first column of the insert row to be AINSWORTH
       rs.updateInt(2,35); // updates the second column to be 35
       rs.updateBoolean(3, true); // updates the third column to true
       rs.insertRow();
       rs.moveToCurrentRow();

A ResultSet object is automatically closed when the Statement object that generated it is closed, re-executed, or used to retrieve the next result from a sequence of multiple results.

The number, types and properties of a ResultSet object's columns are provided by the ResulSetMetaData object returned by the ResultSet.getMetaData method.

See Also:
Statement.executeQuery(java.lang.String) sample code for java.sql.Statement.executeQuery(java.lang.String) definition code for java.sql.Statement.executeQuery(java.lang.String) , Statement.getResultSet() sample code for java.sql.Statement.getResultSet() definition code for java.sql.Statement.getResultSet() , ResultSetMetaData sample code for java.sql.ResultSetMetaData definition code for java.sql.ResultSetMetaData

Field Summary
static int CLOSE_CURSORS_AT_COMMIT sample code for java.sql.ResultSet.CLOSE_CURSORS_AT_COMMIT definition code for java.sql.ResultSet.CLOSE_CURSORS_AT_COMMIT
          The constant indicating that ResultSet objects should be closed when the method Connection.commit is called.
static int CONCUR_READ_ONLY sample code for java.sql.ResultSet.CONCUR_READ_ONLY definition code for java.sql.ResultSet.CONCUR_READ_ONLY
          The constant indicating the concurrency mode for a ResultSet object that may NOT be updated.
static int CONCUR_UPDATABLE sample code for java.sql.ResultSet.CONCUR_UPDATABLE definition code for java.sql.ResultSet.CONCUR_UPDATABLE
          The constant indicating the concurrency mode for a ResultSet object that may be updated.
static int FETCH_FORWARD sample code for java.sql.ResultSet.FETCH_FORWARD definition code for java.sql.ResultSet.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 sample code for java.sql.ResultSet.FETCH_REVERSE definition code for java.sql.ResultSet.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 sample code for java.sql.ResultSet.FETCH_UNKNOWN definition code for java.sql.ResultSet.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 sample code for java.sql.ResultSet.HOLD_CURSORS_OVER_COMMIT definition code for java.sql.ResultSet.HOLD_CURSORS_OVER_COMMIT
          The constant indicating that ResultSet objects should not be closed when the method Connection.commit is called.
static int TYPE_FORWARD_ONLY sample code for java.sql.ResultSet.TYPE_FORWARD_ONLY definition code for java.sql.ResultSet.TYPE_FORWARD_ONLY
          The constant indicating the type for a ResultSet object whose cursor may move only forward.
static int TYPE_SCROLL_INSENSITIVE sample code for java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE definition code for java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE
          The constant indicating the type for a ResultSet object that is scrollable but generally not sensitive to changes made by others.
static int TYPE_SCROLL_SENSITIVE sample code for java.sql.ResultSet.TYPE_SCROLL_SENSITIVE definition code for java.sql.ResultSet.TYPE_SCROLL_SENSITIVE
          The constant indicating the type for a ResultSet object that is scrollable and generally sensitive to changes made by others.
 
Method Summary
 boolean absolute sample code for java.sql.ResultSet.absolute(int) definition code for java.sql.ResultSet.absolute(int) (int row)
          Moves the cursor to the given row number in this ResultSet object.
 void afterLast sample code for java.sql.ResultSet.afterLast() definition code for java.sql.ResultSet.afterLast() ()
          Moves the cursor to the end of this ResultSet object, just after the last row.
 void beforeFirst sample code for java.sql.ResultSet.beforeFirst() definition code for java.sql.ResultSet.beforeFirst() ()
          Moves the cursor to the front of this ResultSet object, just before the first row.
 void cancelRowUpdates sample code for java.sql.ResultSet.cancelRowUpdates() definition code for java.sql.ResultSet.cancelRowUpdates() ()
          Cancels the updates made to the current row in this ResultSet object.
 void clearWarnings sample code for java.sql.ResultSet.clearWarnings() definition code for java.sql.ResultSet.clearWarnings() ()
          Clears all warnings reported on this ResultSet object.
 void close sample code for java.sql.ResultSet.close() definition code for java.sql.ResultSet.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 sample code for java.sql.ResultSet.deleteRow() definition code for java.sql.ResultSet.deleteRow() ()
          Deletes the current row from this ResultSet object and from the underlying database.
 int findColumn sample code for java.sql.ResultSet.findColumn(java.lang.String) definition code for java.sql.ResultSet.findColumn(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Maps the given ResultSet column name to its ResultSet column index.
 boolean first sample code for java.sql.ResultSet.first() definition code for java.sql.ResultSet.first() ()
          Moves the cursor to the first row in this ResultSet object.
 Array sample code for java.sql.Array definition code for java.sql.Array getArray sample code for java.sql.ResultSet.getArray(int) definition code for java.sql.ResultSet.getArray(int) (int i)
          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 sample code for java.sql.Array definition code for java.sql.Array getArray sample code for java.sql.ResultSet.getArray(java.lang.String) definition code for java.sql.ResultSet.getArray(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  colName)
          Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.
 InputStream sample code for java.io.InputStream definition code for java.io.InputStream getAsciiStream sample code for java.sql.ResultSet.getAsciiStream(int) definition code for java.sql.ResultSet.getAsciiStream(int) (int columnIndex)
          Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
 InputStream sample code for java.io.InputStream definition code for java.io.InputStream getAsciiStream sample code for java.sql.ResultSet.getAsciiStream(java.lang.String) definition code for java.sql.ResultSet.getAsciiStream(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
 BigDecimal sample code for java.math.BigDecimal definition code for java.math.BigDecimal getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(int) definition code for java.sql.ResultSet.getBigDecimal(int) (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 sample code for java.math.BigDecimal definition code for java.math.BigDecimal getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(int, int) definition code for java.sql.ResultSet.getBigDecimal(int, int) (int columnIndex, int scale)
          Deprecated.  
 BigDecimal sample code for java.math.BigDecimal definition code for java.math.BigDecimal getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(java.lang.String) definition code for java.sql.ResultSet.getBigDecimal(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
 BigDecimal sample code for java.math.BigDecimal definition code for java.math.BigDecimal getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(java.lang.String, int) definition code for java.sql.ResultSet.getBigDecimal(java.lang.String, int) (String sample code for java.lang.String definition code for java.lang.String  columnName, int scale)
          Deprecated.  
 InputStream sample code for java.io.InputStream definition code for java.io.InputStream getBinaryStream sample code for java.sql.ResultSet.getBinaryStream(int) definition code for java.sql.ResultSet.getBinaryStream(int) (int columnIndex)
          Retrieves the value of the designated column in the current row of this ResultSet object as a binary stream of uninterpreted bytes.
 InputStream sample code for java.io.InputStream definition code for java.io.InputStream getBinaryStream sample code for java.sql.ResultSet.getBinaryStream(java.lang.String) definition code for java.sql.ResultSet.getBinaryStream(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.
 Blob sample code for java.sql.Blob definition code for java.sql.Blob getBlob sample code for java.sql.ResultSet.getBlob(int) definition code for java.sql.ResultSet.getBlob(int) (int i)
          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 sample code for java.sql.Blob definition code for java.sql.Blob getBlob sample code for java.sql.ResultSet.getBlob(java.lang.String) definition code for java.sql.ResultSet.getBlob(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  colName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
 boolean getBoolean sample code for java.sql.ResultSet.getBoolean(int) definition code for java.sql.ResultSet.getBoolean(int) (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 getBoolean sample code for java.sql.ResultSet.getBoolean(java.lang.String) definition code for java.sql.ResultSet.getBoolean(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
 byte getByte sample code for java.sql.ResultSet.getByte(int) definition code for java.sql.ResultSet.getByte(int) (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 getByte sample code for java.sql.ResultSet.getByte(java.lang.String) definition code for java.sql.ResultSet.getByte(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          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 sample code for java.sql.ResultSet.getBytes(int) definition code for java.sql.ResultSet.getBytes(int) (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.
 byte[] getBytes sample code for java.sql.ResultSet.getBytes(java.lang.String) definition code for java.sql.ResultSet.getBytes(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
 Reader sample code for java.io.Reader definition code for java.io.Reader getCharacterStream sample code for java.sql.ResultSet.getCharacterStream(int) definition code for java.sql.ResultSet.getCharacterStream(int) (int columnIndex)
          Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
 Reader sample code for java.io.Reader definition code for java.io.Reader getCharacterStream sample code for java.sql.ResultSet.getCharacterStream(java.lang.String) definition code for java.sql.ResultSet.getCharacterStream(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
 Clob sample code for java.sql.Clob definition code for java.sql.Clob getClob sample code for java.sql.ResultSet.getClob(int) definition code for java.sql.ResultSet.getClob(int) (int i)
          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 sample code for java.sql.Clob definition code for java.sql.Clob getClob sample code for java.sql.ResultSet.getClob(java.lang.String) definition code for java.sql.ResultSet.getClob(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  colName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.
 int getConcurrency sample code for java.sql.ResultSet.getConcurrency() definition code for java.sql.ResultSet.getConcurrency() ()
          Retrieves the concurrency mode of this ResultSet object.
 String sample code for java.lang.String definition code for java.lang.String getCursorName sample code for java.sql.ResultSet.getCursorName() definition code for java.sql.ResultSet.getCursorName() ()
          Retrieves the name of the SQL cursor used by this ResultSet object.
 Date sample code for java.sql.Date definition code for java.sql.Date getDate sample code for java.sql.ResultSet.getDate(int) definition code for java.sql.ResultSet.getDate(int) (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 sample code for java.sql.Date definition code for java.sql.Date getDate sample code for java.sql.ResultSet.getDate(int, java.util.Calendar) definition code for java.sql.ResultSet.getDate(int, java.util.Calendar) (int columnIndex, Calendar sample code for java.util.Calendar definition code for java.util.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 sample code for java.sql.Date definition code for java.sql.Date getDate sample code for java.sql.ResultSet.getDate(java.lang.String) definition code for java.sql.ResultSet.getDate(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          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 sample code for java.sql.Date definition code for java.sql.Date getDate sample code for java.sql.ResultSet.getDate(java.lang.String, java.util.Calendar) definition code for java.sql.ResultSet.getDate(java.lang.String, java.util.Calendar) (String sample code for java.lang.String definition code for java.lang.String  columnName, Calendar sample code for java.util.Calendar definition code for java.util.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.
 double getDouble sample code for java.sql.ResultSet.getDouble(int) definition code for java.sql.ResultSet.getDouble(int) (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.
 double getDouble sample code for java.sql.ResultSet.getDouble(java.lang.String) definition code for java.sql.ResultSet.getDouble(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
 int getFetchDirection sample code for java.sql.ResultSet.getFetchDirection() definition code for java.sql.ResultSet.getFetchDirection() ()
          Retrieves the fetch direction for this ResultSet object.
 int getFetchSize sample code for java.sql.ResultSet.getFetchSize() definition code for java.sql.ResultSet.getFetchSize() ()
          Retrieves the fetch size for this ResultSet object.
 float getFloat sample code for java.sql.ResultSet.getFloat(int) definition code for java.sql.ResultSet.getFloat(int) (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.
 float getFloat sample code for java.sql.ResultSet.getFloat(java.lang.String) definition code for java.sql.ResultSet.getFloat(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
 int getInt sample code for java.sql.ResultSet.getInt(int) definition code for java.sql.ResultSet.getInt(int) (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 getInt sample code for java.sql.ResultSet.getInt(java.lang.String) definition code for java.sql.ResultSet.getInt(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
 long getLong sample code for java.sql.ResultSet.getLong(int) definition code for java.sql.ResultSet.getLong(int) (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.
 long getLong sample code for java.sql.ResultSet.getLong(java.lang.String) definition code for java.sql.ResultSet.getLong(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
 ResultSetMetaData sample code for java.sql.ResultSetMetaData definition code for java.sql.ResultSetMetaData getMetaData sample code for java.sql.ResultSet.getMetaData() definition code for java.sql.ResultSet.getMetaData() ()
          Retrieves the number, types and properties of this ResultSet object's columns.
 Object sample code for java.lang.Object definition code for java.lang.Object getObject sample code for java.sql.ResultSet.getObject(int) definition code for java.sql.ResultSet.getObject(int) (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 sample code for java.lang.Object definition code for java.lang.Object getObject sample code for java.sql.ResultSet.getObject(int, java.util.Map) definition code for java.sql.ResultSet.getObject(int, java.util.Map) (int i, Map sample code for java.util.Map definition code for java.util.Map <String sample code for java.lang.String definition code for java.lang.String ,Class sample code for java.lang.Class definition code for java.lang.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 sample code for java.lang.Object definition code for java.lang.Object getObject sample code for java.sql.ResultSet.getObject(java.lang.String) definition code for java.sql.ResultSet.getObject(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
 Object sample code for java.lang.Object definition code for java.lang.Object getObject sample code for java.sql.ResultSet.getObject(java.lang.String, java.util.Map) definition code for java.sql.ResultSet.getObject(java.lang.String, java.util.Map) (String sample code for java.lang.String definition code for java.lang.String  colName, Map sample code for java.util.Map definition code for java.util.Map <String sample code for java.lang.String definition code for java.lang.String ,Class sample code for java.lang.Class definition code for java.lang.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.
 Ref sample code for java.sql.Ref definition code for java.sql.Ref getRef sample code for java.sql.ResultSet.getRef(int) definition code for java.sql.ResultSet.getRef(int) (int i)
          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 sample code for java.sql.Ref definition code for java.sql.Ref getRef sample code for java.sql.ResultSet.getRef(java.lang.String) definition code for java.sql.ResultSet.getRef(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  colName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.
 int getRow sample code for java.sql.ResultSet.getRow() definition code for java.sql.ResultSet.getRow() ()
          Retrieves the current row number.
 short getShort sample code for java.sql.ResultSet.getShort(int) definition code for java.sql.ResultSet.getShort(int) (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.
 short getShort sample code for java.sql.ResultSet.getShort(java.lang.String) definition code for java.sql.ResultSet.getShort(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
 Statement sample code for java.sql.Statement definition code for java.sql.Statement getStatement sample code for java.sql.ResultSet.getStatement() definition code for java.sql.ResultSet.getStatement() ()
          Retrieves the Statement object that produced this ResultSet object.
 String sample code for java.lang.String definition code for java.lang.String getString sample code for java.sql.ResultSet.getString(int) definition code for java.sql.ResultSet.getString(int) (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 sample code for java.lang.String definition code for java.lang.String getString sample code for java.sql.ResultSet.getString(java.lang.String) definition code for java.sql.ResultSet.getString(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
 Time sample code for java.sql.Time definition code for java.sql.Time getTime sample code for java.sql.ResultSet.getTime(int) definition code for java.sql.ResultSet.getTime(int) (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 sample code for java.sql.Time definition code for java.sql.Time getTime sample code for java.sql.ResultSet.getTime(int, java.util.Calendar) definition code for java.sql.ResultSet.getTime(int, java.util.Calendar) (int columnIndex, Calendar sample code for java.util.Calendar definition code for java.util.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 sample code for java.sql.Time definition code for java.sql.Time getTime sample code for java.sql.ResultSet.getTime(java.lang.String) definition code for java.sql.ResultSet.getTime(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  columnName)
          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 sample code for java.sql.Time definition code for java.sql.Time getTime sample code for java.sql.ResultSet.getTime(java.lang.String, java.util.Calendar) definition code for java.sql.ResultSet.getTime(java.lang.String, java.util.Calendar) (String sample code for java.lang.String definition code for java.lang.String  columnName, Calendar sample code for java.util.Calendar definition code for java.util.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 sample code for java.sql.Timestamp definition code for java.sql.Timestamp getTimestamp