I think you need to display the Data in the format you had shown. Create a Model in java like this,
1. Write an DAO Class in which you query all the records from the table. 2. Get the first Resultset.Create an HashMap with key as personId and value as Order Model. 3. Get the personId for next value resultset, check if the person id is present in the HashMap, if yes the get the Order Model for that id and update the OrderDetails.If not create a new order model and update the Hashmap with the new Personid. 4. Do the same all the values in resultset. 5. Atlast Return the hashmap from DAO. Use it to build xml or display in html.