Examples of QueryResultSet


Examples of com.lingbobu.flashdb.common.QueryResultSet

 
  Object execute(String sql, Object[] params, int maxRows) {
    Object ret = flashDatabase.execute(sql, params, maxRows);
   
    if ((ret != null) && (ret instanceof QueryResultSet)) {
      QueryResultSet qrs = (QueryResultSet) ret;
      ResultSetNextPart rsContinue = null;
      if ((maxRows < 0) && qrs.isResultHasContinueData()) {
        rsContinue = new ResultSetNextPart(flashDatabase, sql, params, -maxRows);
      }
      return new JdbcResultSet((QueryResultSet)ret, rsContinue);
    }
    return ret;
View Full Code Here

Examples of com.lingbobu.flashdb.common.QueryResultSet

    flashDatabase.executeCommand(sql);
  }
 
  ResultSet executeQuery(String sql, Object[] params, int maxRows) throws SQLException {
    if (maxRows == 0) {
      QueryResultSet qrs = flashDatabase.executeQuery(sql, params);
      return new JdbcResultSet(qrs);
    }
    return (ResultSet) execute(sql, params, maxRows);
  }
View Full Code Here

Examples of com.lingbobu.flashdb.common.QueryResultSet

   
    this.joinFieldRelate = relateColumn.getName();
    this.isPrimaryKeyR = (isFirstColumnIsUnique && (relateColumn == this.columns[0]));
   
    if (loadData) {
      QueryResultSet qrsData = flashDatabase.executeQuery(dataSql, new Object[0]);
      this.key2rows = readKey2rows(qrsData, joinFieldRelate, isPrimaryKeyR);
    }
    else this.key2rows = null;
  }
View Full Code Here

Examples of com.lingbobu.flashdb.common.QueryResultSet

    this.columns = base.columns;
    this.isPrimaryKeyR = base.isPrimaryKeyR;
    this.fieldMainIsArray = base.fieldMainIsArray;

    String dataSql = base.dataSqlIsComplex ? base.dataSql : (base.dataSql + " where "+ joinFieldRelate + " in ?");
    QueryResultSet qrs = flashDatabase.executeQuery(dataSql, new Object[]{partJoinKeys});
    this.key2rows = readKey2rows(qrs, joinFieldRelate, isPrimaryKeyR);
  }
View Full Code Here

Examples of com.lingbobu.flashdb.common.QueryResultSet

  }

  private FlashDatabase flashDatabase;
 
  public Object queryForObject(String sql) {
    QueryResultSet qrs = flashDatabase.executeQuery(sql, new Object[0]);
    if (qrs.getColumnCount() != 1)
      throw new RuntimeException("Result of queryForObject(...) must be only one column.");
    if (qrs.getRowCount() > 1)
      throw new RuntimeException("Result of queryForObject(...) must be only one row.");
    if (qrs.getRowCount() == 0)
      return null;
    else
      return qrs.fastGetValue(0, 0);
  }
View Full Code Here

Examples of com.lingbobu.flashdb.common.QueryResultSet

    else
      return qrs.fastGetValue(0, 0);
  }
 
  public Set<Object> queryForSet(String sql) {
    QueryResultSet qrs = flashDatabase.executeQuery(sql, new Object[0]);
    if (qrs.getColumnCount() != 1)
      throw new RuntimeException("Result of queryForSet(...) must be only one column.");
    Set<Object> result = new HashSet<Object>();
    for (int i=0; i < qrs.getRowCount(); i++) {
      Object value = qrs.fastGetValue(i, 0);
      if (value == null) continue;
      result.add(value);
    }
    return result;
  }
View Full Code Here

