Metacat

import java.util.Stack;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.sql.ResultSet;

  private String docId = null;

  private Stack  subTreeNodeStack = null;

    /**

     * Defualt constructor

     */

    public SubTree()

    {

    }

    /**

     * Constructor of subtree

     */

    public SubTree(String myDocId, String mySubTreeId, 

                  long myStartNodeId, long myEndNodeId)

                  throws McdbException

    {

      this.docId = myDocId;

      MetaCatUtil.debugMessage("Docid of Subtree: " + docId, 30);

      this.subTreeId = mySubTreeId;

      MetaCatUtil.debugMessage("id of Subtree: " + subTreeId, 30);

      this.startNodeId = myStartNodeId;

      MetaCatUtil.debugMessage("start node id of Subtree: " + startNodeId, 30);

      this.endNodeId = myEndNodeId;

      MetaCatUtil.debugMessage("end node id of subtree: " + endNodeId, 30);

      subTreeNodeStack = getSubTreeNodeList();

    }

    /**

     * Get subtree node stack

     */

    public Stack getSubTreeNodeStack()

    {

      return this.subTreeNodeStack;

    }

    /** Set the a docId */

    public void setDocId(String myId)

    {

      MetaCatUtil.debugMessage("set doc id: "+myId, 35);

      this.docId = myId;

    }

    /** Get the docId */

    public String getDocId() 

    {

      return this.docId;

    }

    /* Put a subtree node into a stack, on top is the start point of subtree*/

    private Stack getSubTreeNodeList() throws McdbException

    {

       PreparedStatement pstmt = null;

       DBConnection dbconn = null;

       int serialNumber = -1;

       Stack nodeRecordList = new Stack();

       long nodeid = 0;

       long parentnodeid = 0;

       long nodeindex = 0;

       String nodetype = null;

       String nodename = null;

       String nodeprefix = null;

       String nodedata = null;

       String sql = "SELECT nodeid, parentnodeid, nodeindex, " +

                    "nodetype, nodename, nodeprefix, nodedata " +               

                    "FROM xml_nodes WHERE docid = ? AND nodeid >= ? AND " +

                    "nodeid <= ? ORDER BY nodeid DESC";

       try 

       {

         dbconn=DBConnectionPool.

                    getDBConnection("SubTree.getSubTreeNodeList");

         serialNumber=dbconn.getCheckOutSerialNumber();

         pstmt = dbconn.prepareStatement(sql);

         // Bind the values to the query

         pstmt.setString(1, docId);

         pstmt.setLong(2, startNodeId);

         pstmt.setLong(3, endNodeId);

         pstmt.execute();

         ResultSet rs = pstmt.getResultSet();

         boolean tableHasRows = rs.next();

         while (tableHasRows) 

         {

           nodeid = rs.getLong(1);

           parentnodeid = rs.getLong(2);

           nodeindex = rs.getLong(3);

           nodetype = rs.getString(4);

           nodename = rs.getString(5);

           nodeprefix = rs.getString(6);

           nodedata = rs.getString(7);

           nodedata = MetaCatUtil.normalize(nodedata);

           // add the data to the node record list hashtable

           NodeRecord currentRecord = new NodeRecord(nodeid,parentnodeid,nodeindex,

                                      nodetype, nodename, nodeprefix, nodedata);

           nodeRecordList.push(currentRecord);

           // Advance to the next node

           tableHasRows = rs.next();

         }//while

         pstmt.close();

      } //try

      catch (SQLException e) 

      {

        throw new McdbException("Error in SubTree.getSubTreeNodeList 1 " +

                              e.getMessage());

      }//catch

      finally

      {

        try

        {

          pstmt.close();

        }

        catch (SQLException ee)

        {

          MetaCatUtil.debugMessage("error in SubTree.getSubTreeNodeList 2: "

                                    +ee.getMessage(), 30);

        }

        finally

        {

          DBConnectionPool.returnDBConnection(dbconn, serialNumber);

        }

      }//finally

      return nodeRecordList;

    }//getSubtreeNodeList

    public static void main (String agus)

    {

    }