package com.godoro.samples.jdbc;

import java.sql.*;

public class ScrollableResultSetTest {
    
  public static void main(String[] args)
    throws Exception
  {
    String driverClass="sun.jdbc.odbc.JdbcOdbcDriver";     
    Class.forName(driverClass);       
    String url="jdbc:odbc:mydatasource";     
    String username="sa";
    String password="godoro";
    Connection connection = DriverManager.getConnection(url,username,password);
    System.out.println("Connected to database");          

    Statement stmt=connection.createStatement(
            ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    ResultSet rs=stmt.executeQuery("select * from BankAccount");
   
    
    while(rs.next()){
      int accountNum=rs.getInt("AccountNumber");
      float amount=rs.getInt("Amount");      
      System.out.println(accountNum+" : "+amount);        
      if(accountNum==345){
         if(rs.previous()){      
           int accountNumPrevious=rs.getInt("AccountNumber");  
           System.out.println("Account before 345 : "+accountNumPrevious);
           break;
         }
      }
    }    
    if(rs.first()){
      int accountNumFirst=rs.getInt("AccountNumber");
      System.out.println("First Account : "+accountNumFirst);      
    }
    if(rs.last()){
      int accountNumLast=rs.getInt("AccountNumber");
      System.out.println("Last Account : "+accountNumLast);      
    }  
    if(rs.absolute(4)){
      int accountNum4=rs.getInt("AccountNumber");
      System.out.println("4th Account : "+accountNum4);      
    }      
  }
    
}