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
difference between java5 and java6 - Java Beginners
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?
Using while loop to loop through a cursor
How can we find the number of rows in a result set using PHP?
How to retrieve array values from html form to jsp?
how to store dynamic array in hidden field in javascript?
how to store a dynamic values - JSP-Servlet
Result=Set - Java Beginners
Java2
php array loop count
php array loop while
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?
Sort Result set
php array loop key value
php array loop foreach
how to set values from parent page to iframe in javascript
how can i store text box values as it is in database table
php array length for loop
Result Set one to many mapping
Finding duplicates using array in for loop
about java1
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 values in a database using JSTL? - JSP-Servlet
How to store two integer value in a separate file and retrieve those values
how to Insert Array Values Into Separate Rows using java?
JavaScript Array
Array declaration in Java
Hibernate Narrowing Criteria Result Set
JavaScript array for loop
Get values from session to array

Ads