Metacat

/**

 *  '$RCSfile$'

 *    Purpose: class that implements the MARINE interface to the

 *             metadata database.

 *  Copyright: 2000 Regents of the University of California and the

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Chad Berkley

 *

 *   '$Author$'

 *     '$Date$'

 * '$Revision$'

 */

import java.util.*;

import javax.servlet.*;

import javax.servlet.http.*;

import java.net.*;

import java.sql.*;

import org.xml.sax.*;

import org.xml.sax.helpers.*;

import oracle.xml.parser.v2.*;

import oracle.xml.parser.v2.XMLParser;

	private marineUtil util;

	private String resultStyleURL;

	private String saxparser;

	private String defaultdatapath;

	private String executescript;

	private DBQuery queryobj;

	private DBReader docreader;

	private DBTransform dbt;

	private Connection conn;

	private PropertyResourceBundle options;

        private ServletContext	context = null;

	  Initializes the servlet and creates a connection to

	  the database

 	**/

	{

		util = new marineUtil();

		xmlcatalogfile = util.getOption("xmlcatalogfile");

      		saxparser = util.getOption("saxparser");

      		defaultdatapath = util.getOption("defaultdatapath");

      		executescript = util.getOption("executescript");

      		{

        		docreader = new DBReader(conn);

        		dbt = new DBTransform(conn);

      		}

      		catch(Exception e)

      		{

	}

	  Handles any GET requests

	**/

	                   HttpServletResponse response)

    			throws ServletException, IOException

    	{

    		handleGetOrPost(request, response);

    	}

    	  Handles and POST requests

    	**/

    	                    HttpServletResponse response)

    			throws ServletException, IOException

    	{

    		handleGetOrPost(request, response);

    	}

    	  This method is called from doGet and doPost.  It handles

    	  each request and sends back the response. It also handles

    	  the XSL tranformations

    	**/

    			HttpServletResponse response)

    			throws ServletException, IOException

    	{

    		response.setContentType("text/html");

    		PrintWriter out = response.getWriter();

    		try

    		{

    		catch(Exception e)

      		{

    		String name = null;

    		String[] value = null;

    		String[] docid = new String[3];

    		Hashtable params = new Hashtable();

    		Enumeration paramlist = request.getParameterNames();

    		while (paramlist.hasMoreElements())

    		{

      			name = (String)paramlist.nextElement();

      			value = request.getParameterValues(name);

      			// Decode the docid and mouse click information

      			if (name.endsWith(".y"))

      			{

        			docid[0] = name.substring(0,name.length()-2);

        			//out.println("docid => " + docid[0]);

        			params.put("docid", docid);

        			name = "ypos";

      			}

      			if (name.endsWith(".x"))

      			{

        			name = "xpos";

      			}

      			//out.println(name + " => " + value[0]);

      			params.put(name,value);

    		}

		// Determine what type of request the user made

    		// if the action parameter is set, use it as a default

    		// but if the ypos param is set, calculate the action

    		// needed

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

    		long ypos = 0;

    		try

    		{

      			ypos = (new Long(

      			((String[])params.get("ypos"))[0]).longValue());

      			//out.println("<P>YPOS IS " + ypos);

    		}

    		catch (Exception npe)

    		{

    		//Jivka's login code should go here!

    		   {

    		      //send any type of query action to handleQueryAction

      			   handleQueryAction(out, params, response);

    		   }

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

    		   {

    		   	   handleInitAction(out);

    		   }

    		   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);

    		   }

    		   else

    		   {

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

      			               "Please report this error.");

    		   }

    		   conn.close();

		{

		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("marineServlet: SQLError " +

                	                   "in handleViewAbstractAction");

                	sqle.printStackTrace(System.err);

                catch(Exception e)

                {

                	                   "in handleViewAbstractAction");

                	e.printStackTrace(System.err);

                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];

        	    doc = docreader.readXMLDocument(docid);

        	    XSLStylesheet style = new XSLStylesheet(

                                    new URL(docStyleURL), null);

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

                                   (Reader)(new StringReader

                                   (doc)),null);

          	    htmldoc.print(out);

          	}

          	catch(Exception e)

          	{

          		                   "handleViewDocumentationAction");

          		e.printStackTrace(System.err);

        }

        {

        	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(Exception e)

          	{

          		System.err.println("marineServlet: error in handleQueryAction (try1)");

          		e.printStackTrace(System.err);

          	}

        }

        /**

          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.

	**/

               HttpServletResponse response)

        {

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

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

      		Hashtable doclist = null;

      		String[] doctypeArr = null;

      		String doctype = null;

      		Reader xmlquery = null;

       	 		doctypeArr = (String[])params.get("doctype");

        		doctype = null;

        		if (doctypeArr != null)

        		{

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

        		}

        		if (doctype != null)

        		{

          			xmlquery = new StringReader(DBQuery.createQuery(query,doctype));

        		}

        		else

        		{

          			xmlquery = new StringReader(DBQuery.createQuery(query));

        		}

      		}

      			doctypeArr = (String[])params.get("doctype");

        		doctype = null;

        		if (doctypeArr != null)

        		{

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

        		}

        		// for some reason the doctype="ANY" wildcard is not working

        		//correctly. For this reason, I have ommited the doctype

        		//here for the time being (7/20).

        		xmlquery = new StringReader(createSQuery(params));

      		}

      		{

      			   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(Exception e)

          		{

          			e.printStackTrace(System.err);

      		{

      		if (queryobj != null)

      		{

      			doclist = queryobj.findDocuments(xmlquery);

      		else

      		{

      		}

 		//and owner information for the query request

 		extendedQuery = createExtendedQuery(doclist);

      		StringBuffer resultset = new StringBuffer();

      		// Print the resulting root nodes

      		String docid;

      		String document = null;

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

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

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

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

      		//values between queries.

      		Enumeration doclistkeys = doclist.keys();

      		{

        		docid = (String)doclistkeys.nextElement();

        		document = (String)doclist.get(docid);

        		{

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

        			          extendedQuery.get(docid).toString() +

        			          "</document>");

        		}

        		else

        		{

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

      		resultset.append("</resultset>");

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

      		if (qformat.equals("xml"))

      		{

        		// set content type and other response

        		// header fields first

        		response.setContentType("text/xml");

        		out.println(resultset.toString());

      		}

      		else if(qformat.equals("html"))

      		{

        		// set content type and other response header

        		// fields first

        		response.setContentType("text/html");

			//transform the xml to html with XSL

          			XSLStylesheet style = new XSLStylesheet(

                                    new URL(resultStyleURL), null);

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

                                   (Reader)(new StringReader

                                   (resultset.toString())),null);

          			htmldoc.print(out);

        		}

        		catch (Exception e)

        		{

          	        e.printStackTrace(System.err);

      		}

      	}

      	   creates the sql query for the extended information

      	   displayed upon successful query

      	**/

      		Hashtable result = new Hashtable();

      		ResultSet surNameResults = null;

      		ResultSet organizationNameResults = null;

      		ResultSet dateResults = null;

      		String docid = null;

      		String data = null;

      		Object docidObj = null;

      		Enumeration docids = docs.keys();

      		//find all of the owners first names

		String givenNameQuery = "select docid, nodedata from xml_nodes" +

		   " where parentnodeid in" +

		   " (select nodeid from xml_index where path like 'givenName')" +

		   " and parentnodeid in" +

 		   " (select nodeid from xml_nodes where nodename like 'givenName'" +

  		   " and parentnodeid in" +

                   " (select nodeid from xml_nodes where nodename like 'individualName'" +

                   " and parentnodeid in" +

                   " (select parentnodeid from xml_nodes where nodename like 'roleCode'" +

                   " and nodeid in" +

                   " (select parentnodeid from xml_nodes where" +

                   " nodedata = 'Owner'" +

                   " and parentnodeid in" +

                   " (select nodeid from xml_index where path like 'roleCode')))))";

                //find all of the owners last names

		String surNameQuery = "select docid, nodedata from xml_nodes" +

		   " where parentnodeid in" +

		   " (select nodeid from xml_index where path like 'surName')" +

		   " and parentnodeid in" +

 		   " (select nodeid from xml_nodes where nodename like 'surName'" +

  		   " and parentnodeid in" +

                   " (select nodeid from xml_nodes where nodename like 'individualName'" +

                   " and parentnodeid in" +

                   " (select parentnodeid from xml_nodes where nodename like 'roleCode'" +

                   " and nodeid in" +

                   " (select parentnodeid from xml_nodes where" +

                   " nodedata = 'Owner'" +

                   " and parentnodeid in" +

                   " (select nodeid from xml_index where path like 'roleCode')))))";

		//find all of the organizations

		String organizationNameQuery = "select docid, nodedata from xml_nodes" +

		   " where parentnodeid in" +

		   " (select nodeid from xml_index where path like 'organizationName')";

                //find all of the creation and update dates

                String dateQuery = "select docid, date_created, date_updated" +

                   " from xml_documents";

            //execute the queries

                pstatement = conn.prepareStatement(givenNameQuery);

                pstatement.execute();

                givenNameResults = pstatement.getResultSet();

                pstatement = conn.prepareStatement(surNameQuery);

                pstatement.execute();

                surNameResults = pstatement.getResultSet();

		pstatement = conn.prepareStatement(organizationNameQuery);

                pstatement.execute();

                organizationNameResults = pstatement.getResultSet();

      		pstatement = conn.prepareStatement(dateQuery);

                pstatement.execute();

                dateResults = pstatement.getResultSet();

                }

                e.printStackTrace(System.err);

                 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();

                 }

             }

                e.printStackTrace(System.err);

             return result;

      	/**

      	   creates the xml query for the browse list

      	**/

      	{

      		String query;

      		query = "<?xml version=\"1.0\"?>";

		query += "<!DOCTYPE pathquery PUBLIC \"-//NCEAS//pathquery-1.0//EN\" " +

    		query += "<meta_file_id>unspecified</meta_file_id>";

    		query += "<querytitle>unspecified</querytitle>";

    		query += "<querygroup operator=\"union\">";

    		query += "<queryterm casesensitive=\"false\" " +

    				         "searchmode=\"contains\">";

    		query += "<value>";

    		query += "</queryterm>";

    		query += "</querygroup></pathquery>";

    		return query;

      	}

      	    a doctype and returns a structured xml query based

      	    on the parameters.

      	**/

      	private String createSQuery(Hashtable params, String doctype)

	{

    		String query;

    		Enumeration elements;

    		Enumeration keys;

    		Object nextkey;

    		Object nextelement;

		query += "<!DOCTYPE pathquery PUBLIC \"-//NCEAS//pathquery-1.0//EN\" " +