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

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

            String biaodashiPage = request.getParameter("biaodashiPage");
            String basisorsub = request.getParameter("basisorsub");

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

            //打印选择项
            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");

            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);

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

            //得到结果集合
            try{
                if("biaodashi".equals(biaodashiPage))
                {
                  queryResultList = queryDAO.getSuperBiaodashiPrintList(sqlResult,querySelectPrintItem,basisorsub);
                } else
                {
                    queryResultList = queryDAO.getSuperPrintList(sqlResult,querySelectPrintItem);
                }
            } catch(Exception ex){
                Debug.println("[QuerySuperPrintToExcelHandler]processEvent----->Exception::" + ex.getMessage());
            }

            request.setAttribute("queryResultList",queryResultList);

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

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

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