Which Java collection are best to populate one to many data from Database and work on?
<p>Which Java Collection is best in following scenario?</p>

<p>1) Getting very huge data in single SQL Query from 3 tables in Java.</p>

<pre><code>SELECT * FROM TABLE1, TABLE2, TABLE3;
</code></pre>

<p>2) Need to assign result set into three different collections. </p>

<pre><code>Collection&lt;Table1&gt; 
Collection&lt;Table2&gt; 
Collection&lt;Table3&gt;  
</code></pre>

<p>3) Relate the data :</p>

<pre><code>Table Relations:

Table 1.PrimaryKey have multiple rows (0 - n) in Table2.ForeignKey
Collection&lt;Table2&gt;.contains(Table1).fetchAllRecords()

Table 1.PrimaryKey have multiple rows (0-n) in Table3.ForeignKey
Collection&lt;Table3&gt;.contains(Table1).fetchAllRecords()

Table 3.PrimaryKey have multiple rows(0-n) in Table 2.ForeignKey
Collection&lt;Table2&gt;.contains(Table3).fetchAllRecords()
</code></pre>

<p>4) Populate it into single object say ACCOUNT_DETAILS having all properties from all 3 objects.</p>

<p>I have created three POJO; say Table1, Table2 and Table3; with all property names same as of Column names. </p>

<p>Which Java 6 collection should i use for "EASY TRAVERSE AND COMPARE"? Any collection provided by Apache Commons for same?</p>

<p>Will List of  Object be fine or some better object we have?</p>