Metacat

/**

 *    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

 *     '$Date$'

 * '$Revision$'

 * This program is free software; you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation; either version 2 of the License, or

 * (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

import java.net.URL;

import java.net.MalformedURLException;

import java.sql.*;

import java.util.Stack;

import java.util.Hashtable;

import java.util.Enumeration;

import edu.ucsb.nceas.metacat.database.DBConnectionPool;

 * 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

 */

   * the main routine used to test the DBSimpleQuery utility.

   * Usage: java DBSimpleQuery <query>

   * @param query the text to search for in the element and attribute content

   */

        System.err.println("Wrong number of arguments!!!");

     } else {

        try {

          // Execute the simple query

          if (doctype.equals("any") || doctype.equals("ANY")) {

            nodelist = rd.findDocuments(query);

          } else {

            nodelist = rd.findDocuments(query, doctype);

          }

          // Print the reulting root nodes

          StringBuffer result = new StringBuffer();

          result.append("<resultset>\n");

  //        result.append("  <query>" + query + "</query>\n");

          while (doclist.hasMoreElements()) {

            result.append("  <document>\n    " + document +

                          "\n  </document>\n");

          System.out.println(result);

        } catch (Exception e) {

          e.printStackTrace(System.err);

        }

     }

  }

   * construct an instance of the DBSimpleQuery class

   *

                         SQLException,

                         ClassNotFoundException

  {

   * routine to search the elements and attributes looking to match query

   *

   * @param query the text to search for

   */

  }

  /**

   * routine to search the elements and attributes looking to match query

   *

   * @param query the text to search for

   * @param requestedDoctype the type of documents to return from the query

   */

  public Hashtable findDocuments(String query, String requestedDoctype) {

      DBConnection dbConn = null;

      int serialNumber = -1;

      String doctype = null;

      String doctitle = null;

                  getDBConnection("DBSimpleQuery.findDocuments");

        serialNumber=dbConn.getCheckOutSerialNumber();

            requestedDoctype.equals("any") ||

            requestedDoctype.equals("ANY")) {

                "FROM xml_documents " +

                "WHERE docid IN " +

                "(SELECT docid " +

                "FROM xml_nodes WHERE nodedata LIKE ? )");

                pstmt.setString(1, query);

        } else {

                "FROM xml_documents " +

                "WHERE docid IN " +

                "(SELECT docid " +

                "FROM xml_nodes WHERE nodedata LIKE ? ) " +

                "AND doctype = ?");

                // Bind the values to the query

                pstmt.setString(1, query);

                pstmt.setString(2, requestedDoctype);

        }

        boolean tableHasRows = rs.next();

        while (tableHasRows) {

          doctype = rs.getString(3);

          doctitle = rs.getString(4);

            document.append("<docname>" + docname + "</docname>");

          }

          if (doctype != null) {

            document.append("<doctype>" + doctype + "</doctype>");

          }

          if (doctitle != null) {

            document.append("<doctitle>" + doctitle + "</doctitle>");

          }

          // Advance to the next record in the cursor

          tableHasRows = rs.next();

        pstmt.close();

      } catch (SQLException e) {

                            e.getMessage());

      {

        DBConnectionPool.returnDBConnection(dbConn, serialNumber);

      }

}