Additional Notes
How can you iterate backwards through a ResultSet?
Track: Java
Topic: SQL for Java Devs
Focus: ResultSets and Mapping
Java: ResultSets and Mapping
Answer
Use rs.previous() with a scrollable ResultSet.
To iterate backwards, the ResultSet must be created with TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE. Then, use rs.previous() in a loop to move the cursor backwards through the rows.
To iterate backwards, the ResultSet must be created with TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE. Then, use rs.previous() in a loop to move the cursor backwards through the rows.
Topics: Java ResultSets and Mapping SQL for Java Devs