java.sql.ResultSet
Интерфейс 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(); } } }