hbdt.java

JAVA邮件系统

		{
			for(int i=0;i<nPageLarge;i++)
				if(rs.next()){
					//"hbh"
					sTmpArray[i]=rs.getString(1);
					nTmp=i;
				}
		}catch(Exception ex){
			DB.close();
			return null;
		}
		DB.close();
		if(nTmp==nPageLarge-1)
			return sTmpArray;
		else{
			if(nTmp==0)
				return null;
			String[] sTmpArray2 = new String[nTmp];
			for(int i=0;i<nTmp;i++)
				sTmpArray2[i]=sTmpArray[i];
			return sTmpArray2;
		}
	}
	
	

	
	//把四字代码转换成中文地名
	public String szdmToZwqc(String sSzdm)
	{
		if(sSzdm!=null){
			if(sSzdm.trim().length()==0)
				return "四字代码为空！";
			String sSql="SELECT zwqc FROM dmdm WHERE szdm='"+sSzdm+"'";
			DBOperater DB = new DBOperater("hb");
			ResultSet rs = DB.executeQuery(sSql);
			
			String sZwqc="";
			try
			{
				if(rs.next()){
					//"zwqc"
					sZwqc=rs.getString(1);
					if(sZwqc.trim().compareTo("")==0){
						DB.close();
						return "";//"中文全称未录入！";
					}
					else{
						DB.close();
						return sZwqc;
					}
				}else{
					DB.close();
					return " ";//"四字代码未找到！";
				}
			}catch(Exception ex){
				DB.close();
				return "   ";//"转换时出错";
			}
		}
		return "    ";//"为空！";
	}
	
	
	//把中文地名转换成四字代码
	public String zwqcToSzdm(String sZwqc)
	{
		if(sZwqc!=null){
			if(sZwqc.trim().length()==0)
				return "";
			String sSql="SELECT szdm FROM dmdm WHERE zwqc like'%"+sZwqc.trim()+"%'";
			DBOperater DB = new DBOperater("hb");
			ResultSet rs = DB.executeQuery(sSql);
			try
			{
				if(rs.next()){
					//"szdm"
					String sSzdm=rs.getString(1);
					if(sSzdm.trim().compareTo("")==0){
						DB.close();
						return "";//"未找到"+sZwqc+"的四字代码！";
					}
					else{
						DB.close();
						return sSzdm;
					}
				}else{
					DB.close();
					return " ";//"中文名称未找到！";
				}
			}catch(Exception ex){
				DB.close();
			}
			return "   ";//"sZwqc为空！";
		}
		return "    ";//"未输入";
	}
	
	
	//把四位数字表示为时间
	//XXXX变成XX:XX
	public String nemberToTime(String sNember)
	{
		if(sNember!=null){
			if(sNember.length()==4){
				String sTime=sNember.substring(0,2);
				sTime+=":";
				sTime+=sNember.substring(2,4);
				return sTime;
			}
			return "要转换的数字不是四位！";
		}
		return "未知";
	}
	
	
	//获得航空公司名称：
	public String getCompanyName()
	{
		String sSql="SELECT zwqc from gsdm where ezdm='"+sHbh.substring(0,2)+"'";
		DBOperater DB = new DBOperater("hb");
		ResultSet rs = DB.executeQuery(sSql);
		try
		{
			if(rs.next()){
				//"zwqc"
				String sZwqc = rs.getString(1);
				if(sZwqc.trim().compareTo("")==0){
					DB.close();
					return "";//"公司名称为空！";
				}
				DB.close();
				return sZwqc;
			}else{
				DB.close();
				return " ";//"无法获得公司名称";
			}
		}catch(Exception ex){
			DB.close();
			return "  ";//"获得公司名称出错";
		}
	}
	
	public String getCompanyName(String sHbh)
	{
		if(sHbh.length()<2)
			return "无法获得公司名称！";
		String sSql="SELECT zwqc from gsdm where ezdm='"+sHbh.substring(0,2)+"'";
		DBOperater DB = new DBOperater("hb");
		ResultSet rs = DB.executeQuery(sSql);
		try
		{
			if(rs.next()){
				//"zwqc"
				String sZwqc = rs.getString(1);
				if(sZwqc.trim().compareTo("")==0){
					DB.close();
					return "";//"公司名称为空！";
				}
				DB.close();
				return sZwqc;
			}else{
				DB.close();
				return " ";//"无法获得公司名称";
			}
		}catch(Exception ex){
			DB.close();
			return "  ";//"获得公司名称出错";
		}
	}
	
	
	//获得航班号
	public String getHbh()
	{
		if(nHbhLength==0)
			return null;
		return sHbh;
	}
	
	//获得特定班期的长度：
	public int getLineLength()
	{
		return nHbhLength;
	}
	
	
	//获得计划起飞时间数组
	public String[] getJhqf()
	{
		if(nHbhLength==0){
			return null;
		}
		String[] sTmp=new String[nHbhLength];
		for(int i=0;i<nHbhLength;i++){
			sTmp[i] = this.nemberToTime(sJhqf[i]);
		}
		return sTmp;
	}
	
	
	//获得计划落地时间数组
	public String[] getJhld()
	{
		if(nHbhLength==0)
			return null;
		String[] sTmp=new String[nHbhLength];
		for(int i=0;i<nHbhLength;i++){
			sTmp[i] = this.nemberToTime(sJhld[i]);
		}
		return sTmp;
	}
	
	
	//获得实际起飞时间数组
	public String[] getSjqf()
	{
		if(nHbhLength==0)
			return null;
		String[] sTmp=new String[nHbhLength];
		for(int i=0;i<nHbhLength;i++){
			sTmp[i] = this.nemberToTime(sSjqf[i]);	
		}
		return sTmp;
	}
	
	
	//获得实际落地时间数组
	public String[] getSjld()
	{
		if(nHbhLength==0)
			return null;
		String[] sTmp=new String[nHbhLength];
		for(int i=0;i<nHbhLength;i++){
			sTmp[i] = this.nemberToTime(sSjld[i]);
		}
		return sTmp;
	}
	
	
	//获得机型代码
	public String getJxdm()
	{
		if(nHbhLength==0)
			return null;
		return sJxdm;
	}
	
	
	//获得起飞机场数组
	public String[] getQfjc()
	{
		if(nHbhLength==0)
			return null;
		String[] sTmp = new String[nHbhLength];
		for(int i=0;i<nHbhLength;i++)
			sTmp[i]=this.szdmToZwqc(sQfjc[i]);
		return sTmp;
	}
	
	
	//获得落地机场数组
	public String[] getLdjc()
	{
		if(nHbhLength==0)
			return null;
		String[] sTmp = new String[nHbhLength];
		for(int i=0;i<nHbhLength;i++)
			sTmp[i]=this.szdmToZwqc(sLdjc[i]);
		return sTmp;
	}
	
	
	//获得执行日期
	public String getZxrq()
	{
		if(nHbhLength==0)
			return null;
		return sZxrq;
	}
	
	public int[] getZxrq(String sZxrq)
	{
		if(sZxrq.length()!=10)
			return null;
		int[] rq = new int[3];
		try
		{
			rq[0]=Integer.parseInt(sZxrq.substring(0,4));
			rq[1]=Integer.parseInt(sZxrq.substring(5,7));
			rq[2]=Integer.parseInt(sZxrq.substring(8,10));
		}catch(Exception ex){
			return null;
		}
		return rq;
	}
	
	//国内国际：
	public String getGngj()
	{
		if(nHbhLength==0)
			return null;
		String sTmp;
		if(sGngj.compareTo("T")==0)
			sTmp="国际航班";
		else
			sTmp="国内航班";
		return sTmp;
	}
	
	//获得航班状态数组
	public String[] getHbzt()
	{
		if(nHbhLength==0)
			return null;
		String[] sTmp = new String[nHbhLength];
		for(int i=0;i<nHbhLength;i++)
			sTmp[i]=this.hbztToZwzt(sHbzt[i]);
		return sTmp;
	}
	
	//把航班状态转换成中文：
	public String hbztToZwzt(String sTmp)
	{
		if(sTmp==null)
			return "空状态";
		if(sTmp.compareTo("P")==0)
			return "未起飞";

		if(sTmp.compareTo("E")==0)
			return "等待起飞";
		
		if(sTmp.compareTo("A")==0)
			return "已经起飞";
		
		if(sTmp.compareTo("D")==0)
			return "降落";
		
		if(sTmp.compareTo("C")==0)
			return "飞行取消";
		return "未知状态";
	  }
	
	//计算数量：
	int nLength=0;
	public void countNember(String sTmp)
	{
		//获得满足条件的文档信息：
		DBOperater DB = new DBOperater("Hb");
		ResultSet rs= DB.executeQuery(sTmp);
		try
		{
			if(rs.next())
				nLength=rs.getInt(1);
		}catch(Exception ex){
		}
		DB.close();
	}
	
	//获得数量：
	public int getNember()
	{
		return nLength;
	}
	
	public int getNember(String sCompany)
	{
	//获得满足条件的公司信息：
		//加入时间的判断：
		//取得航班动态中的执行日期：
		String sDate="";
		String sSql="SELECT distinct zxrq";
		sSql+=" FROM hbdt WHERE hbh like '"+sCompany+"%' order by zxrq desc";
		
		DBOperater DB = new DBOperater("Hb");
		ResultSet rs = DB.executeQuery(sSql);
		
		try
		{
			if(rs.next()){
				sDate=rs.getString(1);
			}else{
				DB.close();
				nHbhLength=0;
				return 0;
			}
		}catch(Exception ex){
			DB.close();
			nHbhLength=0;
			return 0;
		}
		DB.close();
		
		//如果执行日期比当前时间晚48小时以上，则return false,否则继续查询
		Calendar c1 = Calendar.getInstance(),c2 = Calendar.getInstance();
		int nc[] =getZxrq(sDate);
		c2.set(nc[0],nc[1]-1,nc[2],48,0);
		if(c2.getTime().before(c1.getTime()))
			return 0;
		String sAddition = " AND zxrq = '"+sDate+"'";
		
		sSql="select count(DISTINCT hbh) from hbdt where hbh like '"+sCompany+"%'";
		DB = new DBOperater("Hb");
		rs= DB.executeQuery(sSql);
		int nTmp=0;
		try
		{
			if(rs.next())
				nTmp=rs.getInt(1);
		}catch(Exception ex){
			System.out.println("nTmp"+nTmp);
		}
		DB.close();
		return nTmp;
	}
	
}