Is it possible to start working with ResultSet if the current element is not yet selected or absent?

In Java, when working with a ResultSet object, the cursor initially is positioned before the first row of the result. To start reading data, you need to call the next() method, which moves the cursor to the next row and returns true if the row exists.

If you try to retrieve data from the ResultSet before calling next(), an exception will be thrown because the current element is not selected.

Example usage:

ResultSet rs = statement.executeQuery("SELECT * FROM users");
while (rs.next()) {
    String name = rs.getString("name");
    // process data
}

Therefore, you cannot start working with a ResultSet unless the current element is selected — you must call next() or similar methods to position the cursor.