help with xml parsing using dom4j

[syn3rgyz]

I'm given an XML document at work that is a schema from a database. I'm trying to parse the xml data into PERSON objects, and then store each object into an arraylist or something so that it can be fed back into a different database later. I'm not a very strong programmer and haven't written in java since college so I'm not sure if that's the best way to do it. I'm also not quite sure about how to parse the XML document, should I do it iteratively or using nodelist or something?

The xml document looks something like this

<ROWSET>
  <ROW>
       <ID>01</ID>
       <FIRSTNAME>Bob</FIRSTNAME>
       <LASTNAME>Smith</LASTNAME>
  </ROW>
  <ROW>
       <ID>02</ID>
       <FIRSTNAME>Mary</FIRSTNAME>
       <LASTNAME>Atkins</LASTNAME>
  </ROW>
</ROWSET>

 

[Snowpea]

http://php.net/manual/en/book.simplexml.php

Take your pic of the examples in the comments, they pretty much do exactly what you want. Several of them store them associatively into arrays which you can then loop through to create your insert statements into whatever DB you want.

 

[syn3rgyz]

thanks for the link, i tried reading it but I don't understand the php syntaxes =[