Thread: How to Convert following XML to ArrayList

Hello Expert,

I am new on java. I have following xml file structure.
What I need to do is that
1) Read this xml file and convert to arraylist.
2) insert this arrayList into Mysql database.

Please help out

XML File is

<?xml version="1.0"?>
<root>
<individualorders>
<individualorder>
<patientRole>
<id>8839</id>
<addr >
<streetAddressLine/>
<city/>
<state/>
<postalCode/>
<country/>
</addr>
<telecom />
<mobilenumber>1234567890</mobilenumber>
<patient>
<name>
<salutation>Mr</salutation>
<firstname>TFnam tMidName tLastName</firstname>
<middlename/>
<family/>
</name>
<administrativeGenderCode>Male</administrativeGenderCode>
<birthTime>-00011130</birthTime>
<age>
<years>2014</years>
<months>07</months>
<days>1</days>
</age>
<birthplace>
<place>
<addr>
<state/>
<postalCode/>
<country/>
</addr>
</place>
</birthplace>
</patient>
</patientRole>
<orderinfo>
<id>9066</id>
<grossamount>0</grossamount>
<discountamount>0</discountamount>
<discountpercentage>0</discountpercentage>
<reasonfordiscount>NA</reasonfordiscount>
<netamount>0</netamount>
<referringdoctor>-</referringdoctor>
<referringdoctorcontact>-</referringdoctorcontact>
<ordertype>catalog</ordertype>
<medicalhistory>-</medicalhistory>
</orderinfo>
<tests>
<test>
<testcode>4320</testcode>
<packageid>11729</packageid>
<testid>4320</testid>
<testname>Collage - Executive Health Chk Up - Male</testname>
<sellingprice>0</sellingprice>
</test>
Test can be more
</tests>
</individualorder>
</individualorders>
</root>