wbemployee_ji9hxe__weblogic_cmp_rdbms.java

客户管理系统,很强大的功能,能完成日常生活中的大部分事务

      java.lang.Long __WL_pk = (java.lang.Long) __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, "sn")) {
__WL_stmt.setLong(1, __WL_pk.longValue());
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[4] || this.__WL_isModified[4])) {
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[3] || this.__WL_isModified[3])) {
this.age = new Integer(__WL_rs.getInt(2+__WL_offset));
if (__WL_rs.wasNull()) { 
this.age = null;
}
}
else {
__WL_rs.getInt(2+__WL_offset);
}
if (!(this.__WL_isLoaded[1] || this.__WL_isModified[1])) {
this.name = (java.lang.String)__WL_rs.getString(3+__WL_offset);
if (__WL_rs.wasNull()) { 
this.name = null;
}
}
else {
__WL_rs.getString(3+__WL_offset);
}
if (!(this.__WL_isLoaded[6] || this.__WL_isModified[6])) {
this.note = (java.lang.String)__WL_rs.getString(4+__WL_offset);
if (__WL_rs.wasNull()) { 
this.note = null;
}
}
else {
__WL_rs.getString(4+__WL_offset);
}
if (!(this.__WL_isLoaded[5] || this.__WL_isModified[5])) {
this.pw = (java.lang.String)__WL_rs.getString(5+__WL_offset);
if (__WL_rs.wasNull()) { 
this.pw = null;
}
}
else {
__WL_rs.getString(5+__WL_offset);
}
if (!(this.__WL_isLoaded[2] || this.__WL_isModified[2])) {
this.sex = (java.lang.String)__WL_rs.getString(6+__WL_offset);
if (__WL_rs.wasNull()) { 
this.sex = null;
}
}
else {
__WL_rs.getString(6+__WL_offset);
}
if (!(this.__WL_isLoaded[0] || this.__WL_isModified[0])) {
this.sn = new Long(__WL_rs.getLong(7+__WL_offset));
if (__WL_rs.wasNull()) { 
this.sn = null;
}
}
else {
__WL_rs.getLong(7+__WL_offset);
}
this.__WL_isLoaded[4] = true;
this.__WL_isLoaded[3] = true;
this.__WL_isLoaded[1] = true;
this.__WL_isLoaded[6] = true;
this.__WL_isLoaded[5] = true;
this.__WL_isLoaded[2] = true;
this.__WL_isLoaded[0] = 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,
custom_management.WbEmployee_ji9hxe_Intf beanIntf)
throws java.sql.SQLException, java.lang.Exception
{
custom_management.WbEmployee_ji9hxe__WebLogic_CMP_RDBMS __WL_bean = (custom_management.WbEmployee_ji9hxe__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.sn = new Long(__WL_rs.getLong(1+__WL_offset));
if (__WL_rs.wasNull()) { 
__WL_bean.sn = null;
}
}
else {
__WL_rs.getLong(1+__WL_offset);
}
} else {
__WL_bean.__WL_setPrimaryKey((java.lang.Long) __WL_pk);
}
if (!(__WL_bean.__WL_isLoaded[4] || __WL_bean.__WL_isModified[4])) {
__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[3] || __WL_bean.__WL_isModified[3])) {
__WL_bean.age = new Integer(__WL_rs.getInt(3+__WL_offset));
if (__WL_rs.wasNull()) { 
__WL_bean.age = null;
}
}
else {
__WL_rs.getInt(3+__WL_offset);
}
if (!(__WL_bean.__WL_isLoaded[1] || __WL_bean.__WL_isModified[1])) {
__WL_bean.name = (java.lang.String)__WL_rs.getString(4+__WL_offset);
if (__WL_rs.wasNull()) { 
__WL_bean.name = null;
}
}
else {
__WL_rs.getString(4+__WL_offset);
}
if (!(__WL_bean.__WL_isLoaded[6] || __WL_bean.__WL_isModified[6])) {
__WL_bean.note = (java.lang.String)__WL_rs.getString(5+__WL_offset);
if (__WL_rs.wasNull()) { 
__WL_bean.note = null;
}
}
else {
__WL_rs.getString(5+__WL_offset);
}
if (!(__WL_bean.__WL_isLoaded[5] || __WL_bean.__WL_isModified[5])) {
__WL_bean.pw = (java.lang.String)__WL_rs.getString(6+__WL_offset);
if (__WL_rs.wasNull()) { 
__WL_bean.pw = null;
}
}
else {
__WL_rs.getString(6+__WL_offset);
}
if (!(__WL_bean.__WL_isLoaded[2] || __WL_bean.__WL_isModified[2])) {
__WL_bean.sex = (java.lang.String)__WL_rs.getString(7+__WL_offset);
if (__WL_rs.wasNull()) { 
__WL_bean.sex = null;
}
}
else {
__WL_rs.getString(7+__WL_offset);
}
__WL_bean.__WL_isLoaded[4] = true;
__WL_bean.__WL_isLoaded[3] = true;
__WL_bean.__WL_isLoaded[1] = true;
__WL_bean.__WL_isLoaded[6] = true;
__WL_bean.__WL_isLoaded[5] = true;
__WL_bean.__WL_isLoaded[2] = true;
__WL_bean.__WL_isLoaded[0] = true;
__WL_bean.__WL_beanIsLoaded = true;
__WL_beanIsLoaded = true;
}

  
public void __WL_loadCMRFieldFromRS_wbRole
(java.sql.ResultSet __WL_rs, 
java.lang.Integer __WL_offsetIntObj, 
custom_management.WbEmployee_ji9hxe_Intf beanIntf) 
throws java.sql.SQLException, java.lang.Exception
{
custom_management.WbEmployee_ji9hxe__WebLogic_CMP_RDBMS __WL_bean = (custom_management.WbEmployee_ji9hxe__WebLogic_CMP_RDBMS)beanIntf;
if (__WL_verbose) {
Debug.say("__WL_loadCMRFieldFromRS_wbRole");
}

int __WL_offset = __WL_offsetIntObj.intValue();

if (!(__WL_bean.__WL_isLoaded[0] || __WL_bean.__WL_isModified[0])) {
__WL_bean.sn = new Long(__WL_rs.getLong(1+__WL_offset));
if (__WL_rs.wasNull()) { 
__WL_bean.sn = null;
}
}
else {
__WL_rs.getLong(1+__WL_offset);
}
__WL_bean.__WL_isLoaded[0] = true;

}


  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.Long __WL_pk = null;
    
    __WL_pk = new Long(__WL_rs.getLong(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

  public java.util.Collection __WL_findByWbRole_wjvqb2__WebLogic_CMP_RDBMS_wbEmployee__WL___
    (java.lang.Object param0
    ) throws java.lang.Exception
    {
    if(__WL_verbose) {
      Debug.say("called findByWbRole_wjvqb2__WebLogic_CMP_RDBMS_wbEmployee__WL_");
    }

    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 = null;
    switch(selectForUpdateVal) {
      case DDConstants.SELECT_FOR_UPDATE_DISABLED:
	__WL_query = "SELECT WL2.sn, WL2.address, WL2.age, WL2.name, WL2.note, WL2.pw, WL2.sex  FROM Wb_Role WL0 , Wb_Employee WL2 , Wb_Employee_Role WL1  WHERE WL0.objUid = ?  AND WL0.objUid = WL1.role_uid AND WL1.employee_uid = WL2.sn ";
        break;

      case DDConstants.SELECT_FOR_UPDATE:
        __WL_query = "SELECT WL2.sn, WL2.address, WL2.age, WL2.name, WL2.note, WL2.pw, WL2.sex  FROM Wb_Role WL0 , Wb_Employee WL2 , Wb_Employee_Role WL1  WHERE WL0.objUid = ?  AND WL0.objUid = WL1.role_uid AND WL1.employee_uid = WL2.sn  FOR UPDATE ";
        break;

      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
        __WL_query = "SELECT WL2.sn, WL2.address, WL2.age, WL2.name, WL2.note, WL2.pw, WL2.sex  FROM Wb_Role WL0 , Wb_Employee WL2 , Wb_Employee_Role WL1  WHERE WL0.objUid = ?  AND WL0.objUid = WL1.role_uid AND WL1.employee_uid = WL2.sn  FOR UPDATE NOWAIT ";
        break;

      default:
        throw new AssertionError(
        "Unknown selectForUpdate type: '"+selectForUpdateVal+"'");
    }
    if(__WL_verbose) {
      Debug.say("Finder produced statement string " + __WL_query);
    }


    

    try {
      __WL_con = __WL_pm.getConnection();
    } 
    catch (java.lang.Exception e) {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
      throw new javax.ejb.FinderException("Couldn't get connection: " + EOL +
        e.toString() + EOL +
        RDBMSUtils.throwable2StackTrace(e));
    }

    

    try {

      __WL_stmt = __WL_con.prepareStatement(__WL_query);

      
      // preparedStatementParamIndex reset.
      
java.lang.Long __WL_param0_PK;
__WL_param0_PK = (java.lang.Long)param0;
if (__WL_param0_PK == null) {
__WL_stmt.setNull(1,java.sql.Types.INTEGER);
} else {
__WL_stmt.setLong(1, __WL_param0_PK.longValue());
if (__WL_verbose) {
Debug.say("paramIdx :"+1+" binded with value :"+__WL_param0_PK);
}
}


      __WL_rs = __WL_stmt.executeQuery();
    } 
    catch (java.lang.Exception e) {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
      throw new javax.ejb.FinderException(
        "Exception in findByWbRole_wjvqb2__WebLogic_CMP_RDBMS_wbEmployee__WL_ while preparing or executing " +
        "statement: '" + __WL_stmt + "'" + EOL +
        e.toString() + EOL +
        RDBMSUtils.throwable2StackTrace(e));
    }

    try {
      java.util.Collection __WL_collection = new java.util.ArrayList();
custom_management.WbEmployee_ji9hxe__WebLogic_CMP_RDBMS __WL_bean = null;
Object __WL_eo = null;
Object __WL_eo_rc = null;

      
      
Map __WL_pkMap = new HashMap();

      while (__WL_rs.next()) {
        
Integer __WL_offsetIntObj = new Integer(0);
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 = (custom_management.WbEmployee_ji9hxe__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);
__WL_collection.add(__WL_eo);
Object __WL_retVal = __WL_pkMap.put(__WL_pk, __WL_bean);
}


      }
      return __WL_collection;

    } catch (java.sql.SQLException sqle) {
      throw new javax.ejb.FinderException(
        "Exception in 'findByWbRole_wjvqb2__WebLogic_CMP_RDBMS_wbEmployee__WL_' while using " +
        "result set: '" + __WL_rs + "'" + EOL +
        sqle.toString() + EOL +
        RDBMSUtils.throwable2StackTrace(sqle));
    } catch (java.lang.Exception e) {
      throw new javax.ejb.FinderException(
        "Exception executing finder 'findByWbRole_wjvqb2__WebLogic_CMP_RDBMS_wbEmployee__WL_': " + EOL +
        e.toString() + EOL +
        RDBMSUtils.throwable2StackTrace(e));
    } finally {
      
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }

}





  //=================================================================

  // ================================================================
  // Implementation of CMPBean
  public void __WL_setup(java.util.Map bmMap, PersistenceManager __WL_pm) {
    if (__WL_verbose) {
      Debug.say("WbEmployee_ji9hxe__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);
    }
    try {__WL_wbRole_bm = (CMPBeanManager)bmMap.get("WbRole");
if (__WL_debug) Debug.assertion(bmMap.get("WbRole")!=null);

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

    
  }

  public EntityContext __WL_getEntityContext() {
    return __WL_ctx;
  }

  public Object __WL_getPrimaryKey() {
    java.lang.Long __WL_pk = null;

__WL_pk = this.sn;