Where does a Resultset object's cursor initially point? How do you move the cursor forward in the result set?

A ResultSet object represents the result of executing a SQL query in a Java application. It allows you to retrieve the data returned by the query and to iterate through the rows of the result set.

When a ResultSet object is created, its cursor is initially positioned before the first row of the result set, meaning it doesn't yet point to any row. You will need to move the cursor to the first row (if data is available) to start processing the data.

To move the cursor forward through the result set, you use the 'next()' method of the ResultSet object. The 'next()' method returns a boolean value, indicating whether there is a next row available or not. If the next row is available, the cursor moves to that row; otherwise, it remains at its current position. Here's an example of how to use the 'next()' method: ```java ResultSet resultSet = statement.executeQuery("SELECT * FROM students"); while(resultSet.next()) { // retrieve and process data from the current row using resultSet methods } ``` In this example, the 'while' loop continues to iterate until there are no more rows left in the ResultSet, and the 'next()' method returns false. During each iteration, you can access the data in the current row using various ResultSet methods such as 'getString()', 'getInt()', etc., depending on the data type of the columns.