Fetching single row result without iterating in loop from Mysql using Java

Question

I have a simple query that returns only count of rows.

select count(*) cnt from table

I can read it by iterating through resultset.

like

while(rs.next()){
  int rowCount= rs.getInt(cnt);
}

But is there any way,using which I can get count directly without looping.

mikea · Accepted Answer · 2014-01-31 09:55:13Z

6

How about:

int rowCount = rs.next() ? rs.getInt(cnt) : -1;

It doesn't save you much though

answered Jan 31, 2014 at 9:46

mikea

6,67622 silver badges36 bronze badges

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

5 Comments

I wouldn't return 0. I'd throw an exception to demonstrate something went wrong while obtaining the row value. No response != no rows.

Possibly, but I'd leave that to the developer. It depends on his expectations of the call.

I guess -1 might be a sensible value if you want to avoid exceptions. That's a classic "something is amiss" value.

Ok, agree on that. It does make sense to indicate that we couldn't get an answer

It doesn't save much indeed, but it is a lot cleaner. When you select a count, it is a safe assumption there is one row.