public Map<String, List> fetchBibHolding(boolean cursor) throws SQLException {
    String holdingId = "";
    String tempHoldingId = "";
    List bibIds = new ArrayList();
    Map<String, List> map = null;

    if (cursor) {
      while (bibHoldingsResultSet.next()) {
        holdingId = "who-" + bibHoldingsResultSet.getString("HOLDINGS_ID");
        if (StringUtils.isNotEmpty(tempHoldingId) && !tempHoldingId.equals(holdingId)) {

          if (bibIds.size() > 0) {
            map = new HashMap<>();
            bibIds.remove(0);
            map.put(tempHoldingId, bibIds);
            return map;
          }
        }

        bibIds.add("wbm-" + bibHoldingsResultSet.getString("BIB_ID"));
        tempHoldingId = holdingId;
      }

    } else {
      while (bibHoldingsResultSet.next()) {
        holdingId = "who-" + bibHoldingsResultSet.getString("HOLDINGS_ID");
        if (StringUtils.isNotEmpty(tempHoldingId) && !tempHoldingId.equals(holdingId)) {

          map = new HashMap<>();
          map.put(tempHoldingId, bibIds);
          return map;
        }
        bibIds.add("wbm-" + bibHoldingsResultSet.getString("BIB_ID"));
        tempHoldingId = holdingId;
      }
    }

    if (bibIds.size() > 0) {
      map = new HashMap<>();
      bibIds.remove(0);
      map.put(tempHoldingId, bibIds);
      return map;
    } else {
      map = null;
    }
    bibHoldingsResultSet.close();
    return map;
  }
Exemplo n.º 2
0
  /** Returns a connection to the database */
  public synchronized Connection get() throws DataException {
    // ensure we haven't used too many connections
    if (usedConnections.size() >= MAX_CONNECTIONS) {
      throw new DataException(
          "The database connection pool is out of connections -- a maximum number of "
              + MAX_CONNECTIONS);
    } // if

    try {
      // do we have enough connections to assign one out?
      if (freeConnections.size() == 0) {
        freeConnections.add(createConnection());
      }

      // return the first free connection
      Connection conn = freeConnections.remove(0);
      usedConnections.add(conn);
      // Logger.global.info("Gave out a connection from the pool.  Free size is now: " +
      // freeConnections.size() + "/" + (freeConnections.size() + usedConnections.size()));
      return conn;
    } catch (Exception e) {
      throw new DataException(
          "An error occurred while retrieving a database connection from the pool", e);
    }
  } // get
  /**
   * @param arg0
   * @roseuid 3F4E5F40012D
   */
  public void connectionErrorOccurred(ConnectionEvent event) {
    logger.debug("Connection Error " + event.getSQLException().getMessage());

    synchronized (connectionPool) {
      if (connectionPool.size() <= connectionPoolSize) {
        connectionPool.remove(event.getSource());
        if (!SHUTTING_DOWN) {
          try {
            installConnection();
          } catch (EmanagerDatabaseException e) {
            // noop.  can't throw an exception here, so we'll ignore.
            // It will surface later.
          }
        }
      }
    }
  }
