line just after result of query

[Mohammed Mudassir Mohiuddin]

Using JDBC how to retrieve "5 rows in set (0.00 sec)", line just after result of query.

mysql> select * from authors; +----+-------------------+ | Id | Name | +----+-------------------+ | 1 | Jack London | | 2 | Honore de Balzac | | 3 | Lion Feuchtwanger | | 4 | Emile Zola | | 5 | Truman Capote | +----+-------------------+ 5 rows in set (0.00 sec)

[Peter Johnson]

I've used code like this:

ResultSet rs = xxx
rs.afterLast();
rs.previous();
int count = rs.getRow();

I've always wanted to be able to do something like rs.getRowCount() instead, but having implemented a JDBC driver I realize how dangerous such as function is. The programmer will assume that it is a simple number that the driver can return, but in many case, in order to get that number, the driver has to get all of the rows first. At least, that is what the issue was with our database. So making the programmer do extra work might force him/her to think whether such a thing is a good idea (especially if the row count is possibly in the thousands or higher!)

[Paul Clapham]

However, to produce the posted output, all you need to do is to increment a counter for each row you read.