queryyearcheckupselectprint.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.pageBuilder.model.QuerySuperResultModel;

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

        HandlerEvent handlerEvent = new HandlerEvent();
        String nextPage = null;
        try{
            //接收页面参数
            QueryDAO queryDAO = QueryDAOFactory.getDAO();
            //PageDefineDAO pageDefineDAO = PageDefineDAOFactory.getDAO();
            ArrayList queryResultList = new ArrayList();
            String yearCheckupYear =request.getParameter("yearCheckupYear");
            String yearcheckupSelect = request.getParameter("yearcheckupSelect");

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

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

            //接收页面参数
            HttpSession session = request.getSession(false);
            QuerySessionResultModel querySessionResultModel = null;
            ArrayList querySelectPrintItem = null;
            String sqlResult = "";
            int superQueryCountInt = 0;

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

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

            //获得sql分析结果
            //未年检的企业,未通过
            if( "03".equals(yearcheckupSelect) || "04".equals(yearcheckupSelect) || "07".equals(yearcheckupSelect)){
                //得到结果集合
                try{
                    queryResultList = queryDAO.getUnPassYearCheckupPrintList(sqlResult,querySelectPrintItem);
                } catch(Exception ex){
                    Debug.println("[QueryYearCheckupSelectPrint]processEvent----->Exception::" + ex.getMessage());
                }
            } else
            //已经年检的企业
            if("02".equals(yearcheckupSelect)){
                //得到结果集合
                try{
                    queryResultList = queryDAO.getSuperYearCheckupPrintList(sqlResult,querySelectPrintItem);

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

            }else
            if("05".equals(yearcheckupSelect)||"06".equals(yearcheckupSelect)){
                //得到结果集合
                try{
                    queryResultList = queryDAO.getSuperPrintList(sqlResult,querySelectPrintItem);
                } catch(Exception ex){
                    Debug.println("[QueryYearCheckupSelectPrint]processEvent----->Exception::" + ex.getMessage());
                }
            }else
            //年检综合情况查询
            if("01".equals(yearcheckupSelect)){
                //得到结果集合
                try{
                    queryResultList = queryDAO.getSuperPrintListCheckUp(sqlResult,querySelectPrintItem,yearCheckupYear);
                } catch(Exception ex){
                    Debug.println("[QueryYearCheckupSelectPrint]processEvent----->Exception::" + ex.getMessage());
                }
            }
            request.setAttribute("queryResultList",queryResultList);
            request.setAttribute("yearcheckupSelect",yearcheckupSelect);
            request.setAttribute("yearCheckupYear",yearCheckupYear);

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

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