ABSOLUTE IN RESULTSET

boolean absolute(int row)
Moves the cursor to the given row number in the ResultSet object.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;
public class Test13 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "rakesh");
PreparedStatement ps = con.prepareStatement("select * from student_register",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = ps.executeQuery();
Scanner scan = new Scanner(System.in);
System.out.println("Input row number");
int row = scan.nextInt();
boolean b = rs.absolute(row);
if(b==false)
{
System.out.println("Invalid row number");
}
else
{
int id=rs.getInt(1);
String name=rs.getString(2);
String course=rs.getString(3);
System.out.print(id+" "+name+" "+course);
}
}
}

Output -

Input row number

1

3 runjun mca