querybakrecordlisthandler.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

package com.gs.control.handlers.pageBuilder.query;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
import java.util.*;
import javax.servlet.http.*;
import com.gs.control.handlers.DefaultHandlerSupport;
import com.gs.control.exceptions.WebException;
import com.gs.control.event.HandlerEvent;
import com.gs.pageBuilder.dao.*;
import com.gs.pageBuilder.model.*;
import com.gs.util.*;
import com.gs.pageBuilder.util.AutoBuild;
import com.gs.control.util.PageBuilderScreen;
import com.gs.pageBuilder.util.*;

public class QueryBakRecordListHandler extends DefaultHandlerSupport{
    public HandlerEvent processEvent(HttpServletRequest request) throws
        WebException{
        Debug.println("[QueryBakRecordListHandler]ProcessEvent------->start!");

        HandlerEvent handlerEvent = new HandlerEvent();
        String nextPage = null;
        try{
            //接收页面参数
            String nextAction=(String)request.getParameter("nextAction");
            String nextPageType=(String)request.getParameter("nextPageType");

            QueryDAO queryDAO = QueryDAOFactory.getDAO();
            ArrayList queryResultList=new ArrayList();
            HashMap pageParMap = new HashMap();

            String sqlResult="";
            int queryShowNum=0;//列表个数
            String superQueryCount;
            int superQueryCountInt=0;
            String nowPageNum;
            int querySelectPrintItemNum=0;

            HttpSession session = request.getSession(false);
            QuerySessionResultModel querySessionResultModel = null;

            try{

                String tempdate;//当前年-1日期
                ArrayList querySelectPrintItem=null;
                Calendar al=Calendar.getInstance();
                int yeartemp;
                tempdate=PubFunc.getDateStr(al);
                if(tempdate.length()>4){
                    yeartemp=Integer.parseInt((tempdate).substring(0 ,4))-1;
                    tempdate=""+yeartemp;
                }else{
                    tempdate="";
                }
                request.setAttribute("yearCheckupYear",tempdate);

                //提取页面编号,
                nowPageNum=request.getParameter("nowPageNum");
                if(request.getParameter("queryShowNum")==null||"".equals(request.getParameter("queryShowNum"))){
                    queryShowNum=50;
                }else{
                    queryShowNum=Integer.parseInt(request.getParameter("queryShowNum"));
                }

                //第一次查询时初始化
                if(nowPageNum==null||"".equals(nowPageNum)){
                    nowPageNum="1";

                    Debug.println("第一次查询时初始化 star!");
                    //获得参数
                    pageParMap = getPageElement(request);
                    //获得sql分析结果
                    String searchStr=(String)session.getAttribute("searchStr");
                    if (searchStr!=null && !searchStr.equals("")) {
                        sqlResult=querySqlTransition.getQuerySql(pageParMap,searchStr);
                        session.setAttribute("searchStr","");
                    }else{
                        sqlResult=querySqlTransition.getQuerySql(pageParMap);
                    }


                    //获得查询结果
                    queryResultList = queryDAO.getSuperQuery(sqlResult,Integer.parseInt(nowPageNum),queryShowNum);
                    superQueryCount = queryDAO.getSuperQueryCount(sqlResult);

                    //初始化选择项 2004-04-12
                    superQueryCountInt=Integer.parseInt(superQueryCount);
                    querySelectPrintItem=new ArrayList();
                    for(int i=0;i<superQueryCountInt;i++){
                        querySelectPrintItem.add("1");
                    }
                    querySelectPrintItemNum=superQueryCountInt;

                    //初始化session
                    querySessionResultModel=new QuerySessionResultModel();
                    querySessionResultModel.setQueryType("SuperQuery");
                    querySessionResultModel.setQuerySQLStr(sqlResult);
                    querySessionResultModel.setQueryResultCount(superQueryCount);
                    querySessionResultModel.setQueryNowPageNum(nowPageNum);
                    querySessionResultModel.setQueryShowNum(""+queryShowNum);
                    querySessionResultModel.setQuerySelectPrintItem(querySelectPrintItem);//2004-04-12
                    session.setAttribute("querySessionResultModel",querySessionResultModel);

                }else{
                    //获得查询结果
                    querySessionResultModel=(QuerySessionResultModel) session.getAttribute("querySessionResultModel");//2004-04-12

                    querySessionResultModel.setQueryNowPageNum(nowPageNum);
                    querySessionResultModel.setQueryShowNum(""+queryShowNum);

                    queryResultList = queryDAO.getSuperQuery(querySessionResultModel.getQuerySQLStr(),Integer.parseInt(querySessionResultModel.getQueryNowPageNum()),Integer.parseInt(querySessionResultModel.getQueryShowNum()));

                    //初始化选择项
                    superQueryCountInt=Integer.parseInt(querySessionResultModel.getQueryResultCount());
                    querySelectPrintItem=(ArrayList)querySessionResultModel.getQuerySelectPrintItem();
                    //对选择项进行修改
                    querySelectPrintItemNum=0;
                    for(int i=0;i<superQueryCountInt;i++){
                        String tempStr=(String)request.getParameter("querySelectPrintItem"+i);
                        if("1".equals(tempStr))querySelectPrintItem.set(i,"1");
                        if("0".equals(tempStr))querySelectPrintItem.set(i,"0");
                        if("1".equals(querySelectPrintItem.get(i)))querySelectPrintItemNum++;
                    }
                    querySessionResultModel.setQuerySelectPrintItem(querySelectPrintItem);
                    session.setAttribute("querySessionResultModel",querySessionResultModel);
                }

                //页面需要的参数
                request.setAttribute("queryType",querySessionResultModel.getQueryType());
                request.setAttribute("queryShowNum",querySessionResultModel.getQueryShowNum());
                request.setAttribute("queryNowPageNum",querySessionResultModel.getQueryNowPageNum());
                request.setAttribute("queryResultCount",querySessionResultModel.getQueryResultCount());

                //初始化选择项目
                request.setAttribute("querySelectPrintItem",querySelectPrintItem);
                request.setAttribute("querySelectPrintItemNum",""+querySelectPrintItemNum);

                request.setAttribute("queryResultList",queryResultList);

                //返回查询需要的参数
                request.setAttribute("nextPageType",nextPageType);
                request.setAttribute("nextAction",nextAction);


            }catch(Exception ex){
                Debug.println("[QueryBakRecordListHandler]processEvent----->Exception:" + ex.getMessage());
            }



            Debug.println("[QueryBakRecordListHandler]processEvent----->queryResultList 'size():" + queryResultList.size());

        } catch(Exception ex){
            Debug.println("[QueryBakRecordListHandler]Exception----->" + ex);
            throw new WebException(ex);
        }

        Debug.println("[QueryBakRecordListHandler]-----processEvent END!");
        return handlerEvent;
    }

