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

        HandlerEvent handlerEvent = new HandlerEvent();
        String nextPage = null;
        try{
            //接收页面参数
            HttpSession session = request.getSession(false);
            QuerySessionResultModel querySessionResultModel = null;
            ArrayList querySelectPrintItem = null;

            QueryDAO queryDAO = QueryDAOFactory.getDAO();
            ArrayList queryResultList = new ArrayList();
            QuerySuperResultModel querySuperResultModel = null; //yuxiaogang 20040413 添加
            HashMap pageParMap = new HashMap();
            ArrayList querySubTableFieldList = null; ////yuxiaogang 20040413 添加
            String sqlResult = "";
            String SN = "";
            String subtablename = "sub02_02"; ////yuxiaogang 20040413 添加

            //打印模式 1表格形式输出，2文本形式输出
            String printShowMode = request.getParameter("printShowMode");

            //默认表格形式
            if(printShowMode == null || "".equals(printShowMode.trim())){
                printShowMode = "1";
            }

            request.setAttribute("printShowMode",printShowMode);

            //打印选择项
            String titleStr1 = request.getParameter("titleStr1");
            String titleStr2 = request.getParameter("titleStr2");
            String titleStr3 = request.getParameter("titleStr3");
            String titleStr4 = request.getParameter("titleStr4");
            String titleStr5 = request.getParameter("titleStr5");
            String titleStr6 = request.getParameter("titleStr6");
            String titleStr7 = request.getParameter("titleStr7");
            String titleStr8 = request.getParameter("titleStr8");
            String titleStr9 = request.getParameter("titleStr9");
            String titleStr10 = request.getParameter("titleStr10");
            String titleStr11 = request.getParameter("titleStr11");
            String titleStr12 = request.getParameter("titleStr12");
            String titleStr13 = request.getParameter("titleStr13");
            String titleStr14 = request.getParameter("titleStr14");
            String titleStr15 = request.getParameter("titleStr15");
            String titleStr16 = request.getParameter("titleStr16");
            String titleStr17 = request.getParameter("titleStr17");
            String titleStr18 = request.getParameter("titleStr18");
            String titleStr19 = request.getParameter("titleStr19");
            String titleStr20 = request.getParameter("titleStr20");
            String titleStr21 = request.getParameter("titleStr21");
            String titleStr22 = request.getParameter("titleStr22");
            String titleStr23 = request.getParameter("titleStr23");
            String titleStr24 = request.getParameter("titleStr24");
            String titleStr25 = request.getParameter("titleStr25");
            String titleStr26 = request.getParameter("titleStr26");
            String titleStr27 = request.getParameter("titleStr27");
            String titleStr28 = request.getParameter("titleStr28");

            request.setAttribute("titleStr1",titleStr1);
            request.setAttribute("titleStr2",titleStr2);
            request.setAttribute("titleStr3",titleStr3);
            request.setAttribute("titleStr4",titleStr4);
            request.setAttribute("titleStr5",titleStr5);
            request.setAttribute("titleStr6",titleStr6);
            request.setAttribute("titleStr7",titleStr7);
            request.setAttribute("titleStr8",titleStr8);
            request.setAttribute("titleStr9",titleStr9);
            request.setAttribute("titleStr10",titleStr10);
            request.setAttribute("titleStr11",titleStr11);
            request.setAttribute("titleStr12",titleStr12);
            request.setAttribute("titleStr13",titleStr13);
            request.setAttribute("titleStr14",titleStr14);
            request.setAttribute("titleStr15",titleStr15);
            request.setAttribute("titleStr16",titleStr16);
            request.setAttribute("titleStr17",titleStr17);
            request.setAttribute("titleStr18",titleStr18);
            request.setAttribute("titleStr19",titleStr19);
            request.setAttribute("titleStr20",titleStr20);
            request.setAttribute("titleStr21",titleStr21);
            request.setAttribute("titleStr22",titleStr22);
            request.setAttribute("titleStr23",titleStr23);
            request.setAttribute("titleStr24",titleStr24);
            request.setAttribute("titleStr25",titleStr25);
            request.setAttribute("titleStr26",titleStr26);
            request.setAttribute("titleStr27",titleStr27);
            request.setAttribute("titleStr28",titleStr28);

            //获得session
            //获得查询结果
            querySessionResultModel = (QuerySessionResultModel) session.getAttribute("querySessionResultModel");
            querySelectPrintItem = (ArrayList) querySessionResultModel.getQuerySelectPrintItem();
            sqlResult = (String) querySessionResultModel.getQuerySQLStr();

            //得到结果集合
            try{
                queryResultList = queryDAO.getSuperPrintList(sqlResult,querySelectPrintItem);
                //////////modified by yuxiaogang 20040413 13:25
                if(queryResultList != null){
                    for(int i = 0;i < queryResultList.size();i++){
                        querySuperResultModel = (QuerySuperResultModel) queryResultList.get(i);
                        SN = (String) querySuperResultModel.getSN();
                        querySubTableFieldList = queryDAO.getQuerySubTableFieldList(SN,subtablename);
                       // Debug.print("证件名称个数："+querySubTableFieldList.size());
                        for(int j = 0;j < querySubTableFieldList.size();j++){
                            HashMap fieldmap = (HashMap) querySubTableFieldList.get(i);
                            querySuperResultModel.setzhengjianType((String) fieldmap.get("field025"));
                            querySuperResultModel.setzhengjianhao((String) fieldmap.get("field053"));
                            //Debug.print("负责人证件名称："+querySuperResultModel.getzhengjianType());
                            //Debug.print("负责人证件号码："+querySuperResultModel.getzhengjianhao());
                        }

                        ////////////////////////////////////////////////

                    }
                }

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

            /*
                        if(queryResultList != null){
                              for(int i = 0;i < queryResultList.size();i++){
                                  querySuperResultModel = (QuerySuperResultModel) queryResultList.get(i);
                                  //Debug.print("最后证件类型："+querySuperResultModel.getzhengjianType());
                                   //Debug.print("最后证件号码："+querySuperResultModel.getzhengjianhao());
                              }}
             */
            request.setAttribute("queryResultList",queryResultList);
            //    request.setAttribute("querySubTableFieldList",querySubTableFieldList); //add by yuxiaogang 20040414 9:05

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

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

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