tbreservation_1h64cw__weblogic_cmp_rdbms.java

用j2ee开发的一个旅店管理系统

        "but it already exists in the list, a possible circular detect, ignored.");
      }
      return;
    }
    
    // step 2:
    // This is the place every bean bean added to the list.
    // true  if don't need a database update, db-cascade-delete is specified
    // false if do need a database update, db-cascade-detelet isn't specified
    if (withoutDBUpdate) {
      listCascadeDelBeansWithoutDBUpdate.add(this);
    } else {
      listCascadeDelBeans.add(this);
    }
    
    __WL_method_state = oldState;
    
  }
  
  public void __WL_setBeanParamsForCreateArray(
  java.sql.PreparedStatement[] __WL_stmt_array)
  throws Exception
  {
    
    
    // preparedStatementParamIndex reset.
    if(!__WL_pm.setParamNull(__WL_stmt_array[0], 1, this.reid, "reid")) {
      __WL_stmt_array[0].setString(1, this.reid);
      if (__WL_verbose) {
        Debug.say("paramIdx :"+1+" binded with value :"+this.reid);
      }
    }
    
    if(!__WL_pm.setParamNull(__WL_stmt_array[0], 2, this.cid, "cid")) {
      __WL_stmt_array[0].setString(2, this.cid);
      if (__WL_verbose) {
        Debug.say("paramIdx :"+2+" binded with value :"+this.cid);
      }
    }
    
    if(!__WL_pm.setParamNull(__WL_stmt_array[0], 3, this.cname, "cname")) {
      __WL_stmt_array[0].setString(3, this.cname);
      if (__WL_verbose) {
        Debug.say("paramIdx :"+3+" binded with value :"+this.cname);
      }
    }
    
    if(!__WL_pm.setParamNull(__WL_stmt_array[0], 4, this.rnum, "rnum")) {
      __WL_stmt_array[0].setString(4, this.rnum);
      if (__WL_verbose) {
        Debug.say("paramIdx :"+4+" binded with value :"+this.rnum);
      }
    }
    
    if(!__WL_pm.setParamNull(__WL_stmt_array[0], 5, this.arrivetime, "arrivetime")) {
      __WL_stmt_array[0].setString(5, this.arrivetime);
      if (__WL_verbose) {
        Debug.say("paramIdx :"+5+" binded with value :"+this.arrivetime);
      }
    }
    
    __WL_stmt_array[0].setInt(6, this.days);
    if (__WL_verbose) {
      Debug.say("paramIdx :"+6+" binded with value :"+this.days);
    }
    
    __WL_stmt_array[0].setInt(7, this.members);
    if (__WL_verbose) {
      Debug.say("paramIdx :"+7+" binded with value :"+this.members);
    }
    
    __WL_stmt_array[0].setInt(8, this.prepay);
    if (__WL_verbose) {
      Debug.say("paramIdx :"+8+" binded with value :"+this.prepay);
    }
    
    if(!__WL_pm.setParamNull(__WL_stmt_array[0], 9, this.restuts, "restuts")) {
      __WL_stmt_array[0].setString(9, this.restuts);
      if (__WL_verbose) {
        Debug.say("paramIdx :"+9+" binded with value :"+this.restuts);
      }
    }
    
  }
  
  public void __WL_setBeanParamsForUpdateArray(
  java.sql.PreparedStatement[] __WL_stmt_array,
  boolean[] __WL_isModified,
  java.lang.String __WL_pk,
  int curTableIndex)
  throws Exception
  {
    // set all __WL_stmt_array when curTableIndex == -1
    if ((__WL_stmt_array[0] != null) && ((curTableIndex == 0) || (curTableIndex == -1))) {
      int __WL_num = 1;
      if (__WL_isModified[1]) {
        if(__WL_verbose) Debug.say("setting("+this+") 'cid' using column " +__WL_num + ". Value is " + this.cid);
        if(!__WL_pm.setParamNull(__WL_stmt_array[0], __WL_num, this.cid, "cid")) {
          __WL_stmt_array[0].setString(__WL_num, this.cid);
          if (__WL_verbose) {
            Debug.say("paramIdx :"+__WL_num+" binded with value :"+this.cid);
          }
        }
        __WL_num++;
      };
      
      if (__WL_isModified[2]) {
        if(__WL_verbose) Debug.say("setting("+this+") 'cname' using column " +__WL_num + ". Value is " + this.cname);
        if(!__WL_pm.setParamNull(__WL_stmt_array[0], __WL_num, this.cname, "cname")) {
          __WL_stmt_array[0].setString(__WL_num, this.cname);
          if (__WL_verbose) {
            Debug.say("paramIdx :"+__WL_num+" binded with value :"+this.cname);
          }
        }
        __WL_num++;
      };
      
      if (__WL_isModified[3]) {
        if(__WL_verbose) Debug.say("setting("+this+") 'rnum' using column " +__WL_num + ". Value is " + this.rnum);
        if(!__WL_pm.setParamNull(__WL_stmt_array[0], __WL_num, this.rnum, "rnum")) {
          __WL_stmt_array[0].setString(__WL_num, this.rnum);
          if (__WL_verbose) {
            Debug.say("paramIdx :"+__WL_num+" binded with value :"+this.rnum);
          }
        }
        __WL_num++;
      };
      
      if (__WL_isModified[4]) {
        if(__WL_verbose) Debug.say("setting("+this+") 'arrivetime' using column " +__WL_num + ". Value is " + this.arrivetime);
        if(!__WL_pm.setParamNull(__WL_stmt_array[0], __WL_num, this.arrivetime, "arrivetime")) {
          __WL_stmt_array[0].setString(__WL_num, this.arrivetime);
          if (__WL_verbose) {
            Debug.say("paramIdx :"+__WL_num+" binded with value :"+this.arrivetime);
          }
        }
        __WL_num++;
      };
      
      if (__WL_isModified[5]) {
        if(__WL_verbose) Debug.say("setting("+this+") 'days' using column " +__WL_num + ". Value is " + this.days);
        __WL_stmt_array[0].setInt(__WL_num, this.days);
        if (__WL_verbose) {
          Debug.say("paramIdx :"+__WL_num+" binded with value :"+this.days);
        }
        __WL_num++;
      };
      
      if (__WL_isModified[6]) {
        if(__WL_verbose) Debug.say("setting("+this+") 'members' using column " +__WL_num + ". Value is " + this.members);
        __WL_stmt_array[0].setInt(__WL_num, this.members);
        if (__WL_verbose) {
          Debug.say("paramIdx :"+__WL_num+" binded with value :"+this.members);
        }
        __WL_num++;
      };
      
      if (__WL_isModified[7]) {
        if(__WL_verbose) Debug.say("setting("+this+") 'prepay' using column " +__WL_num + ". Value is " + this.prepay);
        __WL_stmt_array[0].setInt(__WL_num, this.prepay);
        if (__WL_verbose) {
          Debug.say("paramIdx :"+__WL_num+" binded with value :"+this.prepay);
        }
        __WL_num++;
      };
      
      if (__WL_isModified[8]) {
        if(__WL_verbose) Debug.say("setting("+this+") 'restuts' using column " +__WL_num + ". Value is " + this.restuts);
        if(!__WL_pm.setParamNull(__WL_stmt_array[0], __WL_num, this.restuts, "restuts")) {
          __WL_stmt_array[0].setString(__WL_num, this.restuts);
          if (__WL_verbose) {
            Debug.say("paramIdx :"+__WL_num+" binded with value :"+this.restuts);
          }
        }
        __WL_num++;
      };
      
      
      
      
      if(!__WL_pm.setParamNull(__WL_stmt_array[0], __WL_num, __WL_pk, "reid")) {
        __WL_stmt_array[0].setString(__WL_num, __WL_pk);
        if (__WL_verbose) {
          Debug.say("paramIdx :"+__WL_num+" binded with value :"+__WL_pk);
        }
      }
      __WL_num++;
      
      
    }
    
    
  }
  
  public void __WL_setBeanParamsForDeleteArray(
  java.sql.PreparedStatement[] __WL_stmt_array,
  boolean[] __WL_isModified,
  java.lang.String __WL_pk)
  throws Exception
  {
    int __WL_num = 0;
    __WL_num = 1;
    
    if(!__WL_pm.setParamNull(__WL_stmt_array[0], __WL_num, __WL_pk, "reid")) {
      __WL_stmt_array[0].setString(__WL_num, __WL_pk);
      if (__WL_verbose) {
        Debug.say("paramIdx :"+__WL_num+" binded with value :"+__WL_pk);
      }
    }
    __WL_num++;
    
  }
  
  public java.sql.PreparedStatement[] __WL_getStmtArray(
  java.sql.Connection __WL_con,
  boolean[] __WL_isModified,
  int operation)
  throws SQLException
  {
    if (__WL_verbose) {
      Debug.say("called __WL_getStmtArray.");
    }
    
    
    java.sql.PreparedStatement[] __WL_stmt_array = new java.sql.PreparedStatement[1];
    
    java.sql.PreparedStatement __WL_stmt_Reservation_0 = null;
    __WL_stmt_array[0] = __WL_stmt_Reservation_0;
    
    
    
    String[] __WL_query_array = new String[1];
    
    
    if (operation == DDConstants.INSERT) {
      __WL_query_array[0] = "INSERT INTO Reservation (reid, cid, cname, rnum, arrivetime, days, members, prepay, restuts) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
      
    } else if (operation == DDConstants.UPDATE) {
      int __WL_count        = 0;
      
      StringBuffer sb      = new StringBuffer();
      
      
      __WL_count = 0;
      sb.setLength(0);
      if (__WL_isModified[1])  {
        if (__WL_count > 0) sb.append(", ");
        sb.append("cid = ? ");
        __WL_count++;
      }
      
      if (__WL_isModified[2])  {
        if (__WL_count > 0) sb.append(", ");
        sb.append("cname = ? ");
        __WL_count++;
      }
      
      if (__WL_isModified[3])  {
        if (__WL_count > 0) sb.append(", ");
        sb.append("rnum = ? ");
        __WL_count++;
      }
      
      if (__WL_isModified[4])  {
        if (__WL_count > 0) sb.append(", ");
        sb.append("arrivetime = ? ");
        __WL_count++;
      }
      
      if (__WL_isModified[5])  {
        if (__WL_count > 0) sb.append(", ");
        sb.append("days = ? ");
        __WL_count++;
      }
      
      if (__WL_isModified[6])  {
        if (__WL_count > 0) sb.append(", ");
        sb.append("members = ? ");
        __WL_count++;
      }
      
      if (__WL_isModified[7])  {
        if (__WL_count > 0) sb.append(", ");
        sb.append("prepay = ? ");
        __WL_count++;
      }
      
      if (__WL_isModified[8])  {
        if (__WL_count > 0) sb.append(", ");
        sb.append("restuts = ? ");
        __WL_count++;
      }
      
      if (__WL_count != 0) {
        __WL_query_array[0] = "UPDATE Reservation SET " + sb.toString() + " WHERE reid = ?";
      }
      
    } else if (operation == DDConstants.DELETE) {
      
      
      __WL_query_array[0] = "DELETE FROM Reservation WHERE reid = ?" ;
      
    }
    
    if(__WL_verbose) {
      for (int i = 0 ; i < 1 ; i++) {
        Debug.say("__WL_getStmtArray() for " + operation + " produced sqlString: " + __WL_query_array[i]);
      }
    }
    
    
    if (__WL_query_array[0] != null) __WL_stmt_array[0] = __WL_con.prepareStatement(__WL_query_array[0]);
    
    
    return __WL_stmt_array;
    
  }
  
  public void __WL_setBeanParamsForStmtArray(
  java.sql.PreparedStatement[] __WL_stmt_array,
  boolean[] __WL_isModified,
  int operation)
  throws Exception
  {
    if (operation == DDConstants.INSERT) {
      __WL_setBeanParamsForCreateArray(__WL_stmt_array);
    } else if (operation == DDConstants.UPDATE) {
      __WL_setBeanParamsForBulkUpdateArray(__WL_stmt_array, __WL_isModified);
    } else if (operation == DDConstants.DELETE) {
      __WL_setBeanParamsForBulkDeleteArray(__WL_stmt_array, __WL_isModified);
    }
    
  }
  
  public void __WL_setBeanParamsForBulkUpdateArray(
  java.sql.PreparedStatement[] __WL_stmt_array,
  boolean[] __WL_isModified)
  throws Exception
  {
    int oldState = __WL_method_state;
    
    try {
      __WL_method_state = STATE_EJBSTORE;
      
      java.lang.String __WL_pk = (java.lang.String) __WL_ctx.getPrimaryKey();
      
      __WL_setBeanParamsForUpdateArray(__WL_stmt_array, __WL_isModified, __WL_pk, -1);
    } finally {
      __WL_method_state = oldState;
    }
    
  }
  
  public void __WL_setBeanParamsForBulkDeleteArray(
  java.sql.PreparedStatement[] __WL_stmt_array,
  boolean[] __WL_isModified)
  throws Exception
  {
    int oldState = __WL_method_state;
    
    try {
      __WL_method_state = STATE_EJB_REMOVE;
      
      java.lang.String __WL_pk = (java.lang.String) __WL_ctx.getPrimaryKey();
      
      __WL_setBeanParamsForDeleteArray(__WL_stmt_array, __WL_isModified, __WL_pk);
    } finally {
      __WL_method_state = oldState;
    }
    
  }
  
  public boolean[] __WL_getIsModifiedUnion(boolean[] __WL_isModifiedUnion) {
    if (__WL_isModifiedUnion == null) return __WL_isModified;
    
    for (int i=0; i<__WL_isModified.length; i++) {
      __WL_isModifiedUnion[i] |= __WL_isModified[i];
    }
    return __WL_isModifiedUnion;
    
  }
  
  public void __WL_setIsModifiedVars(boolean __WL_isModifiedFlag,
  java.sql.Connection __WL_con)
  throws Exception
  {
    int oldState = __WL_method_state;
    
    try {
      __WL_method_state = STATE_EJBSTORE;
      
      int __WL_num = 1;
      java.lang.String __WL_pk = (java.lang.String) __WL_ctx.getPrimaryKey();
      
      
      for (int __WL_i = 0; __WL_i < __WL_isModified.length; __WL_i++) {
        __WL_isModified[__WL_i] = __WL_isModifiedFlag;
      }
      __WL_modifiedBeanIsRegistered = __WL_isModifiedFlag;
    } finally {
      __WL_method_state = oldState;
    }
    
  }
  
  public void __WL_perhapsTakeSnapshot() {
    
    
  }
  
  public boolean __WL_exists(Object __WL_key) {
    if (__WL_verbose) {
      Debug.say("exists: " + __WL_key);
    }
    
    java.sql.Connection __WL_con = null;
    java.sql.PreparedStatement __WL_stmt = null;
    java.sql.ResultSet __WL_rs = null;
    try {
      java.lang.String __WL_pk = (java.lang.String) __WL_key;
      __WL_con = __WL_pm.getConnection();
      
      java.lang.String __WL_query =
      "select reid from Reservation where reid = ?";
      
      __WL_stmt = __WL_con.prepareStatement(__WL_query);
      
      // preparedStatementParamIndex reset.
      
      if(!__WL_pm.setParamNull(__WL_stmt, 1, __WL_pk, "reid")) {
        __WL_stmt.setString(1, __WL_pk);
        if (__WL_verbose) {
          Debug.say("paramIdx :"+1+" binded with value :"+__WL_pk);
        }
      }
      
      
      __WL_rs = __WL_stmt.executeQuery();
      if (__WL_rs.next()) {
        return true;
      }
      else {
        return false;
      }
    } catch (RuntimeException re) {
      if (__WL_verbose) {
        Debug.say("rethrowing RuntimeException.");
        re.printStackTrace();
      }