Metacat

    /**

     * Look up the node data from the database, but some node would be shown

     * because of access control

     *

     * @param rootnodeid

     *            the id of the root node of the node tree to look up

     * @param accessControl

     *            the hashtable has control info

     */

    private TreeSet getPartNodeRecordList(long rootnodeid,

            Hashtable accessControl) throws McdbException

    {

        PreparedStatement pstmt = null;

        DBConnection dbconn = null;

        int serialNumber = -1;

        TreeSet nodeRecordList = new TreeSet(new NodeComparator());

        long nodeid = 0;

        long parentnodeid = 0;

        long nodeindex = 0;

        String nodetype = null;

        String nodename = null;

        String nodeprefix = null;

        String nodedata = null;

        float nodedatanumerical = -1;

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

                + "nodetype,nodename,nodeprefix,nodedata,nodedatanumerical "

                + "FROM xml_nodes WHERE rootnodeid = ?";

        // go through the access control for some nodes

        Enumeration en = accessControl.elements();

        while (en.hasMoreElements()) {

            SubTree tree = (SubTree) en.nextElement();

            long startId = tree.getStartNodeId();

            long endId = tree.getEndNodeId();

            sql = sql + " AND(nodeid < " + startId + " OR nodeid > " + endId

                    + ")";

        }

        logMetacat.info("The final query to select part node tree: "

                + sql);

        try {

            dbconn = DBConnectionPool

                    .getDBConnection("DocumentImpl.getPartNodeRecordList");

            serialNumber = dbconn.getCheckOutSerialNumber();

            pstmt = dbconn.prepareStatement(sql);

            // Bind the values to the query

            pstmt.setLong(1, rootnodeid);

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

                logMetacat.debug("Node data in read process before normalize=== "+nodedata);

                nodedata = MetaCatUtil.normalize(nodedata);

                logMetacat.debug("Node data in read process after normalize==== "+nodedata);

                nodedatanumerical = rs.getFloat(8);

                // add the data to the node record list hashtable

                NodeRecord currentRecord = new NodeRecord(nodeid, parentnodeid,

                        nodeindex, nodetype, nodename, nodeprefix, nodedata, nodedatanumerical);

                nodeRecordList.add(currentRecord);

                // Advance to the next node

                tableHasRows = rs.next();

            }

            pstmt.close();

        } catch (SQLException e) {

            throw new McdbException(

                    "Error in DocumentImpl.getPartNodeRecordList "

                            + e.getMessage());

        } finally {

            try {

                pstmt.close();

            } catch (SQLException ee) {

                logMetacat.error(

                        "error in DocumentImpl.getPartNodeRecordList: "

                                + ee.getMessage());

            } finally {

                DBConnectionPool.returnDBConnection(dbconn, serialNumber);

            }

        }

        if (!nodeRecordList.isEmpty()) {

            return nodeRecordList;

        } else {

            throw new McdbException("Error getting node data: " + docid);

        }

    }