/ - Diff - Metacat - Ecoinformatics Redmine

        static  int 		elementNo = 0;
        static  String 	docname = null;
        //private String 	docID;
        //private String 	rootNodeID;
        private String 	doctype;
        private String 	systemid;
        private boolean 	debug 	= false;
-...
        private Stack 	nodeStack;
        private Connection	conn = null;
        private DBSAXDocument currentDocument;
        private DBSAXNode rootNode;
        /** Construct an instance of the handler class
+        *
-...
           System.out.println("start Document");
+        }
         // Create the document node represantation as root
         DBSAXNode documentNode = new DBSAXNode(conn, docname);
         rootNode = new DBSAXNode(conn, docname);
         // Add the node to the stack, so that any text data can be
         // added as it is encountered
         nodeStack.push(documentNode);
         nodeStack.push(rootNode);
+       }
        /** SAX Handler that receives notification of end of the document */
-...
             } else if (doctype == null) {
                 doctype = DBEntityResolver.doctype;
+            }
             DBSAXNode documentNode = (DBSAXNode)nodeStack.peek();
             documentNode.writeNodename(docname);
             currentDocument = new DBSAXDocument(conn, documentNode.getNodeID(),
             //DBSAXNode documentNode = (DBSAXNode)nodeStack.peek();
             rootNode.writeNodename(docname);
             rootNode.writeRootNodeID(rootNode.getNodeID());
             currentDocument = new DBSAXDocument(conn, rootNode.getNodeID(),
                                                 docname, doctype);
             rootNode.writeDocID(currentDocument.getDocID());
+          }
           // Create the current node representation
           currentNode = new DBSAXNode(conn, localName, parentNode);
           currentNode = new DBSAXNode(conn, localName, parentNode, rootNode, currentDocument);
           // Add all of the attributes
           for (int i=0; i<atts.getLength(); i++)

+            }
+        }
         /** look up the assigned doc id from DB connection */
         public long getDocID() {
           long doc_id=0;
           Statement stmt;
           try {
             stmt = conn.createStatement();
             stmt.execute("SELECT xml_documents_id_seq.currval FROM dual");
             ResultSet rs = stmt.getResultSet();
             boolean tableHasRows = rs.next();
             if (tableHasRows) {
               doc_id = rs.getLong(1);
+            }
             stmt.close();
           } catch (SQLException e) {
             System.out.println("Error getting id: " + e.getMessage());
+          }
           // assign the new ID number
           return doc_id;
+        }
         /**
          * Get the document title
          */

         this.conn = conn;
         writeChildNodeToDB("DOCUMENT", tagname, null);
         setNodeID(getAssignedNodeID());
         setRootNodeID(getNodeID());
+      }
       /**
-...
        * @param parentNode the parent node for this node being created
        */
       public DBSAXNode (Connection conn, String tagname,
                            DBSAXNode parentNode) {
                         DBSAXNode parentNode, DBSAXNode rootNode, DBSAXDocument currentDocument) {
         super(tagname);
         setParentID(parentNode.getNodeID());
         setRootNodeID(rootNode.getNodeID());
         setDocID(currentDocument.getDocID());
         setNodeIndex(parentNode.incChildNum());
         this.conn = conn;
         writeChildNodeToDB("ELEMENT", getTagName(), null);
-...
             pstmt = conn.prepareStatement(
                 "INSERT INTO xml_nodes " +
                 "(nodeid, nodetype, nodename, " +
                 "parentnodeid, nodedata, nodeindex) " +
                 "VALUES (null, ?, ?, ?, ?, ?)");
                 "parentnodeid, rootnodeid, docid, nodedata, nodeindex) " +
                 "VALUES (null, ?, ?, ?, ?, ?, ?, ?)");
+          }
           // Bind the values to the query
-...
           if (nodetype != "DOCUMENT") {
             if (nodetype == "ELEMENT") {
               pstmt.setLong(3, getParentID());
               pstmt.setString(4, data);
               pstmt.setInt(5, getNodeIndex());
               pstmt.setLong(4, getRootNodeID());
               pstmt.setLong(5, getDocID());
               pstmt.setString(6, data);
               pstmt.setInt(7, getNodeIndex());
             } else {
               pstmt.setLong(3, getNodeID());
               pstmt.setString(4, data);
               pstmt.setInt(5, incChildNum());
               if (nodetype == "COMMENT")
                 System.out.println(getDocID());
               pstmt.setLong(4, getRootNodeID());
               pstmt.setLong(5, getDocID());
               pstmt.setString(6, data);
               pstmt.setInt(7, incChildNum());
+            }
+          }
           // Do the insertion
-...
+          }
+      }
       /**
        * creates SQL code to put root node id for the document node
        * into DB connection
        */
       public void writeRootNodeID(long rootnode_id) {
           try {
             PreparedStatement pstmt;
             pstmt = conn.prepareStatement(
                   "UPDATE xml_nodes set rootnodeid = ? " +
                   "WHERE nodeid = ?");
             // Bind the values to the query
             pstmt.setLong(1, rootnode_id);
             pstmt.setLong(2, getNodeID());
             // Do the insertion
             pstmt.execute();
             pstmt.close();
           } catch (SQLException e) {
             System.out.println(e.getMessage());
+          }
+      }
       /**
        * creates SQL code to put doc ID for the document node and for comment/PI nodes under document node
        * into DB connection
        */
       public void writeDocID(long doc_id) {
           try {
             PreparedStatement pstmt;
             pstmt = conn.prepareStatement(
                   "UPDATE xml_nodes set docid = ? " +
                   "WHERE nodeid = ?");
             // Bind the values to the query
             pstmt.setLong(1, doc_id);
             pstmt.setLong(2, getNodeID());
             // Do the insertion
             pstmt.execute();
             pstmt.close();
             // for comments and PI on the top
             pstmt = conn.prepareStatement(
                   "UPDATE xml_nodes set docid = ? " +
                   "WHERE parentnodeid = ?");
             // Bind the values to the query
             pstmt.setLong(1, doc_id);
             pstmt.setLong(2, getNodeID());
             // Do the insertion
             pstmt.execute();
             pstmt.close();
           } catch (SQLException e) {
             System.out.println(e.getMessage());
+          }
+      }
       /** look up the assigned node id from DB connection */
       private long getAssignedNodeID() {
           long assigned_id=0;

         private long	node_id;
         private String	tagname;
         private long	parent_id;
         private long    rootnode_id;
         private long    doc_id;
         private Hashtable	attributes;
         private int         childNum;
         private int         nodeIndex;
-...
           this.parent_id = parent_id;
+        }
         /** Get the root node id of this node */
         public long getRootNodeID()
+        {
           return rootnode_id;
+        }
         /** Set the root node id of this node */
         public void setRootNodeID(long rootnode_id)
+        {
           this.rootnode_id = rootnode_id;
+        }
         /** Get the doc id of this node */
         public long getDocID()
+        {
           return doc_id;
+        }
         /** Set the doc id of this node */
         public void setDocID(long doc_id)
+        {
           this.doc_id = doc_id;
+        }
         /** Get the name of this node */
         public String getTagName()
+        {

Project

General

Profile

Metacat

Revision 149

Added by bojilova over 24 years ago