__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, "dingDanHao")) {__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_fahuojilu_0 = null;__WL_stmt_array[0] = __WL_stmt_fahuojilu_0;
    String[] __WL_query_array = new String[1];

    if (operation == DDConstants.INSERT) {
      __WL_query_array[0] = "INSERT INTO fahuojilu (dingDanHao, userCode, number, name, model, price, count1, zhiFu) 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("userCode = ? ");__WL_count++;}if (__WL_isModified[2])  {if (__WL_count > 0) sb.append(", ");sb.append("number = ? ");__WL_count++;}if (__WL_isModified[3])  {if (__WL_count > 0) sb.append(", ");sb.append("name = ? ");__WL_count++;}if (__WL_isModified[4])  {if (__WL_count > 0) sb.append(", ");sb.append("model = ? ");__WL_count++;}if (__WL_isModified[5])  {if (__WL_count > 0) sb.append(", ");sb.append("price = ? ");__WL_count++;}if (__WL_isModified[6])  {if (__WL_count > 0) sb.append(", ");sb.append("count1 = ? ");__WL_count++;}if (__WL_isModified[7])  {if (__WL_count > 0) sb.append(", ");sb.append("zhiFu = ? ");__WL_count++;}if (__WL_count != 0) {if (sb.length() != 0) {__WL_query_array[0] = "UPDATE fahuojilu SET " + sb.toString() + " WHERE dingDanHao = ?";}}
    } else if (operation == DDConstants.DELETE) {
      

      __WL_query_array[0] = "DELETE FROM fahuojilu WHERE dingDanHao = ?" ;
    }

    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) {
      __WL_isModifiedUnion = new boolean[8];
    }

    boolean __WL_isModifiedUnionBoolean = false;
  
        for (int i=0; i<__WL_isModified.length; i++) {
      __WL_isModifiedUnion[i] |= __WL_isModified[i];
      __WL_isModifiedUnionBoolean |= __WL_isModified[i];
    }


    if (__WL_isModifiedUnionBoolean) {
      
    }
    
    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 Collection __WL_getNullSnapshotVariables() {
    return null;
  }

  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 dingDanHao from fahuojilu where dingDanHao = ?";

      __WL_stmt = __WL_con.prepareStatement(__WL_query);

      // preparedStatementParamIndex reset.
      if(!__WL_pm.setParamNull(__WL_stmt, 1, __WL_pk, "dingDanHao")) {__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();
      }
      throw re;
    } catch (Exception ex) {
      if (__WL_verbose) {
        Debug.say("wrapping Exception in PersistenceRuntimeException.");
        ex.printStackTrace();
      }
      throw new PersistenceRuntimeException(ex);
    }

    finally {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }

  }

  public void __WL_checkExistsOnMethod() throws NoSuchEntityException
  {
      if (__WL_getIsRemoved()) {
    Loggable l = EJBLogger.lognoSuchEntityExceptionLoggable(
      ((EntityEJBContextImpl)__WL_ctx).__WL_getPrimaryKey().toString());
    NoSuchEntityException nsee = new NoSuchEntityException(l.getMessage());
    if (__WL_verbose) {
      Debug.say("throwing RuntimeException.");
      nsee.printStackTrace();
    }
    throw nsee;
  }

  if (__WL_beanIsLoaded()) return;

  int oldState = __WL_method_state;
  
  try {
    __WL_method_state = WLEnterpriseBean.STATE_BUSINESS_METHOD;
    __WL_pm.disableTransactionStatusCheck();

    __WL_loadGroup0();
      } catch (RuntimeException re) {
      if (__WL_verbose) {
        Debug.say("rethrowing RuntimeException.");
        re.printStackTrace();
      }
      throw re;
    } catch (Exception ex) {
      if (__WL_verbose) {
        Debug.say("wrapping Exception in PersistenceRuntimeException.");
        ex.printStackTrace();
      }
      throw new PersistenceRuntimeException(ex);
    }

  finally {
    __WL_method_state = oldState;
    __WL_pm.enableTransactionStatusCheck();
  }

  }

  public short __WL_getBeanState() 
  {
    return __WL_bean_state;
  } 

  public void __WL_setBeanState(short value)
  {
    __WL_bean_state = value;
  }

  public boolean __WL_getIsRemoved() { return __WL_isRemoved; }
  public void __WL_setIsRemoved(boolean b) { __WL_isRemoved = b; }

  public void __WL_setCreateAfterRemove(boolean createAfterRemove) {
    __WL_createAfterRemove = createAfterRemove;
  }

  public int __WL_appendVerifySqlForBatch(java.util.List verifyPk, 
                                          StringBuffer[] verifySql, 
                                          int[] verifyCount,
                                          int verifyMax)
  {
    int oldState = __WL_method_state;

    try {
      __WL_method_state = STATE_EJBSTORE;

      
    }
    finally {
      __WL_method_state = oldState;
    }

    return verifyMax;
  }

  public void __WL_setVerifyParamsForBatch(java.sql.Connection con,
                                           java.sql.PreparedStatement[] __WL_stmt_array, 
                                           int[] verifyCount)
    throws SQLException 
  {
    
  }

  public int __WL_appendVerifySql(java.util.List verifyPk, 
                             StringBuffer[] verifySql, 
                             int[] verifyCount,
                             int verifyMax)
  {
    int oldState = __WL_method_state;

    try {
      __WL_method_state = STATE_EJBSTORE;
      
      
    }
    finally {
      __WL_method_state = oldState;
    }

    return verifyMax;
  }

  public void __WL_setVerifyParams(java.sql.Connection con,
                              java.sql.PreparedStatement[] __WL_stmt_array, 
                              int[] verifyCount)
    throws SQLException 
  {
    
  }


  public String __WL_getM2NSQL(String cmrf, int operation)
  {
    return "";
  }

  public Collection __WL_getCmrBeansForCmrField(String cmrf)
  {
    return null;
  }


  // end of CMPBean
  // ================================================================


  //=================================================================
  // implementation of javax.ejb.EntityBean

  public boolean __WL_beanIsLoaded() { 
    return __WL_beanIsLoaded; 
  }

    void pkCheck()
    throws javax.ejb.CreateException
  {
    // check that 'dingDanHao' was setif (!__WL_isModified[0]) {Loggable l = EJBLogger.logpkNotSetLoggable("Fahuojilu","dingDanHao");throw new javax.ejb.CreateException(l.getMessage());}
  }


  public java.lang.String ejbCreate(java.lang.String arg0)throws javax.ejb.CreateException{    int oldState = __WL_method_state;
    try {
      __WL_method_state = STATE_EJB_CREATE;

      for (int __WL_i = 0; __WL_i < 8; __WL_i++) {
        __WL_isLoaded[__WL_i] = true;
        __WL_isModified[__WL_i] = false;
      }

      __WL_beanIsLoaded = true;
      

      // set true, this prevents us from registering the bean until after the
      // database insert
      __WL_modifiedBeanIsRegistered = true;
      

      // initialize persistent and cached relationship variables, this
      // is done here purely to ensure robustness as the CMP variables
      // are also initialized whenever the be