Object __WL_pk = __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader);__WL_eo = null;if (__WL_pk != null) { RSInfo __WL_rsInfo = new RSInfoImpl(__WL_rs, 0, 0, __WL_pk);__WL_bean = (ejb.UserInfo_1571he__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromRS(__WL_pk, __WL_rsInfo);__WL_eo = __WL_pm.finderGetEoFromBeanOrPk(__WL_bean, __WL_pk, __WL_getIsLocal());if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean);Object __WL_retVal = __WL_pkMap.put(__WL_pk, __WL_bean);if (__WL_retVal!=null) __WL_isMulti=true;}
      }

      if (__WL_pkMap.size() == 0) {
        if(__WL_verbose) {
          Debug.say("Throwing FinderException because bean wasn't found.");
        }
        throw new javax.ejb.ObjectNotFoundException("Bean with primary key '" + param0.toString() + "' was not found by 'findByPrimaryKey'.");
      }
      if (__WL_isMulti || __WL_pkMap.size() > 1) {
        Loggable l = EJBLogger.logfinderReturnedMultipleValuesLoggable("findByPrimaryKey");
        throw new javax.ejb.FinderException(l.getMessage());
      }
      return __WL_eo;
  } catch (javax.ejb.FinderException fe) {
    throw fe;
  } catch (java.sql.SQLException sqle) {
    throw new javax.ejb.FinderException(
      "Problem in findByPrimaryKey while preparing or executing " +
      "statement: '" +
      __WL_stmt + "': " + EOL +
      sqle.toString() + EOL +
      RDBMSUtils.throwable2StackTrace(sqle));
  } catch (Exception e) {
    throw new javax.ejb.FinderException(
      "Exception raised in findByPrimaryKey " + EOL +
      e.toString() + EOL +
      RDBMSUtils.throwable2StackTrace(e));
  } finally {
    __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    
  }
}

  // loadGroup method for the 'defaultGroup' group.public void __WL_loadGroup0() throws Exception {    java.sql.Connection __WL_con = null;
    java.sql.PreparedStatement __WL_stmt = null;
    java.sql.ResultSet __WL_rs = null;
    int __WL_offset = 0;

    int selectForUpdateVal = __WL_pm.getSelectForUpdateValue();

    java.lang.String __WL_query;

    // http://bugs.beasys.com/CRView?CR=CR070260
    //
    //  optimization.

    switch(selectForUpdateVal) {
      case DDConstants.SELECT_FOR_UPDATE_DISABLED:
        __WL_query = "SELECT WL0.address, WL0.email, WL0.shenfenzheng, WL0.telephone, WL0.userCode, WL0.userName, WL0.userPW, WL0.youZhengBianMa  FROM user_Info WL0  WHERE WL0.userCode = ? ";
        break;

      case DDConstants.SELECT_FOR_UPDATE:
        __WL_query = "SELECT WL0.address, WL0.email, WL0.shenfenzheng, WL0.telephone, WL0.userCode, WL0.userName, WL0.userPW, WL0.youZhengBianMa  FROM user_Info WL0  WHERE WL0.userCode = ?  FOR UPDATE ";
        break;

      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
        __WL_query = "SELECT WL0.address, WL0.email, WL0.shenfenzheng, WL0.telephone, WL0.userCode, WL0.userName, WL0.userPW, WL0.youZhengBianMa  FROM user_Info WL0  WHERE WL0.userCode = ?  FOR UPDATE NOWAIT ";
        break;

      default:
        throw new AssertionError(
        "Unknown selectForUpdate type: '"+selectForUpdateVal+"'");
    }

    

    try {
      if (__WL_verbose) {
        Debug.say("__WL_loadGroup0 for pk=" + __WL_ctx.getPrimaryKey());
      }

      java.lang.String __WL_pk = (java.lang.String) __WL_ctx.getPrimaryKey();

      __WL_con = __WL_pm.getConnection();


      __WL_stmt = __WL_con.prepareStatement(__WL_query);

      // preparedStatementParamIndex reset.
      if(!__WL_pm.setParamNull(__WL_stmt, 1, __WL_pk, "userCode")) {__WL_stmt.setString(1, __WL_pk);if (__WL_verbose) {Debug.say("paramIdx :"+1+" binded with value :"+__WL_pk);}}

      if (__WL_verbose) {
        Debug.say("__WL_loadGroup0 for pk=" + __WL_ctx.getPrimaryKey() + 
                  ", executeQuery: "+__WL_query);
      }

      __WL_rs = __WL_stmt.executeQuery();
      if (__WL_rs.next()) {

        if (__WL_verbose) {
          Debug.say("__WL_loadGroup0 for pk=" + __WL_ctx.getPrimaryKey() + 
                    " now read columns from Results.");
        }
     
        
        if (!(this.__WL_isLoaded[5] || this.__WL_isModified[5])) {this.address = (java.lang.String)__WL_rs.getString(1+__WL_offset);if (__WL_rs.wasNull()) { this.address = null;}}else {__WL_rs.getString(1+__WL_offset);}if (!(this.__WL_isLoaded[7] || this.__WL_isModified[7])) {this.email = (java.lang.String)__WL_rs.getString(2+__WL_offset);if (__WL_rs.wasNull()) { this.email = null;}}else {__WL_rs.getString(2+__WL_offset);}if (!(this.__WL_isLoaded[3] || this.__WL_isModified[3])) {this.shenfenzheng = (java.lang.String)__WL_rs.getString(3+__WL_offset);if (__WL_rs.wasNull()) { this.shenfenzheng = null;}}else {__WL_rs.getString(3+__WL_offset);}if (!(this.__WL_isLoaded[4] || this.__WL_isModified[4])) {this.telephone = (java.lang.String)__WL_rs.getString(4+__WL_offset);if (__WL_rs.wasNull()) { this.telephone = null;}}else {__WL_rs.getString(4+__WL_offset);}if (!(this.__WL_isLoaded[0] || this.__WL_isModified[0])) {this.userCode = (java.lang.String)__WL_rs.getString(5+__WL_offset);if (__WL_rs.wasNull()) { this.userCode = null;}}else {__WL_rs.getString(5+__WL_offset);}if (!(this.__WL_isLoaded[1] || this.__WL_isModified[1])) {this.userName = (java.lang.String)__WL_rs.getString(6+__WL_offset);if (__WL_rs.wasNull()) { this.userName = null;}}else {__WL_rs.getString(6+__WL_offset);}if (!(this.__WL_isLoaded[2] || this.__WL_isModified[2])) {this.userPW = (java.lang.String)__WL_rs.getString(7+__WL_offset);if (__WL_rs.wasNull()) { this.userPW = null;}}else {__WL_rs.getString(7+__WL_offset);}if (!(this.__WL_isLoaded[6] || this.__WL_isModified[6])) {this.youZhengBianMa = (java.lang.String)__WL_rs.getString(8+__WL_offset);if (__WL_rs.wasNull()) { this.youZhengBianMa = null;}}else {__WL_rs.getString(8+__WL_offset);}this.__WL_isLoaded[5] = true;this.__WL_isLoaded[7] = true;this.__WL_isLoaded[3] = true;this.__WL_isLoaded[4] = true;this.__WL_isLoaded[0] = true;this.__WL_isLoaded[1] = true;this.__WL_isLoaded[2] = true;this.__WL_isLoaded[6] = true;this.__WL_beanIsLoaded = true;
        

        __WL_beanIsLoaded = true;
        
      } else {
        if(__WL_verbose) {
          Debug.say("__WL_loadGroup0 could not find primary key " +
                    __WL_pk);
        }
        Loggable l = EJBLogger.lognoSuchEntityExceptionLoggable(__WL_pk.toString());
        throw new NoSuchEntityException(l.getMessage());
              
      }
    } finally {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }

    
}
  // loadGroup from ResultSet to bean method for the 'defaultGroup' group.public void __WL_loadGroup0FromRS(java.sql.ResultSet __WL_rs, java.lang.Integer __WL_offsetIntObj, Object __WL_pk,ejb.UserInfo_1571he_Intf beanIntf)throws java.sql.SQLException, java.lang.Exception{ejb.UserInfo_1571he__WebLogic_CMP_RDBMS __WL_bean = (ejb.UserInfo_1571he__WebLogic_CMP_RDBMS)beanIntf;if (__WL_verbose) {Debug.say("__WL_loadGroup0FromRS");}int __WL_offset = __WL_offsetIntObj.intValue();if (__WL_pk == null) {if (!(__WL_bean.__WL_isLoaded[0] || __WL_bean.__WL_isModified[0])) {__WL_bean.userCode = (java.lang.String)__WL_rs.getString(1+__WL_offset);if (__WL_rs.wasNull()) { __WL_bean.userCode = null;}}else {__WL_rs.getString(1+__WL_offset);}} else {__WL_bean.__WL_setPrimaryKey((java.lang.String) __WL_pk);}if (!(__WL_bean.__WL_isLoaded[5] || __WL_bean.__WL_isModified[5])) {__WL_bean.address = (java.lang.String)__WL_rs.getString(2+__WL_offset);if (__WL_rs.wasNull()) { __WL_bean.address = null;}}else {__WL_rs.getString(2+__WL_offset);}if (!(__WL_bean.__WL_isLoaded[7] || __WL_bean.__WL_isModified[7])) {__WL_bean.email = (java.lang.String)__WL_rs.getString(3+__WL_offset);if (__WL_rs.wasNull()) { __WL_bean.email = null;}}else {__WL_rs.getString(3+__WL_offset);}if (!(__WL_bean.__WL_isLoaded[3] || __WL_bean.__WL_isModified[3])) {__WL_bean.shenfenzheng = (java.lang.String)__WL_rs.getString(4+__WL_offset);if (__WL_rs.wasNull()) { __WL_bean.shenfenzheng = null;}}else {__WL_rs.getString(4+__WL_offset);}if (!(__WL_bean.__WL_isLoaded[4] || __WL_bean.__WL_isModified[4])) {__WL_bean.telephone = (java.lang.String)__WL_rs.getString(5+__WL_offset);if (__WL_rs.wasNull()) { __WL_bean.telephone = null;}}else {__WL_rs.getString(5+__WL_offset);}if (!(__WL_bean.__WL_isLoaded[1] || __WL_bean.__WL_isModified[1])) {__WL_bean.userName = (java.lang.String)__WL_rs.getString(6+__WL_offset);if (__WL_rs.wasNull()) { __WL_bean.userName = null;}}else {__WL_rs.getString(6+__WL_offset);}if (!(__WL_bean.__WL_isLoaded[2] || __WL_bean.__WL_isModified[2])) {__WL_bean.userPW = (java.lang.String)__WL_rs.getString(7+__WL_offset);if (__WL_rs.wasNull()) { __WL_bean.userPW = null;}}else {__WL_rs.getString(7+__WL_offset);}if (!(__WL_bean.__WL_isLoaded[6] || __WL_bean.__WL_isModified[6])) {__WL_bean.youZhengBianMa = (java.lang.String)__WL_rs.getString(8+__WL_offset);if (__WL_rs.wasNull()) { __WL_bean.youZhengBianMa = null;}}else {__WL_rs.getString(8+__WL_offset);}__WL_bean.__WL_isLoaded[5] = true;__WL_bean.__WL_isLoaded[7] = true;__WL_bean.__WL_isLoaded[3] = true;__WL_bean.__WL_isLoaded[4] = true;__WL_bean.__WL_isLoaded[0] = true;__WL_bean.__WL_isLoaded[1] = true;__WL_bean.__WL_isLoaded[2] = true;__WL_bean.__WL_isLoaded[6] = true;__WL_bean.__WL_beanIsLoaded = true;__WL_beanIsLoaded = true;}
  

  // methods to load related beans - for Dynamic Finders
  
  public void __WL_loadBeansRelatedToCachingName(String cachingName, java.sql.ResultSet rs, CMPBean bean, int groupColumnCount)throws Exception {}

  public static Object __WL_getPKFromRS(java.sql.ResultSet __WL_rs, java.lang.Integer __WL_offsetIntObj, ClassLoader __WL_classLoader)
    throws java.sql.SQLException, java.lang.Exception
  {
    if (__WL_verbose) {
      Debug.say("__WL_getPKFromRS");
    }

    int __WL_offset = __WL_offsetIntObj.intValue();
    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("UserInfo_1571he__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.userCode;return __WL_pk;
  }

  public void __WL_setPrimaryKey(java.lang.String __WL_pk) {
    this.userCode = __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_superEjbStore()  {
    int oldState = __WL_method_state;

    try {
      __WL_method_state = STATE_EJBSTORE;
      if (__WL_verbose) {
        Debug.say("__WL_superEjbStore "+ __WL_ctx.getPrimaryKey());
      }
      super.ejbStore();
    } finally {
      __WL_method_state = oldState;
    }
  }

  public void __WL_superEjbRemove()  throws javax.ejb.RemoveException {
        int oldState = __WL_method_state;

    try {
      __WL_method_state = STATE_EJB_REMOVE;
      if (__WL_verbose) {
        Debug.say("__WL_superEjbRemove " + __WL_ctx.getPrimaryKey());
      }
      super.ejbRemove();

      
      
      
      // initialize state before this instance goes back into the pool
      if (!__WL_getIsRemoved()) __WL_initialize();

    } finally {
      __WL_method_state = oldState;
    }

  }