package com.monkeygarage.carclubhub.clubinfo;
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.logging.Logger;
import com.monkeygarage.DBConnect;
import java.util.logging.Level;
import java.util.*;

public class Search 

{
	private List<SearchResults> list = new ArrayList<SearchResults>(); 
	DBConnect db = new DBConnect(); 
		public Iterator getResult() {
		Result();
		return list.iterator();
		}
	
	
	private void Result()
	{
		try {
			ResultSet rs = db.getResult("SELECT club.clubId, " +
					"club.clubName, club.clubDescrip, " +
					"clubaddress.zipcode, state.stateName FROM club, " +
					"clubaddress, state WHERE clubaddress.stateId=38 " +
					"AND clubaddress.clubId = club.clubId AND " +
					"clubaddress.stateId = state.stateId");
			
			list = new ArrayList();
			
			while(rs.next())
					{
				list.add(new SearchResults(rs.getLong(1), rs.getString(2),
						rs.getString(3),rs.getLong(4),rs.getString(5)));
					}
			}		
		catch (SQLException ex) {LOGGER.log(Level.SEVERE, "Error", ex);}
					
	
			
			finally 
			{ db.disconnect(); } 
				
	
		}
	private static final Logger LOGGER = Logger.getLogger(Search.class.getName());
	public static void main(String[] args) {
		Search list = new Search();
		Iterator it = list.getResult();
		
	
		}

}

package com.monkeygarage.carclubhub.clubinfo;

public class SearchResults {
	private Long clubId;
	private String clubName;
	private String clubDescrip;
	private Long zipcode;
	private String stateName;
	
	SearchResults(Long clubId, String clubName,
	String clubDescrip,
	Long zipcode,
	String stateName)
	{
		this.clubId=clubId;
		this.clubName=clubName;
		this.clubDescrip=clubDescrip;
		this.zipcode=zipcode;
		this.stateName=stateName;
	}
	
	public Long getClubId(){
		return clubId;
	}
	
	public String getClubName(){
		return clubName;
	}
	
	public String getClubDescrip(){
		return clubDescrip;
	}
	
	public Long getZipcode(){
		return zipcode;
	}
	
	public String getStateName(){
		return stateName;
		}
	
	public Long toLong() { return this.clubId; }
	
	public String toString() { return this.clubName; }
	
	public String toString() { return this.clubDescrip; }
	
	public Long toLong() { return this.zipcode; }
	
	public String toString() { return this.stateName; }
}

public static void main(String[] args) {
		Search list = new Search();
		Iterator it = list.getResult();
		
	
		}