Java looping through result set

Question

In Java  I have a query like this   String querystring1   SELECT rlink id  COUNT                           FROM dbo Locate                          GROUP BY rlink id      The table rlink id has this data   Sid        lid  3           2  4           4  7           3  9           1   How do I extract these values with a Java ResultSet   Here is what I have so far   String show      rs4 getString 1    String actuate      rs4 getString 2    asString   Arrays toString actuate

User · Answer

Result Set are actually contains multiple rows of data  and use a cursor to point out current position  So in your case  rs4 getString 1  only get you the data in first column of first row  In order to change to next row  you need to call next    a quick example  while  rs next          String sid   rs getString 1       String lid   rs getString 2          Do whatever you want to do with these 2 values     there are many useful method in ResultSet  you should take a look

User · Answer

The problem with your code is         String  show     rs4 getString 1         String actuate    rs4 getString 2      This will create a new array every time your loop  an not append as you might be assuming  and hence  in the end you will have only one element per array   Here is one more way to solve this        StringBuilder sids   new StringBuilder         StringBuilder lids   new StringBuilder          while  rs4 next              sids append rs4 getString 1   append               lids append rs4 getString 2   append                  String show     sids toString   split            String actuate     lids toString   split         These arrays will have all the required element

User · Answer

List lt String gt  sids   new ArrayList lt String gt     List lt String gt  lids   new ArrayList lt String gt      String query    SELECT rlink id  COUNT                     FROM dbo Locate                    GROUP BY rlink id     Statement stmt   yourconnection createStatement    try       ResultSet rs4   stmt executeQuery query        while  rs4 next              sids add rs4 getString 1            lids add rs4 getString 2            finally       stmt close       String show     sids toArray sids size     String actuate     lids toArray lids size

[java] Java, looping through result set

Examples related to java

Examples related to jdbc