bookbean_1sxrd__weblogic_cmp_rdbms.java

Java项目案例导航源代码

      "result set: '" + __WL_rs + "'" + EOL +
      sqle.toString() + EOL +
      RDBMSUtils.throwable2StackTrace(sqle));
    } catch (java.lang.Exception e) {
      throw new javax.ejb.FinderException(
      "Exception executing finder 'findExpensiveBooks': " + EOL +
      e.toString() + EOL +
      RDBMSUtils.throwable2StackTrace(e));
    } finally {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }
    
  }
  
  public java.util.Collection ejbFindCheapBooks(double param0) throws javax.ejb.FinderException
  {
    if(__WL_verbose) {
      Debug.say("called findCheapBooks");
    }
    
    java.sql.Connection __WL_con = null;
    java.sql.PreparedStatement __WL_stmt = null;
    java.sql.ResultSet __WL_rs = null;
    
    
    
    int selectForUpdateVal = __WL_pm.getSelectForUpdateValue();
    
    java.lang.String __WL_query = null;
    switch(selectForUpdateVal) {
      case DDConstants.SELECT_FOR_UPDATE_DISABLED:
      __WL_query = "SELECT WL0.BOOKID, WL0.BASEPRICE, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE ( (WL0.BASEPRICE < ?) ) ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE:
      __WL_query = "SELECT WL0.BOOKID, WL0.BASEPRICE, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE ( (WL0.BASEPRICE < ?) )  FOR UPDATE ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
      __WL_query = "SELECT WL0.BOOKID, WL0.BASEPRICE, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE ( (WL0.BASEPRICE < ?) )  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.
      
      __WL_stmt.setDouble(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 findCheapBooks while preparing or executing " +
      "statement: '" + __WL_stmt + "'" + EOL +
      e.toString() + EOL +
      RDBMSUtils.throwable2StackTrace(e));
    }
    
    try {
      java.util.Collection __WL_collection = new java.util.ArrayList();
      test.bookBean_1sxrd__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);
        if (__WL_pk != null) { 
          RSInfo __WL_rsInfo = new RSInfoImpl(__WL_rs, 0, 0);
          __WL_bean = (test.bookBean_1sxrd__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);
          __WL_pkMap.put(__WL_pk, __WL_bean);
        }
        
        
      }
      return __WL_collection;
      
    } catch (java.sql.SQLException sqle) {
      throw new javax.ejb.FinderException(
      "Exception in 'findCheapBooks' 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 'findCheapBooks': " + EOL +
      e.toString() + EOL +
      RDBMSUtils.throwable2StackTrace(e));
    } finally {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }
    
  }
  
  public java.util.Collection ejbFindAllBooks() throws javax.ejb.FinderException
  {
    if(__WL_verbose) {
      Debug.say("called findAllBooks");
    }
    
    java.sql.Connection __WL_con = null;
    java.sql.PreparedStatement __WL_stmt = null;
    java.sql.ResultSet __WL_rs = null;
    
    
    
    int selectForUpdateVal = __WL_pm.getSelectForUpdateValue();
    
    java.lang.String __WL_query = null;
    switch(selectForUpdateVal) {
      case DDConstants.SELECT_FOR_UPDATE_DISABLED:
      __WL_query = "SELECT WL0.BOOKID, WL0.BASEPRICE, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE ( WL0.BOOKID IS NOT NULL ) ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE:
      __WL_query = "SELECT WL0.BOOKID, WL0.BASEPRICE, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE ( WL0.BOOKID IS NOT NULL )  FOR UPDATE ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
      __WL_query = "SELECT WL0.BOOKID, WL0.BASEPRICE, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE ( WL0.BOOKID IS NOT NULL )  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.
      
      
      
      __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 findAllBooks while preparing or executing " +
      "statement: '" + __WL_stmt + "'" + EOL +
      e.toString() + EOL +
      RDBMSUtils.throwable2StackTrace(e));
    }
    
    try {
      java.util.Collection __WL_collection = new java.util.ArrayList();
      test.bookBean_1sxrd__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);
        if (__WL_pk != null) { 
          RSInfo __WL_rsInfo = new RSInfoImpl(__WL_rs, 0, 0);
          __WL_bean = (test.bookBean_1sxrd__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);
          __WL_pkMap.put(__WL_pk, __WL_bean);
        }
        
        
      }
      return __WL_collection;
      
    } catch (java.sql.SQLException sqle) {
      throw new javax.ejb.FinderException(
      "Exception in 'findAllBooks' 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 'findAllBooks': " + EOL +
      e.toString() + EOL +
      RDBMSUtils.throwable2StackTrace(e));
    } finally {
      __WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
    }
    
  }
  
  public java.lang.Object 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;
    test.bookBean_1sxrd__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.BOOKID, WL0.BASEPRICE, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE ( (WL0.BOOKID = ?) ) ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE:
      __WL_query = "SELECT WL0.BOOKID, WL0.BASEPRICE, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE ( (WL0.BOOKID = ?) )  FOR UPDATE ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
      __WL_query = "SELECT WL0.BOOKID, WL0.BASEPRICE, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE ( (WL0.BOOKID = ?) )  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();
      
      
      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);
        if (__WL_pk != null) { 
          __WL_bean = (test.bookBean_1sxrd__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromPool();
          __WL_bean.__WL_initialize();
          __WL_bean = __WL_loadGroup0FromRS(__WL_rs, __WL_offsetIntObj, __WL_bean);
          
          __WL_eo = __WL_pm.finderCacheInsert(__WL_bean, __WL_getIsLocal());
          if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean);
          __WL_pkMap.put(__WL_pk, __WL_bean);
        }
        
        
      }
      
      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_pkMap.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_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 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.BASEPRICE, WL0.BOOKID, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE WL0.BOOKID = ? ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE:
      __WL_query = "SELECT WL0.BASEPRICE, WL0.BOOKID, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE WL0.BOOKID = ?  FOR UPDATE ";
      break;
      
      case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
      __WL_query = "SELECT WL0.BASEPRICE, WL0.BOOKID, WL0.DESCRIPTION, WL0.NAME  FROM BOOKS WL0  WHERE WL0.BOOKID = ?  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, "bookid")) {
        __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();