/ - Diff - Metacat - Ecoinformatics Redmine

     /**
      *        Name: DBSAXHandler.java
      *     Purpose: A Class that handles the SAX XML events as they
      *              are generated from XML documents
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
      *      Name: DBSAXHandler.java
      *   Purpose: A Class that handles the SAX XML events as they
      *            are generated from XML documents
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Matt Jones
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *      Name: GenericXMLValidate.java
      *   Purpose: A Class that validates XML documents
      *            This class is designed to be 'parser independent
      *            i.e. it uses only org.xml.sax classes
      *            It is tied to SAX 1.0 methods
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Dan Higgins
+     *
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *        Name: ElementNode.java
      *     Purpose: A Class that represents an XML element and its contents,
      *              and can build itself from a database connection
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
      *      Name: ElementNode.java
      *   Purpose: A Class that represents an XML element and its contents,
      *            and can build itself from a database connection
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Matt Jones
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *        Name: DBSAXDocument.java
      *     Purpose: A Class that writes an XML document main data
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Jivka Bojilova
      *      Name: DBSAXDocument.java
      *   Purpose: A Class that writes an XML document main data
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Jivka Bojilova
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *      Name: DBEntityResolver.java
      *   Purpose: A Class that implements org.xml.sax.EntityResolver interface
      *              for resolving external entities
      *            for resolving external entities
      * Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Jivka Bojilova
+     *
      *   Version: '$Id$'

     /**
      *        Name: DBSAXNode.java
      *     Purpose: A Class that represents an XML node and its contents
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
      *      Name: DBSAXNode.java
      *   Purpose: A Class that represents an XML node and its contents
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Matt Jones
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *      Name: GenericXMLValidate.java
      *   Purpose: A Class that validates XML documents
      *            This class is designed to be 'parser independent
      *            i.e. it uses only org.xml.sax classes
      *            It is tied to SAX 1.0 methods
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Dan Higgins
+     *
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *        Name: DBReader.java
      *     Purpose: A Class that creates an XML text document
      *              from a query to a relational DB containing a DOM representation
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
      *      Name: DBReader.java
      *   Purpose: A Class that creates an XML text document
      *            from a query to a relational DB containing a DOM representation
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Matt Jones
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *      Name: XMLValidate.java
      *   Purpose: A Class that validates XML documents
      *            This class is uses a specific parser
      *            and calls the GenericXMLValidate class
      *            to do the actual validation
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Dan Higgins
+     *
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;
     import org.w3c.dom.*;

     /**
      *        Name: MetaCatUtil.java
      *     Purpose: A Class that implements utility methods for a metadata catalog
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
      *      Name: MetaCatUtil.java
      *   Purpose: A Class that implements utility methods for a metadata catalog
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Matt Jones
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *        Name: DBDTDHandler.java
      *     Purpose: A Class that implements org.xml.sax.DTDHandler interface
      *              for resolving external entities
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Jivka Bojilova
      *      Name: DBDTDHandler.java
      *   Purpose: A Class that implements org.xml.sax.DTDHandler interface
      *            for resolving external entities
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Jivka Bojilova
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *        Name: AccessionNumber.java
      *     Purpose: A class that gets Accession Number, check for uniqueness
      *              and register it into db
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Jivka Bojilova
      *      Name: AccessionNumber.java
      *   Purpose: A class that gets Accession Number, check for uniqueness
      *            and register it into db
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Jivka Bojilova
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;
-...
     public class AccessionNumber  {
         public static String generate (String accNumber, String action)
             throws ClassNotFoundException, StringIndexOutOfBoundsException, SQLException
             throws ClassNotFoundException, StringIndexOutOfBoundsException,
                    SQLException
+        {
             String globalName = null;
-...
             String defaultDB = (String)options.handleGetObject("defaultDB");
             String user = (String)options.handleGetObject("user");
             String password = (String)options.handleGetObject("password");
             String defaultGlobalName = (String)options.handleGetObject("defaultGlobalName");
             String defaultGlobalName =
                    (String)options.handleGetObject("defaultGlobalName");
             String sep = (String)options.handleGetObject("accNumberSeparator");
             try {
                 // Open a new connection to the database
                 Connection conn = MetaCatUtil.openDBConnection(dbDriver, defaultDB, user, password);
                 Connection conn = MetaCatUtil.openDBConnection(dbDriver,
                                   defaultDB, user, password);
                 conn.setAutoCommit(true);
                 // split the acc # in 2 parts - global name & local id
-...
                         return put(conn, globalName, localId, sep);
             } catch (SQLException e) {
                 System.out.println("Error on AccessionNumber.genAccessionNumber(): " + e.getMessage());
                 System.out.println(
                            "Error on AccessionNumber.genAccessionNumber(): " +
                            e.getMessage());
                 throw e;
+            }
             return null;
+        }
         private static String put (Connection conn, String globalName, String localId, String sep)
         private static String put (Connection conn, String globalName,
                     String localId, String sep)
                     throws SQLException
+        {
-...
                 // insert globalName & l
                 PreparedStatement pstmt;
                 pstmt = conn.prepareStatement("INSERT INTO xml_acc_numbers (global_name, local_id) " +
                                               "VALUES (?, ?)");
                 pstmt = conn.prepareStatement(
                         "INSERT INTO xml_acc_numbers (global_name, local_id) " +
                         "VALUES (?, ?)");
                 pstmt.setString(1,globalName);
                 pstmt.setString(2,l.toString());
                 pstmt.execute();
             } catch (SQLException e) {
                 System.out.println("Error on AccessionNumber.put(conn, globalName, localId): " + e.getMessage());
                 System.out.println(
                        "Error on AccessionNumber.put(conn, globalName, localId): "
                        + e.getMessage());
                 throw e;
+            }
             return globalName + sep + l;
+        }
         /** check for existance of Accesssion Number */
         private static boolean unique (Connection conn, String globalName, String localId)
                     throws SQLException
         private static boolean unique (Connection conn, String globalName,
                     String localId) throws SQLException
