Resultset Java Check If Empty. Anu suggestions on how to check for an empty result set will be helpful. Get last row number if rsRows 0 return true.
With the above statement you will not have a null ResultSet rs. It is necessary to back to top the pointer so we can see all rows in our ResultSet object. It checks it using a null check using null and isEmpty method of string.
We can use the next method to iterate and if it returns True then it is not empty if it returns False means the ResultSet is empty.
If I check for rsnext I cannot see the first row fetched in the jTable1. Iterating over ResultSet since you are calling the next method again it will now point to the second row and you have missed the first row while rs. The wasNull method of the ResultSet interface determines whether the last column read had a Null value. Checking if ResultSet is empty if rs.