/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 137

Added by Matt Jones about 24 years ago

Renamed DBSAXElement to DBSAXNode

     /**
      *        Name: DBSAXElement.java
      *     Purpose: A Class that represents an XML element and its contents
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
+     *
      *     Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;
     import java.sql.*;
     import java.io.IOException;
     import java.util.Hashtable;
     import java.util.Enumeration;
     /**
      * A Class that represents an XML element and its contents and
      * can write its own representation to a database connection
      */
     public class DBSAXElement extends BasicNode {
       private Connection		conn;
       /**
        * Construct a new node instance for DOCUMENT nodes
+       *
        * @param conn the JDBC Connection to which all information is written
        * @param tagname the name of the node
        */
       public DBSAXElement (Connection conn, String tagname) {
         super(tagname);
         this.conn = conn;
         writeChildNodeToDB("DOCUMENT", tagname, null);
         setNodeID(getAssignedNodeID());
+      }
       /**
        * Construct a new node instance for ELEMENT nodes
+       *
        * @param conn the JDBC Connection to which all information is written
        * @param tagname the name of the node
        * @param parentNode the parent node for this node being created
        */
       public DBSAXElement (Connection conn, String tagname,
                            DBSAXElement parentNode) {
         super(tagname);
         setParentID(parentNode.getNodeID());
         setNodeIndex(parentNode.incChildNum());
         this.conn = conn;
         writeChildNodeToDB("ELEMENT", getTagName(), null);
         setNodeID(getAssignedNodeID());
+      }
       /** creates SQL code and inserts new node into DB connection */
       public void writeChildNodeToDB(String nodetype, String nodename,
                                      String data) {
         try {
           PreparedStatement pstmt;
           if (nodetype == "DOCUMENT") {
             pstmt = conn.prepareStatement(
                 "INSERT INTO xml_nodes " +
                 "(nodeid, nodetype, nodename) " +
                 "VALUES (null, ?, ?)");
           } else {
             pstmt = conn.prepareStatement(
                 "INSERT INTO xml_nodes " +
                 "(nodeid, nodetype, nodename, " +
                 "parentnodeid, nodedata, nodeindex) " +
                 "VALUES (null, ?, ?, ?, ?, ?)");
+          }
           // Bind the values to the query
           pstmt.setString(1, nodetype);
           pstmt.setString(2, nodename);
           if (nodetype != "DOCUMENT") {
             if (nodetype == "ELEMENT") {
               pstmt.setLong(3, getParentID());
               pstmt.setString(4, data);
               pstmt.setInt(5, getNodeIndex());
             } else {
               pstmt.setLong(3, getNodeID());
               pstmt.setString(4, data);
               pstmt.setInt(5, incChildNum());
+            }
+          }
           // Do the insertion
           pstmt.execute();
           pstmt.close();
         } catch (SQLException e) {
           System.err.println("Error inserting node: (" + nodetype + ", " +
                                                          nodename + ", " +
                                                          data + ")" );
           System.err.println(e.getMessage());
+        }
+      }
       /**
        * creates SQL code to put nodename for the document node
        * into DB connection
        */
       public void writeNodename(String nodename) {
           try {
             PreparedStatement pstmt;
             pstmt = conn.prepareStatement(
                   "UPDATE xml_nodes set nodename = ? " +
                   "WHERE nodeid = ?");
             // Bind the values to the query
             pstmt.setString(1, nodename);
             pstmt.setLong(2, getNodeID());
             // Do the insertion
             pstmt.execute();
             pstmt.close();
           } catch (SQLException e) {
             System.out.println(e.getMessage());
+          }
+      }
       /** look up the assigned element id from DB connection */
       private long getAssignedNodeID() {
           long assigned_id=0;
           Statement stmt;
           try {
             stmt = conn.createStatement();
             stmt.execute("SELECT xml_nodes_id_seq.currval FROM dual");
             ResultSet rs = stmt.getResultSet();
             boolean tableHasRows = rs.next();
             if (tableHasRows) {
               assigned_id = rs.getLong(1);
+            }
             stmt.close();
           } catch (SQLException e) {
             System.out.println("Error getting id: " + e.getMessage());
+          }
           // assign the new ID number
           return assigned_id;
+      }
       /** Add a new attribute to this element, or set its value */
       public void setAttribute(String attName, String attValue) {
         if (attName != null) {
           // Enter the attribute in the hash table
           super.setAttribute(attName, attValue);
           // And enter the attribute in the database
           writeChildNodeToDB("ATTRIBUTE", attName, attValue);
         } else {
           System.err.println("Attribute name must not be null!");
+        }
+      }
+    }

        private String 	systemid;
        private boolean 	debug 	= false;
        private boolean 	stackCreated = false;
        private Stack 	elementStack;
        private Stack 	nodeStack;
        private Connection	conn = null;
        /** Construct an instance of the handler class
-...
        public DBSAXHandler(Connection conn) {
           this.conn = conn;
           // Create the stack for keeping track of element context
           // Create the stack for keeping track of node context
           // if it doesn't already exist
           if (!stackCreated) {
             elementStack = new Stack();
             nodeStack = new Stack();
             stackCreated = true;
+          }
-...
           System.out.println("start Document");
+        }
         // Create the document node represantation as root
         DBSAXElement documentNode = new DBSAXElement(conn, docname);
         // Add the element to the stack, so that any text data can be
         DBSAXNode documentNode = new DBSAXNode(conn, docname);
         // Add the node to the stack, so that any text data can be
         // added as it is encountered
         elementStack.push(documentNode);
         nodeStack.push(documentNode);
+       }
        /** SAX Handler that receives notification of end of the document */