Exemplo n.º 4
0
  /** Releases a connection that was previously in use */
  public synchronized void release(Connection conn) throws DataException {
    try {
      // be sure that this connection was committed (so it is at a fresh, new transaction)
      conn.commit();

      // first remove the connection from the used list
      usedConnections.remove(conn);

      // next add it back to the free connection list
      freeConnections.add(conn);
      // Logger.global.info("Released a connection back to the pool.  Free size is now: " +
      // freeConnections.size() + "/" + (freeConnections.size() + usedConnections.size()));
    } catch (Exception e) {
      throw new DataException(
          "An error occurred while releasing a database connection back to the pool", e);
    }
  } // release
  public List<ReportParameter> getAvailableParameters(Report report) throws ProviderException {
    List<ReportParameter> parameters = getReportParameters();

    Iterator<ReportParameter> iterator = parameters.iterator();
    while (iterator.hasNext()) {
      ReportParameter rp = iterator.next();

      Iterator<ReportParameterMap> reportIterator = report.getParameters().iterator();
      while (reportIterator.hasNext()) {
        ReportParameterMap rpMap = reportIterator.next();

        if (rp.getId().equals(rpMap.getReportParameter().getId())) {
          parameters.remove(rp);
          iterator = parameters.iterator();
        }
      }
    }

    return parameters;
  }
  /**
   * @return Connection
   * @roseuid 3F3A5FFD0338
   */
  public Connection getConnection() throws EmanagerDatabaseException {
    long connectionId;
    Connection connection;
    PooledConnection pooledConnection;

    connection = null;
    pooledConnection = null;
    connectionId = InvalidConnectionId;

    try {
      synchronized (connectionPool) {
        if (!connectionPool.isEmpty()) {
          try {
            boolean connectionClosed;

            connectionClosed = false;

            pooledConnection = (PooledConnection) connectionPool.remove(0);
            connection = pooledConnection.getConnection();
            connection.clearWarnings();
            connectionId = getConnectionID(connection);
            connectionClosed = connection.isClosed();
            if (connectionId == InvalidConnectionId || connectionClosed == true) {
              logger.debug("Pooled connection closed.");
              connection = null;
            }
          } catch (SQLException sqe) {
            logger.debug("Pooled connection closed.");
            connection = null;
          }
        }
      }

      if (connection == null) {
        logger.debug("Getting a new connection.");
        pooledConnection = poolDataSource.getPooledConnection();
        pooledConnection.addConnectionEventListener(this);
        connection = pooledConnection.getConnection();
        connection.clearWarnings();
        connectionId = getConnectionID(connection);
      }
    } catch (SQLException sqe) {
      String logString;
      EmanagerDatabaseException ede;

      logString =
          EmanagerDatabaseStatusCode.UnableToGetPooledConnection.getStatusCodeDescription()
              + sqe.getMessage();

      logger.error(logString);
      ede =
          new EmanagerDatabaseException(
              EmanagerDatabaseStatusCode.UnableToGetPooledConnection, logString);
      throw ede;
    }

    if (connectionId == InvalidConnectionId) {
      EmanagerDatabaseException ede;
      ede =
          new EmanagerDatabaseException(
              EmanagerDatabaseStatusCode.UnableToGetPooledConnection,
              EmanagerDatabaseStatusCode.UnableToGetPooledConnection.getStatusCodeDescription());
      throw ede;
    }

    logger.debug(
        "\n*****************************"
            + "\nPooled Connection Init"
            + "\nCon ID:"
            + connectionId
            + "\nCon Object:"
            + pooledConnection
            + "\nPool Object:"
            + connection
            + "\n*****************************");

    return connection;
  }
