jdbc scrollable resultset methods

The following code illustrate how to limit the number of result in a result set and methods in scrollable result set go through it and may helpful in some way

package basics.in.java.blogspot.in;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {
 
 private static final String USERNAME="root";
 private static final String PASSWORD="";
 private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot";
 

 public static void main(String[] args) throws ClassNotFoundException, SQLException {
  Class.forName("com.mysql.jdbc.Driver");
  Connection conn=null;
  Statement stmt=null;
  ResultSet rs=null;
  
  
  try {
   conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD);
            System.out.println("database connection successful"); 
            stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
            stmt.setMaxRows(5);
            rs=stmt.executeQuery("select * from tours");
                      
            display(rs);
            rs.last();
            System.out.println("number of rows:"+rs.getRow());
            
            rs.first();
            System.out.println("first row is:"+rs.getString("tourName"));
            
            rs.absolute(4);
            System.out.println("4th row is:"+rs.getString("tourName"));
            
            
  } catch (SQLException e) {
   System.err.println(e);
   System.err.println("Error message:"+e.getMessage());
   System.err.println("Error code is:"+e.getErrorCode());
   System.err.println("sql state:"+e.getSQLState());
   
  }
  
  finally{
   if(rs!=null){
    rs.close();
   }
   if(stmt!=null){
    stmt.close();
   }
   if(conn!=null){
    conn.close();
   }
  }
  

 }
 public static void display(ResultSet rs) throws SQLException{
  while(rs.next()){
   StringBuffer sBuffer=new StringBuffer();
   sBuffer.append("Tour id: "+rs.getInt("tourId"));
   System.out.println(sBuffer);
  }
 }
 

}