-...
           String localName;
           String nsName;
           String expName;
           DBSAXElement parentElement = null;
           DBSAXElement currentElement = null;
           DBSAXNode parentNode = null;
           DBSAXNode currentNode = null;
           qName = name.getQualifiedName();
           localName = name.getLocalName();
-...
           expName = name.getExpandedName();
           elementNo++;
           // Get a reference to the parent element for the id
           // Get a reference to the parent node for the id
           try {
             parentElement = (DBSAXElement)elementStack.peek();
             parentNode = (DBSAXNode)nodeStack.peek();
           } catch (EmptyStackException e) {
+          }
-...
             } else if (doctype == null) {
                 doctype = DBEntityResolver.doctype;
+            }
             DBSAXElement documentNode = (DBSAXElement)elementStack.peek();
             DBSAXNode documentNode = (DBSAXNode)nodeStack.peek();
             documentNode.writeNodename(docname);
             new DBSAXDocument(conn, documentNode.getNodeID(), docname, doctype);
+          }
           // Create the current element representation
           currentElement = new DBSAXElement(conn, localName, parentElement);
           // Create the current node representation
           currentNode = new DBSAXNode(conn, localName, parentNode);
           // Add all of the attributes
           for (int i=0; i<atts.getLength(); i++)
-...
              String type = atts.getType(qName);
              String value = atts.getValue(qName);
              currentElement.setAttribute(localName, value);
              currentNode.setAttribute(localName, value);
+          }
           // Add the element to the stack, so that any text data can be
           // Add the node to the stack, so that any text data can be
           // added as it is encountered
           elementStack.push(currentElement);
           nodeStack.push(currentNode);
+       }
        /** SAX Handler that is called for each XML text node */
        public void characters(char[] cbuf, int start, int len) {
           DBSAXElement currentElement = (DBSAXElement)elementStack.peek();
           DBSAXNode currentNode = (DBSAXNode)nodeStack.peek();
           String data = new String(cbuf, start, len);
           // Write the content of the element to the database
           currentElement.writeChildNodeToDB("TEXT", null, data);
           // Write the content of the node to the database
           currentNode.writeChildNodeToDB("TEXT", null, data);
+       }
        /**
-...
        /**
         * SAX Handler called once for each comment found:
         * node that comment may occur before or after the root element.
         * For now works only for comments after the root element.
         */
        public void comment(String data) throws SAXException {
           DBSAXElement currentElement = (DBSAXElement)elementStack.peek();
           currentElement.writeChildNodeToDB("COMMENT", null, data);
           DBSAXNode currentNode = (DBSAXNode)nodeStack.peek();
           currentNode.writeChildNodeToDB("COMMENT", null, data);
+       }
        /**
-...
         */
        public void processingInstruction(String target, String data)
               throws SAXException {
           DBSAXElement currentElement = (DBSAXElement)elementStack.peek();
           currentElement.writeChildNodeToDB("PI", target, data);
           DBSAXNode currentNode = (DBSAXNode)nodeStack.peek();
           currentNode.writeChildNodeToDB("PI", target, data);
+       }
        /** SAX Handler that is called at the end of each XML element */
-...
           // information.
           String expName = name.getExpandedName();
           // Get the element from the stack
           DBSAXElement currentElement = (DBSAXElement)elementStack.pop();
           // Get the node from the stack
           DBSAXNode currentNode = (DBSAXNode)nodeStack.pop();
+       }
        /** Debug routine */

     /**
      *        Name: DBSAXElement.java
      *     Purpose: A Class that represents an XML element and its contents
      *        Name: DBSAXNode.java
      *     Purpose: A Class that represents an XML node and its contents
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
-...
     import java.util.Enumeration;
     /**
      * A Class that represents an XML element and its contents and
      * A Class that represents an XML node and its contents and
      * can write its own representation to a database connection
      */
     public class DBSAXElement extends BasicNode {
     public class DBSAXNode extends BasicNode {
       private Connection		conn;
-...
        * @param conn the JDBC Connection to which all information is written
        * @param tagname the name of the node
        */
       public DBSAXElement (Connection conn, String tagname) {
       public DBSAXNode (Connection conn, String tagname) {
         super(tagname);
         this.conn = conn;
         writeChildNodeToDB("DOCUMENT", tagname, null);
-...
        * @param tagname the name of the node
        * @param parentNode the parent node for this node being created
        */
       public DBSAXElement (Connection conn, String tagname,
                            DBSAXElement parentNode) {
       public DBSAXNode (Connection conn, String tagname,
                            DBSAXNode parentNode) {
         super(tagname);
         setParentID(parentNode.getNodeID());
-...
+          }
+      }
       /** look up the assigned element id from DB connection */
       /** look up the assigned node id from DB connection */
       private long getAssignedNodeID() {
           long assigned_id=0;
           Statement stmt;
-...
           return assigned_id;
+      }
       /** Add a new attribute to this element, or set its value */
       /** Add a new attribute to this node, or set its value */
       public void setAttribute(String attName, String attValue) {
         if (attName != null) {
           // Enter the attribute in the hash table

Also available in: Unified diff

Project

General

Profile

Metacat

Revision 137

Added by Matt Jones about 24 years ago