/ - Diff - Metacat - Ecoinformatics Redmine

     import java.sql.*;
     import java.util.Stack;
     import java.util.EmptyStackException;
     // Extensions to the SAX Interfaces for Namespace support.
     import oracle.xml.parser.v2.DefaultXMLDocumentHandler;
-...
        public DBSAXHandler(Connection conn)
+       {
           System.out.println("\nINITIALIZING HANDLER....\n");
           this.conn = conn;
           // Create the stack for keeping track of element context
-...
           String localName;
           String nsName;
           String expName;
           DBSAXElement parentElement;
           DBSAXElement currentElement;
           qName = name.getQualifiedName();
-...
           nsName = name.getNamespace();
           expName = name.getExpandedName();
           // Get a reference to the parent element for the id
           long parent_id;
           try {
             parentElement = (DBSAXElement)elementStack.peek();
             parent_id = parentElement.getElementID();
           } catch (EmptyStackException e) {
             parent_id = 0;
+          }
           // Create the current element representation
           currentElement = new DBSAXElement(conn, 1, localName, false, 0);
           currentElement = new DBSAXElement(conn, localName, parent_id);
           System.out.println("Element created:" + currentElement.getTagName());
           // Add all of the attributes
-...
              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
-...
           // Use the methods getQualifiedName(), getLocalName(), getNamespace()
           // and getExpandedName() in NSName interface to get Namespace
           // information.
           String expName = name.getExpandedName();
           // Remove the element from the stack
           // Get the element from the stack
           DBSAXElement currentElement = (DBSAXElement)elementStack.pop();
           // Write the content of the element to the database
           currentElement.writeContentToDB();
           System.out.println("Final content: " + currentElement.getContent());
           System.out.println("Closing element: " + expName);

     import java.sql.*;
     import java.util.Stack;
     import java.util.EmptyStackException;
     // Extensions to the SAX Interfaces for Namespace support.
     import oracle.xml.parser.v2.DefaultXMLDocumentHandler;
-...
        public DBSAXHandler(Connection conn)
+       {
           System.out.println("\nINITIALIZING HANDLER....\n");
           this.conn = conn;
           // Create the stack for keeping track of element context
-...
           String localName;
           String nsName;
           String expName;
           DBSAXElement parentElement;
           DBSAXElement currentElement;
           qName = name.getQualifiedName();
-...
           nsName = name.getNamespace();
           expName = name.getExpandedName();
           // Get a reference to the parent element for the id
           long parent_id;
           try {
             parentElement = (DBSAXElement)elementStack.peek();
             parent_id = parentElement.getElementID();
           } catch (EmptyStackException e) {
             parent_id = 0;
+          }
           // Create the current element representation
           currentElement = new DBSAXElement(conn, 1, localName, false, 0);
           currentElement = new DBSAXElement(conn, localName, parent_id);
           System.out.println("Element created:" + currentElement.getTagName());
           // Add all of the attributes
-...
              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
-...
           // Use the methods getQualifiedName(), getLocalName(), getNamespace()
           // and getExpandedName() in NSName interface to get Namespace
           // information.
           String expName = name.getExpandedName();
           // Remove the element from the stack
           // Get the element from the stack
           DBSAXElement currentElement = (DBSAXElement)elementStack.pop();
           // Write the content of the element to the database
           currentElement.writeContentToDB();
           System.out.println("Final content: " + currentElement.getContent());
           System.out.println("Closing element: " + expName);

         private long		element_id;
         private String		tagname;
         private StringBuffer	content;
         private boolean		isEmpty;
         private long		parent_id;
         private Hashtable		attributes;
         private Connection		conn;
         public DBSAXElement (Connection conn, long element_id, String tagname,
                              boolean isEmpty, long parent_id) {
         public DBSAXElement (Connection conn, String tagname,
                              long parent_id) {
           this.conn = conn;
           this.element_id = assignElementID();
           this.tagname = tagname;
           this.isEmpty = isEmpty;
           this.parent_id = parent_id;
           content = new StringBuffer();
           attributes = new Hashtable();
           writeElementToDB();
           System.out.println("******ELEMENT_ID: " + this.element_id);
         };
         private long assignElementID() {
-...
     	return value.toString ();
+        }
         /** Get the id of this element */
         public long  getElementID() { return element_id; }
         /** Get the name of this element */
         public String  getTagName() { return tagname; }
-...
         public String getContent() {
           return this.content.toString();
+        }
         /** Write the element content to the db connection */
         public void writeContentToDB() {
             try {
               PreparedStatement pstmt = conn.prepareStatement(
                     "UPDATE xml_elements SET nodedata = ? WHERE nodeid = ?");
               // Bind the values to the query
               pstmt.setString(1, getContent());// The first ? is for NODEDATA
               pstmt.setLong(2, element_id); // The second ? is for NODEID
               // Do the update
               pstmt.execute();
               pstmt.close();
             } catch (SQLException e) {
               System.out.println(e.getMessage());
+            }
+        }
+    }

         private long		element_id;
         private String		tagname;
         private StringBuffer	content;
         private boolean		isEmpty;
         private long		parent_id;
         private Hashtable		attributes;
         private Connection		conn;
         public DBSAXElement (Connection conn, long element_id, String tagname,
                              boolean isEmpty, long parent_id) {
         public DBSAXElement (Connection conn, String tagname,
                              long parent_id) {
           this.conn = conn;
           this.element_id = assignElementID();
           this.tagname = tagname;
           this.isEmpty = isEmpty;
           this.parent_id = parent_id;
           content = new StringBuffer();
           attributes = new Hashtable();
           writeElementToDB();
           System.out.println("******ELEMENT_ID: " + this.element_id);
         };
         private long assignElementID() {
-...
     	return value.toString ();
+        }
         /** Get the id of this element */
         public long  getElementID() { return element_id; }
         /** Get the name of this element */
         public String  getTagName() { return tagname; }
-...
         public String getContent() {
           return this.content.toString();
+        }
         /** Write the element content to the db connection */
         public void writeContentToDB() {
             try {
               PreparedStatement pstmt = conn.prepareStatement(
                     "UPDATE xml_elements SET nodedata = ? WHERE nodeid = ?");
               // Bind the values to the query
               pstmt.setString(1, getContent());// The first ? is for NODEDATA
               pstmt.setLong(2, element_id); // The second ? is for NODEID
               // Do the update
               pstmt.execute();
               pstmt.close();
             } catch (SQLException e) {
               System.out.println(e.getMessage());
+            }
+        }
+    }

         private long		element_id;
         private String		tagname;
         private StringBuffer	content;
         private boolean		isEmpty;
         private long		parent_id;
         private Hashtable		attributes;
         private Connection		conn;
         public DBSAXElement (Connection conn, long element_id, String tagname,
                              boolean isEmpty, long parent_id) {
         public DBSAXElement (Connection conn, String tagname,
                              long parent_id) {
           this.conn = conn;
           this.element_id = assignElementID();
           this.tagname = tagname;
           this.isEmpty = isEmpty;
           this.parent_id = parent_id;
           content = new StringBuffer();
           attributes = new Hashtable();
           writeElementToDB();
           System.out.println("******ELEMENT_ID: " + this.element_id);
         };
         private long assignElementID() {
-...
     	return value.toString ();
+        }
         /** Get the id of this element */
         public long  getElementID() { return element_id; }
         /** Get the name of this element */
         public String  getTagName() { return tagname; }
-...
         public String getContent() {
           return this.content.toString();
+        }
         /** Write the element content to the db connection */
         public void writeContentToDB() {
             try {
               PreparedStatement pstmt = conn.prepareStatement(
                     "UPDATE xml_elements SET nodedata = ? WHERE nodeid = ?");
               // Bind the values to the query
               pstmt.setString(1, getContent());// The first ? is for NODEDATA
               pstmt.setLong(2, element_id); // The second ? is for NODEID
               // Do the update
               pstmt.execute();
               pstmt.close();
             } catch (SQLException e) {
               System.out.println(e.getMessage());
+            }
+        }
+    }

Project

General

Profile

Metacat

Revision 18

Added by Matt Jones over 24 years ago