Интерфейс java.sql.ResultSet предоставляет доступ к набору строк (выборке данных), полученному в результате выполнения поискового SQL-запроса.

Пример

import java.sql.*;
import com.relx.jdbc.LinterDriver;

public class ResultSetDemo
{
  public static void main (String[] args)
  {
    try
    {
      Driver d = (Driver)Class.forName("com.relx.jdbc.LinterDriver").newInstance();

      String address = "jdbc:linter:linapid:localhost:1070:DEMO";
      String user    = "SYSTEM";
      String password= "MANAGER8";

      Connection con =
                    DriverManager.getConnection(address,user,password);
      Statement stmt = con.createStatement();

      ResultSet results;

      stmt.executeUpdate("create table test1 (a int, b char(20));");

      //INSERT
      stmt.executeUpdate("insert into test1 values(1, 'First string');");
      stmt.executeUpdate("insert into test1 values(2, 'Another string');");
      stmt.executeUpdate("insert into test1 values(3,'Third string');");

      results = stmt.executeQuery("select * from test1;");

      while (results.next())
      {
        // Loop through each column, getting the column
        // data and displaying
        System.out.print("| "+results.getInt(1));
        System.out.println("| "+results.getString(2)+" |");
      }

      System.out.println();
      System.out.println("To previous...");
      if(results.previous())
      {
        System.out.print("| " + results.getInt(1));
        System.out.println("| " + results.getString(2)+" |");
      }
      System.out.println("To (current+1)...");
      if(results.relative(1))
      {
        System.out.print("| " + results.getInt(1));
        System.out.println("| " + results.getString(2)+" |");
      }

      System.out.println("To first...");
      if(results.absolute(1))
      {
        System.out.print("| " + results.getInt(1));
        System.out.println("| " + results.getString(2)+" |");
      }

      results.close();

      try
      {
        stmt.executeUpdate("drop table test1;");
      }
      catch(SQLException e)
      {
        System.out.println("Error deleting table:"+e.getMessage());
      }

      con.close();
    }
    catch (Exception e)
    {
      System.out.println("Catched :" + e + " mess= " + e.getMessage() );
      e.printStackTrace();
    }
  }
}