how to store the REsult Set values in array and loop through it in java?

how to store the REsult Set values in array and loop through it in java?

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?

View Answers









Related Tutorials/Questions & Answers:
how to store the REsult Set values in array and loop through it in java?
how to store the REsult Set values in array and loop through it in java?
Advertisements
how to store array values into two different tables in java?
How to store unique values in Java using Set?
How to store unique values in Java using Set?
how to set the values in jsp
how to chech result set is null or not - Java Beginners
How to add a columns with a button set to a Jtable built with database result set
How to call Array Length for loop in PHP
How to access session values through Ajax?
how to store jtable value in multidimensional array?
how to store jtable value in multidimensional array?
difference between java5 and java6 - Java Beginners
How can we find the number of rows in a result set using PHP?
Using while loop to loop through a cursor
how to store dynamic array in hidden field in javascript?
how to store a dynamic values - JSP-Servlet
How to retrieve array values from html form to jsp?
Java2
Result=Set - Java Beginners
php array foreach/how to use foreach loop to iterate and print all the values in an array
How to store extracted values from xml in a database? - XML
How to store extracted values from xml in a database? - XML
how to set values in object using java and what are the ways?
php array loop count
php array loop while
how to set values from parent page to iframe in javascript
how can i store text box values as it is in database table
Sort Result set
php array loop key value
php array loop foreach
How to store values in a database using JSTL? - JSP-Servlet
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How to store two integer value in a separate file and retrieve those values
Result Set one to many mapping
php array length for loop
about java1
how to Insert Array Values Into Separate Rows using java?
Finding duplicates using array in for loop
Array declaration in Java
JavaScript Array
Hibernate Narrowing Criteria Result Set
JavaScript array for loop
Get values from session to array

Ads