your example is from http://jakarta.apache.org/commons/dbutils/examples.html,
Just look at the text below the example:
"In the examples above we implemented the ResultSetHandler interface to turn the FIRST row of the ResultSet into an Object."
If you want to display all rows, just use one of the other resultsethandlers that DBUtils has(BeanListHandler looks OK to me).
Originally posted by Tome Wagese:
When i try to print the result, it only prints first row even though it has multiple rows.
what the java Docs Says :
A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. 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