// Author: Robert Lie (mobilefish.com)
// 
// Note: oracle.jdbc.driver.OracleDriver can be downloaded
// from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
// This code example is based on Oracle8i Release 2 (8.1.7)
// The classes12.zip JDBC classes are used.  
//
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import oracle.jdbc.driver.OracleDriver;

public class RetrieveRecordsOracleTable {

    public static void main (String args []) throws SQLException {
        DriverManager.registerDriver(new OracleDriver());
        
        //jdbc:oracle:thin:@machine:port:database", "user", "passwd"
        Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@serverone:3980:mobilefishdb", "admin", "mysecret");
        
        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select name from address");
        while (rset.next()) {
            System.out.println (rset.getString(1)); 
        }   
        stmt.close();
    }
}