sb.append("pw = ? ");__WL_count++;}if (__WL_isModified[6])  {if (__WL_count > 0) sb.append(", ");sb.append("note = ? ");__WL_count++;}if (__WL_count != 0) {__WL_query_array[0] = "UPDATE Wb_Employee SET " + sb.toString() + " WHERE sn = ?";}
    } else if (operation == DDConstants.DELETE) {
      

      __WL_query_array[0] = "DELETE FROM Wb_Employee WHERE sn = ?" ;
    }

    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.Long __WL_pk = (java.lang.Long) __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.Long __WL_pk = (java.lang.Long) __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[7];
    }

    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.Long __WL_pk = (java.lang.Long) __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.Long __WL_pk = (java.lang.Long) __WL_key;
      __WL_con = __WL_pm.getConnection();

      java.lang.String __WL_query =
        "select sn from Wb_Employee where sn = ?";

      __WL_stmt = __WL_con.prepareStatement(__WL_query);

      // preparedStatementParamIndex reset.
      if(!__WL_pm.setParamNull(__WL_stmt, 1, __WL_pk, "sn")) {__WL_stmt.setLong(1, __WL_pk.longValue());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 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)
  {
      if (cmrf.equals("wbRole")) {
    getWbRole();
    if (operation == DDConstants.INSERT) {
      String __WL_query = ((RDBMSM2NSet) __WL_wbRole_field_).getAddJoinTableSQL();
      if (__WL_verbose) {
        Debug.say("__WL_getM2NSQL() produced sqlString: " + __WL_query);
      }
      return __WL_query;
    }
    else {
      throw new AssertionError("Unknown request for Many To Many Get SQL: "+
	operation);
    }
  }
throw new AssertionError(" in __WL_getM2NSQL: unknown Many To Many cmr-field "+cmrf+".");
  }

  public Collection __WL_getCmrBeansForCmrField(String cmrf)
  {
      if (cmrf.equals("wbRole")) {
    return getWbRole();
  }
throw new AssertionError(" in __WL_getCmrBeansForCmrField: unknown Many To Many cmr-field "+cmrf+".");
  }


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


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

  public boolean __WL_beanIsLoaded() { 
    return __WL_beanIsLoaded; 
  }

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


  public java.lang.Long ejbCreate(java.lang.Long arg0, java.lang.String arg1, java.lang.String arg2, java.lang.Integer arg3, java.lang.String arg4, java.lang.String arg5, java.lang.String arg6)throws javax.ejb.CreateException{    int oldState = __WL_method_state;
    try {
      __WL_method_state = STATE_EJB_CREATE;

      for (int __WL_i = 0; __WL_i < 7; __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;
      __WL_wbRole_isLoaded_ = false;

      // initialize persistent and cached relationship variables, this
      // is done here purely to ensure robustness as the CMP variables
      // are also initialized whenever the bean enters the pooled state
      sex = null;sn = null;age = null;pw = null;address = null;note = null;name = null;
      __WL_wbRole_field_ = null;

      super.ejbCreate( arg0, arg1, arg2, arg3, arg4, arg5, arg6);

      pkCheck();

      

      java.lang.Long __WL_pk = null;__WL_pk = (java.lang.Long) __WL_getPrimaryKey();return __WL_pk;} catch (javax.ejb.CreateException ce) {throw ce;    } 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;
    }
}

  public void ejbPostCreate(java.lang.Long arg0, java.lang.String arg1, java.lang.String arg2, java.lang.Integer arg3, java.lang.String arg4, java.lang.String arg5, java.lang.String arg6)throws javax.ejb.CreateException{    int oldState = __WL_method_state;
    try {
      __WL_method_state = STATE_EJB_POSTCREATE;

      

      super.ejbPostCreate( arg0, arg1, arg2, arg3, arg4, arg5, arg6);

      if (!__WL_pm.getOrderDatabaseOperations())__WL_create();

      

      } catch (javax.ejb.CreateException ce) {throw ce;

          } 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;
    }
}