I want to check if my ResultSet has records in it or it is empty?

[Constantinos Grevenitis]

I thought that wasNull() was the one a I was wrong. Is there any method that checks that or do I have to do it "manually"?

[Masoud Kalali]

Hi Constantinos,
You can try rs.next() which return a boolean value indecating that whether ResultSet has any record or not.

To explain more, When you execute a query and it return a resultset, resultset pointer is before first row, when you call resultSet.next() it trys to move to first rows and if the row is not present it will return false.