TYPE-SCROLL-INSENSITIVE-Example

import java.sql.*;
class  ScrollRS
{
    public static void main(String[] args) throws Exception
    {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con=DriverManager.getConnection
    ("jdbc:odbc:ds","system","chandru");
        
        System.out.println(" Connected 2 DB.....");
/* In case of scroll insensitive the changes made by another
application can't be pickup after opening the Resultset. */
        Statement stmt=con.createStatement
        (ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
        String vsql="select * from emp2";
        ResultSet rs=stmt.executeQuery(vsql);
        while(rs.next())
        {
          System.out.println("ENO:"+rs.getInt(1));
          System.out.println("ENAME:"+rs.getString(2));
          System.out.println("SAL:"+rs.getInt(3));
        }  
        
        rs.absolute(1);
        System.out.println("ENO:"+rs.getInt(1));
        System.in.read();
        System.out.println(" After change DB.....");
        System.out.println("ENO:"+rs.getInt(1));
       
         

        
    }
}