Exemplo n.º 7
0
  /**
   * 生产checkbox html代码
   *
   * @param chkName checkbox 名字
   * @param checkedValues 以,分隔
   * @param lineValues 一行显示多少个checkbox 0所有
   * @return
   */
  public static String getCheckHtml(
      String company_id, String chkName, List<String> lsChkValues, int lineValues) {
    int showValues = 0; // 已经显示checkbox 数量 断行后 重新计数
    int width = 110;
    String item_id = null;
    String item_name = null;
    StringBuffer buf = new StringBuffer(64);

    buf.append(
        "<table cellspacing='1' cellpadding='2' border='0' class='TblClass' style='width:100%'>\r\n");
    for (Item topItem : Item.getTopItems()) {
      showValues = 0;
      width = 110;
      if (topItem.getItem_state() == 0) continue;

      if (topItem.getItem_id().equals("3")) {
        // continue;
      }

      if (topItem.getItem_id().equals("4") && !company_id.equals("xt_qd")) continue;

      if (topItem.getItem_id().equals("5") && !company_id.equals("xt_kpl")) continue;

      if (topItem.getItem_id().equals("6") && !company_id.equals("xt_sz")) continue;

      if (topItem.getItem_code().equals("PERSONAL")) {
        if (company_id.equals("xiaen")) {
          topItem = Item.getItemByCode("PERSONAL.JF");
        } else {
          topItem = Item.getItemByCode("PERSONAL.CGKS");
        }
      }
      if (topItem.getItem_code().equals("PERSONAL.JF")
          || topItem.getItem_code().equals("PERSONAL.CGKS")
          || topItem.getItem_code().equals("PERSONAL")) {
        int rowIndex = 1;
        buf.append(
            "<tr height='25px'><td align=\"right\" class=\"DetailBar\" width=80 rowspan="
                + topItem.getChildren().size()
                + ">"
                + topItem.getItem_name()
                + "</td>\r\n");
        for (Item item1 : topItem.getChildren()) {
          if (item1.getItem_state() == 0) continue;

          if (rowIndex == 1) {
            buf.append("<td align='right' class='DetailBar'>" + item1.getItem_name() + "</td>\r\n");
          } else {
            buf.append(
                "<tr><td align='right' class='DetailBar'>" + item1.getItem_name() + "</td>\r\n");
          }

          java.util.List<Item> lsItem = item1.getChildren();
          buf.append("<td class='DetailBar' style='width:560px'>");

          for (Item item : lsItem) {
            boolean bChecked = false;
            if (item.getItem_state() == 0) continue;

            item_id = item.getItem_id();
            item_name = item.getItem_name();
            for (int idx = 0; lsChkValues != null && idx < lsChkValues.size(); idx++) {
              String val = lsChkValues.get(idx);
              if (val.equals(item_id)) {
                bChecked = true;
                lsChkValues.remove(idx);
                break;
              }
            }
            buf.append(
                "  <span style=\"width:"
                    + width
                    + "px\"><input type='checkbox' name='"
                    + chkName
                    + "' showName='"
                    + item_name
                    + "' value='"
                    + item_id
                    + "'");
            if (bChecked) buf.append(" checked");
            buf.append(">" + item_name + "</input></span>");
            showValues++;
            if (lineValues > 0 && showValues == lineValues) {
              buf.append("<br>");
              showValues = 0;
            }
          }
          buf.append("</td></tr>\r\n");
          rowIndex++;
        }

      } else {
        boolean has_child = false;
        java.util.List<Item> lsItem = topItem.getChildren();
        for (Item item : lsItem) {
          if (!topItem.getItem_id().equals("3")) {
            has_child = true;
            break;
          }
          if (JUtil.convertNull(item.getCompany_id()).length() > 0
              && item.getCompany_id().equals(company_id)) {
            has_child = true;
            break;
          }
        }

        if (has_child) {
          buf.append(
              "<tr><td align=\"right\" class=\"DetailBar\" width=80>"
                  + topItem.getItem_name()
                  + "</td>\r\n");
          buf.append("<td class=\"DetailBar\" colspan=2>");
          for (Item item : lsItem) {
            boolean bChecked = false;
            item_id = item.getItem_id();
            item_name = item.getItem_name();

            if (JUtil.convertNull(item.getCompany_id()).length() > 0
                && !item.getCompany_id().equals(company_id)) continue;
            for (int idx = 0; lsChkValues != null && idx < lsChkValues.size(); idx++) {
              String val = lsChkValues.get(idx);
              if (val.equals(item_id)) {
                bChecked = true;
                lsChkValues.remove(idx);
                break;
              }
            }
            buf.append(
                "  <span style=\"width:"
                    + width
                    + "px\"><input type='checkbox' name='"
                    + chkName
                    + "' value='"
                    + item_id
                    + "'");
            if (bChecked) buf.append(" checked");
            buf.append(">" + item_name + "</input></span>");
            showValues++;
            if (lineValues > 0 && showValues == lineValues) {
              buf.append("<br>");
              showValues = 0;
            }
          }
          buf.append("</td></tr>\r\n");
        }
      }
    }
    buf.append("</table>");
    /*
    for(int i=0; ls!=null&&i< ls.size(); i++)
    {
    	String szCourse = ls.get(i);
    	if( szCourse.length() ==0) continue;

    	buf.append("  <input type='checkbox' name='" + chkName + "' value='" + szCourse+ "'" );
    	buf.append(" checked>" + szCourse + "</input>");

    	showValues ++;
    	if( lineValues >0 && showValues  == lineValues){buf.append("<br>"); showValues =0;}
    }*/

    return buf.toString();
  }