listendentities.jsp

一套JAVA的CA证书签发系统.

              if(query.isLegalQuery()){
                users = rabean.filterByQuery(query,record,size);  
              }else{
                 illegalquery = true;
              } 

     }
     else{
       if( request.getParameter(BUTTON_FIND) != null){
         String username = request.getParameter(TEXTFIELD_USERNAME); 
         if(username != null){
           username=username.trim();
           if(!username.equals("")){
             record=0;
             users = rabean.filterByUsername(username);
             oldaction=OLD_ACTION_FINDUSER;
             oldactionvalue=username;
          }
        }
      }else{
         if( request.getParameter(BUTTON_LIST) != null){
           String status = request.getParameter(SELECT_LIST_STATUS); 
           if(status != null){
             status= status.trim();
             if(!status.equals("")){
               record=0;
               if(status.equals(Integer.toString(ALL_STATUS))){
                  users = rabean.findAllUsers(record,size);
               }
               else{
                 Query query = new Query(Query.TYPE_USERQUERY); 
                 query.add(UserMatch.MATCH_WITH_STATUS,BasicMatch.MATCH_TYPE_EQUALS,status);
                 users = rabean.filterByQuery(query,record,size);
               }
               oldaction=OLD_ACTION_LISTUSERS;
               oldactionvalue=status;
             }
             else{
               blank=true;
             }
           }
         }else{
           if( request.getParameter(BUTTON_ISREVOKED) != null){
               String serialnumber = request.getParameter(TEXTFIELD_SERIALNUMBER);  
               if(serialnumber != null){
                 serialnumber=serialnumber.trim();
                 if(!serialnumber.equals("")){
                   record=0;   
                   users = rabean.filterByCertificateSerialNumber(serialnumber,record,size);
                   oldaction=OLD_ACTION_ISREVOKED;
                   oldactionvalue=serialnumber;  
                 }
               }
           }else{
             if( request.getParameter(BUTTON_FINDTOKEN) != null){
               String tokenserialnumber = request.getParameter(TEXTFIELD_TOKENSERIALNUMBER);  
               if(tokenserialnumber != null){
                 tokenserialnumber=tokenserialnumber.trim();
                 if(!tokenserialnumber.equals("")){
                   record=0;   
                   users = rabean.filterByTokenSN(tokenserialnumber,record,size);
                   oldaction=OLD_ACTION_FINDTOKEN;
                   oldactionvalue=tokenserialnumber;  
                 }
               }

           }else{
             if( request.getParameter(BUTTON_LISTEXPIRED) != null){
               String days = request.getParameter(TEXTFIELD_DAYS); 
               if(days != null){
                 days=days.trim();
                 if(!days.equals("")){                
                   record=0;   
                   users = rabean.filterByExpiringCertificates(days,record,size);

                   oldaction=OLD_ACTION_LISTEXPIRED;
                   oldactionvalue=days; 
                 }
               }
            }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 == UserMatch.MATCH_WITH_ENDENTITYPROFILE || matchwithrow1 == UserMatch.MATCH_WITH_CERTIFICATEPROFILE){
                    matchvaluerow1 = request.getParameter(SELECT_MATCHVALUE_ROW1);
                    if(matchvaluerow1 == null || matchvaluerow1.equals("0")) matchvaluerow1 = null;
               }else{
                  if(matchwithrow1 == UserMatch.MATCH_WITH_STATUS || matchwithrow1 == UserMatch.MATCH_WITH_CA){
                    matchvaluerow1 = request.getParameter(SELECT_MATCHVALUE_ROW1);
                  }else{
                    matchvaluerow1 = request.getParameter(TEXTFIELD_MATCHVALUE_ROW1);
                  } 
               } 
               if(matchwithrow2 == UserMatch.MATCH_WITH_ENDENTITYPROFILE || matchwithrow2 == UserMatch.MATCH_WITH_CERTIFICATEPROFILE){
                 matchvaluerow2 = request.getParameter(SELECT_MATCHVALUE_ROW2);
                 if(matchvaluerow2 == null || matchvaluerow2.equals("0")) matchvaluerow2 = null;
               }else{
                  if(matchwithrow2 == UserMatch.MATCH_WITH_STATUS || matchwithrow2 == UserMatch.MATCH_WITH_CA){
                    matchvaluerow2 = request.getParameter(SELECT_MATCHVALUE_ROW2);
                  }else{
                     matchvaluerow2 = request.getParameter(TEXTFIELD_MATCHVALUE_ROW2);
                  }                 
               }

               if(matchwithrow3 == UserMatch.MATCH_WITH_ENDENTITYPROFILE || matchwithrow3 == UserMatch.MATCH_WITH_CERTIFICATEPROFILE){
                 matchvaluerow3 = request.getParameter(SELECT_MATCHVALUE_ROW3);
                 if(matchvaluerow3 == null || matchvaluerow3.equals("0")) matchvaluerow3 = null; 
               }else{
                  if(matchwithrow3 == UserMatch.MATCH_WITH_STATUS || matchwithrow3 == UserMatch.MATCH_WITH_CA){
                    matchvaluerow3   = request.getParameter(SELECT_MATCHVALUE_ROW3);
                  }else{
                    matchvaluerow3    = request.getParameter(TEXTFIELD_MATCHVALUE_ROW3);
                  }                 
               } 


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

              Query query = new Query(Query.TYPE_USERQUERY);

              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()){
                users = rabean.filterByQuery(query,record,size);  
              }else{
                 illegalquery = true;
              }

              
 
            }else{
            users = rabean.getUsers(record,size);
            }}}}}}}
          }
        }
      }
    }
  }
  if(users != null){ 
    numcheckboxes= users.length;
  }

  if(blank)
    rabean.clearUsers();

  
    int[] availablestatuses = {UserDataRemote.STATUS_NEW, UserDataRemote.STATUS_FAILED ,UserDataRemote.STATUS_INITIALIZED, 
                               UserDataRemote.STATUS_INPROCESS, UserDataRemote.STATUS_GENERATED, UserDataRemote.STATUS_REVOKED,
                               UserDataRemote.STATUS_HISTORICAL};
    String[] availablestatustexts = {"STATUSNEW", "STATUSFAILED", "STATUSINITIALIZED", "STATUSINPROCESS", "STATUSGENERATED",
                                     "STATUSREVOKED", "STATUSHISTORICAL"}; 

    if(globalconfiguration.getEnableKeyRecovery()){
      int[] tempintarray = {UserDataRemote.STATUS_NEW, UserDataRemote.STATUS_FAILED ,UserDataRemote.STATUS_INITIALIZED, 
                               UserDataRemote.STATUS_INPROCESS, UserDataRemote.STATUS_GENERATED, UserDataRemote.STATUS_REVOKED,
                               UserDataRemote.STATUS_HISTORICAL, UserDataRemote.STATUS_KEYRECOVERY}; 
       
      String[] tempstringarray = {"STATUSNEW", "STATUSFAILED", "STATUSINITIALIZED", "STATUSINPROCESS", "STATUSGENERATED",
                                  "STATUSREVOKED", "STATUSHISTORICAL", "STATUSKEYRECOVERY"};
      availablestatuses=tempintarray;
      availablestatustexts=tempstringarray; 
    }

    if(users != null)
      if(rabean.getResultSize() >= RAInterfaceBean.MAXIMUM_QUERY_ROWCOUNT) 
        largeresult = true; 

%>

<%@ include file="listendentitieshtml.jsp" %>