Metacat

        if (nodetype == "ELEMENT") {

          pstmt.setLong(3, getParentID());

          pstmt.setLong(4, getRootNodeID());

          pstmt.setString(6, data);

          pstmt.setInt(7, getNodeIndex());

        } else {

          pstmt.setLong(3, getNodeID());

          pstmt.setLong(4, getRootNodeID());

          pstmt.setString(6, data);

          pstmt.setInt(7, incChildNum());

        }

   * creates SQL code to put doc ID for the document node and for comment/PI nodes under document node

   * into DB connection 

   */

      try {

        PreparedStatement pstmt;

        pstmt = conn.prepareStatement(

              "WHERE nodeid = ?");

        // Bind the values to the query

        pstmt.setLong(2, getNodeID());

        // Do the insertion

        pstmt.execute();

              "UPDATE xml_nodes set docid = ? " +

              "WHERE parentnodeid = ?");

        // Bind the values to the query

        pstmt.setLong(2, getNodeID());

        // Do the insertion

        pstmt.execute();