Metacat

package edu.ucsb.nceas.metacat;

import java.util.StringTokenizer;

import java.util.Vector;

import javax.servlet.ServletOutputStream;

/**

 * A Class that searches a relational DB for elements and

 * attributes that have free text matches a query string,

          double connTime = System.currentTimeMillis();

          // Execute the query

          FileReader xml = new FileReader(new File(xmlfile));

          Hashtable nodelist = null;

          nodelist = queryobj.findDocuments(xml, null, null, useXMLIndex);

        // Get the XML query and covert it into a SQL statment

        QuerySpecification qspec = new QuerySpecification(xmlquery,

                                   parserName,

        result = findDocuments(qspec, user, groups, useXMLIndex);

      }

      catch (IOException ioe)

              && !qspec.isPercentageSearch())

          {

            MetaCatUtil.debugMessage("Back tracing now...", 20);

            StringBuffer btBuf = new StringBuffer();

            btBuf.append("select docid from xml_relation where ");

            { //there was a backtrackable document found

              DocumentImpl xmldoc = null;

              String packageDocid = btrs.getString(1);

              try

              {

                //  THIS CONSTRUCTOR BUILDS THE WHOLE XML doc not needed here

                //  xmldoc = new DocumentImpl(dbconn);

                xmldoc = new DocumentImpl(packageDocid, false);

                if (xmldoc == null) {

                }

              }

              catch(Exception e)

              String docid_org = xmldoc.getDocID();

              if (docid_org == null) {

              }

              docid   = docid_org.trim();

              docname = xmldoc.getDocname();

              document = new StringBuffer();

              completeDocid += rev;

              document.append("<docid>").append(completeDocid);

              document.append("</docid>");

            document = new StringBuffer();

            completeDocid += rev;

            document.append("<docid>").append(completeDocid).append("</docid>");

            if (docname != null) {

            MetaCatUtil.debugMessage("Time for execute access extended query: "

                              +(extendedAccessQueryEnd-extendedQueryStart), 30);

            MetaCatUtil.debugMessage("Extended query: "+ extendedQuery, 30);

            pstmt = dbconn.prepareStatement(extendedQuery);

            //increase dbconnection usage count

            // get attribures return

          }//if doclist lenght is great than zero

        }//if has extended query

          //String connstring = "metacat://"+util.getOption("server")+"?docid=";

          String connstring = "%docid=";

          String docidkey = (String)docidkeys.nextElement();

          pstmt.execute();

          rs = pstmt.getResultSet();

          tableHasRows = rs.next();

   * A method to return search result after running a query which return

   * field have attribue

   */

  {

    StringBuffer XML = null;

    String sql = null;

    // if has attribute as return field

    if (squery.containAttributeReturnField())

    {

      try

      {

        dbconn=DBConnectionPool.getDBConnection("DBQuery.getAttributeValue");

    }//try

    catch (SQLException e)

    {

                            +e.getMessage(), 30);

    }

    finally

        }

        String docidPlusVersion=((String)docIdList.elementAt(i))

        //create new documentImpl object

    byte[] byteString = null;

    ZipEntry zEntry = null;

    // this is data file; add file to zip

    if (!filePath.endsWith("/"))

    {

      filePath += "/";

    }//try

    catch (IOException ioe)

    {

    }//catch

  }//addDataFileToZipOutputStream()

      docImpls=new DocumentImpl(docId);

      //checking if the user has the permission to read the documents

      {

        zOut = new ZipOutputStream(out);

        //if the docImpls is metadata

        version=currentVersion;

        //get package zip entry name

        //it should be docId.revsion.package

        //get the whole id list for data packadge

        docIdList=getCurrentDocidListForDataPackage(packageId);

        //get the whole documentImple object

      else  //for an old version

      {

        //get the whole id list for data packadge

        docIdList=getOldVersionDocidListForDataPackage(docIdString);

          //create a docmentImpls object (represent xml doc) base on the docId

          docImpls=(DocumentImpl)documentImplList.elementAt(i);

          //checking if the user has the permission to read the documents

          {

            //if the docImpls is metadata

            if ((docImpls.getDoctype()).compareTo("BIN")!=0)

      return xmlFieldValue;

    }

  }

}