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

        HandlerEvent handlerEvent = new HandlerEvent();
        String nextPage = null;
        try{
            //接收页面参数
            String nextAction=(String)request.getParameter("nextAction");
            String nextPageType=(String)request.getParameter("nextPageType");
            String biaodashiPage=(String)request.getParameter("aa");//add by yuxiaogang
            String biaodashiSql = (String)request.getParameter("hstrsql_basis2");//add by yuxiaogang
            String basisorsub = (String)request.getParameter("hbasisorsub");//add by yuxiaogang
            if(("".equals(biaodashiPage)||biaodashiPage==null)&&("".equals(basisorsub)||basisorsub==null))
            {
                 biaodashiSql = (String)request.getAttribute("aa");
                 basisorsub = (String)request.getAttribute("hbasisorsub");
            }
            Debug.print("basis or sub:"+basisorsub);

            HttpSession session = request.getSession(false);
            UserModel user = (UserModel) session.getAttribute("userModel");
            String DJJG = user.getAreaCoding();
            biaodashiSql += " and field104 like '"+DJJG+"'";

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

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

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

            try{

                String tempdate;//当前年-1日期
                ArrayList querySelectPrintItem=null;
                Calendar al=Calendar.getInstance();
                int yeartemp;
                tempdate=PubFunc.getDateStr(al);
                if(tempdate.length()>4){
                    yeartemp=Integer.parseInt((tempdate).substring(0 ,4))-1;
                    tempdate=""+yeartemp;
                }else{
                    tempdate="";
                }
                request.setAttribute("yearCheckupYear",tempdate);

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

                //第一次查询时初始化
                if(nowPageNum==null||"".equals(nowPageNum)){
                    nowPageNum="1";

                    Debug.println("第一次查询时初始化 star!");
                    //获得参数
                    pageParMap = getPageElement(request);
                    //获得sql分析结果
                    String searchStr=(String)session.getAttribute("searchStr");
                    if (searchStr!=null && !searchStr.equals("")) {
                        sqlResult=querySqlTransition.getQuerySql(pageParMap,searchStr);
                        session.setAttribute("searchStr","");
                    }else{
                        sqlResult=querySqlTransition.getQuerySql(pageParMap);
                    }


                    //获得查询结果
                    if("biaodashi".equals(biaodashiPage))
                    {
                        queryResultList = queryDAO.getSuperBiaodashiQuery(PubFunc.decodeISO(biaodashiSql),Integer.parseInt(nowPageNum),queryShowNum,basisorsub);
                        superQueryCount = queryDAO.getSuperBiaodashiQueryCount(PubFunc.decodeISO(biaodashiSql),basisorsub);
                    }else
                    {
                        queryResultList = queryDAO.getSuperQuery(sqlResult,Integer.parseInt(nowPageNum),queryShowNum);
                        superQueryCount = queryDAO.getSuperQueryCount(sqlResult);
                    }


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

                    //初始化session
                    querySessionResultModel=new QuerySessionResultModel();
                    querySessionResultModel.setQueryType("SuperQuery");
                    querySessionResultModel.setQueryBiaodashi(biaodashiPage);//add by yuxiaogang 20040622
                    querySessionResultModel.setQueryBasisSub(basisorsub);//add by yuxiaogang 20040622
                    if("biaodashi".equals(biaodashiPage))
                    {
                        querySessionResultModel.setQuerySQLStr(PubFunc.decodeISO(biaodashiSql));
                    }else
                    {
                        querySessionResultModel.setQuerySQLStr(sqlResult);
                    }
                    querySessionResultModel.setQueryResultCount(superQueryCount);
                    querySessionResultModel.setQueryNowPageNum(nowPageNum);
                    querySessionResultModel.setQueryShowNum(""+queryShowNum);
                    querySessionResultModel.setQuerySelectPrintItem(querySelectPrintItem);
                    session.setAttribute("querySessionResultModel",querySessionResultModel);

                }else{
                    //获得查询结果
                    querySessionResultModel=(QuerySessionResultModel) session.getAttribute("querySessionResultModel");

                    querySessionResultModel.setQueryNowPageNum(nowPageNum);
                    querySessionResultModel.setQueryShowNum(""+queryShowNum);

                    if("biaodashi".equals(querySessionResultModel.getQueryBiaodashi()))
                        {
                        queryResultList = queryDAO.getSuperBiaodashiQuery(querySessionResultModel.getQuerySQLStr(),Integer.parseInt(querySessionResultModel.getQueryNowPageNum()),Integer.parseInt(querySessionResultModel.getQueryShowNum()),querySessionResultModel.getQueryBasisSub());
                    }else
                    {
                        queryResultList = queryDAO.getSuperQuery(querySessionResultModel.getQuerySQLStr(),Integer.parseInt(querySessionResultModel.getQueryNowPageNum()),Integer.parseInt(querySessionResultModel.getQueryShowNum()));
                    }


                    //初始化选择项
                    superQueryCountInt=Integer.parseInt(querySessionResultModel.getQueryResultCount());
                    querySelectPrintItem=(ArrayList)querySessionResultModel.getQuerySelectPrintItem();
                    //对选择项进行修改
                    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("querySelectPrintItem",querySelectPrintItem);
                request.setAttribute("querySelectPrintItemNum",""+querySelectPrintItemNum);

                request.setAttribute("queryResultList",queryResultList);

                //返回查询需要的参数
                request.setAttribute("nextPageType",nextPageType);
                request.setAttribute("nextAction",nextAction);
                request.setAttribute("biaodashiPage",biaodashiPage);
                request.setAttribute("basisorsub",basisorsub);


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



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

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

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

}