import java.sql.*;

public class Test {
    public static final void main(String[] args) {
        new Test().process();
    }

    public void process() {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection conn = DriverManager.getConnection(
                                  "jdbc:oracle:thin:@HOSTNAME:1521:ORCL", "scott", "tiger");
            PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM TABLE_NAME");

            ResultSet resultSet = pstmt.executeQuery();
            for (;resultSet.next();) {
                System.out.println(resultSet.getString(1));
                System.out.println(resultSet.getString(2));
                System.out.println(resultSet.getString(3));
                System.out.println(resultSet.getString(4));
                System.out.println(resultSet.getString(5));
                System.out.println(resultSet.getString(6));
                System.out.println(resultSet.getString(7));
            }

            resultSet.close();
            pstmt.close();
            conn.close();
        } catch (SQLException ex) {
            System.out.println(ex.toString());
            ex.printStackTrace();
        } catch (ClassNotFoundException ex) {
            System.out.println(ex.toString());
            ex.printStackTrace();
        }
    }
}