Metacat

/**

 *        Name: DBElement.java

 *     Purpose: A Class that represents an XML element and can

 *		write its contents to a database connection

 * Institution: National Center for Ecological Analysis and Synthesis

 *   Copyright: 1998

 *     Authors: Matt Jones

 *

 *     Version: '$Id$'

 */

//package project;

import com.sun.xml.tree.ElementNode;

import org.w3c.dom.DOMException;

import org.w3c.dom.Element;

import org.w3c.dom.Node;

import org.w3c.dom.Text;

import java.io.IOException;

public class DBElement extends ElementNode {

      super();

    };

     * Writes this element and all of its children out to the

     * given database connection

     */

    public void writeXmlToDB(Connection conn) throws IOException {

/*

        if (attributes != null)

	    attributes.writeXml(conn);

*/

        int maxid=0;

        Statement stmt;

        try {

          stmt = conn.createStatement();

          stmt.execute("SELECT MAX(nodeid) FROM xml_elements");

          try {

            ResultSet rs = stmt.getResultSet();

            try {

              boolean tableHasRows = rs.next();

              if (tableHasRows) {

                try {

                  maxid = rs.getInt(1);

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

          }

          stmt.close();

        } catch (SQLException e) {

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

        }

        try {

          PreparedStatement pstmt = conn.prepareStatement(

                "INSERT INTO xml_elements(nodeid, nodename) values (?, ?)");

          // Add an element as element number 1500

          pstmt.setInt(1, maxid+1); // The first ? is for NODEID

          pstmt.setString(2, getTagName());// The second ? is for NODENAME

          // Do the insertion

          pstmt.execute();

          pstmt.close();

        } catch (SQLException e) {

          System.out.println(e.getMessage());

        }

	if (hasChildNodes())

	    writeChildrenXmlToDB(conn);

        System.out.println("ID: " + maxid + "\tTag: " + getTagName());

      NodeList children = getChildNodes();

      if (children != null) {

        for (int i = 0; i < children.getLength(); i++) {

          if (children.item(i) instanceof ElementNode) {

            ((DBElement)children.item(i)).writeXmlToDB(conn);

          } else {

            System.out.println("    Text Node skipped.");

          }

        }

      }

    }

    public String toString ()

    {

	StringBuffer	value = new StringBuffer ();

	value.append ('<');

	value.append (getTagName ());

	value.append (getAttributes ().toString ());

	value.append ('>');

	return value.toString ();

    }

}