3

package com.atos.java.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class navigational {

    private static final String DB_URL = "jdbc:oracle:thin:@localhost:1521:xe";
    private static final String USER_ID ="hr";
    private static final String PASSWORD ="hr";


    public static void main(String[] args) {

        final String sql = "select country_id, country_name from countries";
        Connection conn = null;
        try
        {
            Class.forName("oracle.jdbc.OracleDriver");
            conn = DriverManager.getConnection(DB_URL, USER_ID, PASSWORD);
            Statement statement = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY,ResultSet.CLOSE_CURSORS_AT_COMMIT);
            ResultSet result =statement.executeQuery(sql);
            result.next();
            result.relative(3);


           /* while (result.next())
            {
                String id = result.getString("COUNTRY_ID");
                String name = result.getString("COUNTRY_NAME");
                System.out.println(id +" " +name);

            }
            */



            String id = result.getString("COUNTRY_ID");
            String name = result.getString("COUNTRY_NAME");
            System.out.println(id +" " +name);

        }

        catch (SQLException e)
        {
            e.printStackTrace();
        }
        catch(ClassNotFoundException e)
        {
            e.printStackTrace();
        }
        finally
        {
            try
            {
                conn.close();
            }
        catch (SQLException e)
            {
            e.printStackTrace();
            }


        }

    }

}