Ejemplo n.º 1
0
  /**
   * Gets all the data connection names in the application specified by its appid
   *
   * @param lAppID
   * @return a Vector of database connection names stored in the Vector as Strings
   */
  public Vector getAllDataConnectionNames(long lAppID) {
    Vector vReturn = new Vector();
    Connection cxSys = null;
    Statement stmt = null;
    ResultSet rs = null;

    m_SysCtx.doDebug(pmaLog.DEBUGLEVEL_FULL, "getAllDataConnectionNames(appid)", this);

    try {
      String szQuery =
          "SELECT DBConnectionName FROM APPLICATION,DBCONNECTION WHERE APPLICATION.AppID="
              + lAppID
              + " AND APPLICATION.AppID=DBCONNECTION.AppID";
      cxSys = m_SysCtx.getSystemConnection();
      stmt = cxSys.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
      rs = stmt.executeQuery(szQuery);
      while (rs.next()) {
        String sConnName = rs.getString(1);
        if (sConnName != null && sConnName.length() > 0) vReturn.add(sConnName);
      }
    } catch (Exception de) {
      m_SysCtx.doError("pmaSystem.getDataConnectionError", new String[] {de.toString()}, m_SessCtx);
    } finally {
      Util.closeJDBC(rs);
      Util.closeJDBC(stmt);
      m_SysCtx.releaseSystemConnection(cxSys);
    }

    return vReturn;
  }
