querylogoutrevokehandler.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.*;
import com.gs.component.sysadmin.model.*;

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

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

                int superQueryCountInt=0;
                int querySelectPrintItemNum=0;

                String sqlResult="";
                int queryShowNum=0;//列表个数
                String superQueryCount="";
                String nowPageNum;
                String page_code;
                HttpSession session = request.getSession(false);
                QuerySessionResultModel querySessionResultModel = null;
                UserModel user = (UserModel) session.getAttribute("userModel");

                request.setAttribute("queryDJJG",user.getAreaCoding());
                request.setAttribute("queryGXDW",user.getAreaCoding());
                request.setAttribute("queryGXDW",user.getAreaCoding());

                try{
                    //打印选择项目
                    ArrayList querySelectPrintItem=null;

                    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"));
                    }
                    page_code = request.getParameter("page_code");

                    //第一次查询时初始化

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

                        //异常处理 第一次查询
                        if(page_code == null || "".equals(page_code)){
                            Debug.println("[QueryLogoutRevokeHandler]ProcessEvent------->page_code is null!");
                            return handlerEvent;
                        }

                        nowPageNum = "1";

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

                        //获得查询结果

                        //吊销
                        if("query013".equals(page_code)){
                            //获得查询结果
                            String yearCheckupYear = request.getParameter("query0109field110"); //注销吊销年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);

                            queryResultList = queryDAO.getSuperQuery(sqlResult,Integer.parseInt(nowPageNum),queryShowNum);
                            superQueryCount = queryDAO.getSuperQueryCount(sqlResult);
                            request.setAttribute("yearcheckupSelect","04");
                        } else

                        //注销
                        if("query014".equals(page_code)){
                            //获得查询结果
                            String yearCheckupYear = request.getParameter("query0109field110"); //注销吊销年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);

                            queryResultList = queryDAO.getSuperQuery(sqlResult,Integer.parseInt(nowPageNum),queryShowNum);
                            superQueryCount = queryDAO.getSuperQueryCount(sqlResult);
                            request.setAttribute("yearcheckupSelect","05");
                        }

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

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

                        //吊销
                        if("query013".equals(page_code)){
                            //获得查询结果
                            String yearCheckupYear = request.getParameter("yearCheckupYear"); //注销吊销年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);

                            queryResultList = queryDAO.getSuperQuery(querySessionResultModel.getQuerySQLStr(),Integer.parseInt(querySessionResultModel.getQueryNowPageNum()),Integer.parseInt(querySessionResultModel.getQueryShowNum()));
                            superQueryCount = queryDAO.getSuperQueryCount(querySessionResultModel.getQuerySQLStr());
                            request.setAttribute("yearcheckupSelect","04");
                        } else

                        //注销
                        if("query014".equals(page_code)){
                            //获得查询结果
                            String yearCheckupYear = request.getParameter("yearCheckupYear"); //注销吊销年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);

                            queryResultList = queryDAO.getSuperQuery(querySessionResultModel.getQuerySQLStr(),Integer.parseInt(querySessionResultModel.getQueryNowPageNum()),Integer.parseInt(querySessionResultModel.getQueryShowNum()));
                            superQueryCount = queryDAO.getSuperQueryCount(querySessionResultModel.getQuerySQLStr());
                            request.setAttribute("yearcheckupSelect","05");
                        }

                        //对选择项进行修改
                        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("queryResultList",queryResultList);

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

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


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

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

            Debug.println("[QueryLogoutRevokeHandler]-----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 = new String(strtemp2.getBytes("ISO-8859-1"));
                        strtemp2 =PubFunc.decodeISO(strtemp2);
                    } catch(Exception ex){}
                    Debug.println("[QueryLogoutRevokeHandler]---->>>strParName:" + strtemp);
                    Debug.println("[QueryLogoutRevokeHandler]---->>>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("[QueryLogoutRevokeHandler]---->getQuerySql sub:"+sub.get(0)+"  ,"+sub.get(1));
                //Debug.println(""+strParment.size());
            }
            return strParment;
        }

    }