amanagerlogbean_anhkeg__weblogic_cmp_rdbms.java

一个J2EE四层架构的实例

  }

  public java.lang.Integer getId()
  {
    try {
            if (!__WL_isLoaded[7]) {
        __WL_loadGroup0();
      }

      return id;
    } 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 void setId(
    java.lang.Integer id)
  {
        this.id = id;
    __WL_isModified[7] = true;
    
    if (! __WL_modifiedBeanIsRegistered) {
      __WL_pm.registerModifiedBean(__WL_ctx.getPrimaryKey());
      __WL_modifiedBeanIsRegistered = true;
    }


  }


  
  

  //=================================================================
  //Finder methods.
  public java.util.Collection ejbFindAllManagelog() throws javax.ejb.FinderException
    {
    if(__WL_verbose) {
      Debug.say("called findAllManagelog");
    }

    java.sql.Connection __WL_con = null;
    java.sql.PreparedStatement __WL_stmt = null;
    java.sql.ResultSet __WL_rs = null;

    

    String selectForUpdate = __WL_pm.selectForUpdate();

    

    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 {
      java.lang.String __WL_query = "SELECT WL0.USERNAME, WL0.ID, WL0.INFO1, WL0.ODATE, WL0.OPERATION, WL0.PURVIEW, WL0.SDATE, WL0.TOKENSN  FROM A_ManagerLog WL0  WHERE ( (1 = 1) ) "  + selectForUpdate;
      if(__WL_verbose) {
        Debug.say("Finder produced statement string " + __WL_query);
      }

      __WL_stmt = __WL_con.prepareStatement(__WL_query);

      
      // preparedStatementParamIndex reset.
      


      __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 findAllManagelog while preparing or executing " +
        "statement: '" + __WL_stmt + "'" + EOL +
        e.toString() + EOL +
        RDBMSUtils.throwable2StackTrace(e));
    }

    try {
          java.util.Collection __WL_collection = new java.util.ArrayList();
    sqlaccounts.AManagerLogBean_anhkeg__WebLogic_CMP_RDBMS __WL_bean = null;

      
    Set __WL_pkSet = new HashSet();

      while (__WL_rs.next()) {
                                
          Integer __WL_offsetIntObj = new Integer(0);
          Object __WL_pk = __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader);
          if (__WL_pk != null) { 
            __WL_pkSet.add(__WL_pk);
            __WL_bean = (sqlaccounts.AManagerLogBean_anhkeg__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromPool();
            __WL_bean.__WL_initialize();

            __WL_bean = __WL_loadGroup0FromRS(__WL_rs, __WL_offsetIntObj, __WL_bean);

            if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean);
            __WL_collection.add(__WL_bean);
          }


      }
      return __WL_collection;

    } catch (java.sql.SQLException sqle) {
      throw new javax.ejb.FinderException(
        "Exception in 'findAllManagelog' 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 'findAllManagelog': " + EOL +
        e.toString() + EOL +
        RDBMSUtils.throwable2StackTrace(e));
    } finally {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }

    

}

