Metacat

/**

 *    Purpose: A Class that implements org.xml.sax.DTDHandler interface

 *             for resolving external entities

 *  Copyright: 2000 Regents of the University of California and the

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Jivka Bojilova

 *     '$Date$'

 * '$Revision$'

 * This program is free software; you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation; either version 2 of the License, or

 * (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

import org.xml.sax.*;

import java.sql.*;

import java.net.URL;

import java.net.MalformedURLException;

import java.util.Stack;

import java.util.EmptyStackException;

/**

 * parser to call when processing the XML stream and intercepting notations

 * and unparsed entities

public class DBDTDHandler implements DTDHandler

{

   /** Construct an instance of the DBDTDHandler clas

    *

    * @param conn the JDBC connection to which information is written

    */

   /** Notation declarations are not signaled */

   public void notationDecl(String name, String publicId, String systemId)

            throws SAXException

   {

    System.out.println("from DBDTDHandler.notationDecl");

    System.out.print(publicId);

    System.out.print(systemId);

   }

    * startElement event

    */

   public void unparsedEntityDecl(String name, String publicId,

                                  String systemId, String notationName)

   {

    System.out.println("from DBDTDHandler.unparsedEntityDecl");

    System.out.print(name);

    System.out.print(publicId);

    System.out.print(systemId);

    System.out.println(notationName);

    //    registerEntityPublicID(conn, doctype, publicId, systemId);

   }

    * Look at db XML Catalog to get System ID (if any) for that Public ID

    * and doctype.

    * Return empty string if there are not

    */

/*

 * server url on the front of the system ID.

 *

                                     String publicId)

        String system_id = "";

        Statement stmt;

        try {

          stmt = conn.createStatement();

                        doctype + "' AND public_id = '" + publicId + "'");

            ResultSet rs = stmt.getResultSet();

            try {

              boolean tableHasRows = rs.next();

              if (tableHasRows) {

                try {

                  system_id = rs.getString(1);

                } catch (SQLException e) {

                         "- Error with getString: " + e.getMessage());

              }

            } catch (SQLException e) {

                         "- Error with next: " + e.getMessage());

          } catch (SQLException e) {

                         "- Error with getrset: " + e.getMessage());

          stmt.close();

        } catch (SQLException e) {

                         "- Error getting id: " + e.getMessage());

        // return the selected System ID

        return system_id;

   }

   /**

    * Register Public ID in db XML Catalog

    */

/*

   private void registerEntityPublicID (Connection conn, String doctype,

                                        String publicId, String systemId)

        try {

          PreparedStatement pstmt;

          pstmt = conn.prepareStatement(

                "entry_type, source_doctype, public_id, system_id) " +

          // Bind the values to the query

          pstmt.setString(1, doctype);

          pstmt.setString(2, publicId);

          pstmt.setString(3, systemId);

          // Do the insertion

          pstmt.execute();

          pstmt.close();

        } catch (SQLException e) {

          System.out.println(e.getMessage());

        }

   }