/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 691

Added by bojilova almost 24 years ago

cleared DOCTITLE attribute in xml_documents and xml_revisions
cleared all mentions of doctitle

        private int serverCode = 1;
        private static final int MAXDATACHARS = 4000;
        private static final int MAXTITLELEN = 1000;
     // DOCTITLE attr cleared from the db
     //   private static final int MAXTITLELEN = 1000;
        /** Construct an instance of the handler class
+        *
-...
            currentNode.writeChildNodeToDB("TEXT", null, data, docid);
+         }
          // write the title of document if there are tag <title>
          if ( currentNode.getTagName().equals("title") ) {
            if ( leftover > MAXTITLELEN )
              currentDocument.setTitle(new String(cbuf, start, MAXTITLELEN));
            else
              currentDocument.setTitle(new String(cbuf, start, leftover));
+         }
     // DOCTITLE attr cleared from the db
     //     // write the title of document if there are tag <title>
     //     if ( currentNode.getTagName().equals("title") ) {
     //       if ( leftover > MAXTITLELEN )
     //         currentDocument.setTitle(new String(cbuf, start, MAXTITLELEN));
     //       else
     //         currentDocument.setTitle(new String(cbuf, start, leftover));
     //     }
+       }
        /**

       private String docid = null;
       private String docname = null;
       private String doctype = null;
       private String doctitle = null;
     // DOCTITLE attr cleared from the db
     //  private String doctitle = null;
       private String createdate = null;
       private String updatedate = null;
       private String system_id = null;
-...
         return docid;
+      }
       /**
        *get the document title
        */
       public String getDocTitle() {
         return doctitle;
+      }
     // DOCTITLE attr cleared from the db
     //  /**
     //   *get the document title
     //   */
     //  public String getDocTitle() {
     //    return doctitle;
     //  }
       public String getUserowner() {
         return userowner;
-...
         try {
           StringBuffer sql = new StringBuffer();
           sql.append("SELECT docname, doctype, rootnodeid,doctitle, ");
     // DOCTITLE attr cleared from the db
     //      sql.append("SELECT docname, doctype, rootnodeid, doctitle, ");
           sql.append("SELECT docname, doctype, rootnodeid, ");
           sql.append("date_created, date_updated, ");
           sql.append("user_owner, user_updated, server_location, ");
           sql.append("rev FROM ").append(table);
-...
             this.docname        = rs.getString(1);
             this.doctype        = rs.getString(2);
             this.rootnodeid     = rs.getLong(3);
             this.doctitle       = rs.getString(4);
     // DOCTITLE attr cleared from the db
     //        this.doctitle       = rs.getString(4);
             this.createdate     = rs.getString(5);
             this.updatedate     = rs.getString(6);
             this.userowner      = rs.getString(7);
-...
+        }
+      }
       /**
        * Get the document title
        */
       public String getTitle() {
         return doctitle;
+      }
     // DOCTITLE attr cleared from the db
     //  /**
     //   * Get the document title
     //   */
     //  public String getTitle() {
     //    return doctitle;
     //  }
       /**
        * Set the document title
+       *
        * @param title the new title for the document
        */
     // DOCTITLE attr cleared from the db
     //  /**
     //   * 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.setString(2, docid);
     //
     //      // Do the insertion
     //      pstmt.execute();
     //      pstmt.close();
     //    } catch (SQLException e) {
     //      System.out.println("Error in DocumentImpl.setTitle: " + e.getMessage());
     //    }
     //  }
       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.setString(2, docid);
           // Do the insertion
           pstmt.execute();
           pstmt.close();
         } catch (SQLException e) {
           System.out.println("Error in DocumentImpl.setTitle: " + e.getMessage());
+        }
+      }
       /**
        * Write an XML file to the database, given a filename
+       *
-...
         // for that document as selected from xml_documents
         PreparedStatement pstmt = conn.prepareStatement(
           "INSERT INTO xml_revisions " +
             "(revisionid, docid, rootnodeid, docname, doctype, doctitle, " +
             "(revisionid, docid, rootnodeid, docname, doctype, " +
             "user_owner, user_updated, date_created, date_updated, server_location, " +
             "rev)" +
           "SELECT null, ?, rootnodeid, docname, doctype, doctitle," +
           "SELECT null, ?, rootnodeid, docname, doctype, " +
             "user_owner, ?, sysdate, sysdate, server_location, rev "+
           "FROM xml_documents " +
           "WHERE docid = ?");

Also available in: Unified diff

Project

General

Profile

Metacat

Revision 691

Added by bojilova almost 24 years ago