Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Basic question about a sql select

 
Julien Martin
Ranch Hand
Posts: 384
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I have a single table that contains redundant data and that really should have been modelled as several tables and unfortunately I have to make do with it.

The data is as follows:



I am looking for the best way to use those data and display and structure it as follows (in html or xml):



What is the best way to solve that problem bearing in mind I use SQL and Java.

Thanks in advance,

Julien.
 
Arulanand Dayalan
Ranch Hand
Posts: 128
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Julien,

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.

Thanks,
Arul.
 
Julien Martin
Ranch Hand
Posts: 384
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks a lot for your reply!!
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic