viewlog.jsp

JAVA做的J2EE下CA认证系统 基于EJB开发

    if( request.getParameter(ACTION).equals(ACTION_CHANGEFILTERMODETO_BASIC)){
      ejbcawebbean.setLastLogFilterMode(AdminPreference.FILTERMODE_BASIC);
      filtermode = AdminPreference.FILTERMODE_BASIC;    
    }

    if( request.getParameter(ACTION).equals(ACTION_CHANGEENTRIESPERPAGE)){
      size = Integer.parseInt(request.getParameter(SELECT_ENTRIESPERPAGE));
      ejbcawebbean.setLogEntriesPerPage(size);
    }
 
   if( request.getParameter(BUTTON_PREVIOUS) != null ){
     record = Integer.parseInt(request.getParameter(HIDDEN_RECORDNUMBER));
     record -= ejbcawebbean.getLogEntriesPerPage();
     if(record < 0 ) record=0;
   }
   if( request.getParameter(BUTTON_NEXT) != null ){
     record = Integer.parseInt(request.getParameter(HIDDEN_RECORDNUMBER));
     record += ejbcawebbean.getLogEntriesPerPage();
   }



   if(  request.getParameter(BUTTON_RELOAD)!=null &&  oldaction.equals(OLD_ACTION_VIEWLAST) ){
       logentries = logbean.filterByTime(VIEWLASTTIMES[Integer.parseInt(oldactionvalue)],record,size);
     }else{
       if( request.getParameter(BUTTON_RELOAD)!=null && oldaction.equals(OLD_ACTION_ADVANCEDLIST) ){

               int matchwithrow1 = (request.getParameter(OLD_MATCHWITHROW1)==null?-1:Integer.parseInt(request.getParameter(OLD_MATCHWITHROW1)));
               int matchwithrow2 = (request.getParameter(OLD_MATCHWITHROW2)==null?-1:Integer.parseInt(request.getParameter(OLD_MATCHWITHROW2)));
               int matchwithrow3 = (request.getParameter(OLD_MATCHWITHROW3)==null?-1:Integer.parseInt(request.getParameter(OLD_MATCHWITHROW3)));
               int matchwithrow4 = (request.getParameter(OLD_MATCHWITHROW4)==null?-1:Integer.parseInt(request.getParameter(OLD_MATCHWITHROW4)));
               int matchtyperow1 = (request.getParameter(OLD_MATCHTYPEROW1)==null?-1:Integer.parseInt(request.getParameter(OLD_MATCHTYPEROW1)));
               int matchtyperow2 = (request.getParameter(OLD_MATCHTYPEROW2)==null?-1:Integer.parseInt(request.getParameter(OLD_MATCHTYPEROW2)));
               int matchtyperow3 = (request.getParameter(OLD_MATCHTYPEROW3)==null?-1:Integer.parseInt(request.getParameter(OLD_MATCHTYPEROW3)));
               int connectorrow2 = (request.getParameter(OLD_CONNECTORROW2)==null?-1:Integer.parseInt(request.getParameter(OLD_CONNECTORROW2)));
               int connectorrow3 = (request.getParameter(OLD_CONNECTORROW3)==null?-1:Integer.parseInt(request.getParameter(OLD_CONNECTORROW3)));
               int connectorrow4 = (request.getParameter(OLD_CONNECTORROW4)==null?-1:Integer.parseInt(request.getParameter(OLD_CONNECTORROW4)));
               int dayrow4       = (request.getParameter(OLD_DAY_ROW4)==null?-1:Integer.parseInt(request.getParameter(OLD_DAY_ROW4)));
               int dayrow5       = (request.getParameter(OLD_DAY_ROW5)==null?-1:Integer.parseInt(request.getParameter(OLD_DAY_ROW5)));
               int monthrow4     = (request.getParameter(OLD_MONTH_ROW4)==null?-1:Integer.parseInt(request.getParameter(OLD_MONTH_ROW4)));
               int monthrow5     = (request.getParameter(OLD_MONTH_ROW5)==null?-1:Integer.parseInt(request.getParameter(OLD_MONTH_ROW5)));
               int yearrow4      = (request.getParameter(OLD_YEAR_ROW4)==null?-1:Integer.parseInt(request.getParameter(OLD_YEAR_ROW4)));
               int yearrow5      = (request.getParameter(OLD_YEAR_ROW5)==null?-1:Integer.parseInt(request.getParameter(OLD_YEAR_ROW5)));
               int timerow4      = (request.getParameter(OLD_TIME_ROW4)==null?-1:Integer.parseInt(request.getParameter(OLD_TIME_ROW4)));
               int timerow5      = (request.getParameter(OLD_TIME_ROW5)==null?-1:Integer.parseInt(request.getParameter(OLD_TIME_ROW5)));
               
               String matchvaluerow1 = request.getParameter(OLD_MATCHVALUEROW1);
               String matchvaluerow2 = request.getParameter(OLD_MATCHVALUEROW2);
               String matchvaluerow3 = request.getParameter(OLD_MATCHVALUEROW3);
               boolean matchadded = false; 
    
              Query query = new Query(Query.TYPE_LOGQUERY);

              if(matchwithrow1 != -1 && matchtyperow1 != -1 && matchvaluerow1 != null){
                 if(!matchvaluerow1.trim().equals("")){
                   query.add(matchwithrow1,matchtyperow1, matchvaluerow1);
                   matchadded = true; 
                 } 
              }
              if(connectorrow2 != -1 && matchwithrow2 != -1 && matchtyperow2 != -1 && matchvaluerow2 != null){
                 if(!matchvaluerow2.trim().equals("")){
                   query.add(connectorrow2);
                   query.add(matchwithrow2,matchtyperow2, matchvaluerow2);
                   matchadded = true; 
                 } 
              }
              if(connectorrow3 != -1 && matchwithrow3 != -1 && matchtyperow3 != -1 && matchvaluerow3 != null){
                 if(!matchvaluerow3.trim().equals("")){
                   query.add(connectorrow3);
                   query.add(matchwithrow3,matchtyperow3, matchvaluerow3);
                   matchadded = true; 
                 } 
              }
              Date startdate = null;
              Date enddate = null;
              Calendar querytime = Calendar.getInstance();
              if( matchwithrow4 != -1 ){
                querytime.set(yearrow4, monthrow4, dayrow4, timerow4, 0 ,0); 
                startdate = querytime.getTime();
                querytime.set(yearrow5, monthrow5, dayrow5, timerow5, 0 ,0); 
                enddate = querytime.getTime();
              }

              if(connectorrow4 != -1 && matchwithrow4 != -1 ){
                   query.add(connectorrow4);
                   query.add(startdate, enddate);
              }

              if(connectorrow4 == -1 && !matchadded && matchwithrow4 != -1 ){
                   query.add(startdate, enddate);
              }


              if(query.isLegalQuery() && !query.hasIllegalSqlChars()){
                logentries  = logbean.filterByQuery(query,record,size);  
              }else{
                 illegalquery = true;
              } 

     }
     else{
       if( request.getParameter(BUTTON_VIEWLAST) != null){
         String timeindex = request.getParameter(SELECT_VIEWLASTENTRIES); 
         if(!timeindex.equals("")){
           record=0;
           logentries  = logbean.filterByTime(VIEWLASTTIMES[Integer.parseInt(timeindex)],record,size);
           oldaction=OLD_ACTION_VIEWLAST;
           oldactionvalue=timeindex;
         }else{
           oldaction=OLD_ACTION_VIEWLAST;
           oldactionvalue="-1";         
         }
       }else{
         if( request.getParameter(BUTTON_ADVANCEDLIST) != null){
            oldaction = OLD_ACTION_ADVANCEDLIST;
            oldmatchwithrow1 = request.getParameter(SELECT_MATCHWITH_ROW1);
            oldmatchwithrow2 = request.getParameter(SELECT_MATCHWITH_ROW2);
            oldmatchwithrow3 = request.getParameter(SELECT_MATCHWITH_ROW3);
            oldmatchwithrow4 = request.getParameter(SELECT_MATCHWITH_ROW4);
            oldmatchtyperow1 = request.getParameter(SELECT_MATCHTYPE_ROW1);
            oldmatchtyperow2 = request.getParameter(SELECT_MATCHTYPE_ROW2);
            oldmatchtyperow3 = request.getParameter(SELECT_MATCHTYPE_ROW3);
            oldconnectorrow2 = request.getParameter(SELECT_CONNECTOR_ROW2);
            oldconnectorrow3 = request.getParameter(SELECT_CONNECTOR_ROW3);
            oldconnectorrow4 = request.getParameter(SELECT_CONNECTOR_ROW4);
            olddayrow4 = request.getParameter(SELECT_DAY_ROW4); 
            olddayrow5 = request.getParameter(SELECT_DAY_ROW5); 
            oldmonthrow4 = request.getParameter(SELECT_MONTH_ROW4);
            oldmonthrow5 = request.getParameter(SELECT_MONTH_ROW5);
            oldyearrow4 = request.getParameter(SELECT_YEAR_ROW4);
            oldyearrow5 = request.getParameter(SELECT_YEAR_ROW5);
            oldtimerow4 = request.getParameter(SELECT_TIME_ROW4);
            oldtimerow5 = request.getParameter(SELECT_TIME_ROW5);              

            int matchwithrow1 = (request.getParameter(SELECT_MATCHWITH_ROW1)==null?-1:Integer.parseInt(request.getParameter(SELECT_MATCHWITH_ROW1)));
            int matchwithrow2 = (request.getParameter(SELECT_MATCHWITH_ROW2)==null?-1:Integer.parseInt(request.getParameter(SELECT_MATCHWITH_ROW2)));
            int matchwithrow3 = (request.getParameter(SELECT_MATCHWITH_ROW3)==null?-1:Integer.parseInt(request.getParameter(SELECT_MATCHWITH_ROW3)));
            int matchwithrow4 = (request.getParameter(SELECT_MATCHWITH_ROW4)==null?-1:Integer.parseInt(request.getParameter(SELECT_MATCHWITH_ROW4)));
            int matchtyperow1 = (request.getParameter(SELECT_MATCHTYPE_ROW1)==null?-1:Integer.parseInt(request.getParameter(SELECT_MATCHTYPE_ROW1)));
            int matchtyperow2 = (request.getParameter(SELECT_MATCHTYPE_ROW2)==null?-1:Integer.parseInt(request.getParameter(SELECT_MATCHTYPE_ROW2)));
            int matchtyperow3 = (request.getParameter(SELECT_MATCHTYPE_ROW3)==null?-1:Integer.parseInt(request.getParameter(SELECT_MATCHTYPE_ROW3)));
            int connectorrow2 = (request.getParameter(SELECT_CONNECTOR_ROW2)==null?-1:Integer.parseInt(request.getParameter(SELECT_CONNECTOR_ROW2)));
            int connectorrow3 = (request.getParameter(SELECT_CONNECTOR_ROW3)==null?-1:Integer.parseInt(request.getParameter(SELECT_CONNECTOR_ROW3)));
            int connectorrow4 = (request.getParameter(SELECT_CONNECTOR_ROW4)==null?-1:Integer.parseInt(request.getParameter(SELECT_CONNECTOR_ROW4)));
            int dayrow4       = (request.getParameter(SELECT_DAY_ROW4)==null?-1:Integer.parseInt(request.getParameter(SELECT_DAY_ROW4)));
            int dayrow5       = (request.getParameter(SELECT_DAY_ROW5)==null?-1:Integer.parseInt(request.getParameter(SELECT_DAY_ROW5)));
            int monthrow4     = (request.getParameter(SELECT_MONTH_ROW4)==null?-1:Integer.parseInt(request.getParameter(SELECT_MONTH_ROW4)));
            int monthrow5     = (request.getParameter(SELECT_MONTH_ROW5)==null?-1:Integer.parseInt(request.getParameter(SELECT_MONTH_ROW5)));
            int yearrow4      = (request.getParameter(SELECT_YEAR_ROW4)==null?-1:Integer.parseInt(request.getParameter(SELECT_YEAR_ROW4)));
            int yearrow5      = (request.getParameter(SELECT_YEAR_ROW5)==null?-1:Integer.parseInt(request.getParameter(SELECT_YEAR_ROW5)));
            int timerow4      = (request.getParameter(SELECT_TIME_ROW4)==null?-1:Integer.parseInt(request.getParameter(SELECT_TIME_ROW4)));
            int timerow5      = (request.getParameter(SELECT_TIME_ROW5)==null?-1:Integer.parseInt(request.getParameter(SELECT_TIME_ROW5)));
               
            String matchvaluerow1 = null;
            String matchvaluerow2 = null;
            String matchvaluerow3 = null;
                
             boolean matchadded = false; 

             if(matchwithrow1 == LogMatch.MATCH_WITH_SPECIALADMIN || matchwithrow1 == LogMatch.MATCH_WITH_EVENT || 
                matchwithrow1 == LogMatch.MATCH_WITH_MODULE || matchwithrow1 == LogMatch.MATCH_WITH_CA){
                  matchvaluerow1 = request.getParameter(SELECT_MATCHVALUE_ROW1);
             }else{
               if(matchwithrow1 == LogMatch.MATCH_WITH_ADMINCERTIFICATE)
                  matchvaluerow1 = request.getParameter(TEXTFIELD_MATCHVALUE_ROW1).toLowerCase();
               else
                 if(matchwithrow1 == LogMatch.MATCH_WITH_CERTIFICATE)
                   matchvaluerow1 = request.getParameter(TEXTFIELD_MATCHVALUE_ROW1).toLowerCase();
                 else{ 
                  matchvaluerow1 = request.getParameter(TEXTFIELD_MATCHVALUE_ROW1);  
                }
              } 
              if(matchwithrow2 == LogMatch.MATCH_WITH_SPECIALADMIN || matchwithrow2 == LogMatch.MATCH_WITH_EVENT || 
                matchwithrow2 == LogMatch.MATCH_WITH_MODULE || matchwithrow2 == LogMatch.MATCH_WITH_CA){
                    matchvaluerow2 = request.getParameter(SELECT_MATCHVALUE_ROW2);
              }else{
                  if(matchwithrow2 == LogMatch.MATCH_WITH_ADMINCERTIFICATE)
                    matchvaluerow2 = request.getParameter(TEXTFIELD_MATCHVALUE_ROW1).toLowerCase();
                  else
                    if(matchwithrow2 == LogMatch.MATCH_WITH_CERTIFICATE)
                      matchvaluerow2 = request.getParameter(TEXTFIELD_MATCHVALUE_ROW1).toLowerCase();
                    else{
                      matchvaluerow2 = request.getParameter(TEXTFIELD_MATCHVALUE_ROW2);              
                    }
               }
               if(matchwithrow3 == LogMatch.MATCH_WITH_SPECIALADMIN || matchwithrow3 == LogMatch.MATCH_WITH_EVENT || 
                 matchwithrow3 == LogMatch.MATCH_WITH_MODULE || matchwithrow3 == LogMatch.MATCH_WITH_CA){
                  matchvaluerow3 = request.getParameter(SELECT_MATCHVALUE_ROW3);
               }else{
                    if(matchwithrow3 == LogMatch.MATCH_WITH_ADMINCERTIFICATE)
                      matchvaluerow3 = request.getParameter(TEXTFIELD_MATCHVALUE_ROW1).toLowerCase();