It's not a secret anymore!*
The moose likes Beginning Java and the fly likes transform ResultSet data into a DTO Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "transform ResultSet data into a DTO" Watch "transform ResultSet data into a DTO" New topic
Author

transform ResultSet data into a DTO

Arnav Velimala
Ranch Hand

Joined: Jun 04, 2007
Posts: 37
Hi,

Am trying to retrieve the following data from the database.


The table has "SupplierID, SupplierName, SiteId, SiteName" information.
For a given supplierID, there can be more than one siteID's.
The Query is
"SELECT DISTINCT supplier_id, supplier_name, site_division_id, site_division_name FROM spend ORDER BY supplier_id"
And there are some 5000 records.



Can any one suggest me the best way to populate these values in my DTO's?

Is it fine if I use a Map to store these retrieved values -
Map with Key having the supplierDTO(which has id & name attributes) and values being a *List* of SiteDTO(with id & name attributes)'s.
As one supplier can have more than one site, I'll be searching for the supplier in the Map before inserting.

Please suggest.

thanks,
Arnav
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38481
    
  23
That suggestion would work, but I can't help thinking there is a way to write an SQL query which will do that work for you.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: transform ResultSet data into a DTO