Metacat

/**

 *        Name: ReaderElement.java

 *     Purpose: A Class that represents an XML element and its contents,

 *              and can build itself from a database connection

 * Institution: National Center for Ecological Analysis and Synthesis

 *   Copyright: 2000

 *     Authors: Matt Jones

 *

 *     Version: '$Id: ReaderElement.java 23 2000-04-11 20:56:55Z jones $'

 */

//package project;

import java.sql.*;

import java.io.IOException;

import java.util.Vector;

import java.util.Enumeration;

public class ReaderElement extends BasicElement {

    private Connection	conn;

    private Vector	children;

    public ReaderElement (Connection conn, long nodeid) {

      this.conn = conn;

      //Lookup data for self

      getElementInfo(nodeid);

      //Lookup list of child nodes

      //foreach childnode (childid,childtype)

      //  if (type.equals("ATTRIBUTE")) {

      //    add the att to attribute hash

      //  else (type.equals("ELEMENT")) {

      //    ReaderElement child = new ReaderElement(childid);

      //    add child to vector of children

      //  }

      //}

    }

    private void getElementInfo(long nodeid) {

      long element_id=0;

      long parentnodeid=0;

      String nodetype=null;

      String nodename=null;

      String nodedata=null;

      PreparedStatement pstmt;

      try {

        pstmt =

          conn.prepareStatement("SELECT nodeid,parentnodeid,nodetype, " +

                  "nodename,nodedata FROM xml_nodes WHERE nodeid = ?");

        // Bind the values to the query

        pstmt.setLong(1, nodeid);

        pstmt.execute();

        try {

          ResultSet rs = pstmt.getResultSet();

          try {

            boolean tableHasRows = rs.next();

            if (tableHasRows) {

              try {

                element_id = rs.getLong(1);

                parentnodeid = rs.getLong(2);

                nodetype = rs.getString(3);

                nodename = rs.getString(4);

                nodedata = rs.getString(5);

              } catch (SQLException e) {

                System.out.println("Error with getInt: " + e.getMessage());

              }

            }

          } catch (SQLException e) {

            System.out.println("Error with next: " + e.getMessage());

          }

        } catch (SQLException e) {

          System.out.println("Error with getrset: " + e.getMessage());

        }

        pstmt.close();

      } catch (SQLException e) {

        System.out.println("Error getting id: " + e.getMessage());

      }

      if (nodetype.equals("ELEMENT")) {

        setElementID(element_id);

        setParentID(parentnodeid);

        setTagName(nodename);

        content.append(nodedata);

      }

    }

}