Please give me an example of building an xml with multiple child nodes, in java.

I want something like :

<Parent>

<Child1>something</Child1>

<Child2>something else</Child2>

</Parent>

Now, the values for Child1 and Child2 must be picked using SQL from AS400. Picking values is where i think i am failing. My program constructs something like :

<Parent>

<Child1>something</Child1>

</Parent>

<Parent>

<Child2>something else</Child2>

</Parent>

:( help!

 

 



Software/Hardware used:
java 1.5, as400, jdbc