viewlog.jsp

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

                    else
                      if(matchwithrow3 == LogMatch.MATCH_WITH_CERTIFICATE)
                        matchvaluerow3 = request.getParameter(TEXTFIELD_MATCHVALUE_ROW1).toLowerCase();
                      else{
                       matchvaluerow3 = request.getParameter(TEXTFIELD_MATCHVALUE_ROW3);
                      }   
               }
                         

               oldmatchvaluerow1=matchvaluerow1;
               oldmatchvaluerow2=matchvaluerow2;
               oldmatchvaluerow3=matchvaluerow3;    

              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{
            logentries  = logbean.getEntries (record,size);
            }
          }
        }
      }
   }


   if( request.getParameter(SORTBY_TIME_ACC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_TIME_ACC;
     logbean.sortUserData(SortBy.TIME,SortBy.ACCENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_TIME_DEC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_TIME_DEC;
     logbean.sortUserData(SortBy.TIME,SortBy.DECENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_ADMINTYPE_ACC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_ADMINTYPE_ACC;
     logbean.sortUserData(SortBy.ADMINTYPE,SortBy.ACCENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_ADMINTYPE_DEC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_ADMINTYPE_DEC;
     logbean.sortUserData(SortBy.ADMINTYPE,SortBy.DECENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_ADMINDATA_ACC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_ADMINDATA_ACC;
     logbean.sortUserData(SortBy.ADMINDATA,SortBy.ACCENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_ADMINDATA_DEC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_ADMINDATA_DEC;
     logbean.sortUserData(SortBy.ADMINDATA,SortBy.DECENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_CA_ACC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_CA_ACC;
     logbean.sortUserData(SortBy.CA,SortBy.ACCENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_CA_DEC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_CA_DEC;
     logbean.sortUserData(SortBy.CA,SortBy.DECENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_MODULE_ACC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_MODULE_ACC;
     logbean.sortUserData(SortBy.MODULE,SortBy.ACCENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_MODULE_DEC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_MODULE_DEC;
     logbean.sortUserData(SortBy.MODULE,SortBy.DECENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_USERNAME_ACC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_USERNAME_ACC;
     logbean.sortUserData(SortBy.USERNAME,SortBy.ACCENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_USERNAME_DEC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_USERNAME_DEC;
     logbean.sortUserData(SortBy.USERNAME,SortBy.DECENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_CERTIFICATE_ACC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_CERTIFICATE_ACC;
     logbean.sortUserData(SortBy.CERTIFICATE,SortBy.ACCENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_CERTIFICATE_DEC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_CERTIFICATE_DEC;
     logbean.sortUserData(SortBy.CERTIFICATE,SortBy.DECENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_EVENT_ACC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_EVENT_ACC;
     logbean.sortUserData(SortBy.EVENT,SortBy.ACCENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_EVENT_DEC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_EVENT_DEC;
     logbean.sortUserData(SortBy.EVENT,SortBy.DECENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_COMMENT_ACC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_COMMENT_ACC;
     logbean.sortUserData(SortBy.COMMENT,SortBy.ACCENDING);
     logentries  = logbean.getEntries (record,size);
   }
   if( request.getParameter(SORTBY_COMMENT_DEC+".x") != null ){
     // Sortby username accending
     sortby = SORTBY_COMMENT_DEC;
     logbean.sortUserData(SortBy.COMMENT,SortBy.DECENDING);
     logentries  = logbean.getEntries (record,size);
   }

   if(logentries  != null)
     if(logbean.getResultSize() >= LogInterfaceBean.MAXIMUM_QUERY_ROWCOUNT) 
        largeresult = true; 

%>

<%@ include file="viewloghtml.jspf" %>