Metacat

/**

 *        Name: DBSAXHandler.java

 *     Purpose: A Class that handles the SAX XML events as they

 *              are generated from XML documents

 * Institution: National Center for Ecological Analysis and Synthesis

 *   Copyright: 2000

 *     Authors: Matt Jones

 *

 *     Version: '$Id$'

 */

import org.xml.sax.*;

import java.sql.*;

import java.util.Stack;

// Extensions to the SAX Interfaces for Namespace support.

import oracle.xml.parser.v2.DefaultXMLDocumentHandler;

import oracle.xml.parser.v2.NSName;

import oracle.xml.parser.v2.SAXAttrList;

import oracle.xml.parser.v2.SAXParser;

class DBSAXHandler extends DefaultXMLDocumentHandler

{

   private boolean 	debug 	= false;

   private boolean 	stackCreated = false;

   private Stack 	elementStack;

   private Connection	conn = null;

   public DBSAXHandler(Connection conn)

   {

      this.conn = conn;

      // Create the stack for keeping track of element context

      // if it doesn't already exist

      if (!stackCreated) {

        elementStack = new Stack();

        stackCreated = true;

      }

   }

   public void startElement(NSName name, SAXAttrList atts) throws SAXException

   {

      // Use the methods getQualifiedName(), getLocalName(), getNamespace()

      // and getExpandedName() in NSName interface to get Namespace

      // information.

      String qName;

      String localName;

      String nsName;

      String expName;

      qName = name.getQualifiedName();

      localName = name.getLocalName();

      nsName = name.getNamespace();

      expName = name.getExpandedName();

      long parent_id;

      try {

        parentElement = (DBSAXElement)elementStack.peek();

        parent_id = parentElement.getElementID();

      } catch (EmptyStackException e) {

        parent_id = 0;

      }

      // Add all of the attributes

      for (int i=0; i<atts.getLength(); i++)

      {

         // Use the methods getQualifiedName(), getLocalName(), getNamespace()

         // and getExpandedName() in SAXAttrList interface to get Namespace

         // information.

         qName = atts.getQualifiedName(i);

         localName = atts.getLocalName(i);

         nsName = atts.getNamespace(i);

         expName = atts.getExpandedName(i);

         // You can get the type and value of the attributes either

         // by index or by the Qualified Name.

         String type = atts.getType(qName);

         String value = atts.getValue(qName);

         currentElement.setAttribute(localName, value);

         System.out.println(" Added ATTRIBUTE Name:" + localName);

         System.out.println("                 Type:" + type);

         System.out.println("                Value:" + value);

         System.out.println();

      }

      // Add the element to the stack, so that any text data can be

      // added as it is encountered

      elementStack.push(currentElement);

   }

   public void characters(char[] cbuf, int start, int len)

   {

      DBSAXElement currentElement = (DBSAXElement)elementStack.peek();

      currentElement.appendContent(cbuf,start,len);

      System.out.println("   Characters: " + new String(cbuf,start,len));

      System.out.println("     Appended: " + currentElement.getContent());

   }

   public void ignorableWhitespace(char[] cbuf, int start, int len)

   {

      System.out.println("IgnorableWhiteSpace");

   }

   public void endElement(NSName name) throws SAXException

   {

      // Use the methods getQualifiedName(), getLocalName(), getNamespace()

      // and getExpandedName() in NSName interface to get Namespace

      // information.

      String expName = name.getExpandedName();

      // Write the content of the element to the database

      currentElement.writeContentToDB();

      System.out.println("Final content: " + currentElement.getContent());

      System.out.println("Closing element: " + expName);

   }

   /** Debug routine */

   private void db(int flag) {

     if (debug) {

       System.err.println("DEBUG POSITION " + flag);

     }

   }

}