// Author: Robert Lie (mobilefish.com)
// 
// Note: How to install the MySQL Connector/J JDBC driver can be found at:
// http://www.mobilefish.com/developer/mysql/mysql_quickguide_connector_3.0.11.html
// This code example is based on MySQL 4.0.18
// MySQL Connector/J 3.0.11 is used.  
//

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.mysql.jdbc.Driver;

public class RetrieveRecordsMySQLTable {

    public static void main (String args []) throws SQLException {
        DriverManager.registerDriver(new Driver());
        
        //jdbc:mysql://machine:port/database?user=myuser&password=mypass
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mobilefishdb?user=root&password=mysecret");
        
        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select street from address");
        while (rset.next()) {
            System.out.println (rset.getString(1)); 
        }   
        stmt.close();
    }
}