Ejemplo n.º 2
0
  /**
   * Gets all keywords matching sKey (case insensitive).
   *
   * @param sKey the keyword name
   * @param bSortByValue Pass true to have the results put in the vector in sorted Data order.
   * @return null if no match
   */
  public Vector getAllKeywordValues(String sKey, boolean bSortByValue) {
    Vector vReturn = null;
    Connection cxSys = null;
    PreparedStatement stmt = null;
    ResultSet rs = null;
    String sAppGroup = m_rPath.Group, sAppName = m_rPath.Application;
    String sOrderClause = " ORDER BY KeywordOrder,Data";

    // m_SysCtx.doDebug(pmaLog.DEBUGLEVEL_FULL, "getAllKeywordValues()", m_SessCtx);
    if (sKey == null || sKey.length() == 0) return null;
    if (sAppName == null || sAppName.length() == 0) return null;
    boolean bHasGroup = true;
    if (sAppGroup == null || sAppGroup.length() == 0) bHasGroup = false;

    if (bSortByValue) sOrderClause = " ORDER BY Data";
    String sQuery =
        "SELECT Data FROM APPLICATION,KEYWORD,KEYWORDDATA WHERE UPPER(APPLICATION.AppName)=? AND (APPLICATION.AppGroup='' OR APPLICATION.AppGroup IS NULL) AND APPLICATION.AppID=KEYWORD.AppID AND KEYWORD.KeywordID=KEYWORDDATA.KeywordID AND UPPER(KEYWORD.Name)=?"
            + sOrderClause;
    if (bHasGroup) {
      sQuery =
          "SELECT Data FROM APPLICATION,KEYWORD,KEYWORDDATA WHERE UPPER(APPLICATION.AppName)=? AND (UPPER(APPLICATION.AppGroup)=? OR APPLICATION.AppGroup='*') AND APPLICATION.AppID=KEYWORD.AppID AND KEYWORD.KeywordID=KEYWORDDATA.KeywordID AND UPPER(KEYWORD.Name)=?"
              + sOrderClause;
    }

    try {
      // System.out.println("[" + szQuery + "]");
      cxSys = m_SysCtx.getSystemConnection();
      stmt =
          cxSys.prepareStatement(sQuery, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
      stmt.setString(1, sAppName.toUpperCase());
      if (bHasGroup) {
        stmt.setString(2, sAppGroup.toUpperCase());
        stmt.setString(3, sKey.toUpperCase());
      } else stmt.setString(2, sKey.toUpperCase());

      rs = stmt.executeQuery();
      while (rs.next()) {
        if (vReturn == null) vReturn = new Vector();
        vReturn.add(rs.getString("Data"));
      }
      rs.close();
      stmt.close();
    } catch (Exception de) {
      m_SysCtx.doError(
          "HTTPRequest.getKeywordError", new String[] {sKey, de.toString()}, m_SessCtx);
    } finally {
      Util.closeJDBC(rs);
      Util.closeJDBC(stmt);
      m_SysCtx.releaseSystemConnection(cxSys);
    }
    return vReturn;
  }
Ejemplo n.º 3
0
  /**
   * Transforms an xml document based on the xsl deign element specified.
   *
   * @param xmlData
   * @param sDesignElement
   * @return a transformed lock of XML
   */
  public StringBuilder xmlTransform(StringBuilder xmlData, String sDesignElement) {

    DesignElement de = getDesignObject(sDesignElement, DesignElement.DESIGN_TYPE_RESOURCE);

    if (de == null) {
      // get the xml columns
      String sColumns[] = TableManager.getXMLColumnNames(xmlData);
      // for(int i=0; i<sColumns.length; i++) System.out.println(sColumns[i]);
      // make a stylesheet and save it to the design collection
      // if it saved ok, then recall this method, cause we'll find the sheet next time
      if (saveXSLDesignElement(sDesignElement, sColumns))
        return xmlTransform(xmlData, sDesignElement);

      return null;
    }
    // maybe check the contenttype is xsl ??
    String sXML = null;
    try {
      sXML = new String(de.getContent(), "UTF-8");
      if (sXML != null && (sXML.indexOf("<P@") >= 0 || sXML.indexOf("<p@") >= 0)) {
        // FIXME parse out the <P@ST tags
        HTMLDocument docHTML = new HTMLDocument(this);
        docHTML.designObject = de;
        docHTML.rPath = new RequestPath(getRequestPath().getFullPath());
        docHTML.setParameters(getRequestPath().Parameters);
        docHTML.prepare();
        docHTML.renderDocument(false);
        sXML = new String(docHTML.getContent(), "UTF-8");
      }
    } catch (Exception e) {
    }
    StringBuilder xslData = new StringBuilder(sXML);
    return Util.xmlTransform(m_SysCtx, xmlData, xslData);
  }
Ejemplo n.º 4
0
  /**
   * Gets the first keyword matching szKey (case insensitive). Note that if there are multiple
   * keywords, there is no guarantee which will be returned.
   *
   * @param sKey
   * @return null if no match
   */
  public String getKeywordValue(String sKey) {
    Connection cxSys = null;
    PreparedStatement stmt = null;
    ResultSet rs = null;
    String sReturn = null;
    String sAppGroup = m_rPath.Group, sAppName = m_rPath.Application;

    m_SysCtx.doDebug(pmaLog.DEBUGLEVEL_FULL, "getKeywordValue()", m_SessCtx);
    if (sAppName == null || sAppName.length() == 0) return null;

    boolean bHasGroup = true;
    if (sAppGroup == null || sAppGroup.length() == 0) bHasGroup = false;

    String sQuery =
        "SELECT Data FROM APPLICATION,KEYWORD,KEYWORDDATA WHERE UPPER(APPLICATION.AppName)=? AND (APPLICATION.AppGroup='' OR APPLICATION.AppGroup IS NULL) AND APPLICATION.AppID=KEYWORD.AppID AND KEYWORD.KeywordID=KEYWORDDATA.KeywordID AND UPPER(KEYWORD.Name)=?";
    if (bHasGroup) {
      sQuery =
          "SELECT Data FROM APPLICATION,KEYWORD,KEYWORDDATA WHERE UPPER(APPLICATION.AppName)=? AND (UPPER(APPLICATION.AppGroup)=? OR APPLICATION.AppGroup='*') AND APPLICATION.AppID=KEYWORD.AppID AND KEYWORD.KeywordID=KEYWORDDATA.KeywordID AND UPPER(KEYWORD.Name)=?";
    }

    try {
      cxSys = m_SysCtx.getSystemConnection();
      stmt =
          cxSys.prepareStatement(sQuery, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
      stmt.setString(1, sAppName.toUpperCase());
      if (bHasGroup) {
        stmt.setString(2, sAppGroup.toUpperCase());
        stmt.setString(3, sKey.toUpperCase());
      } else stmt.setString(2, sKey.toUpperCase());
      rs = stmt.executeQuery();
      if (rs.next()) {
        sReturn = rs.getString(1);
      }
    } catch (Exception de) {
      m_SysCtx.doError(
          "HTTPRequest.getKeywordError", new String[] {sKey, de.toString()}, m_SessCtx);
    } finally {
      Util.closeJDBC(rs);
      Util.closeJDBC(stmt);
      m_SysCtx.releaseSystemConnection(cxSys);
    }

    return sReturn;
  }
Ejemplo n.º 5
0
  /**
   * Runs the named action against the passed document.
   *
   * @param doc
   * @param sActionClass
   * @param iDesignElementType can be either DesignElement.DESIGN_TYPE_ACTION or
   *     DesignElement.DESIGN_TYPE_SCHEDULEDACTION
   * @return an ActionReturn object that the programmer may check to see what the action has done
   */
  public ActionReturn runActionOnDocument(
      HTMLDocument doc, String sActionClass, int iDesignElementType) {
    ActionReturn act_return = null;
    SystemContext SysCtx = null;

    if (sActionClass == null || sActionClass.length() == 0 || doc == null) return null;

    try {
      // ActionClassLoader aLoader= new ActionClassLoader(m_HTTPRM, m_SysCtx, m_SessCtx,
      // doc.rPath.Group, doc.rPath.Application, szActionClass);
      act_return = new ActionReturn();
      SysCtx = (SystemContext) m_SysCtx.clone();
      SessionContext SessCtx = (SessionContext) m_SessCtx.clone(); // ditto with the session
      RequestPath rp = new RequestPath(m_rPath.getFullPath());
      if (doc.rPath != null) rp = doc.rPath;
      HTTPSessionContext HTTPSessCtx = new HTTPSessionContext(m_HTTPRM, SysCtx, SessCtx, rp);
      SharedActionClassLoader aLoader = m_SysCtx.getActionClassLoader(rp); // , iDesignElementType);
      // Class runclass = aLoader.getActionClass();
      Class runclass = aLoader.getActionClass(sActionClass, DesignElement.DESIGN_TYPE_ACTION);
      if (runclass == null) return act_return;
      Object object = runclass.newInstance();
      ActionRunnerInterface act = (ActionRunnerInterface) object;
      act.init(HTTPSessCtx, doc, rp.Group, rp.Application);
      act_return.RedirectTo = act.execute();
      act_return.HasStreamed = act.hasStreamed();
      act_return.bBuffer = act.getByteBuffer();
      act_return.ContentType = act.getContentType();
    } catch (Throwable e) {
      String sPath = sActionClass;
      if (doc != null) sPath = doc.rPath.getFullPath() + " - " + sActionClass;
      m_SysCtx.doError(
          "HTTPRequest.ActionExecuteError", new String[] {sPath, e.toString()}, m_SessCtx);
      Util.logStackTrace(e, m_SysCtx, 99);
    }

    return act_return;
  }
Ejemplo n.º 6
0
  /**
   * Stores a new xsl resource based on the column names and design name
   *
   * @param sDesignName
   * @param sColumnNames
   * @return
   */
  private boolean saveXSLDesignElement(String sDesignName, String sColumnNames[]) {

    if (sDesignName == null
        || sDesignName.length() == 0
        || sColumnNames == null
        || sColumnNames.length == 0) {
      m_SysCtx.doError("HTTPSessionContext.NoXML", new String[] {sDesignName}, this);
      return false;
    }
    boolean bOK = true;
    Connection cx = null;
    PreparedStatement prepStmt = null;
    String sQuery;
    StringBuilder sbXSL = new StringBuilder(4096);

    sbXSL.append("<?xml version=\"1.0\"?>\r\n");
    sbXSL.append(
        "<xsl:stylesheet xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\" version=\"1.0\">\r\n\r\n");

    sbXSL.append("<xsl:output method=\"html\" indent=\"yes\"/>\r\n");

    sbXSL.append("<xsl:template match=\"/\">\r\n");
    sbXSL.append("\t<xsl:apply-templates/>\r\n");
    sbXSL.append("</xsl:template>\r\n\r\n");

    sbXSL.append("<xsl:template match=\"data\">\r\n");
    sbXSL.append("<table class=\"listTable\">\r\n");
    sbXSL.append("<thead>\r\n");
    sbXSL.append("<tr>\r\n");
    sbXSL.append("\t<th>&#160;</th>\r\n");
    // for each column, show the header
    for (int i = 0; i < sColumnNames.length; i++) {
      sbXSL.append("\t<th>");
      sbXSL.append(sColumnNames[i]);
      sbXSL.append("</th>\r\n");
    }
    sbXSL.append("</tr>\r\n");
    sbXSL.append("</thead>\r\n\r\n");

    sbXSL.append("<tbody>\r\n");
    sbXSL.append("<xsl:for-each select=\"row\">\r\n");
    sbXSL.append("<tr>\r\n");

    sbXSL.append(
        "\r\n\t<!-- Decimals: <xsl:value-of select=\"format-number(item[@name='numbercolumn']/value, '###,###.00')\" /> -->\r\n");
    sbXSL.append(
        "\t<!-- Totals: <xsl:value-of select=\"format-number(sum(/data/row/item[@name='numbercolumn']/value), '###,###.00')\" /> -->\r\n");
    sbXSL.append(
        "\t<!-- Dates: <xsl:value-of select=\"item[@name='datecolumn']/value/year\" /> (year,month,day,hour,minute,second) -->\r\n\r\n");

    // show an example of a delete column
    sbXSL.append("\t<td>\r\n");
    sbXSL.append(
        "\t\t<a><xsl:attribute name=\"href\">JavaScript:deleteRecord('<xsl:value-of select=\"item[@name='columnid']/value\"/>');</xsl:attribute>\r\n");
    sbXSL.append(
        "\t\t<img border=\"0\" alt=\"Delete this record\"><xsl:attribute name=\"src\"><xsl:value-of select=\"/data/@path\"/>/recyclebin.gif?OpenResource</xsl:attribute></img>\r\n");
    sbXSL.append("\t\t</a>\r\n");
    sbXSL.append("\t</td>\r\n");

    // for each column
    for (int i = 0; i < sColumnNames.length; i++) {
      sbXSL.append("\t<td>\r\n");
      if (i == 0)
        sbXSL.append(
            "\t\t<a><xsl:attribute name=\"href\"><xsl:value-of select=\"/data/@path\"/><xsl:text>/EditPageName?OpenPage&amp;id=</xsl:text><xsl:value-of select=\"item[@name='idcolumn']/value\"/></xsl:attribute>\r\n");
      sbXSL.append(
          "\t\t<xsl:value-of select=\"item[@name='"
              + sColumnNames[i].toLowerCase()
              + "']/value\"/>\r\n");
      if (i == 0) sbXSL.append("\t\t</a>\r\n");
      sbXSL.append("\t</td>\r\n");
    }

    sbXSL.append("</tr>\r\n");
    sbXSL.append("</xsl:for-each>\r\n");
    sbXSL.append("</tbody>\r\n\r\n");
    sbXSL.append("<!-- sum a column or count all the rows\r\n");
    sbXSL.append("<tr>\r\n");
    sbXSL.append(
        "\t<td>$<xsl:value-of select=\"format-number(sum(/data/row/item[@name='numbercolumn']/value), '###,###.00')\"/></td>\r\n");
    sbXSL.append("\t<td><xsl:value-of select=\"count(/data/row)\"/></td>\r\n");
    sbXSL.append("</tr>\r\n");
    sbXSL.append("-->\r\n\r\n");

    sbXSL.append("</table>\r\n");
    sbXSL.append("</xsl:template>\r\n");
    sbXSL.append("</xsl:stylesheet>\r\n");

    TornadoServerInstance tsi = TornadoServer.getInstance(m_SysCtx);
    try {
      cx = m_SysCtx.getSystemConnection();
      sQuery =
          "INSERT INTO DESIGNBUCKET(AppID,Name,DesignType,ContentType,Updated,UpdatedBy,Comment,Options,InheritFrom,DesignData) VALUES(?,?,?,?,?,?,?,?,?,?)";
      prepStmt = cx.prepareStatement(sQuery);
      long lAppID =
          tsi.getApplicationID(
              m_rPath.Group,
              m_rPath.Application); // HTTPServer.getAppID(m_SysCtx, m_rPath.Application,
      // m_rPath.Group);
      if (lAppID > 0) {
        prepStmt.setLong(1, lAppID);
        prepStmt.setString(2, sDesignName);
        prepStmt.setInt(3, DesignElement.DESIGN_TYPE_RESOURCE); // designtype

        // if(docDesign.getItemValue("Type").equals(String.valueOf(DesignElement.DESIGN_TYPE_PAGE)))
        // szMimeType = "text/html";
        prepStmt.setString(4, "text/xml"); // contenttype
        prepStmt.setTimestamp(5, new Timestamp((new java.util.Date()).getTime())); // updated
        prepStmt.setString(6, pmaSystem.SYSTEM_ACCOUNT); // updatedby
        prepStmt.setString(7, ""); // comment
        prepStmt.setString(8, "");
        prepStmt.setString(9, ""); // inherit

        prepStmt.setBinaryStream(
            10,
            new ByteArrayInputStream(sbXSL.toString().getBytes()),
            (int) sbXSL.length()); // designdata

        prepStmt.execute();
      } else bOK = false;

    } catch (Exception sqle) {
      m_SysCtx.doError(sqle.getMessage(), m_SessCtx);
    } finally {
      Util.closeJDBC(prepStmt);
      m_SysCtx.releaseSystemConnection(cx);
    }

    return bOK;
  }
Ejemplo n.º 7
0
 /**
  * This method calls the puakma.util.Util version, provided here for convenience
  *
  * @param xmlData
  * @param xslData
  * @return a transformed xml document as a StringBuilder
  */
 public StringBuilder xmlTransform(StringBuilder xmlData, StringBuilder xslData) {
   return Util.xmlTransform(m_SysCtx, xmlData, xslData);
 }