    //得到页面参数如果为空不接受
    private HashMap getPageElement(HttpServletRequest request) throws
        AppException{
        String strtemp;
        String strtemp2;
        int i;
        int num=0;
        HashMap strParment = new HashMap();
        ArrayList sub = new ArrayList();

        //得到参数群
        Enumeration e;
        e = request.getParameterNames();
        for(i = 0;e.hasMoreElements();i++){
            strtemp = (e.nextElement()).toString();
            strtemp2 = request.getParameter(strtemp);
            if(strtemp2!=null&&!(strtemp2).equals("")){
                sub = new ArrayList();
                try{
                    strtemp2=PubFunc.decodeISO(strtemp2);
                    //strtemp2 = new String(strtemp2.getBytes("ISO-8859-1"));
                } catch(Exception ex){}
                //Debug.println("[QueryBakRecordListHandler]---->>>strParName:" + strtemp);
                //Debug.println("[QueryBakRecordListHandler]---->>>strParValue:" + strtemp2);
                sub.add(strtemp); // namefield
                sub.add(strtemp2); // namevalue
                strParment.put((Object) (new Integer(num++)),sub);
            }
        }

        for(i = 0;i < strParment.size();i++){
            sub = (ArrayList) (strParment.get((Object)new Integer(i)));
            Debug.println("[QueryBakRecordListHandler]---->getQuerySql sub:"+sub.get(0)+"  ,"+sub.get(1));
            //Debug.println(""+strParment.size());
        }
        return strParment;
    }

}