Resultset Java Get Number Of Rows. Can some one guide any way to get the no of rows from result set except looping through all the rows. In this class we will create database connection as.
ExecuteQuery - This method executes the query. Through this example you can do it. So when you access your results it starts from second row.
It remembers the current cursor location.
GetFetchSize retrieves the number of result set rows that is the default fetch size for result sets generated from this Statement object. Rows Count Example Using JDBC ResultSet. In most cases the requirement is to get the number of rows a query would return without fetching the rows. If this Statement object has not set a fetch size by calling the method setFetchSize the return value is implementation-specific.