[jdom-interest] Transforming flat xml to hierachial xml format

[Vijay Mummaneni]

Hi,

I have an xml file that has 100 "Employee" elements. The elements are
related (they are from the RDBMS table). Each element is related to another
elemnt by employee-manager relationship. Currently it is flat xml file. What
I meant is, it looks like (I used JDOM to grab the data from the database) :

<Employees>
  <employee id="1" name="emp1" managerId="2" />
  <employee id="2" name="emp2" managerId="5" />
  <employee id="3" name="emp3" managerId="5" />
  <employee id="4" name="emp4" managerId="2" />
  <employee id="5" name="emp5" />
</Employees>

I have the above tree as a JDOM document. Here is how I want to transform it 
:

<Employees>
          <folder  id="5" name="emp5" >
                         <folder  id="2" name="emp2">
                                 <leaf  id="4" name="emp4" />
                                 <leaf  id="1" name="emp1" />
                        </folder>
                        <leaf  id="3" name="emp3" />
       </folder>
</Employees>


Can you pl suggest me a solution, for this transformation.  Is JDOM helpful
for the transormation ?

Thanks
vijay




_________________________________________________________________
Surf the Web without missing calls! Get MSN Broadband. 
http://resourcecenter.msn.com/access/plans/freeactivation.asp