resultset – Page 4 – Tarik Billa

How do I get the size of a java.sql.ResultSet?

September 29, 2022 by Tarik

Do a SELECT COUNT(*) FROM … query instead. OR int size =0; if (rs != null) { rs.last(); // moves cursor to the last row size = rs.getRow(); // get row id } In either of the case, you won’t have to loop over the entire data.

Checking for a null int value from a Java ResultSet

September 28, 2022 by Tarik

The default for ResultSet.getInt when the field value is NULL is to return 0, which is also the default value for your iVal declaration. In which case your test is completely redundant. If you actually want to do something different if the field value is NULL, I suggest: int iVal = 0; ResultSet rs = … Read more