• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Basic question about a sql select

 
Ranch Hand
Posts: 384
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 128
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
thanks a lot for your reply!!
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic