showplanqueryaction.java

基于Java的地图数据管理软件。使用MySQL数据库管理系统。

/* 创建日期：Dec 17, 2006
 * 作　　者：朱　闰
 * 公　　司：安徽通途信息技术有限公司
 */

package com.tongtu.Action.planManage;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.tongtu.Action.TopBaseAction;
import com.tongtu.util.CurrentUser;
import com.tongtu.util.Page;
import com.tongtu.util.QueryStr;

public class ShowPlanQueryAction extends TopBaseAction
{
    public ActionForward execute(ActionMapping actionMapping,
            ActionForm actionForm, HttpServletRequest httpServletRequest,
            HttpServletResponse httpServletResponse) {
    	   ActionErrors errors = new ActionErrors();
    	   
    	   String startTmp = httpServletRequest.getParameter("start");//获取首页的
 		  int start = 0,count = CurrentUser.rowCount,pagenum=0;
 	 	  if(startTmp!=null){
 		            start = Integer.parseInt(startTmp);
 		        }
 	 	  HttpSession session = httpServletRequest.getSession();   
 	 	  QueryStr  qs =(QueryStr)session.getAttribute("queryStr");
 	 	  
 	 	  String typeid = httpServletRequest.getParameter("typeId");//获取类型
 	 	 	
 	 	  int typeId = 0;
 	 	  if (typeid != null) {
 	 		  typeId = Integer.parseInt(typeid);
 	 	 if (typeId  == 1){
 	 		  if (qs.getMileType() == 1) 
 	 			  qs.setMileType(2);
 	 		  else qs.setMileType(1);
 	 	  }
 	   	 if (typeId  == 2){
	 		  if (qs.getLjkdType() == 1) 
	 			  qs.setLjkdType(2);
	 		  else qs.setLjkdType(1);
	 	  }
 	 	 if (typeId  == 3){
	 		  if (qs.getLmkdType() == 1) 
	 			  qs.setLmkdType(2);
	 		  else qs.setLmkdType(1);
	 	  }
 	 	 if (typeId  == 4){
	 		  if (qs.getInvestType() == 1) 
	 			  qs.setInvestType(2);
	 		  else qs.setInvestType(1);
	 	  }
 	 	 if (typeId  == 5){
	 		  if (qs.getProType() == 1) 
	 			  qs.setProType(2);
	 		  else qs.setProType(1);
	 	  }
	 	 if (typeId  == 6){
	 		  if (qs.getStartType() == 1) 
	 			  qs.setStartType(2);
	 		  else qs.setStartType(1);
	 	  }
	 	 if (typeId  == 7){
	 		  if (qs.getEndType() == 1) 
	 			  qs.setEndType(2);
	 		  else qs.setEndType(1);
	 	  }
	 	 if (typeId == 8){
      	 	  if (qs.getRoadType() == 1) 
  	 			  qs.setRoadType(2);
  	 		  else qs.setRoadType(1);
      	 	 }
      	  if (typeId == 9){
      	 	  if (qs.getJhType() == 1) 
  	 			  qs.setJhType(2);
  	 		  else qs.setJhType(1);
      	 	 }
      	 if (typeId == 10){
     	 	  if (qs.getTownType() == 1) 
 	 			  qs.setTownType(2);
 	 		  else qs.setTownType(1);
     	 	 }
      	 if (typeId == 11){
     	 	  if (qs.getCunType() == 1) 
 	 			  qs.setCunType(2);
 	 		  else qs.setCunType(1);
     	 	 }
      	 
      	 if (typeId == 12){
    	 	  if (qs.getCityType() == 1) 
	 			  qs.setCityType(2);
	 		  else qs.setCityType(1);
    	 	 }
	 	 qs.setTypeId(typeId);
	 	 
 	 	  }
 	 	 	
 	 	 
	      pagenum = getPlanHelper().getQueryPlanCount(qs);  //获取计划总数 
 		        Page page = getPlanHelper().QueryPlan(start, count, qs);//分页获取计划信息
 	            httpServletRequest.setAttribute("page",page);
 		        httpServletRequest.setAttribute("pagenum",pagenum+"");
 		        httpServletRequest.setAttribute("start",start+"");
 		        httpServletRequest.setAttribute("rowCount",count+"");
 		        
 		       return actionMapping.findForward("success"); 
    }
}