+        {
             boolean hasAccNumber = false;
             try {
                 PreparedStatement pstmt;
                 pstmt = conn.prepareStatement("SELECT 'x' FROM xml_acc_numbers " +
                                              "WHERE global_name LIKE ? AND local_id = ?");
                 pstmt = conn.prepareStatement(
                         "SELECT 'x' FROM xml_acc_numbers " +
                         "WHERE global_name LIKE ? AND local_id = ?");
                 pstmt.setString(1,globalName);
                 pstmt.setString(2,localId);
                 pstmt.execute();
-...
                 pstmt.close();
             } catch (SQLException e) {
                 System.out.println("Error on AccessionNumber.unique(globalName, localId): " + e.getMessage());
                 System.out.println("Error on AccessionNumber.unique(globalName,
                                    localId): " + e.getMessage());
                 throw e;
+            }
-...
+        {
             try {
                 PreparedStatement pstmt;
                 pstmt = conn.prepareStatement("SELECT max(local_id) FROM xml_acc_numbers " +
                                              "WHERE global_name LIKE ?");
                 pstmt = conn.prepareStatement(
                         "SELECT max(local_id) FROM xml_acc_numbers " +
                         "WHERE global_name LIKE ?");
                 pstmt.setString(1,globalName);
                 pstmt.execute();
                 ResultSet rs = pstmt.getResultSet();
-...
                 pstmt.close();
             } catch (SQLException e) {
                 System.out.println("Error on AccessionNumber.get(): " + e.getMessage());
                 System.out.println(
                        "Error on AccessionNumber.get(): " + e.getMessage());
                 throw e;
+            }

     /**
      *        Name: DBTransform.java
      *     Purpose: A Class that transforms an XML text document
      *              into a another type using XSL
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
      *      Name: DBTransform.java
      *   Purpose: A Class that transforms an XML text document
      *            into a another type using XSL
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Matt Jones
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *        Name: DBWriter.java
      *     Purpose: A Class that reads in an XML text document and
      *              write its contents to a database connection using SAX
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
      *      Name: DBWriter.java
      *   Purpose: A Class that reads in an XML text document and
      *            write its contents to a database connection using SAX
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Matt Jones
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *        Name: DBSimpleQuery.java
      *     Purpose: A Class that searches a relational DB for elements and
      *              attributes that have free text matches to the query string.
      *              It returns a result set consisting of the root nodeid for
      *              each document that satisfies the query
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
      *      Name: DBSimpleQuery.java
      *   Purpose: A Class that searches a relational DB for elements and
      *            attributes that have free text matches to the query string.
      *            It returns a result set consisting of the root nodeid for
      *            each document that satisfies the query
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Matt Jones
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *        Name: BasicNode.java
      *     Purpose: A Class that represents an XML node and its contents
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
      *      Name: BasicNode.java
      *   Purpose: A Class that represents an XML node and its contents
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Matt Jones
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

     /**
      *        Name: TextNode.java
      *     Purpose: A Class that represents an XML Text node and its contents,
      *              and can build itself from a database connection
      *   Copyright: 2000 Regents of the University of California and the
      *              National Center for Ecological Analysis and Synthesis
      *     Authors: Matt Jones
      *      Name: TextNode.java
      *   Purpose: A Class that represents an XML Text node and its contents,
      *            and can build itself from a database connection
      * Copyright: 2000 Regents of the University of California and the
      *            National Center for Ecological Analysis and Synthesis
      *   Authors: Matt Jones
+     *
      *     Version: '$Id$'
      *   Version: '$Id$'
      */
     package edu.ucsb.nceas.metacat;

Project

General

Profile

Metacat

Revision 168

Added by Matt Jones over 24 years ago