// Programm 3-14: BSP_ROOT/meinewebapp/WEB-INF/classes/jdbcbasis/ResultSetNavigation.java
import java.sql.*;
public class ResultSetNavigation {
  public static void main(String[] args) throws Exception {
  Connection c;
    Class.forName("org.gjt.mm.mysql.Driver"); 
    c=DriverManager.getConnection("jdbc:mysql://localhost:3306/Kurse","root","");
    Statement s = c.createStatement();
      ResultSet r = s.executeQuery("SELECT * FROM Personen");
      r.absolute(1);
      r.last(); System.out.println("last: isLast "+r.isLast());
      r.next(); System.out.println("next: isAfterLast "+r.isAfterLast());
      r.relative(99); System.out.println("rel+: isAfterLast "+r.isAfterLast());
      r.first(); System.out.println("first: isFirst "+r.isFirst());
      r.previous(); System.out.println("prev: isBeforeFirst "+r.isBeforeFirst());
      r.relative(-99); System.out.println("rel-: isBeforeFirst "+r.isBeforeFirst());
      r.afterLast(); System.out.println("after: isAfterLast "+r.isAfterLast());
      r.beforeFirst(); System.out.println("before: isBeforeFir "+r.isBeforeFirst());
  }
}