wbpayout_l59ak2__weblogic_cmp_rdbms.java

cs_人财务记账系统每个例子文件夹都附有数据库表、程序源文件和一个war包（或者jar包）。如果是cs结构的

    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;
    int __WL_offset = 0;
    personal_payout_manage.ejbs.WbPayout_l59ak2__WebLogic_CMP_RDBMS __WL_bean = null;
Object __WL_eo = null;
Object __WL_eo_rc = null;

    

    

    int selectForUpdateVal = __WL_pm.getSelectForUpdateValue();

    java.lang.String __WL_query = null;

    switch(selectForUpdateVal) {
      case DDConstants.SELECT_FOR_UPDATE_DISABLED:
	__WL_query = "SELECT WL0.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0 WHERE ( WL0.id = ? )";
        break;

      case DDConstants.SELECT_FOR_UPDATE:
        __WL_query = "SELECT WL0.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0 WHERE ( WL0.id = ? ) FOR UPDATE ";
        break;

      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
        __WL_query = "SELECT WL0.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0 WHERE ( WL0.id = ? ) 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.
      
if (param0 == null) {
__WL_stmt.setNull(1,java.sql.Types.INTEGER);
} else {
__WL_stmt.setLong(1, param0.longValue());
if (__WL_verbose) {
Debug.say("paramIdx :"+1+" binded with value :"+param0);
}
}

      __WL_rs = __WL_stmt.executeQuery();

      
      
Map __WL_pkMap = new HashMap();

      boolean __WL_isMulti = false;
      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 = (personal_payout_manage.ejbs.WbPayout_l59ak2__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);
    
  }

}

public java.util.Collection ejbFindByWbPerson_c79zps__WebLogic_CMP_RDBMS_wbPayout__WL_
    (java.lang.String param0
    ) throws java.lang.Exception
    {
    if(__WL_verbose) {
      Debug.say("called findByWbPerson_c79zps__WebLogic_CMP_RDBMS_wbPayout__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 WL0.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0 WHERE ( WL0.pesonal_sn = ? )";
        break;

      case DDConstants.SELECT_FOR_UPDATE:
        __WL_query = "SELECT WL0.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0 WHERE ( WL0.pesonal_sn = ? ) FOR UPDATE ";
        break;

      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
        __WL_query = "SELECT WL0.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0 WHERE ( WL0.pesonal_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.
      
if (param0 == null) {
__WL_stmt.setNull(1,java.sql.Types.VARCHAR);
} else {
__WL_stmt.setString(1, param0);
if (__WL_verbose) {
Debug.say("paramIdx :"+1+" binded with value :"+param0);
}
}


      __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 findByWbPerson_c79zps__WebLogic_CMP_RDBMS_wbPayout__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();
personal_payout_manage.ejbs.WbPayout_l59ak2__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 = (personal_payout_manage.ejbs.WbPayout_l59ak2__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 'findByWbPerson_c79zps__WebLogic_CMP_RDBMS_wbPayout__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 'findByWbPerson_c79zps__WebLogic_CMP_RDBMS_wbPayout__WL_': " + EOL +
        e.toString() + EOL +
        RDBMSUtils.throwable2StackTrace(e));
    } finally {
      
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }

}

public java.util.Collection ejbFindByWbMaterial_utl58__WebLogic_CMP_RDBMS_wbPayout__WL_
    (java.lang.String param0
    ) throws java.lang.Exception
    {
    if(__WL_verbose) {
      Debug.say("called findByWbMaterial_utl58__WebLogic_CMP_RDBMS_wbPayout__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 WL0.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0 WHERE ( WL0.material_sn = ? )";
        break;

      case DDConstants.SELECT_FOR_UPDATE:
        __WL_query = "SELECT WL0.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0 WHERE ( WL0.material_sn = ? ) FOR UPDATE ";
        break;

      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
        __WL_query = "SELECT WL0.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0 WHERE ( WL0.material_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.
      
if (param0 == null) {
__WL_stmt.setNull(1,java.sql.Types.VARCHAR);
} else {
__WL_stmt.setString(1, param0);
if (__WL_verbose) {
Debug.say("paramIdx :"+1+" binded with value :"+param0);
}
}


      __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 findByWbMaterial_utl58__WebLogic_CMP_RDBMS_wbPayout__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();
personal_payout_manage.ejbs.WbPayout_l59ak2__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 = (personal_payout_manage.ejbs.WbPayout_l59ak2__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 'findByWbMaterial_utl58__WebLogic_CMP_RDBMS_wbPayout__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 'findByWbMaterial_utl58__WebLogic_CMP_RDBMS_wbPayout__WL_': " + 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.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0  WHERE WL0.id = ? ";
        break;

      case DDConstants.SELECT_FOR_UPDATE:
        __WL_query = "SELECT WL0.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0  WHERE WL0.id = ?  FOR UPDATE ";
        break;

      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
        __WL_query = "SELECT WL0.id, WL0.material_sn, WL0.note, WL0.payout_time, WL0.pesonal_sn, WL0.spend_money  FROM Wb_Payout WL0  WHERE WL0.id = ?  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.Long __WL_pk = (java.lang.Long) __WL_ctx.getPrimaryKey();

      __WL_con = __WL_pm.getConnection();


      __WL_stmt = __WL_con.prepareStatement(__WL_query);