Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » UltraLite - Java Programming » UltraLiteJ application development » Data creation and modification using SQL statements


SQL result set navigation

Schema information can be obtained with the Connection.prepareStatement and PreparedStatement.executeQuery methods. These methods query the UltraLite database with a user-defined SQL statement, and store the result set in a ResultSet object.

You can traverse ResultSet objects using the navigational methods in the ResultSet interface. This interface contains the following navigational methods:

  • afterLast1   Position immediately after the last row.

  • beforeFirst1   Position immediately before the first row.

  • first1   Move to the first row.

  • last1   Move to the last row.

  • next   Move to the next row.

  • previous   Move to the previous row.

  • relative(offset)1   Move a specified number of rows relative to the current row, as specified by the signed offset value. Positive offset values move forward in the result set, relative to the current pointer position in the result set. Negative offset values move backward in the result set. An offset value of zero does not move the current location, but allows you to repopulate the row buffer.

1 This method is not supported for UltraLite Java edition databases.

 See also
 Retrieval example
 Navigation example