/ - Diff - Metacat - Ecoinformatics Redmine

      */
     public class DBSAXHandler extends DefaultXMLDocumentHandler {
        static int elementNo = 0;
        static String docname = null;
        private String doctype;
        private String systemid;
        static  int 		elementNo = 0;
        static  String 	docname = null;
        private String 	doctype;
        private String 	systemid;
        private boolean 	debug 	= false;
        private boolean 	stackCreated = false;
        private Stack 	elementStack;
-...
           System.out.println("start Document");
+        }
         // Create the document node represantation as root
         DBSAXElement documentNode = new DBSAXElement(conn, docname, 0, 0);
         //DBSAXElement documentNode = new DBSAXElement(conn, docname, 0, 0);
         DBSAXElement documentNode = new DBSAXElement(conn, docname);
         // Add the element to the stack, so that any text data can be
         // added as it is encountered
         elementStack.push(documentNode);
-...
           String localName;
           String nsName;
           String expName;
           DBSAXElement parentElement;
           DBSAXElement parentElement = null;
           DBSAXElement currentElement;
           qName = name.getQualifiedName();
-...
           elementNo++;
           // Get a reference to the parent element for the id
           long parent_id;
           int nodeIndex;
           try {
             parentElement = (DBSAXElement)elementStack.peek();
             parent_id = parentElement.getNodeID();
             nodeIndex = parentElement.incChildNum();
           } catch (EmptyStackException e) {
             parent_id = 0;
             nodeIndex = 0;
+          }
           // Document representation that points to the root document node
           if (elementNo == 1) {
             // If no DOCTYPE declaration: docname = root element name
             if (docname == null)
             if (docname == null) {
                 docname = localName;
             else if (doctype == null)
             } else if (doctype == null) {
                 doctype = DBEntityResolver.doctype;
+            }
             DBSAXElement documentNode = (DBSAXElement)elementStack.peek();
             documentNode.writeNodename(docname);
             new DBSAXDocument(conn, documentNode.getNodeID(), docname, doctype);
+          }
           // Create the current element representation
           currentElement = new DBSAXElement(conn, localName, parent_id, nodeIndex);
           currentElement = new DBSAXElement(conn, localName, parentElement);
           // Add all of the attributes
           for (int i=0; i<atts.getLength(); i++)
-...
        /** SAX Handler that is called for each XML text node */
        public void characters(char[] cbuf, int start, int len) {
           DBSAXElement currentElement = (DBSAXElement)elementStack.peek();
           int nodeIndex = currentElement.incChildNum();
           String data = new String(cbuf, start, len);
           // Write the content of the element to the database
           currentElement.writeChildNodeToDB("TEXT", null, data, nodeIndex);
           currentElement.writeChildNodeToDB("TEXT", null, data);
+       }
        /**
-...
         */
        public void comment(String data) throws SAXException {
           DBSAXElement currentElement = (DBSAXElement)elementStack.peek();
           int nodeIndex = currentElement.incChildNum();
           currentElement.writeChildNodeToDB("COMMENT", null, data, nodeIndex);
           currentElement.writeChildNodeToDB("COMMENT", null, data);
+       }
        /**
-...
        public void processingInstruction(String target, String data)
               throws SAXException {
           DBSAXElement currentElement = (DBSAXElement)elementStack.peek();
           int nodeIndex = currentElement.incChildNum();
           currentElement.writeChildNodeToDB("PI", target, data, nodeIndex);
           currentElement.writeChildNodeToDB("PI", target, data);
+       }
        /** SAX Handler that is called at the end of each XML element */

       private Connection		conn;
       /**
        * Construct a new element instance
        * 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 element
        * @param parent_id the parent id number for this element
        * @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,
                            long parent_id, int nodeIndex) {
                            DBSAXElement parentNode) {
         super(tagname, parent_id, nodeIndex);
         super(tagname);
         setParentID(parentNode.getNodeID());
         setNodeIndex(parentNode.incChildNum());
         this.conn = conn;
         if (getParentID() != 0) {
           writeChildNodeToDB("ELEMENT", getTagName(), null, getNodeIndex());
         } else {
           writeChildNodeToDB("DOCUMENT", getTagName(), null, 0);
+        }
         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, int nodeIndex) {
                                      String data) {
         try {
           PreparedStatement pstmt;
           if (nodetype == "DOCUMENT") {
-...
           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());
+            }
             pstmt.setString(4, data);
             pstmt.setInt(5, nodeIndex);
+          }
           // Do the insertion
           pstmt.execute();
-...
         } catch (SQLException e) {
           System.err.println("Error inserting node: (" + nodetype + ", " +
                                                          nodename + ", " +
                                                          data + ", " +
                                                          nodeIndex + ")" );
                                                          data + ")" );
           System.err.println(e.getMessage());
+        }
+      }
-...
           // Enter the attribute in the hash table
           super.setAttribute(attName, attValue);
           writeChildNodeToDB("ATTRIBUTE", attName, attValue, 0);
           // And enter the attribute in the database
           writeChildNodeToDB("ATTRIBUTE", attName, attValue);
         } else {
           System.err.println("Attribute name must not be null!");
+        }

         private String      nodeType;
         private Vector	children;
         /** Construct a Basic Element */
         /** Construct a Basic Node */
         public BasicNode () {
           children = new Vector();
           attributes = new Hashtable();
           this.childNum = 0;
+        }
         /** Construct a Basic Element
         /**
          * Construct a Basic Node
+         *
          * @param tagname the name of the node
          */
         public BasicNode (String tagname) {
           this();
           this.tagname = tagname;
+        }
         /**
          * Construct a Basic Node
+         *
          * @param tagname the name of the node
          * @param parent_id the id number of the parent node
          * @param nodeIndex - order of node among siblings in parent node
          * @param nodeIndex - index of node among siblings in parent node
          *                    Every node initializes childNum to 0 when
          *                    created and has interface incChildNum
          *                    when new child is created
-...
           this.nodeIndex = nodeIndex;
+        }
         /** Construct a Basic Element
         /** Construct a Basic Node
+         *
          * @param node_id the id number of the node
          * @param tagname the name of the node

Project

General

Profile

Metacat

Revision 135

Added by Matt Jones over 24 years ago