whchannel.java

JAVA邮件系统

			start=start+selectwhcode[i].length()+1 ;
			i=i+1;
		}
		selectcount=i;
		DBOperater DB = new DBOperater ("wh");
		//获取用户已有的信息
		String selectedwhcode[];
		selectedwhcode=new String[100];
		int selectedcount;
		queryString ="select whwarn_hlcode from wh_warning where whwarn_userid='"+CommonMethods.DealWithSQLParameter(p.username)+"'";				
		rs = DB.executeQuery(queryString);
			i=0;
			if(rs!=null){
				try{
					while(rs.next())
					{   
						
				
						selectedwhcode[i]=rs.getString(1).trim ();
						i=i+1;
			
					}
				}catch(Exception er){
				}
			}	
		selectedcount=i;
		
		
		
			//添加
			for(i=0;i<selectcount;i++)
			{
				for(j=0;j<selectedcount;j++)
				{
					
					if(selectwhcode[i].compareTo(selectedwhcode[j])==0)
					{
						exist=true;
						
					}
			

				}
				if(exist==false)
				{
					
					queryString="insert into wh_warning(whwarn_userid,whwarn_hlcode,whwarn_type,whwarn_top,whwarn_down) values('"
								+CommonMethods.DealWithSQLParameter(p.username) +"','"+CommonMethods.DealWithSQLParameter(selectwhcode[i])+"','"+"',10000.0,0.0)";			
					DB.executeUpdate (queryString);

				}
				exist=false;
			}
			//删除
			
			exist=true;
			for(i=0;i<selectedcount;i++)
			{
				for(j=0;j<selectcount;j++)
				{
					
					if(selectedwhcode[i].compareTo(selectwhcode[j])==0)
					{
						exist=false;
						
					}
				
				}
				if(exist==true)
				{
						queryString ="delete from wh_warning where whwarn_userid='"+CommonMethods.DealWithSQLParameter(p.username) +"' and whwarn_hlcode='"+CommonMethods.DealWithSQLParameter(selectedwhcode[i])+"'";
						DB.executeUpdate (queryString);
				}
				exist=true;
			}
		DB.close ();
		return true;
	}
	
	// 删除外汇
	boolean deleteWh(String whcode,Person p,HtmlOut desHtml)
	{
		if(!checkWh(whcode))
		{
			desHtml.setErrorID (desHtml.SHOW_SIMPLE_MESSAGE ,"",
								"外汇代码不正确!"
								,"EditChannel?channel=wh" );
			return false;
		}
		String queryString,count="";
		ResultSet rs;
		DBOperater DB = new DBOperater ("wh");
		queryString="select count(*) from wh_warning where whwarn_userid='"+
					CommonMethods.DealWithSQLParameter(p.getName())+"' and whwarn_hlcode='"+CommonMethods.DealWithSQLParameter(whcode)+"'";
		rs=DB.executeQuery (queryString);
		if(rs!=null)
		{
			try{
				rs.next ();
				count=rs.getString(1);
			}catch(Exception ex) {
			}
		}
		if(count.compareTo ("")!=0)
		{
			queryString = "delete from wh_warning where whwarn_userid='" +
					CommonMethods.DealWithSQLParameter(p.getName()) + "' AND whwarn_hlcode ='" + CommonMethods.DealWithSQLParameter(whcode) + "'";
			DB.executeUpdate (queryString);
		}
		
		else
		{
			desHtml.setErrorID (desHtml.SHOW_SIMPLE_MESSAGE ,"",
							 "该外汇不存在","Login");
			desHtml.outHtml();
			DB.close ();
			return false;
		}
		DB.close ();
		
		return true;

	}
	//查看行情
	boolean showhq(String whcode,String biaomin,HtmlOut desHtml)
	{
		if(!checkWh(whcode))
		{
			desHtml.setErrorID (desHtml.SHOW_SIMPLE_MESSAGE ,"",
								"外汇代码不正确!"
								,"EditChannel?channel=wh" );
			return false;
		}
		String queryString,temp="",hldm="",rq="",kpj="",zgj="",zdj="",spj="",zd="";
		ResultSet rs;
		int len;
		if(biaomin.compareTo ("wh_rhq")!=0&&biaomin.compareTo ("wh_yhq")!=0&&biaomin.compareTo ("wh_zhq")!=0)
		{
			desHtml.setErrorID (desHtml.SHOW_SIMPLE_MESSAGE ,"",
								"没有您要的信息!"
								,"EditChannel?channel=wh" );	
			return false;
		}
		len=biaomin.length ();
		temp="wh"+biaomin.substring (3,len);
		DBOperater DB = new DBOperater ("wh");
		queryString = "select * from "+ biaomin+" where "+temp+"_code = '" + CommonMethods.DealWithSQLParameter(whcode) + "'";	
		rs=DB.executeQuery (queryString);
		if(rs!=null)
		{
			try{
				if(rs.next ())
				{
				hldm = rs.getString(1);
				rq = rs.getString(2);
				kpj = rs.getString(3);
				zdj = rs.getString(4);
				zgj = rs.getString(5);
				spj = rs.getString(6);
				zd = rs.getString(7);
				
				//
				kpj = CommonMethods.FormatDoubleString (kpj,4);
				zgj = CommonMethods.FormatDoubleString (zgj,4);
				zdj = CommonMethods.FormatDoubleString (zdj,4);
				spj = CommonMethods.FormatDoubleString (spj,4);
				zd = CommonMethods.FormatDoubleString (zd,4);
				}
				else{
					desHtml.setErrorID (desHtml.SHOW_SIMPLE_MESSAGE ,"",
								"该条纪录的信息没有!"
								,"EditChannel?channel=wh" );
					DB.close ();
					return false;
					
				}
	   	    	
			}catch(Exception ex) {
			}
		}
		DB.close ();
					
		KeyResultList kr = new KeyResultList();
		TemplateList tl = CommonMethods.getshowhqTemplate();
		SingleTemplate st = tl.searchTemplate("ROOT");
		
		kr.setKeyResult("汇率代码",hldm);
		kr.setKeyResult("日期",rq);
		kr.setKeyResult("开盘价",kpj);
		kr.setKeyResult("最高价",zgj);
		kr.setKeyResult("最低价",zdj);
		kr.setKeyResult("收盘价",spj);
		kr.setKeyResult("涨跌",zd);
	
		desHtml.addString(st.makeResult(kr));
		
		return true;
	}
	
	// 编辑外汇警报页面
	boolean editWarn(String whcode,Person p,HtmlOut desHtml)
	{
		if(!checkWh(whcode))
		{
			desHtml.setErrorID (desHtml.SHOW_SIMPLE_MESSAGE ,"",
								"外汇代码不正确!"
								,"EditChannel?channel=wh" );
			return false;
		}
		String queryString,warnmax="",warnmin="";
		ResultSet rs;
		String warntype="0";
		double maxV,minV;
	
		DBOperater DB = new DBOperater ("wh");
		queryString = "select whwarn_top,whwarn_down from wh_warning where whwarn_userid='" +
			      CommonMethods.DealWithSQLParameter(p.getName()) + "' AND whwarn_hlcode = '" + CommonMethods.DealWithSQLParameter(whcode) + "'";	
		rs=DB.executeQuery (queryString);
		if(rs!=null)
		{
			try{
				if(rs.next ())
				{
	   	    	warnmax = rs.getString(1);
				maxV=CommonMethods.GetDouble (warnmax,200);			
				warnmax = CommonMethods.FormatDouble(maxV,4);
				
				if( Double.valueOf (warnmax).doubleValue () >= 10000 ){
						warnmax = "";
					}
	   	    	warnmin = rs.getString(2);
				minV=CommonMethods.GetDouble (warnmin,10);			
				warnmin = CommonMethods.FormatDouble(minV,4);
				if( Double.valueOf (warnmin).doubleValue () <= 0 ){
						warnmin = "";
					}
				}
			}catch(Exception ex) {
			}
		}
		else
		{
			desHtml.setErrorID (desHtml.SHOW_SIMPLE_MESSAGE ,"",
							 "该外汇不存在","Login");
			desHtml.outHtml();
			DB.close ();
			return false;
		}
		DB.close ();				
		KeyResultList kr = new KeyResultList();
		TemplateList tl = CommonMethods.getEditWhTemplate1();
		SingleTemplate st = tl.searchTemplate("ROOT");
		
		kr.setKeyResult("cgi-path",CommonMethods.sHostNameCGI);
		kr.setKeyResult("warnmax",warnmax);
		kr.setKeyResult("warnmin",warnmin);
		kr.setKeyResult("外汇代码",whcode);
		desHtml.addString(st.makeResult(kr));
		
		return true;
	}

	// 编辑外汇警报内容
	boolean makeWarn(String whcode,Person p,HtmlOut desHtml,HttpServletRequest request)
	{
		String queryString;
		if(!checkWh(whcode))
		{
			desHtml.setErrorID (desHtml.SHOW_SIMPLE_MESSAGE ,"",
								"外汇代码不正确!"
								,"EditChannel?channel=wh" );
			return false;
		}
		DBOperater DB = new DBOperater ("wh");
		double warnmax,warnmin;
		String sMax = request.getParameter("warnmax");
		String sMin = request.getParameter("warnmin");
		try{
			warnmax = Double.valueOf (sMax).doubleValue ();
			if(warnmax>10000||warnmax<=0)
				warnmax=10000;
			}catch(Exception e){
				warnmax = 10000;
			}
		try{
				warnmin = Double.valueOf (sMin).doubleValue ();
				if(warnmin<=0)
					warnmin=0;
			}catch(Exception e){
				warnmin = 0;
			}

			queryString = "update wh_warning SET " +
				"whwarn_top = " + warnmax + ",whwarn_down = " + warnmin + 
				" where whwarn_userid='" +
			      CommonMethods.DealWithSQLParameter(p.getName()) + "' AND whwarn_hlcode = '" + CommonMethods.DealWithSQLParameter(whcode) + "'";
	 	    DB.executeUpdate (queryString);
	   	    
	   	    DB.close ();
		
		return true;
	}
	