public javax.ejb.EntityBean ejbFindByPrimaryKey(java.lang.String param0) throws javax.ejb.FinderException
    {
    if(__WL_verbose) {
      Debug.say("called findByPrimaryKey.");
    }

    java.sql.Connection __WL_con = null;
    java.sql.PreparedStatement __WL_stmt = null;
    java.sql.ResultSet __WL_rs = null;
        sqlaccounts.AManagerLogBean_anhkeg__WebLogic_CMP_RDBMS __WL_bean = null;


    

    String selectForUpdate = __WL_pm.selectForUpdate();

    

    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 {
      java.lang.String __WL_query = "SELECT WL0.USERNAME, WL0.ID, WL0.INFO1, WL0.ODATE, WL0.OPERATION, WL0.PURVIEW, WL0.SDATE, WL0.TOKENSN  FROM A_ManagerLog WL0  WHERE ( (WL0.USERNAME = ?) ) " + selectForUpdate;
      if(__WL_verbose) {
        Debug.say("Finder produced statement string " + __WL_query);
      }

      __WL_stmt = __WL_con.prepareStatement(__WL_query);
      // preparedStatementParamIndex reset.
      
    if (param0 == null) {
      __WL_stmt.setNull(1,java.sql.Types.VARCHAR);
    } else {
    __WL_stmt.setString(1, param0);
  }

      __WL_rs = __WL_stmt.executeQuery();

      
  Set __WL_pkSet = new HashSet();

      while (__WL_rs.next()) {
                          
        Integer __WL_offsetIntObj = new Integer(0);
        Object __WL_pk = __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader);
        if (__WL_pk != null) { 
          __WL_pkSet.add(__WL_pk);
          __WL_bean = (sqlaccounts.AManagerLogBean_anhkeg__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromPool();
          __WL_bean.__WL_initialize();

          __WL_bean = __WL_loadGroup0FromRS(__WL_rs, __WL_offsetIntObj, __WL_bean);

          if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean);
        }


      }

      if (__WL_pkSet.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_pkSet.size() != 1) {
        throw new javax.ejb.FinderException("finder/ejbSelect 'findByPrimaryKey'" +
          "has returned more than one value.  We were expecting only ONE value. "+
          " See EJB Spec 10.5.6.1, 10.5.7.1");
      }
      return __WL_bean;
  } 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;

    String selectForUpdate = __WL_pm.selectForUpdate();

    

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

      java.lang.String __WL_query = 
        "SELECT WL0.ID, WL0.INFO1, WL0.ODATE, WL0.OPERATION, WL0.PURVIEW, WL0.SDATE, WL0.TOKENSN, WL0.USERNAME  FROM A_ManagerLog WL0  WHERE WL0.USERNAME = ? "  +
        selectForUpdate;

      __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("__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[7] || this.__WL_isModified[7])) {
      this.id = new Integer(__WL_rs.getInt(1+__WL_offset));
      if (__WL_rs.wasNull()) { 
        this.id = null;
      }
    }
    else {
      __WL_rs.getInt(1+__WL_offset);
    }
    if (!(this.__WL_isLoaded[6] || this.__WL_isModified[6])) {
      this.info1 = (java.lang.String)__WL_rs.getString(2+__WL_offset);
      if (__WL_rs.wasNull()) { 
        this.info1 = null;
      }
    }
    else {
      __WL_rs.getString(2+__WL_offset);
    }
    if (!(this.__WL_isLoaded[2] || this.__WL_isModified[2])) {
      this.odate = (java.sql.Timestamp)__WL_rs.getTimestamp(3+__WL_offset);
      if (__WL_rs.wasNull()) { 
        this.odate = null;
      }
    }
    else {
      __WL_rs.getTimestamp(3+__WL_offset);
    }
    if (!(this.__WL_isLoaded[3] || this.__WL_isModified[3])) {
      this.operation = (java.lang.String)__WL_rs.getString(4+__WL_offset);
      if (__WL_rs.wasNull()) { 
        this.operation = null;
      }
    }
    else {
      __WL_rs.getString(4+__WL_offset);
    }
    if (!(this.__WL_isLoaded[1] || this.__WL_isModified[1])) {
      this.purview = (java.lang.String)__WL_rs.getString(5+__WL_offset);
      if (__WL_rs.wasNull()) { 
        this.purview = null;
      }
    }
    else {
      __WL_rs.getString(5+__WL_offset);
    }
    if (!(this.__WL_isLoaded[4] || this.__WL_isModified[4])) {
      this.sdate = (java.sql.Timestamp)__WL_rs.getTimestamp(6+__WL_offset);
      if (__WL_rs.wasNull()) { 
        this.sdate = null;
      }
    }
    else {
      __WL_rs.getTimestamp(6+__WL_offset);
    }
    if (!(this.__WL_isLoaded[5] || this.__WL_isModified[5])) {
      this.tokensn = (java.lang.String)__WL_rs.getString(7+__WL_offset);
      if (__WL_rs.wasNull()) { 
        this.tokensn = null;
      }
    }
    else {
      __WL_rs.getString(7+__WL_offset);
    }
    if (!(this.__WL_isLoaded[0] || this.__WL_isModified[0])) {
      this.username = (java.lang.String)__WL_rs.getString(8+__WL_offset);
      if (__WL_rs.wasNull()) { 
        this.username = null;
      }
    }
    else {
      __WL_rs.getString(8+__WL_offset);
    }
    this.__WL_isLoaded[7] = true;
    this.__WL_isLoaded[6] = true;
    this.__WL_isLoaded[2] = true;
    this.__WL_isLoaded[3] = true;
    this.__WL_isLoaded[1] = true;
    this.__WL_isLoaded[4] = true;
    this.__WL_isLoaded[5] = true;
    this.__WL_isLoaded[0] = true;

        

        __WL_beanIsLoaded = true;
      } else {
        if(__WL_verbose) {
          Debug.say("__WL_loadGroup0 could not find primary key " +
                    __WL_pk);
        }
        throw new NoSuchEntityException("Bean with " +
          "primary key: '" + __WL_pk + "' not found.");
      }
    } finally {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }

    
  }

  
  // loadGroup from ResultSet to bean method for the 'defaultGroup' group.
  public sqlaccounts.AManagerLogBean_anhkeg__WebLogic_CMP_RDBMS
    __WL_loadGroup0FromRS
      (java.sql.ResultSet __WL_rs, 
      java.lang.Integer __WL_offsetIntObj, 
      sqlaccounts.AManagerLogBean_anhkeg__WebLogic_CMP_RDBMS __WL_bean) 
    throws java.sql.SQLException, java.lang.Exception
  {
    if (__WL_verbose) {
      Debug.say("__WL_loadGroup0FromRS");
    }

    int __WL_offset = __WL_offsetIntObj.intValue();

    if (!(__WL_bean.__WL_isLoaded[0] || __WL_bean.__WL_isModified[0])) {
      __WL_bean.username = (java.lang.String)__WL_rs.getString(1+__WL_offset);
      if (__WL_rs.wasNull()) { 
        __WL_bean.username = null;
      }
    }
    else {
      __WL_rs.getString(1+__WL_offset);
    }
    if (!(__WL_bean.__WL_isLoaded[7] || __WL_bean.__WL_isModified[7])) {
      __WL_bean.id = new Integer(__WL_rs.getInt(2+__WL_offset));
      if (__WL_rs.wasNull()) { 
        __WL_bean.id = null;
      }
    }
    else {
      __WL_rs.getInt(2+__WL_offset);
    }
    if (!(__WL_bean.__WL_isLoaded[6] || __WL_bean.__WL_isModified[6])) {
      __WL_bean.info1 = (java.lang.String)__WL_rs.getString(3+__WL_offset);
      if (__WL_rs.wasNull()) { 
        __WL_bean.info1 = null;
      }
    }
    else {
      __WL_rs.getString(3+__WL_offset);
    }
    if (!(__WL_bean.__WL_isLoaded[2] || __WL_bean.__WL_isModified[2])) {
      __WL_bean.odate = (java.sql.Timestamp)__WL_rs.getTimestamp(4+__WL_offset);
      if (__WL_rs.wasNull()) { 
        __WL_bean.odate = null;
      }
    }
    else {
      __WL_rs.getTimestamp(4+__WL_offset);
    }
    if (!(__WL_bean.__WL_isLoaded[3] || __WL_bean.__WL_isModified[3])) {
      __WL_bean.operation = (java.lang.String)__WL_rs.getString(5+__WL_offset);
      if (__WL_rs.wasNull()) { 
        __WL_bean.operation = null;
      }
    }
    else {
      __WL_rs.getString(5+__WL_offset);
    }
    if (!(__WL_bean.__WL_isLoaded[1] || __WL_bean.__WL_isModified[1])) {
      __WL_bean.purview = (java.lang.String)__WL_rs.getString(6+__WL_offset);
      if (__WL_rs.wasNull()) { 
        __WL_bean.purview = null;
      }
    }
    else {
      __WL_rs.getString(6+__WL_offset);
    }
    if (!(__WL_bean.__WL_isLoaded[4] || __WL_bean.__WL_isModified[4])) {
      __WL_bean.sdate = (java.sql.Timestamp)__WL_rs.getTimestamp(7+__WL_offset);
      if (__WL_rs.wasNull()) { 
        __WL_bean.sdate = null;
      }
    }
    else {
      __WL_rs.getTimestamp(7+__WL_offset);
    }
    if (!(__WL_bean.__WL_isLoaded[5] || __WL_bean.__WL_isModified[5])) {
      __WL_bean.tokensn = (java.lang.String)__WL_rs.getString(8+__WL_offset);
      if (__WL_rs.wasNull()) { 
        __WL_bean.tokensn = null;
      }
    }
    else {
      __WL_rs.getString(8+__WL_offset);
    }
    __WL_bean.__WL_isLoaded[7] = true;
    __WL_bean.__WL_isLoaded[6] = true;
    __WL_bean.__WL_isLoaded[2] = true;
    __WL_bean.__WL_isLoaded[3] = true;
    __WL_bean.__WL_isLoaded[1] = true;
    __WL_bean.__WL_isLoaded[4] = true;
    __WL_bean.__WL_isLoaded[5] = true;
    __WL_bean.__WL_isLoaded[0] = true;


    return __WL_bean;
  }

  
  
  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
  {
    int __WL_offset = __WL_offsetIntObj.intValue();