Que função usar para ir a um registro anterior em um banco?

/* by Rodrigo G. Tavares de Souza 
 * Arquivo: TesteSql.java 
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class TesteSql {
	public static void main(String[] args) {
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			
			
			Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost;"+
			"User=sa;"+
			"Password=senha"+
			"DatabaseName=db");
			Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			
			ResultSet rs = st.executeQuery("select * from gruposdac");
			
			int qtdLinhas = 0; 
			
			while (rs.next()) {
				qtdLinhas++;
			}
			
			rs.previous();
			rs.first();
			rs.last();
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
}

Class.forName("org.hsqldb.jdbcDriver");
    
    conn = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost", "sa", "");
    
    conn.setAutoCommit(true);
    connect();
    Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
    ResultSet rs = stmt.executeQuery("SELECT " + query);