quit while loop whilst iterating through SQL table

Question

I want to add items from a SQL table to an Java ArrayList. To get each item in the table, I am using the loop:

while(results.next())

However, I believe that this won't quit the loop if there are no more results found unlike the .hasNext available from some classes and will cause an error of some sort. How would I get the while loop to quit if there is nothing else in the SQL table without causing an error?

havexz · Accepted Answer · 2012-03-19 02:27:56Z

4

Looking at the docs, i think it should work fine. Snippet from the docs:

Returns:
    true if the new current row is valid; false if there are no more rows

I hope you are talking about ResultSet

answered Mar 19, 2012 at 2:27

havexz

9,6202 gold badges35 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pickypg · Accepted Answer · 2012-03-19 02:29:28Z

3

Assuming that you are using a ResultSet, this is straight from the JavaDocs:

The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set.

answered Mar 19, 2012 at 2:29

pickypg

22.4k5 gold badges75 silver badges85 bronze badges

Collectives™ on Stack Overflow

quit while loop whilst iterating through SQL table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related