queryfightutil.java

主要是航空预订系统

/**
 * 
 */
package com.air.backend.util;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.air.exceptions.AirException;
import com.air.form.FightForm;
import com.air.model.Fight;
import com.air.persistence.DataSrcUtil;
import com.air.persistence.IsqlDataSource;
import com.air.util.ValHelper;


/**
 * @author jelly_yang
 *
 */
public class QueryFightUtil {

	private static Log log = LogFactory.getLog(QueryFightUtil.class);
	public static class QueryTicketUtilHolder{
		static QueryFightUtil queryTicketUtil = new QueryFightUtil();
	}
	
	public static QueryFightUtil getInstance(){
		return QueryTicketUtilHolder.queryTicketUtil;
	}
	private QueryFightUtil() {
		// TODO Auto-generated constructor stub
	}
	
	public List<Fight> retrieveFight(FightForm fightForm)throws AirException{
		List<Fight> list = new ArrayList<Fight>();
		List<Map<String,String>> result = new ArrayList<Map<String,String>>();
		String sSql ="";
		if(fightForm!=null){
			sSql = "select * from fights where leave_date='"+fightForm.getLeaveDate()+"' and leave_city='"+
		              fightForm.getLeaveCity()+"' and arrive_city='"+fightForm.getArriveCity()+
		              "' and (special_num+business_num+economic_num+head_num)>0 order by price";
		}else{
			sSql = "select * from fights order by leave_date";
		}
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		log.debug("retrieveFight() -- sSql["+ sSql+ "]");
		try
		{
			conn = src.getConnection();
			result = src.executeRetrieve(conn, sSql);
		}
		catch(SQLException se)
		{
			log.error("retrieveFight() caught SQLException: " + se);
		}
		catch(Exception ex)
		{
			log.error("retrieveFight() caught Exception: " + ex);
		}
		finally
		{
			src.closeConn(conn);
		}
		if(!result.isEmpty())
		{
			int size = result.size();
			
			for( int i=0;i<size;i++)
			{
				Map<String,String> resultMap = result.get(i);
				Integer fightId = ValHelper.getInstance().getIntValue(resultMap, "fid");
				String fightName = ValHelper.getInstance().getValue(resultMap, "fight_name");
				String fightNo = ValHelper.getInstance().getValue(resultMap, "fight_no");
				String leaveCity = ValHelper.getInstance().getValue(resultMap, "leave_city");
				String arriveCity = ValHelper.getInstance().getValue(resultMap, "arrive_city");
				String leaveTime = ValHelper.getInstance().getValue(resultMap, "leave_time");
				String arriveTime = ValHelper.getInstance().getValue(resultMap, "arrive_time");
				double price = ValHelper.getInstance().getDoubleValue(resultMap, "price");
				double fuelRate = Double.parseDouble(ValHelper.getInstance().getValue(resultMap, "fuel_rate"));
				double buildRate = Double.parseDouble(ValHelper.getInstance().getValue(resultMap, "build_rate"));
				String leaveDate = ValHelper.getInstance().getValue(resultMap, "leave_date");
				Integer specialNum = ValHelper.getInstance().getIntValue(resultMap, "special_num");
				Integer economicNum = ValHelper.getInstance().getIntValue(resultMap, "economic_num");
				Integer businessNum = ValHelper.getInstance().getIntValue(resultMap, "business_num");
				Integer headNum = ValHelper.getInstance().getIntValue(resultMap, "head_num");
				
				Fight fight = new Fight();
				fight.setFightId(fightId);
				fight.setLeaveDate(leaveDate.substring(0,10));
				fight.setFightName(fightName);
				fight.setFightNo(fightNo);
				fight.setLeaveCity(leaveCity);
				fight.setArriveCity(arriveCity);
				fight.setLeaveTime(leaveTime);
				fight.setArriveTime(arriveTime);
				fight.setPrice(price);
				fight.setFuelRate(fuelRate);
				fight.setBuildRate(buildRate);
				fight.setSpecialNum(specialNum);
				fight.setEconomicNum(economicNum);
				fight.setBusinessNum(businessNum);
				fight.setHeadNum(headNum);
				
			    list.add( fight );
			}
		}
		return list;
	}

}