8.5.69 relative(int rows)
- Organization of this subsection
(1) Function
This method moves the cursor.
(2) Format
public synchronized boolean relative(int rows) throws SQLException
(3) Arguments
- int rows
-
Specifies the number of rows (from the current row) by which the cursor is to be moved.
If a positive value is specified, the cursor moves forward. If a negative value is specified, the cursor moves backwards.
(4) Return value
If the cursor position resulting from execution of this method is before the first row or after the last row, the method returns false; otherwise, the method returns true.
(5) Exceptions
The JDBC driver throws an SQLException in the following cases:
-
This ResultSet object is closed.
This includes the case where the ResultSet object was closed because the Statement object that created this ResultSet object was closed.
-
The Connection used to create the Statement object that created this ResultSet object has been closed.
-
The type of this ResultSet object is ResultSet.TYPE_FORWARD_ONLY.
-
The current position cannot be acquired.
-
The cursor's current position is not on a valid row.
-
The ResultSet object has become invalid due to transaction settlement.
-
A database access error occurs.