Exemple #1
0
  public String QuerySQL(String xmlStr) {
    String outstr = "";
    Document doc;
    Element rootNode;
    String intStr = Basic.decode(xmlStr);

    try {
      Reader reader = new StringReader(intStr);
      SAXBuilder ss = new SAXBuilder();
      doc = ss.build(reader);

      rootNode = doc.getRootElement();

      String SqlStr = "select " + rootNode.getAttributeValue("fieldStr");
      SqlStr = SqlStr + "  from  " + rootNode.getAttributeValue("tableStr");
      SqlStr = SqlStr + "  where (1=1) " + rootNode.getAttributeValue("whereStr");

      DBTable datatable = new DBTable();

      RecordSet rs = datatable.queryData(SqlStr);
      String[] fieldArr = rootNode.getAttributeValue("fieldStr").split(",");

      outstr = "<queryDataS success=\"true\">";
      while (rs.next()) {
        outstr = outstr + "<queryData";
        for (int i = 0; i < fieldArr.length; i++) {
          outstr =
              outstr + "  " + fieldArr[i].trim() + "=\"" + rs.getString(fieldArr[i].trim()) + "\"";
        }
        outstr = outstr + "/>";
      }
      outstr = outstr + "</queryDataS>";

    } catch (JDOMException ex) {
      outstr = "<queryDataS success=false>";
      outstr = outstr + ex.getMessage() + "</queryDataS>";
    }
    return Basic.encode(outstr);
  }
  @Override
  public void writeScores(RecordSet rs, ScoreFunction sf) {

    Variable[] variables = rs.getVariableArray();

    if (variables.length > 31)
      throw new UnsupportedOperationException(
          "Current implementation does not support more than 31 variables.");

    final long[] bitmasks = new long[variables.length];
    final long all = (1L << bitmasks.length) - 1;
    for (int i = 0; i < bitmasks.length; i++) bitmasks[i] = 1L << i;
    final int nscores = (int) (all + 1) / 2;

    LOG.debug("All-parent bitmask: " + Long.toBinaryString(all));

    // Initialize the output stream
    try {
      try (DataOutputStream stream =
          new DataOutputStream(new BufferedOutputStream(new FileOutputStream(outFile)))) {

        LOG.debug("Output file opened.");

        // Write the header
        writeHeader(stream, variables.length - 1, rs.size(), variables.length);

        LOG.debug("Header written.");

        // Iterate over all variables
        for (int i = 0; i < variables.length; i++) {

          LOG.info(
              "Writing scores for variable \""
                  + variables[i].getName()
                  + "\" ("
                  + i
                  + " out of "
                  + variables.length
                  + ").");
          LOG.debug("Variable bitmask: " + Long.toBinaryString(bitmasks[i]));

          // Write header for variable
          writeVariable(stream, variables[i], nscores);

          LOG.debug("Variable header weritten. Writing " + nscores + " scores...");

          // Iterate over all subsets
          for (long bits = all; bits >= 0; bits--)
            // If set doesn't contain current variable (i)
            if ((bits & bitmasks[i]) == 0) {

              // Make set
              Set<Variable> set = new HashSet<>();
              for (int j = 0; j < variables.length; j++)
                // If set contains variable j
                if ((bits & bitmasks[j]) != 0) set.add(variables[j]);

              // Compute score
              LOG.trace("Computing score...");
              double score = sf.score(variables[i], set, rs);

              // Write score
              writeScore(stream, bits, score);
            }

          LOG.debug("Scores written.");
        }
      }
    } catch (FileNotFoundException e) {
      LOG.fatal(e.getMessage());
      LOG.trace(e, e);
    } catch (IOException e) {
      LOG.fatal(e.getMessage());
      LOG.trace(e, e);
    }
  }