java.lang.String __WL_pk = null;
    
    __WL_pk = (java.lang.String)__WL_rs.getString(1+__WL_offset);    if (__WL_rs.wasNull()) {       __WL_pk = null;    }    
    
    return __WL_pk;
  }
  
  public Object __WL_getPKFromRSInstance(java.sql.ResultSet __WL_rs, java.lang.Integer __WL_offsetIntObj, ClassLoader __WL_classLoader)
  throws java.sql.SQLException, java.lang.Exception
  {
    return __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader);
  }
  
  //End finder methods.
  //=================================================================
  
  //=================================================================
  //Home methods.
  
  
  //End home methods.
  //=================================================================
  
  //=================================================================
  // ejbSelect methods defined in this Bean's abstract class
  
  
  
  
  //=================================================================
  // ejbSelectInternal methods that are to run in this Bean
  
  
  
  
  
  //=================================================================
  
  // ================================================================
  // Implementation of CMPBean
  public void __WL_setup(java.util.Map bmMap, PersistenceManager __WL_pm) {
    if (__WL_verbose) {
      Debug.say("UserTableBean_wg8twd__WebLogic_CMP_RDBMS.setup called.");
    }
    if (__WL_debug) {
      Debug.assertion(bmMap!=null);
      Debug.assertion(__WL_pm !=null);
    }
    this.__WL_pm = (RDBMSPersistenceManager)__WL_pm; 
    this.__WL_classLoader = this.__WL_pm.getClassLoader();
    if (__WL_debug) {
      Debug.assertion(this.__WL_classLoader != null);
    }
    
    
  }
  
  public EntityContext __WL_getEntityContext() {
    return __WL_ctx;
  }
  
  public Object __WL_getPrimaryKey() {
    java.lang.String __WL_pk = null;        __WL_pk = this.userName;    return __WL_pk;    
  }
  
  public void __WL_setPrimaryKey(java.lang.String __WL_pk) {
    this.userName = __WL_pk;    
  }
  
  public void __WL_superEjbLoad()  {
    int oldState = __WL_method_state;
    
    try {
      __WL_method_state = STATE_EJBLOAD;
      super.ejbLoad();
    } finally {
      __WL_method_state = oldState;
    }
  }
  
  public void __WL_copyFrom(CMPBean otherBean) {
    UserTableBean_wg8twd__WebLogic_CMP_RDBMS __WL_bean = null;    try {      __WL_bean = (UserTableBean_wg8twd__WebLogic_CMP_RDBMS)otherBean;    } 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);
    }
    if (!(this.__WL_isLoaded[0] || this.__WL_isModified[0])) {      if (__WL_bean.__WL_isLoaded[0]) {        if (__WL_verbose) {          Debug.say("copying field 'userName' to bean '" +          __WL_bean.__WL_getPrimaryKey() + "'.");        }        this.userName = __WL_bean.userName;        this.__WL_isLoaded[0] = true;      }    }        if (!(this.__WL_isLoaded[1] || this.__WL_isModified[1])) {      if (__WL_bean.__WL_isLoaded[1]) {        if (__WL_verbose) {          Debug.say("copying field 'userPassword' to bean '" +          __WL_bean.__WL_getPrimaryKey() + "'.");        }        this.userPassword = __WL_bean.userPassword;        this.__WL_isLoaded[1] = true;      }    }        if (!(this.__WL_isLoaded[2] || this.__WL_isModified[2])) {      if (__WL_bean.__WL_isLoaded[2]) {        if (__WL_verbose) {          Debug.say("copying field 'baseInforFunction' to bean '" +          __WL_bean.__WL_getPrimaryKey() + "'.");        }        this.baseInforFunction = __WL_bean.baseInforFunction;        this.__WL_isLoaded[2] = true;      }    }        if (!(this.__WL_isLoaded[3] || this.__WL_isModified[3])) {      if (__WL_bean.__WL_isLoaded[3]) {        if (__WL_verbose) {          Debug.say("copying field 'stockFunction' to bean '" +          __WL_bean.__WL_getPrimaryKey() + "'.");        }        this.stockFunction = __WL_bean.stockFunction;        this.__WL_isLoaded[3] = true;      }    }        if (!(this.__WL_isLoaded[4] || this.__WL_isModified[4])) {      if (__WL_bean.__WL_isLoaded[4]) {        if (__WL_verbose) {          Debug.say("copying field 'stockManageFunction' to bean '" +          __WL_bean.__WL_getPrimaryKey() + "'.");        }        this.stockManageFunction = __WL_bean.stockManageFunction;        this.__WL_isLoaded[4] = true;      }    }        if (!(this.__WL_isLoaded[5] || this.__WL_isModified[5])) {      if (__WL_bean.__WL_isLoaded[5]) {        if (__WL_verbose) {          Debug.say("copying field 'saleFunction' to bean '" +          __WL_bean.__WL_getPrimaryKey() + "'.");        }        this.saleFunction = __WL_bean.saleFunction;        this.__WL_isLoaded[5] = true;      }    }        
  }
  
  public void __WL_loadGroupByIndex(int index, java.sql.ResultSet rs,
  Integer offset, Object __WL_pk, javax.ejb.EntityBean eb) throws Exception
  {
    switch(index) {
      case 0: __WL_loadGroup0FromRS(rs, offset, __WL_pk, (stockmanagementpro.UserTableBean_wg8twd__WebLogic_CMP_RDBMS)eb); break;      default: throw new AssertionError("Bad Group index: "+index);      
    }
  }
  
  public void __WL_loadCMRFieldByCmrField(String cmrField, java.sql.ResultSet rs,
  Integer offset, javax.ejb.EntityBean eb) throws Exception
  {
    
  }
  
  public PersistenceManager __WL_getPersistenceManager() {
    return __WL_pm;
  }
  
  public void __WL_ejbRemoveWithoutDBUpdate()  throws javax.ejb.RemoveException {
    int oldState = __WL_method_state;
    
    try {
      __WL_method_state = STATE_EJB_REMOVE;
      if (__WL_verbose) {
        Debug.say("ejbRemoveWithoutDBUpdate " + __WL_ctx.getPrimaryKey());
      }
      super.ejbRemove();
      
      
      
      // initialize state before this instance goes back into the
      // pool
      __WL_initialize();
      
    } finally {
      __WL_method_state = oldState;
    }
    
  }
  
  public void __WL_makeCascadeDelList(java.util.Map mapCascadeDelBeans,
  java.util.List listCascadeDelBeans,
  java.util.List listCascadeDelBeansWithoutDBUpdate,
  boolean withoutDBUpdate)
  throws java.lang.Exception
  {
    
    int oldState = __WL_method_state;
    __WL_method_state = STATE_EJB_REMOVE;
    
    // create a unique mapKey to map beans to mapCascadeDelBeans
    // re-use weblogic.ejb20.cache.CacheKey class since it take two
    // objects to create the key
    Object pk = __WL_ctx.getPrimaryKey();
    Object beanManager = __WL_pm.getBeanManager();
    weblogic.ejb20.cache.CacheKey mapKey =
    new weblogic.ejb20.cache.CacheKey(pk, (CachingManager)beanManager);
    
    // step 1:
    // keep track of all of the beans been visited is the map to detect the circular case
    if (mapCascadeDelBeans.get(mapKey) == null) {
      mapCascadeDelBeans.put(mapKey, this);
    }
    else {
      if (__WL_verbose) {
        Debug.say("Trying to add " + mapKey + " to list during cascade delete, " +
        "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 java.sql.PreparedStatement[] __WL_getBulkStmtArray(java.sql.Connection __WL_con)
  throws Exception
  {
    if (__WL_verbose) {
      Debug.say("called __WL_getBulkStmtArray.");
    }
    
        java.sql.PreparedStatement[] __WL_stmt_array = new java.sql.PreparedStatement[1];        java.sql.PreparedStatement __WL_stmt_userTable_0 = null;    __WL_stmt_array[0] = __WL_stmt_userTable_0;        
        String[] __WL_query_array = new String[1];    
    
        __WL_query_array[0] = "INSERT INTO userTable (userName, userPassword, baseInforFunction, stockFunction, stockManageFunction, saleFunction) VALUES (?, ?, ?, ?, ?, ?)";    
    
    if(__WL_verbose) {
      for (int i = 0 ; i < 1 ; i++) {
        Debug.say("__WL_getBulkStmtArray() produced sqlString " + __WL_query_array[i]);
      }
    }
    
        __WL_stmt_array[0] = __WL_con.prepareStatement(__WL_query_array[0]);    
    
    return __WL_stmt_array;
    
  }
  
  public void __WL_setBeanParamsForCreateArray(java.sql.PreparedStatement[] __WL_stmt_array)
  throws Exception
  {
    
    // preparedStatementParamIndex reset.    if(!__WL_pm.setParamNull(__WL_stmt_array[0], 1, this.userName, "userName")) {      __WL_stmt_array[0].setString(1, this.userName);      if (__WL_verbose) {        Debug.say("paramIdx :"+1+" binded with value :"+this.userName);      }    }        if(!__WL_pm.setParamNull(__WL_stmt_array[0], 2, this.userPassword, "userPassword")) {      __WL_stmt_array[0].setString(2, this.userPassword);      if (__WL_verbose) {        Debug.say("paramIdx :"+2+" binded with value :"+this.userPassword);      }    }        __WL_stmt_array[0].setInt(3, this.baseInforFunction);    if (__WL_verbose) {      Debug.say("paramIdx :"+3+" binded with value :"+this.baseInforFunction);    }        __WL_stmt_array[0].setInt(4, this.stockFunction);    if (__WL_verbose) {      Debug.say("paramIdx :"+4+" binded with value :"+this.stockFunction);    }        __WL_stmt_array[0].setInt(5, this.stockManageFunction);    if (__WL_verbose) {      Debug.say("paramIdx :"+5+" binded with value :"+this.stockManageFunction);    }        __WL_stmt_array[0].setInt(6, this.saleFunction);    if (__WL_verbose) {      Debug.say("paramIdx :"+6+" binded with value :"+this.saleFunction);    }    
    
  }
  
  public void __WL_resetIsModifiedVars() {
    for (int __WL_i = 0; __WL_i < __WL_isModified.length; __WL_i++) {
      __WL_isModified[__WL_i] = false;
    }
    __WL_modifiedBeanIsRegistered = false;
    
  }
  
  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 userName from userTable where userName = ?";
      
      __WL_stmt = __WL_con.prepareStatement(__WL_query);
      
      // preparedStatementParamIndex reset.
            if(!__WL_pm.setParamNull(__WL_stmt, 1, __WL_pk, "userName")) {        __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
  {
    
  }
  
  public short __WL_getBeanState() 
  {
    return __WL_bean_state;
  } 
  
  public void __WL_setBeanState(short value)
  {
    __WL_bean_state = value;
  }
  
  
  public String __WL_getM2NSQL(String cmrf,
  int    operation)
  {
    return "";
  }
  
  public void __WL_setBeanParamsForM2NStmt(PreparedStatement __WL_stmt,
  String            cmrf,
  int               operation)
  throws SQLException
  {
    
  }
  
  
  
  // end of CMPBean
  // ================================================================
  
  
  //=================================================================
  // implementation of javax.ejb.EntityBean
  
  public boolean __WL_beanIsLoaded() { 
    return __WL_beanIsLoaded; 
  }
  
  void pkCheck()
  throws javax.ejb.CreateException
  {
    // check that 'userName' was set    if (!__WL_isModified[0]) {      throw new javax.ejb.CreateException("In EJB UserTable, primary key field 'userName' was not set during ejbCreate.  All primary key fields must be initialized during ejbCreate.");    }
  }
  
  
  public java.lang.String ejbCreate(java.lang.String arg0, java.lang.String arg1, int arg2, int arg3, int arg4, int arg5)
  throws javax.ejb.CreateException
  {
    int oldState = __WL_method_state;
    try {
      __WL_method_state = STATE_EJB_CREATE;
      
      for (int __WL_i = 0; __WL_i < 6; __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 bean enters the pooled state
            stockFunction = 0;      saleFunction = 0;      userPassword = null;      baseInforFunction = 0;      userName = null;      stockManageFunction = 0;      
            
      
      super.ejbCreate( arg0, arg1, arg2, arg3, arg4, arg5);