import java.util.*;
import java.sql.*;

public class RatesRecord {
	private Hashtable	rates = new Hashtable();
	
	public Enumeration keys() { return rates.keys(); }

	public double	getRate(String task) {
		double rate = 0.0;
		try {
			Double data = (Double) rates.get(task);
			rate = data.doubleValue();
		}
		catch (Exception e) { }
		return rate;
	}


	public RatesRecord() {
		loadTable();
	}


	private void loadTable() {
		Connection db = DBInfo.connectToDatabase();
		if(db != null) {
		    try {
			Statement stmt = 
				db.createStatement ();						
			String request =
					"select * from rates";

			ResultSet rset = stmt.executeQuery(request);
			
			while(rset.next()) {
				String key = rset.getString("ACTIVITY");
				double val = rset.getDouble("RATE");
				Double dval = new Double(val);
				rates.put(key,dval);
			}
			stmt.close();
			db.close();
		    }
		    catch(Exception e) { }
		}


	}

}