flightinfoload.java

EOmodeler 读取数据库的方法

package edu.thu.airlinerecovery.eof;


import com.webobjects.eocontrol.EOQualifier;
import com.webobjects.foundation.NSArray;


/**
 * @author Huang Ke
 * @version $Id: FlightInfoLoad.java,v 1.1 2007/12/14 11:36:59 lzh Exp $
 */

public class FlightInfoLoad {
	
	DataFetcher df;
	EOQualifier qualifier;
	NSArray sortOrderings;
	NSArray flightInfo = null;
	
	public FlightInfoLoad(){
		df = new DataFetcher();		
	}
	
	public void loadFlightInfoByAirplane(String tailNum){
		
		// consider the airplane_plan only for now
		qualifier=EOQualifier.qualifierWithQualifierFormat("airplane_plan.tailNum = '"+ tailNum +"'", null);
		flightInfo = df.getObjectsWithSpecification("Flight", qualifier, sortOrderings);
		
	}
	
	public String getOrigin(int tailNum, int sequence){
		String anOrigin= null;
		NSArray allOrigins = null;
		try {
			this.loadFlightInfoByAirplane(Integer.toString(tailNum));
			allOrigins = (NSArray)flightInfo.valueForKey("airport_origin.airportName");
			anOrigin = allOrigins.get(sequence).toString();
			
		} catch (Exception e) {
			System.out.println(e);
		}
		return anOrigin;
	}
	
	public int getDestPlanStatus(int tailNum, int sequence){
		int anDestPlanStatus= -1;
		NSArray allDestPlanStatuses = null;
		try {
			this.loadFlightInfoByAirplane(Integer.toString(tailNum));
			allDestPlanStatuses = (NSArray)flightInfo.valueForKey("airport_dest_plan.status");
			anDestPlanStatus = Integer.parseInt(allDestPlanStatuses.get(sequence).toString());
			
		} catch (Exception e) {
			System.out.println(e);
		}
		return anDestPlanStatus;
	}
	
	public String getDestPlan(int tailNum, int sequence){
		String aDestPlan= null;
		NSArray allDestPlans = null;		
		try {
			this.loadFlightInfoByAirplane(Integer.toString(tailNum));
			allDestPlans = (NSArray)flightInfo.valueForKey("airport_dest_plan.airportName");
			aDestPlan = allDestPlans.get(sequence).toString();
			
		} catch (Exception e) {
			System.out.println(e);
		}
		return aDestPlan;
	}
	
	public String getDepTimePlan(int tailNum, int sequence){
		String aDepTimePlan= null;
		NSArray allDepTimePlans = null;
		try {
			this.loadFlightInfoByAirplane(Integer.toString(tailNum));
			allDepTimePlans = (NSArray)flightInfo.valueForKey("depTimePlan");
			aDepTimePlan = allDepTimePlans.get(sequence).toString();
			
		} catch (Exception e) {
			System.out.println(e);
		}
		return aDepTimePlan;
	}
	
	public String getArrTimePlan(int tailNum, int sequence){
		String aArrTimePlan= null;
		NSArray allaArrTimePlans = null;
		try {
			this.loadFlightInfoByAirplane(Integer.toString(tailNum));
			allaArrTimePlans = (NSArray)flightInfo.valueForKey("arrTimePlan");
			aArrTimePlan = allaArrTimePlans.get(sequence).toString();
			
		} catch (Exception e) {
			System.out.println(e);
		}
		return aArrTimePlan;
	}
	
	public int getArrTimePlanInMinute(int tailNum, int sequence){
		int arrTimePlanInMinute= -1;
		String time="";
		int hour=-1;
		int minute=-1;
		
		try {
			time=this.getArrTimePlan(tailNum, sequence);
			hour=Integer.parseInt(time.substring(11, 13));
			minute=Integer.parseInt(time.substring(14, 16));
			arrTimePlanInMinute = hour*60 + minute;
			
		} catch (Exception e) {
			System.out.println(e);
		}
		return arrTimePlanInMinute;
	}
	
	public String getDepTimeReal(String tailNum, int sequence){
		String aDepTimeReal= null;
		NSArray allDepTimeReals = null;
		try {
			this.loadFlightInfoByAirplane(tailNum);
			allDepTimeReals = (NSArray)flightInfo.valueForKey("depTimePlan");
			aDepTimeReal = allDepTimeReals.get(sequence).toString();
			
		} catch (Exception e) {
			System.out.println(e);
		}
		return aDepTimeReal;
	}
	
	public int getDepTimePlanInMinute(int tailNum, int sequence){
		int depTimePlanInMinute= -1;
		String time="";
		int hour=-1;
		int minute=-1;
		
		try {
			time=this.getDepTimePlan(tailNum, sequence);
			hour=Integer.parseInt(time.substring(11, 13));
			minute=Integer.parseInt(time.substring(14, 16));
			depTimePlanInMinute = hour*60 + minute;
			
		} catch (Exception e) {
			System.out.println(e);
		}
		return depTimePlanInMinute;
	}
	
}