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 locateids. this i should write it in java. how can i do this?

View Answers

Ads









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 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?
how to store dynamic array in hidden field in javascript?
Using while loop to loop through a cursor
How to retrieve array values from html form to jsp?
how to set values in object using java and what are the ways?
Java2
how can i store text box values as it is in database table
Sort Result set
How to store two integer value in a separate file and retrieve those values
how to Insert Array Values Into Separate Rows using java?
Result Set one to many mapping
Finding duplicates using array in for loop
JavaScript Array
Array declaration in Java
JavaScript array for loop
Hibernate Narrowing Criteria Result Set
how to store multiple values from drop down in database where i am using java struts 1.3
Javah
Storing the Color Image pixel values into 2d array
store dropdown box values in database server
How to calculate average of array in Java?

Ads