Result Set

[Tome Wagese]

Greetings everyone,
When i try to print the result, it only prints first row even though it has multiple rows.What am i doing wrong here.

        ResultSetHandler h = new ResultSetHandler() 
         {      public Object handle(ResultSet rs) throws SQLException 
         {
                if (!rs.next()) 
                {
                return null;
                }            
                ResultSetMetaData meta = rs.getMetaData();
                int cols = meta.getColumnCount();
                Object[] result = new Object[cols];
                for (int i = 0; i < cols; i++) 
                {                
                    result[i] = rs.getObject(i + 1);
                }
                return result;
            }
        };
QueryRunner run = new QueryRunner();
Object[] result = (Object[]) run.query(con, "SELECT * FROM Address",h);
            
for(int i =0;i<result.length;i++)
  {
     System.out.println(result[i]);
  }
    
    

[Scott Selikoff]

I gotta say I'm not familiar with your strategy here... why aren't you just using the common practice of iterating over a result set with a while loop?

[Herman Schelti]

hi Tome,

your example is from http://jakarta.apache.org/commons/dbutils/examples.html,
right?

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).

Herman

[Muhammad Saifuddin]

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

[Tome Wagese]

Thanks everyone.