searchaction_xianlu.java

java做的 公交车查询系统....毕业设计

//在main.jsp主页中,进行线路查询处理动作
package gongjiaochexitong.gongjiaoche.main_pkg;

import gongjiaochexitong.gongjiaoche.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessages;
import org.apache.struts.action.ActionMessage;
import javax.servlet.ServletContext;
import javax.sql.DataSource;

public final class searchAction_XianLu extends Action {
	
	public ActionForward execute(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,  
			HttpServletResponse response) throws Exception {
				
		    xianLuForm xianluForm = (xianLuForm)form;
		    String qidian = xianluForm.getQidian();
		    String zhongdian = xianluForm.getZhangdian();
		    
		    ServletContext context = servlet.getServletContext();
			DataSource dataSource = (DataSource)context.getAttribute("db_gongjiaoche");
			conn_Bus db = new conn_Bus(dataSource);   		
			
			HttpSession session = request.getSession();
			ActionMessages actionMessages = new ActionMessages();
			
			if(qidian==null || qidian.equals("") || zhongdian==null || zhongdian.equals("")){
				actionMessages.add(ActionMessages.GLOBAL_MESSAGE,
						new ActionMessage("label.searchFailure"));
							
				if (!actionMessages.isEmpty()) {
							saveMessages(request, actionMessages);
				}
				db.conn_Close();     //close connection
				return mapping.findForward("searchError");
			}
			else if(procedure.search_XIANLU(db,qidian,zhongdian)!=null){    //查询结果集不为空
				request.setAttribute(constants.SEARCH_XIANLU_KEY,procedure.search_XIANLU(db,qidian,zhongdian));
				actionMessages.add(ActionMessages.GLOBAL_MESSAGE,
						new ActionMessage("label.searchSuccess"));
							
				if (!actionMessages.isEmpty()) {
							saveMessages(request, actionMessages);
				}
				db.conn_Close();     //close connection
			    return mapping.findForward("searchSuccess");
			}
			else{     //在信息上提示无直达车                   
				actionMessages.add(ActionMessages.GLOBAL_MESSAGE,
						new ActionMessage("label.searchXianLuFailure"));
							
				if (!actionMessages.isEmpty()) {
							saveMessages(request, actionMessages);
				}
				db.conn_Close();     //close connection
			    return mapping.findForward("searchError");
			}
			
		}
	
}