// 检查外汇代码是否合法
	boolean checkWh(String whcode)
	{
		DBOperater DB = new DBOperater ("wh");
		
		ResultSet rs = DB.executeQuery ("select whhl_code from wh_hldic where whhl_code='"
										+CommonMethods.DealWithSQLParameter(whcode)+"'");
		if(rs==null)
		{
			DB.close();
			return false;
		}
		try{
			if(rs.next()){
				DB.close ();
				return true;
			}
		}catch(Exception e){
		}
		DB.close ();
		return false;
	}
boolean makeTX(Person p,HtmlOut desHtml,HttpServletRequest request)
	{
		String sSet= request.getParameter ("set");

		String sSet1= request.getParameter ("warnby1");
		String sSet2= request.getParameter ("warnby2");
		
		DBOperater DB = new DBOperater ("wh");
		String queryString;

	   	int nWhTX = 0;
		if( sSet!=null ){
			if( sSet1!=null ){
				nWhTX |= 1;	
			}
			if( sSet2!=null ){
				nWhTX |= 2;	
			}
			DB.executeUpdate ( "update person set whtx="
							   +nWhTX +" where username='"
							   +p.getName()+"'" );
			DB.close ();
			desHtml.setErrorID (desHtml.SHOW_SIMPLE_MESSAGE_WITHCLOSE  ,
								"","设置成功！"
								,"");
			return true;									   
		}
		
		ResultSet rs ;
		try{
			rs= DB.executeQuery ("select whtx from person where username='"
										+p.getName()+"'" );
			if(rs.next ())
				nWhTX=rs.getInt (1);
		}catch(Exception e){
		}
	   	    
		DB.close();
		
		TemplateList tempList = CommonMethods.getDZTemplate();
		SingleTemplate st = tempList.searchTemplate ("ROOT");
		String sKey;
		for( int i=0;i<st.getKeyNum ();i++){
			sKey=st.getKeyAt (i);
			desHtml.addString(st.getStringAt (i));
			if( sKey .compareTo("cgi-path")==0 )
				desHtml.addString (CommonMethods.sHostNameCGI);
			if( sKey.compareTo ("warnby")==0)
				desHtml.addString (Integer.toString (nWhTX));
			if( sKey.compareTo ("warncgi")==0)
				desHtml.addString ("ServeWh");
		}
		desHtml.addString(st.getEndString ());
		
		return true;
	}
}