Metacat

import java.sql.PreparedStatement;

import java.sql.ResultSet;

      String qformat = ((String[])params.get("qformat"))[0]; 

      if (qformat.equals("xml")) {

        // set content type and other response header fields first

        response.setContentType("text/xml");

        out.println(doc);

      } else if (qformat.equals("html")) {

        // set content type and other response header fields first

        response.setContentType("text/html");

        //out.println("Converting to HTML...");

        XMLDocumentFragment htmldoc = null;

        // Look up the System ID of the XSL sheet

        PreparedStatement pstmt;

        String xsl_system_id = null;

        try {

          pstmt =

            conn.prepareStatement("SELECT system_id " +

                    "FROM xml_catalog_entities " +

                    "WHERE source_doctype LIKE ? " +

                    "AND target_doctype LIKE ?");

          // Bind the values to the query

          pstmt.setString(1, "-//NCEAS//eml-dataset//EN");

          pstmt.setString(2, "-//W3C//HTML//EN");

          pstmt.execute();

          try {

            ResultSet rs = pstmt.getResultSet();

            try {

              boolean tableHasRows = rs.next();

              if (tableHasRows) {

                try {

                  xsl_system_id = rs.getString(1);

                } catch (SQLException e) {

                  System.out.println("Error with getString: " + e.getMessage());

                }

              }

            } catch (SQLException e) {

              System.out.println("Error with next: " + e.getMessage());

            }

          } catch (SQLException e) {

            System.out.println("Error with getrset: " + e.getMessage());

          }

          pstmt.close();

        } catch (SQLException e) {

          System.out.println("Error getting id: " + e.getMessage());

        }

        // Try to apply the style

        try {

          XSLStylesheet style = new XSLStylesheet(new URL(xsl_system_id), null);

          htmldoc = (new XSLProcessor()).processXSL(style, 

                     (Reader)(new StringReader(doc)),null);

          htmldoc.print(out);

        } catch (Exception e) {

          out.println("Error transforming document:\n" + e.getMessage());

        }

      }