<b>ResultsSet navigate methods</b>
Method | Description | Requires Scrollable ResultSet
------ | ------ | ------
boolean absolute(int rowNum) | Move cursor to the specified row number | Yes
void afterLast() | Move cursor to a location immediately after the last row | Yes
void beforeFirst() | Move cursor to a location immediately before the first row | Yes
boolean first() | Move cursor to the first row | Yes
boolean last() | Move cursor to the last row | Yes
boolean next() | Move cursor one row forward | No
boolean previous() | Move cursor one row back-ward | Yes
boolean relative(int rowNum) | Move cursor forward or back-ward the specified number of rows | Yes
<b>ResultsSet get methods</b>
Method Name | Return Type | Example Database Type
------ | ------ | ------
getBoolean | boolean | BOOLEAN
getDate | java.sql.Date | DATE
getDouble | double | DOUBLE
getInt | int | INTEGER
getLong | long | BIGINT
getObject | Object | Any type
getString | String | CHAR, VARCHAR
getTime | java.sql.Time | TIME
getTimeStamp | java.sql.TimeStamp | TIMESTAMP
* Always use an if statement or while loop when calling rs.next().
* Column indexes begin with 1