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.
E.g. 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
that is: 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 pointing to another HashMap containing one key-value pair, manc => Gus
Alternatively, is there some better way to store the results rather than trying to duplicate Perl hashes?