I have two tables Slink and Locate Slink has column name Slinkid ,locate has Locateid,Slinkid. Slink has 9 rows 1,2,3,4,5,6,7,8,9 Locate has
Locateid Slinkid
1 1
2 2
3 3
4 3
5 4
6 7
7 7
8 7
9 8
10 8
11 4
12 4
13 9
14 4
here I need find out howmany locateids are there for Slinkid. Following query is doing that
"SELECT superlinkid, COUNT(*) "
+ "FROM dbo.Locator "
+ "GROUP BY Superlinkid
giving me this op
slinkid count
1 1
2 1
3 2
4 4
7 3
8 2
9 1
But I need to store this in array by loop through it. So that, I should able to access this array everywhere in the program. While looping it should loop every rows(14 rows).simply shouldn't give count value.slinkid 4 has locateid 5,11,12,14 so count is 4. array should loop 4 locate_ids. this i should write it in java. how can i do this?