package soccer;

import java.sql.*;
import java.util.*;
public class SoccerSearchBean {
	private static final String allstr =
		"select * from TEAMS";
	private static final String drawstr =
		"select * from TEAMS where SCORE1=SCORE2";
	private static final String awaystr =
		"select * from TEAMS where SCORE1<SCORE2";
	private static final String homestr =
		"select * from TEAMS where SCORE1>SCORE2";
	private String searchType;
	private Vector results;
	public void setSearchType(String typ)
	{
		searchType = typ;
	}
	public Iterator games() {
		if(results!=null)
			return results.iterator();
		else
			return null;
	}
	public int numGames() {
		if(results!=null)
			return results.size();
		else
			return 0;
	}
	public void doSearch()
	{
		results = new Vector();
		try {
			Connection db = DBInfo.connectToDatabase();
			Statement stmt = db.createStatement();
			String request = allstr;
			if("drawn".equals(searchType))
				request = drawstr;
			else
			if("away".equals(searchType))
				request = awaystr;
			else
			if("home".equals(searchType))
				request = homestr;
			else
			if("all".equals(searchType))
				request = allstr;
		
			ResultSet rset = stmt.executeQuery(request);
			while(rset.next()){
				SoccerGame sg = new SoccerGame();
				sg.loadFromResultSet(rset);
				results.addElement(sg);
			}
			rset.close();
			stmt.close();
			db.close();
		}
		catch(Exception e) { 
			System.out.println("Database problems- soocer jsp");
			System.out.println(e.toString());
		}
	}
}