querylicenceinformationlisthandler.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 QueryLicenceInformationListHandler extends DefaultHandlerSupport{
    public HandlerEvent processEvent(HttpServletRequest request) throws
        WebException{
        Debug.println("[QueryLicenceInformationListHandler]ProcessEvent------->start!");

        HandlerEvent handlerEvent = new HandlerEvent();
        String nextPage = null;
        try{
            //接收页面参数
            QueryDAO queryDAO = QueryDAOFactory.getDAO();
            ArrayList queryResultList=new ArrayList();
            HashMap pageParMap = new HashMap();

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

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

            try{
                licenceSavePageFlage=request.getParameter("licenceSavePageFlage");//执照是否保存

                querySessionResultModel=(QuerySessionResultModel) session.getAttribute("querySessionResultModel");

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

                //第一次查询时初始化

                if(querySessionResultModel==null||nowPageNum==null||"".equals(nowPageNum)){
                    nowPageNum="1";

                    Debug.println("第一次查询时初始化 star!");
                    //获得参数
                    pageParMap = getPageElement(request);
                    //获得sql分析结果
                    sqlResult=querySqlTransition.getQuerySql(pageParMap);

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

                    //初始化session
                    querySessionResultModel=new QuerySessionResultModel();
                    querySessionResultModel.setQueryType("SuperQuery");
                    querySessionResultModel.setQuerySQLStr(sqlResult);
                    querySessionResultModel.setQueryResultCount(superQueryCount);
                    querySessionResultModel.setQueryNowPageNum(nowPageNum);
                    querySessionResultModel.setQueryShowNum(""+queryShowNum);
                    session.setAttribute("querySessionResultModel",querySessionResultModel);
                }else{
                    //获得查询结果
                    querySessionResultModel.setQueryNowPageNum(nowPageNum);
                    querySessionResultModel.setQueryShowNum(""+queryShowNum);

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

                }

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

                request.setAttribute("queryResultList",queryResultList);

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

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

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

        Debug.println("[QueryLicenceInformationListHandler]-----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("[QueryLicenceInformationListHandler]---->>>strParName:" + strtemp);
                Debug.println("[QueryLicenceInformationListHandler]---->>>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("[QueryLicenceInformationListHandler]---->getQuerySql sub:"+sub.get(0)+"  ,"+sub.get(1));
            //Debug.println(""+strParment.size());
        }
        return strParment;
    }
}