Metacat

    * number will decrease one for every allow rule

   boolean allow=false;//initial value is no allow rule

           //ticketCount isnot null and greater than 0, order is not allowfirst

           if (!rs.wasNull() &&ticketCount>0 && !isAllowFirst(principals,docId))

           {

              decreaseNumberOfAccess(permissionValueInTable, principals[i],

                                              docId, ALLOW, DENYFIRST);

           }

           allow=true;//has allow rule entry

         }//if

      }//while

    }//for

    pStmt.close();

    return allow;

 }//hasAllowRule

  /**

    * Check if the users array has allow rules for given users, docid and 

    * permission.

    * If it has permission rule and ticket count is greater than 0, the ticket

    * number will decrease one

    * @param principals, list of names of principals to check for 

    * @param docid, document identifier to check for

    * @param permission, the permssion need to check

    */

  private boolean hasAllowRuleBackup(String [] principals, String docId, 

                                  String permission)

                  throws SQLException, Exception

 {

   int lengthOfArray=principals.length;

   ResultSet rs;

   PreparedStatement pStmt;

   int permissionValue=intValue(permission);

   int permissionValueInTable;

   int ticketCount;

   //This sql statement will select entry with 

   //begin_time<=currentTime<=end_time in xml_access table

   //If begin_time or end_time is null in table, isnull(begin_time, sysdate)

   //function will assign begin_time=sysdate

   pStmt = conn.prepareStatement(

                "SELECT permission, ticket_count " +

                "FROM xml_access " +

                "WHERE docid = ? " + 

                "AND principal_name = ? " +

                "AND perm_type = ? " +

                "AND " + sysdate + 

                " BETWEEN " + isnull + "(begin_time," + sysdate + ") " +

                     "AND " + isnull + "(end_time," + sysdate + ")");

   //bind docid, perm_type

   pStmt.setString(1, docId);

   pStmt.setString(3, ALLOW);

   //bind every elenment in user name array

    for (int i=0;i<lengthOfArray; i++)

    {

      pStmt.setString(2, principals[i]);

      pStmt.execute();

      rs=pStmt.getResultSet();

      while (rs.next())//check every entry for one user

      {

        permissionValueInTable=rs.getInt(1);

        ticketCount=rs.getInt(2);

        //permission is ok and ticketcount geat than 0 or ticket is null, 

        //the user have a permission to access the file

        if ((( permissionValueInTable & permissionValue )== permissionValue )

              && (rs.wasNull()||ticketCount > 0))

        {

           //ticket count should minus one 

           //ticketCount isnot null and greater than 0, order is allowfirst

           if (!rs.wasNull() && ticketCount>0 && isAllowFirst(principals,docId))

           {

              decreaseNumberOfAccess(permissionValueInTable, principals[i],

                                              docId, ALLOW, ALLOWFIRST);

            }