This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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.
Hope this Helps.
Joined: Apr 24, 2004
thanks a lot for your reply!!
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com