/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 142

Added by Matt Jones over 24 years ago

reincorporated Title registration code for documents

        private boolean 	stackCreated = false;
        private Stack 	nodeStack;
        private Connection	conn = null;
        private DBSAXDocument currentDocument;
        /** Construct an instance of the handler class
+        *
-...
        /** SAX Handler that receives notification of end of the document */
        public void endDocument() throws SAXException {
         currentDocument.setTitleFromChildElement();
         if (debug) {
           System.out.println("end Document");
+        }
-...
+            }
             DBSAXNode documentNode = (DBSAXNode)nodeStack.peek();
             documentNode.writeNodename(docname);
             new DBSAXDocument(conn, documentNode.getNodeID(), docname, doctype);
             currentDocument = new DBSAXDocument(conn, documentNode.getNodeID(),
                                                 docname, doctype);
+          }
           // Create the current node representation

      */
     public class DBSAXDocument {
         private Connection		conn;
         private Connection      conn;
         private long            rootnodeid;
         private String          docname;
         private String          doctype;
         private String          doctitle;
         private long            docid;
         /**
          * Construct a new document instance
-...
               // Do the insertion
               pstmt.execute();
               pstmt.close();
               long assigned_id=0;
               Statement stmt;
               stmt = conn.createStatement();
               stmt.execute("SELECT xml_documents_id_seq.currval FROM dual");
               ResultSet rs = stmt.getResultSet();
               boolean tableHasRows = rs.next();
               if (tableHasRows) {
                 assigned_id = rs.getLong(1);
                 this.docid = assigned_id;
+              }
               stmt.close();
               conn.commit();
               conn.setAutoCommit(true);
             } catch (SQLException e) {
-...
+            }
+        }
         /**
          * Get the document title
          */
         public String getTitle() {
           return doctitle;
+        }
         /**
          * Set the document title
+         *
          * @param title the new title for the document
          */
         public void setTitle( String title ) {
           this.doctitle = title;
           try {
             PreparedStatement pstmt;
             pstmt = conn.prepareStatement(
                   "UPDATE xml_documents " +
                   " SET doctitle = ? " +
                   "WHERE docid = ?");
             // Bind the values to the query
             pstmt.setString(1, doctitle);
             pstmt.setLong(2, docid);
             // Do the insertion
             pstmt.execute();
             pstmt.close();
           } catch (SQLException e) {
             System.out.println(e.getMessage());
+          }
+        }
         /**
          * Look up the title of the first child element named "title"
          * and record it as the document title
          */
         public void setTitleFromChildElement() {
             String title = null;
             long assigned_id=0;
             PreparedStatement pstmt;
             try {
               pstmt = conn.prepareStatement(
                       "SELECT nodedata FROM xml_nodes " +
                       "WHERE nodetype = 'TEXT' " +
                       "AND parentnodeid IN " +
                       "(SELECT nodeid FROM xml_nodes " +
                       "WHERE nodename = 'title' " +
                       "START WITH nodeid = ? " +
                       "CONNECT BY PRIOR nodeid = parentnodeid)");
     /*
                         "SELECT nodeid " +
                         "FROM xml_nodes " +
                         "START WITH nodeid = ? " +
                         "CONNECT BY PRIOR nodeid = parentnodeid " +
                         "AND PRIOR nodename = 'title' " );
               pstmt = conn.prepareStatement("SELECT nodedata " +
                         "FROM xml_nodes " +
                         "WHERE nodetype = 'TEXT' " +
                         "  AND nodeid in " +
                         "(SELECT nodeid FROM xml_nodes " +
                         "  WHERE nodename = 'title' " +
                         "  START WITH nodeid = ? " +
                         "  CONNECT BY PRIOR nodeid = parentnodeid ");
     */
               // Bind the values to the query
               pstmt.setLong(1, rootnodeid);
               pstmt.execute();
               ResultSet rs = pstmt.getResultSet();
               boolean tableHasRows = rs.next();
               if (tableHasRows) {
                 title = rs.getString(1);
+              }
               pstmt.close();
             } catch (SQLException e) {
               System.out.println("Error getting id: " + e.getMessage());
+            }
             // assign the new title
             this.setTitle(title);
+        }
+    }

          if (publicId != null) {
             pIdCounter += 1;
     /*
             System.out.println("from DBEntityResolver: current element is " +
                                DBSAXHandler.elementNo);
             System.out.println("from DBEntityResolver: " + pIdCounter + " " +
                                publicId);
     */
             // look at the db XML Catalog and get dbSystemId by this publicId
             if (currentElementNo == 0) {
                 doctype = publicId;

Also available in: Unified diff

Project

General

Profile

Metacat

Revision 142

Added by Matt Jones over 24 years ago