import java.sql.*;

public class ResultSet1 {

    public static void main(String[] args) throws Exception{
        // TODO Auto-generated method stub
        String JDBCDrivers = "oracle.jdbc.driver.OracleDriver";
        String useThisDriver_url = "jdbc:oracle:thin:@localhost:1521:xe";

        Class.forName(JDBCDrivers);
        Connection con = DriverManager.getConnection(useThisDriver_url,"user08","1111");
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * from EMP2");
        while(rs.next()){
            Integer col1 = rs.getInt(1);
            String col2 = rs.getString("ename");
            System.out.print("EMPNO: " + col1.toString() );
            System.out.print("\tENAME:  " + col2.toString());
            System.out.println();
        }
        rs.close(); stmt.close(); con.close();
    }

}