Examples of com.lingbobu.flashdb.common.QueryResultSet

    Object[] keyValues;
    if (mainIsTableName) {
      String mainSql = "select "+mainKeyColumnInfo.getName()+" from "+mainTableOrSql;
      if ((condition != null) && (! condition.isEmpty()))
        mainSql += " where " + condition;
      QueryResultSet qrs = flashDatabase.executeQuery(mainSql, conditionParams != null ? conditionParams : new Object[0]);
      keyValues = new Object[qrs.getRowCount()];
      for (int i=0; i < keyValues.length; i++) {
        keyValues[i] = qrs.getValue(i, 0);
      }
      Arrays.sort(keyValues);
    }
    else {
      QueryResultSet qrs = flashDatabase.executeQuery(mainTableOrSql, conditionParams != null ? conditionParams : new Object[0]);
      keyValues = new Object[qrs.getRowCount()];
      for (int i=0; i < keyValues.length; i++) {
        keyValues[i] = qrs.getRow(i);
      }
    }
   
    // 根据主键分段
    int partCount = (keyValues.length + partSize - 1) / partSize;
View Full Code Here

Examples of org.dbwiki.data.query.QueryResultSet

            ySize = query.substring(comma+1, closeParen);
            query = query.substring(colon+1);
          } else {
            query = query.substring(1);
          }
          QueryResultSet rs = database.query(query);
          body.openPARAGRAPH(CSS.CSSPageText);
          drawChart(ChartType.Column, xSize, ySize, rs, body);
        } else if(query.toLowerCase().startsWith("pie:") || query.toLowerCase().startsWith("pie(")) {
          // FIXME: should parse the arguments to charts in a more
          // sensible scalable way.
          query = query.substring("pie".length());
          String xSize = "800";
          String ySize = "600";
          if(query.startsWith("(")) {
            int comma = query.indexOf(",");
            int closeParen = query.indexOf(")", comma);
            int colon = query.indexOf(":", closeParen);

            if(comma == -1 || closeParen == -1 || colon != closeParen+1)
              throw new WikiQueryException(WikiQueryException.UnknownQueryFormat, _queryString);

            xSize = query.substring(1, comma);
            ySize = query.substring(comma+1, closeParen);
            query = query.substring(colon+1);
          } else {
            query = query.substring(1);
          }
          QueryResultSet rs = database.query(query);
          body.openPARAGRAPH(CSS.CSSPageText);
          drawChart(ChartType.Pie, xSize, ySize, rs, body);
        } else if(query.toLowerCase().startsWith("map:")) {
          query = query.substring("map:".length());
          QueryResultSet rs = database.query(query);
          body.openPARAGRAPH(CSS.CSSPageText);
          drawMap(rs, body);
        } else {
          QueryResultSet rs = database.query(query);
          if (!rs.isEmpty()) {
            body.openPARAGRAPH(CSS.CSSPageText);
            if (rs.isElement()) {
              RequestParameterVersion versionParameter = null;
              if (rs.hasTimestamp()) {
                versionParameter = new RequestParameterVersionTimestamp(rs.getTimestamp());
              } else {
                versionParameter = new RequestParameterVersionCurrent();
              }
              body.add(contentPrinter.getLinesForNodeList(new SchemaNodeList(rs),
                                    versionParameter));
            } else {
              for (int i = 0; i < rs.size(); i++) {
                contentPrinter.printTextNode((DatabaseTextNode)rs.get(i), body);
              }
            }
          }
        }
    } catch (org.dbwiki.exception.data.WikiQueryException queryException) {
View Full Code Here

Examples of org.emftrace.metamodel.QUARCModel.Query.QueryResultSet

   * <!-- end-user-doc -->
   * @generated NOT
   */
  @Override
  public String getText(Object object) {
    QueryResultSet resultSet = (QueryResultSet) object;
    GSSQuery query = (GSSQuery) resultSet.eContainer();
    boolean obsolete = false;
    if (query != null){
     
      obsolete = obsolete || query.isChanged();
     
View Full Code Here

Examples of org.terrier.matching.QueryResultSet

  /** {@inheritDoc} */
  public ResultSet getResultSet(int start, int length)
  {
    if (arraysInitialised) {
      length = length < docids.length ? length : docids.length;
      QueryResultSet resultSet = new QueryResultSet(length);
      resultSet.setExactResultSize(this.getExactResultSize());
      System.arraycopy(docids, start, resultSet.getDocids(), 0, length);
      System.arraycopy(scores, start, resultSet.getScores(), 0, length);
      System.arraycopy(occurrences, start, resultSet.getOccurrences(), 0, length);
      return resultSet;
    } else
      throw new UnsupportedOperationException("");
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.