trainsearch.java

JAVA邮件系统

//列车时刻查询入口程序，由模版生成查询界面
import java.io.*;
import java.text.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 * 
 *
 * @author zhukejun
 */

public class TrainSearch extends HttpServlet {
	public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
       
		HtmlOut htmlOut = new HtmlOut (response);
     
		// 得到名字
		String pass;
		Person person = new Person();
		person.setName (CommonMethods.GetUserName(request));
		
		pass = CommonMethods.GetUserPass (request);
		person.setPassword ( pass );
		if( person.getName ()==null || (!person.checkPassword(pass)) )
		{
	    	htmlOut.setErrorID (htmlOut.SHOW_SIMPLE_MESSAGE ,"",
								"请先登录！","Login?action=reLog");
			htmlOut.outHtml();
			return;
		}
		
		TemplateList tempList = CommonMethods.gettrainsearchTemplate ();
		if( tempList == null ){
			htmlOut.setErrorID (htmlOut.TEMPLATE_NOTFIND ,""
							 ,"gettrainsearchTemplate error","Login");
			htmlOut.outHtml ();
			return;
		}
		
		ResultSet rs;
		String queryString,s2="";
		DBOperater DB = new DBOperater ("train");
		//获得车次存入数组
		queryString="select distinct id from train_id";
		rs=DB.executeQuery (queryString);
		int i,j,count2;
		i=0;
		String train_id[];
		train_id=new String[6000];
		if(rs!=null)
			{
				try{
					while(rs.next ())
					{	
						train_id[i]=rs.getString (1).trim ();
						i=i+1;		
					}
	   					
					}catch(Exception e){
						 }   	
			}
		count2=i;
		DB.close ();
		//用车次替换关键字
		SingleTemplate st = tempList.searchTemplate("ROOT");
		int nKey = st.getKeyNum ();
		for(i=0;i<nKey;i++){
			htmlOut.addString (st.getStringAt (i));
			String sKey = st.getKeyAt (i);
			if( sKey .compareTo("cgi-path")==0 )
				htmlOut.addString (CommonMethods.sHostNameCGI);
			if(sKey.compareTo ("TrainID")==0){
				for(j=0;j<count2;j++)
				{
					
					s2=s2+"<option>"+train_id[j]+"</option>";
				}
				htmlOut.addString(s2);
			}			
		}
		htmlOut.addString (st.getEndString () );
		
		htmlOut.outHtml();
	
	}
	
	public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
		 doGet(request,response);
	}
}