TestScroll(28)

import java.sql.*;

public class TestScroll {

 public static void main(String[] args) {
  try{
   new oracle.jdbc.driver.OracleDriver();
   String url = "jdbc:oracle:thin:@122.207.171.222:1521:ORCL";
   Connection conn = DriverManager.getConnection(url, "scott", "tiger");
   Statement stmt = conn.createStatement(
     ResultSet.TYPE_SCROLL_INSENSITIVE,
     ResultSet.CONCUR_READ_ONLY);
   ResultSet rs = stmt.executeQuery("select * from emp order by sal");
   rs.next();
   System.out.println(rs.getInt(1));
   rs.last();
   System.out.println(rs.getString(1));
   System.out.println(rs.isLast());
   System.out.println(rs.isAfterLast());
   System.out.println(rs.getRow());
   rs.previous();
   System.out.println(rs.getString(1));
   rs.absolute(6);
   System.out.println(rs.getRow());
   System.out.println(rs.getString(1));
   rs.close();
   stmt.close();
   conn.close();
   
  } catch(SQLException e) {
   e.printStackTrace();
  }

 }

}