queryyearcheckuplist.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

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

                        //初始化选择项
                        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(page_code);
                        querySessionResultModel.setQuerySQLStr(sqlResult);
                        querySessionResultModel.setQueryResultCount(superQueryCount);
                        querySessionResultModel.setQueryNowPageNum(nowPageNum);
                        querySessionResultModel.setQueryShowNum("" + queryShowNum);
                        querySessionResultModel.setQuerySelectPrintItem(querySelectPrintItem);
                        session.setAttribute("querySessionResultModel",querySessionResultModel);
                    } else{
                        //获得session
                        querySessionResultModel=(QuerySessionResultModel) session.getAttribute("querySessionResultModel");

                        //获得查询结果
                        querySessionResultModel.setQueryNowPageNum(nowPageNum);
                        querySessionResultModel.setQueryShowNum(""+queryShowNum);
                        page_code=querySessionResultModel.getQueryType();
                        //获得查询结果
                        //年检综合情况
                        if("query005".equals(page_code)){
                            //获得查询结果
                            String yearCheckupYear = request.getParameter("yearCheckupYear"); //年检年度
                            queryResultList = queryDAO.getSuperQueryCheckUp(querySessionResultModel.getQuerySQLStr(),Integer.parseInt(querySessionResultModel.getQueryNowPageNum()),Integer.parseInt(querySessionResultModel.getQueryShowNum()),yearCheckupYear);
                            superQueryCount = querySessionResultModel.getQueryResultCount();
                            request.setAttribute("yearcheckupSelect","01");
                        } else

                        //已经年检的企业条件
                        if("query003".equals(page_code)){
                            //获得查询结果
                            String yearCheckupYear = request.getParameter("yearCheckupYear"); //年检年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);

                            queryResultList = queryDAO.getYearCheckupQuery(querySessionResultModel.getQuerySQLStr(),Integer.parseInt(querySessionResultModel.getQueryNowPageNum()),Integer.parseInt(querySessionResultModel.getQueryShowNum()));
                            superQueryCount = querySessionResultModel.getQueryResultCount();
                            request.setAttribute("yearcheckupSelect","02");
                        } else

                        //未年检企业(未申报)
                        if("query008".equals(page_code)){
                            String yearCheckupYear = request.getParameter("yearCheckupYear"); //年检年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);
                            //获得查询结果
                            queryResultList = queryDAO.getUnPassYearCheckup(querySessionResultModel.getQuerySQLStr(),Integer.parseInt(querySessionResultModel.getQueryNowPageNum()),Integer.parseInt(querySessionResultModel.getQueryShowNum()));
                            superQueryCount = querySessionResultModel.getQueryResultCount();
                            request.setAttribute("yearcheckupSelect","03");
                        }else

                        //未年检企业(未通过)
                        if("query015".equals(page_code)){
                            String yearCheckupYear = request.getParameter("yearCheckupYear"); //年检年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);
                            //获得查询结果
                            queryResultList = queryDAO.getUnPassYearCheckup(querySessionResultModel.getQuerySQLStr(),Integer.parseInt(querySessionResultModel.getQueryNowPageNum()),Integer.parseInt(querySessionResultModel.getQueryShowNum()));
                            superQueryCount = querySessionResultModel.getQueryResultCount();
                            request.setAttribute("yearcheckupSelect","04");
                        }else

                        //未年检企业 add by yuxiaogang 20040520
                       if("query022".equals(page_code)){
                           String yearCheckupYear = request.getParameter("yearCheckupYear"); //年检年度
                           request.setAttribute("yearCheckupYear",yearCheckupYear);
                           //获得查询结果
                           queryResultList = queryDAO.getUnPassYearCheckup(querySessionResultModel.getQuerySQLStr(),Integer.parseInt(querySessionResultModel.getQueryNowPageNum()),Integer.parseInt(querySessionResultModel.getQueryShowNum()));
                           superQueryCount = querySessionResultModel.getQueryResultCount();
                           request.setAttribute("yearcheckupSelect","07");
                       }else


                        //企业吊销情况
                        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 = querySessionResultModel.getQueryResultCount();
                            request.setAttribute("yearcheckupSelect","05");
                        } 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 = querySessionResultModel.getQueryResultCount();
                            request.setAttribute("yearcheckupSelect","06");
                        } else


                        //初始化选择项
                        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("queryResultList",queryResultList);

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

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


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

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

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

    }