Metacat

	<link rel="stylesheet" type="text/css" href="/xmltodb/lib/marine/rowcol.css" />

      <script language="JavaScript">

        function gotoNceas()

        {

          window.location="http://www.nceas.ucsb.edu";

        }

      </script>

        <table width="100%">

        <tr>

          <td align="left" valign="top">

            <form action="http://alpha.nceas.ucsb.edu/servlets/marineServlet#browse"

                  method="POST">

               <input type="hidden" name="action" value="squery" />   

    	       <input type="hidden" name="query" value="" />

    	       <input type="hidden" name="qformat" value="html" />

               <input type="hidden" name="operator" value="UNION" />

               <input type="hidden" name="anyfield" value="%" />

               <input type="submit" value="Browse the Database" size="15" />

            </form>   

          </td>

          <td align="center" valign="bottom">

            <img src="/xmltodb/lib/marine/logo-line.gif" alt="NCEAS Logo" onClick="gotoNceas()" />

          </td>

          <td align="right" valign="top">

            <form action="http://alpha.nceas.ucsb.edu/servlets/marineServlet#browse"

                  method="POST">

               Quick Search: <input type="text" name="query" size="10" />

               <input type="hidden" name="action" value="query" />   

    	       <input type="hidden" name="qformat" value="html" />

    	       <input type="hidden" name="operator" value="UNION" />

    	     </form>

    	   </td>

    	 </tr>

        </table>

        <hr />

        <font size="2">

        <p class="intro">

          This page is used to query information for 

          <a href="http://www.mms.gov/omm/pacific/enviro/mint.htm">MARINE</a> scientists from

          the NCEAS Ecological Metadata Database.  For more information on

          this project, please read the 

          <a href="https://www2.nceas.ucsb.edu/admin/db/web.ppage?projid_in=2841">

          proposal abstract</a>.

        </p>

        <p class="intro">

           Each step below contains several fields relating to a part of the dataset.  

           You may also browse

           the entire database by simply clicking the browse link at the top of the page.

           Clicking on the buttons next to each data line will give you more

           information about the dataset or allow you to download the entire dataset.  

           Please note some fields in the query forms will not be pertinent to your dataset.  

           If this is the case, simply leave any field blank to omit it from the searching.  

        </p>

        <p class="intro">

           Note that the wildcard character is a percent sign (%).  It may be used in any

           field to denote "any" value.  For example, the query "do%" would return "document"

           or "dog" or "domino" or "dolphin", etc.  Placing a single percent sign in a field

           will return any document that contains that field.  Placing a percent sign in

           the "Any Field" field is equivalent to browsing the database (i.e. it will return

           every document).  

        </p>

        </font>

        <form action="http://alpha.nceas.ucsb.edu/servlets/marineServlet#browse" 

             <td valign="bottom" width = "25">

        	<img src="http://alpha.nceas.ucsb.edu/xmltodb/lib/marine/step1.jpg" />

             <td>

               <h4>Keywords and Title</h4>

               <p>

               <font size="2">

                 Enter any keywords that might partain to the dataset you are looking for.  

                 The "Any Field" text box will search for any field in any document for 

                 the text you provide.  The title and alternate title will search for text 

                 in the title or alternate title fields of a document only.  Fields left 

                 blank will not be used in the search criteria.

               </font></p>

             </td> 

                <td>

                  <input type="text" name="title" size="15">

                  <xsl:attribute name="value">

                  <xsl:value-of select="resultset/query/title" />

                  </xsl:attribute>

                  </input>

                </td>

                <td>Any Field:</td>

                <td>

                  <input type="text" name="anyfield" size="15">

                  <xsl:attribute name="value">

                  <xsl:value-of select="resultset/query/anyfield" />

                  </xsl:attribute>

                  </input>

                </td>

                <td>Alternate Title:</td>

             	<td>        

		  <input type="text" name="alttitle" size="15">

             	  <xsl:attribute name="value">

                  <xsl:value-of select="resultset/query/alttitle" />

                  </xsl:attribute>

                  </input>

                </td>

                <td>Keywords:</td>

                <td>

                  <input type="text" name="keyword" size="15">

                  <xsl:attribute name="value">

                  <xsl:value-of select="resultset/query/keyword" />

                  </xsl:attribute>

                  </input>

                </td>

             <td valign="bottom" width="25">

        	<img src="http://alpha.nceas.ucsb.edu/xmltodb/lib/marine/step2.jpg" />

             </td>

             <td>

                <h4>Dataset Owner Information</h4>

        	<p>

        	   <font size="2">

        	   Enter data about the owner of the dataset.  There may be more than one

        	   owner of any given dataset.  Any field(s) left blank will not be used

        	   in the search criteria.

        	   </font>

                <td>First Name:</td>

                <td> 

                  <input type="text" name="given_name" size="15">

             	  <xsl:attribute name="value">

                  <xsl:value-of select="resultset/query/given_name" />

                  </xsl:attribute>

                  </input>

                </td>

                <td>Last Name:</td>

                <td> <!-- <input type="text" name="surname" /> -->

                  <input type="text" name="surname" size="15">

             	  <xsl:attribute name="value">

                  <xsl:value-of select="resultset/query/surname" />

                  </xsl:attribute>

                  </input>

                </td>

             <tr>

             	<td>Organization:</td>

             	<td> 

             	  <input type="text" name="organizationName" size="15">

             	  <xsl:attribute name="value">

                  <xsl:value-of select="resultset/query/organizationName" />

                  </xsl:attribute>

                  </input>

                </td>

             	<td>Email Address:</td>

             	<td> 

             	  <input type="text" name="electronicMailAddress" size="15">

             	  <xsl:attribute name="value">

                  <xsl:value-of select="resultset/query/electronicMailAddress" />

                  </xsl:attribute>

                  </input>

                </td>

             </tr>

           </table>

             <td valign="bottom" width="25">

        	<img src="http://alpha.nceas.ucsb.edu/xmltodb/lib/marine/step3.jpg" />

             </td>

             <td>

        	<h4>Query the Database</h4>

        	<p>

        	   <font size="2">

        	   Click the Query button to submit your query.  The results will be

        	   displayed below under the heading "Results".

        	   </font>

        <input type="submit" value="Query" />

        <input type="reset" value="Clear Form" />

	<font size="3"><xsl:number value="count(resultset/document)" /> documents found.</font>

	<!-- This tests to see if there are returned documents,

	     if there are not then don't show the query results

	-->

	<xsl:if test="count(resultset/document) &gt; 0">

        <th><xsl:text>Owner</xsl:text></th>

        <th><xsl:text>Organization</xsl:text></th>

        <th><xsl:text>Creation Date</xsl:text></th>

        <th><xsl:text>Last Updated</xsl:text></th>

          <xsl:sort select="doctitle"/>

                         mod 2 = 1">/xmltodb/lib/marine/whiteMenu.jpg</xsl:when>

                         mod 2 = 0">/xmltodb/lib/marine/blueMenu.jpg</xsl:when>

          </td>

          <td><xsl:value-of select="./givenName" />

              <xsl:text>&nbsp;</xsl:text>

              <xsl:value-of select="./surName" />

              <xsl:text>&nbsp;</xsl:text>

          </td>

          <td><xsl:value-of select="./organizationName" />

              <xsl:text>&nbsp;</xsl:text>

          </td>

              <xsl:value-of select="./date_created" />

              <xsl:text>&nbsp;</xsl:text>

          <td>

              <xsl:value-of select="./date_updated" /> 

              <xsl:text>&nbsp;</xsl:text>

          </td>

        </xsl:if>

 .page    {font-family: Tahoma, sans-serif; background-color:white}

 .emlbody    {font-family: Tahoma, sans-serif; background-color:white}

 .rowodd  {background-color: #CCCCCC; color: black; vertical-align: top}

 .roweven {background-color: #F8F8F8; color: black; vertical-align: top}

 .rowlight {background-color: #0099C8; color: black;  vertical-align: top}

 .rowwhite {background-color: #FFFFFF; color: black; vertical-align: top}

 .stephead {background=color: #000000; color: white;}

 .coleven {}

 .colodd  {}

 .shaded  {background-color: #DDDDDD; color: black; font-size: -1}

docStyleURL=http://alpha.nceas.ucsb.edu/xmltodb/lib/marine/marineDoc.xsl

<?xml version="1.0" ?>

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

  <xsl:output method="html"/>

  <xsl:template match="/">

  <!--

    List elements in the following order:

    - ID

    - Title

    - Alt title

    - URL

    - originator(s)

    - abstract

    - keyword info

      - keyword, keyword type

    - additionalInfo

  -->

  <html>

  <head>

  <title>

  <xsl:value-of select="title" />

  </title>

  </head>

  <body>

  <h1>

  <xsl:value-of select-"title" />

  </h1>

  <h2>

  <xsl:value-of select="alternateTitle" />

  </h2>

  <font size = 5>

  ID: <xsl:value-of select="identifier" />

  </font>

  <h3>URL:

  <xsl:value-of select="URL" />

  </h3>

  <xsl:for-each select="originator">

   <p>

    <xsl:value-of select="salutation" />

    <xsl:value-of select="givenName" />

    <xsl:value-of select="surName" />

    <br/>

    <xsl:value-of select="deliveryPoint" />

    <br/>

    <xsl:value-of select="city" />, 

    <xsl:value-of select="adminitrativeArea />

    <xsl:value-of select="postalCode" />

    <br/>

    <xsl:value-of select="electronicMailAddress" />

    <br/>

    <xsl:value-of select="onlineResource/URL" />

    <br/>

    <xsl:value-of select="hoursOfService" />

    <br/>

    <xsl:value-of select="contactInstructions" />

    <br/>

    voice:<xsl:value-of select="voice" />

    <br/>

    fax:<xsl:value-of select="facsimile" />

    <br/>

   </p> 

  </xsl:for-each>

  </body>

  </html>

<script language="JavaScript">

window.location="http://alpha.nceas.ucsb.edu/servlets/marineServlet?action=init&query=&doctype=any&qformat=html";

</script>

<center><img src="/xmltodb/lib/marine/logo-line.gif"></center>

<center><h4>Connecting to the MARINE Database...Please Wait</h4></center>

<noscript>

Please click 

<a href="http://alpha.nceas.ucsb.edu/servlets/marineServlet?action=init&query=&doctype=any&qformat=html"> 

 here</a> to enter the MARINE database.  To disable this message in the future please

 enable JavaScript on your browser.

</noscript>

	private String docStyleURL;

	private String msg=null;

	private ServletConfig		config = null;

        private ServletContext	context = null;

	/**

	  Initializes the servlet and creates a connection to 

	  the database

 	**/

		docStyleURL = util.getOption("docStyleURL");

      		    conn = util.openDBConnection();  

      		    e.printStackTrace(System.err);

	/**

	  Handles any GET requests 

	**/

    	/**

    	  Handles and POST requests

    	**/

    	/**

    	  This method is called from doGet and doPost.  It handles

    	  each request and sends back the response. It also handles

    	  the XSL tranformations

    	**/

      			System.err.println("marineServlet: Exception in init in handleGetOrPost: ");

      			e.printStackTrace(System.err);

      			if (ypos <= 20) 

        			action = "viewabstract";

      			else if (ypos > 20 && ypos <= 45) 

        			action = "viewdocumentation";

      			else if (ypos > 45) 

        			action = "download";

      			npe.printStackTrace(System.err);

    		if(action.equals("query") || action.equals("squery")

    		    //send any type of query action to handleQueryAction

    		}

    		else if(action.equals("viewabstract"))

    		{

    		    //when the user clicks the view abstract graphic

    			handleViewAbstractAction(out, params, response);

    		}

    		else if(action.equals("viewdocumentation"))

    		{

    		    //when the user clicks the view documentation graphic

    		 	handleViewDocumentationAction(out, params, response);

    		}

    		else if(action.equals("download"))

    		{

    		    //when the user clicks the download graphic

    			handleDownloadAction(out, params, response);

    		}

      			out.println("Error: action " + action + " not registered" +

			//out.print("There was an exception, check the log file for details.<br>");

			//out.print("msg:<br> ");

			e.printStackTrace(System.err);

			//out.println("<br><br>marineServlet says: ok");

			//out.close();

		System.err.println("msg: " + msg);

		out.close();

        /**

          Handles when the user clicks the View Abstract graphic.

        **/

	private void handleViewAbstractAction(PrintWriter out, Hashtable params, 

               HttpServletResponse response)

        {

         	PreparedStatement pstatement;

         	ResultSet rs = null;

        	String markup = null;

        	String docid = ((String[])params.get("docid"))[0];

        	//this query is based on the eml-resource datatype

        	//it will NOT work with eml-dataset documents because

        	//eml-dataset removes the abstract data an extra level

        	//from the <abstract> tag.

        	String querysql = "select nodedata from xml_nodes" +

                             " where parentnodeid in" +

                             " (select nodeid from xml_nodes where" +

                             " nodename like 'abstract') and docid like '" +

                             docid + "'";

                try{

                   //create the query, execute it, get the result

                   pstatement = conn.prepareStatement(querysql);

                   pstatement.execute();

                   rs = pstatement.getResultSet();

                   boolean moreRows = rs.next();

                   //print out the html.  This does not use any XSL

                   markup = "<html><body bgcolor=\"white\"><h1>Abstract</h1>";

                   while(moreRows)

                   {

                	   markup += "<p>" + rs.getString(1) + "</p>";

                	   moreRows = rs.next();

                   }

                   markup += "</body></html>";

                   }

                catch(SQLException sqle)

                {

                	System.err.println("Error returning abstract");

                } 

                catch(Exception e)

                {

                	System.err.println("error in handleviewabstract " +

                	    e.fillInStackTrace().toString());

                }

                out.println(markup); //send the output to the browser

        }

        /**

          Handles when the user clicks the View Documentation graphic.

        **/

        private void handleViewDocumentationAction(PrintWriter out, Hashtable params, 

               HttpServletResponse response)

        {

        	String doc = null;

        	String docid = ((String[])params.get("docid"))[0];

        	//out.println("view documentation not yet implemented");

		try{        	

        	    doc = docreader.readXMLDocument(docid);

        	    XMLDocumentFragment htmldoc = null;

        	    XSLStylesheet style = new XSLStylesheet(

                                    new URL(docStyleURL), null);

          	    htmldoc = (new XSLProcessor()).processXSL(style, 

                                   (Reader)(new StringReader

                                   (doc)),null);

          	    htmldoc.print(out);

          	}

          	catch(Exception e)

          	{

          		System.err.println("error retrieving document details.");

          		System.err.println(e.fillInStackTrace().toString());

          	}

        }

        /**

          Handles when the user clicks the Download graphic.

        **/

        private void handleDownloadAction(PrintWriter out, Hashtable params, 

               HttpServletResponse response)

	{

		out.println("download not yet implemented");

	}

	/**

	  This method handles any and all query requests including the 

	  init request.  It separates the queries into 3 classes.

	  1) query-This executes a free text search.

	  2) squery-This executes a structured query.

	  3) init-This executes a null query.

	  After executing the query, the xml results are sent through

	  the XSL processor and returned to the browser as HTML (if

	  qformat="html").  If qformat="xml" the xml document is returned

	  without transformation.

	**/

      		Hashtable extendedQuery = new Hashtable();

      			try{

      			   StringBuffer temp = new StringBuffer();

      			   XMLDocumentFragment html = null;

      			   temp.append("<?xml version=\"1.0\"?>\n");

      		       temp.append("<resultset></resultset>\n");

      		       //create a null query and run it through the

      		       //xsl processor to create the opening page      			

      			   XSLStylesheet style = new XSLStylesheet(

                                    new URL(resultStyleURL), null);

          		   html = (new XSLProcessor()).processXSL(style, 

                                   (Reader)(new StringReader(temp.toString())), null);

          		   html.print(out);

          		   }

          		catch(IOException ioe)

          		{

          			System.err.println("IO error in init");

          		}

          		catch(XSLException xsle)

          		{

          			System.err.println("XSL exception in init");

          		}

          		catch(Exception e)

          		{

          			System.err.println("error in init");

          		}

        		msg += "marineServlet: Error handling query -- illegal action value";

 		//get the date_created, date_updated, organization

 		//and owner information for the query request

 		extendedQuery = createExtendedQuery(doclist);

      		//queryname contains the xmlquery.  This sends the query

      		//itself back to the page to refresh the text boxes

      		//Without the queryname, the text boxes do not retain their

      		//values between queries.

      		//add the returned documents to the xml result

        		if(extendedQuery.containsKey(docid))

        		{

        			resultset.append("  <document>" + document +

        			          extendedQuery.get(docid).toString() +

        			          "</document>");

        		}

        		else

        		{

        			resultset.append("  <document>" + document + 

        		}

			//transform the xml to html with XSL

      	private Hashtable createExtendedQuery(Hashtable docs)

      		ResultSet givenNameResults = null;

      		ResultSet surNameResults = null;

      		ResultSet organizationNameResults = null;

      		ResultSet dateResults = null;

      		String docid = null;

      		String data = null;

      		Object docidObj = null;

            //execute the queries

             try{

                 boolean moreRows = givenNameResults.next();

                 //add the givenName information to the xml.

                 while(moreRows)

                 {

                 	docid = givenNameResults.getString(1);

             	    data = givenNameResults.getString(2);

             	    //check if the original result set contains this docid

             	    if(docs.containsKey(docid))

             	    {

             		    String markup = "<givenName>" + data + "</givenName>";

             		    result.put(docid, markup);

             	    }

             	    moreRows = givenNameResults.next();

                 }	

                 moreRows = surNameResults.next();

                 //add the surName information to the xml.

                 while(moreRows)

                 {

             	    docid = surNameResults.getString(1);

             	    data = surNameResults.getString(2);

             	    //check if the original result set contains this docid

             	    if(docs.containsKey(docid))

             	    {

             		    //check if this key is already in the result hashtable

             		    //i.e. there was a givenName for that docid.

             		    if(result.containsKey(docid))

             		    {

             			    String markup = result.get(docid).toString();

             			    markup += "<surName>" + data + "</surName>";

             			    result.remove(docid);

             			    result.put(docid, markup);

             		    }

             		    else

             	 	    { 

             			    String markup = "<surName>" + data + "</surName>";

             			    result.put(docid, markup);

             		    }

             	    }

             	    moreRows = surNameResults.next();

                 }

                 //add the organizationName information to the xml.

                 moreRows = organizationNameResults.next();

                 while(moreRows)

                 {

             	    docid = organizationNameResults.getString(1);

             	    data = organizationNameResults.getString(2);

             	    //check if the original result set contains this docid

             	    if(docs.containsKey(docid))

             	    {

             		    //check if this key is already in the result hashtable

             		    //i.e. there was a givenName for that docid.

             		    if(result.containsKey(docid))

             		    {

             			    String markup = result.get(docid).toString();

             			    markup += "<organizationName>" + data + "</organizationName>";

             			    result.remove(docid);

             			    result.put(docid, markup);

             		    }

             		    else

             	 	    { 

             			    String markup = "<organizationName>" + data + "</organizationName>";

             			    result.put(docid, markup);

             		    }

             	    }

             	    moreRows = organizationNameResults.next();

                 }

                 moreRows = dateResults.next();

                 //add the date information to the xml.

                 while(moreRows)

                 {

             	    docid = dateResults.getString(1);

             	    data = dateResults.getString(2); //date_created

             	    String data2 = dateResults.getString(3); //date_updated

             	    //check if the original result set contains this docid

             	    if(docs.containsKey(docid))

             	    {

             		    //check if this key is already in the result hashtable

             		    //i.e. there was a givenName for that docid.

             		    if(result.containsKey(docid))

             		    {

             			    String markup = result.get(docid).toString();

             			    markup += "<date_created>" + data + "</date_created>";

             			    markup += "<date_updated>" + data2 + "</date_updated>";

             			    result.remove(docid);

             			    result.put(docid, markup);

             		    }

             		    else

             	 	    { 

             			    String markup = "<date_created>" + data + "</date_created>";

             			    markup += "<date_updated>" + data2 + "</date_updated>";

             			    result.put(docid, markup);

             		    }

             	    }

             	    moreRows = dateResults.next();

                 }

             }

             catch(SQLException e)

             {

             	System.err.println("Error in SQL " + e.getMessage());

             }

             return result;

    		query += "%";           //return everything

    		queryname = " ";

    		//anyfield is a special case because it does a 

    		//free text search.  It does not have a <pathexpr>

    		//tag.

    			         queryname += "<anyfield>";

    			         queryname += ((String[])params.get("anyfield"))[0];

    			         queryname += "</anyfield>";

    		//this while loop finds the rest of the parameters

    		//and attempts to query for the field specified

    		//by the parameter.

    			//make sure we aren't querying for any of these

    			//parameters.

    				//add the query value

    				query += "</value><pathexpr>" +

    				//add the path to query by 

    				//add the query back into the xml to fill in 

    				//the text boxes.

    				queryname += "<" + nextkey.toString() + ">";

    				queryname += ((String[])nextelement)[0];

    				queryname += "</" + nextkey.toString() + ">";

    //System.err.println(getOption("dbDriver") + " " + getOption("defaultDB") + " " +

    //                 getOption("user") + " " +getOption("password"));