This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes Beginning Java and the fly likes JDBC result set - best way to store results? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » Beginning Java
Reply locked New topic

JDBC result set - best way to store results?

Shailan Mm

Joined: Oct 06, 2004
Posts: 8

I was wondering what the common ways to store the results of a JDBC query were. I have recently migrated from Perl, and am used to storing the results in a hash. Is there a similar data structure that can easily handle the results of the query. I have tried HashMap, but cant figure out how to get a key to map to another HashMap internally without explicitly creating the internal HashMaps first.

The query is something like this:
select animal, type, name from animals;

and the result set is:

Animal Type Name
dog husky Bella
dog poodle Alfie
cat manc Gus

I want the data structure to look like this:

dog => husky => Bella
poodle => Alfie
cat => manc => Gus

Alternatively, is there some better way to store the results rather than trying to duplicate Perl hashes?

Thank you
Shailan Mm

Joined: Oct 06, 2004
Posts: 8
To clarify (the formatting got messed up)

I want the data structure to have:

1) 2 top level keys - dog and cat
2) the 'dog' key pointing to another HashMap which itself has 2 keys - husky and poodle, with the value for husky being Bella and the value for poodle, Alfie
3) the cat key having a value Gus

Sorry to belabor the point, but the graphical representation i tried to give was not clear. It looked like I wanted to make poodle a top level key, which is not the case

Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63869

Shailan, please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place. Please continue any discussion of this topic here in the JDBC forum.

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: JDBC result set - best way to store results?
It's not a secret anymore!