nbsearch.java

重要 重要 重要 重要 重要 重要 重要 重要

package com.safetys.search;

import java.util.ArrayList;

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

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 com.safetys.haike.util.ParamTrans;
import com.safetys.haike.util.SepPage;

public class NbSearch extends Action {
	public ActionForward execute(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,  
			HttpServletResponse response) throws Exception {
		String companyName = request.getParameter("companyName")+"";
		SepPage page=new SepPage();
		 String where =" lastly=1";
		 if(!"".equals(ParamTrans.getParameter(companyName))&&!"null".equals(ParamTrans.getParameter(companyName))){
			 where+=" and companyName like '%"+companyName+"%'";
		 }
		    System.out.println(where);
		    page.setStrWhere(where);
		    page.setTable("deal_second_main");
		    String sumCount="";
		    if(request.getAttribute("total")==null){
		    	sumCount=page.getDataSumCount()+"";
		    }else{
		    	sumCount=request.getAttribute("total").toString();
		    }
		    request.setAttribute("sumCount",sumCount);
		    String pageNo=ParamTrans.getParameter(request,"pageNo");
		    if(!pageNo.equals("")){ //not first page
			    String pageSize=ParamTrans.getParameter(request,"pageSize");
			    page.setPageIndex(Integer.parseInt(pageNo));
			    page.setPageSize(Integer.parseInt(pageSize));
			    request.setAttribute("rowNumber",((Integer.parseInt(pageNo)-1)*Integer.parseInt(pageSize))+"");
		    }else{
			    request.setAttribute("rowNumber","0");
		    }
		    page.setDoCount(0);
		    page.setOrderName("id");
		//    page.setOrderWhere("userName,id");
		    page.setFieldCount(4);
		    page.setFieldName("id,companyName,referDate,(select nodeName from flow_submenu where id=deal_second_main.submenuId)");
		    ArrayList dataSet=page.getDataSet();
		    request.setAttribute("dataSet",dataSet);
		    return mapping.findForward("search");
	}

}