Getting row count from executeQuery()

[Java Tip]

Row count is not returned by executeQuery(). It means that if we want to get row count, we have to count them ourselves. It is shown in the following example:

Code:

   Statement s = conn.createStatement ();
   s.executeQuery ("SELECT id, name, category FROM animal");
   ResultSet rs = s.getResultSet ();
   int count = 0;
   while (rs.next ())
   {
       int idVal = rs.getInt ("id");
       String name = rs.getString ("name");
       System.out.println ("name = " + name);
       ++count;
   }
   rs.close ();
   s.close ();
   System.out.println ("No of rows retrieved: "  count);