I am trying to run an sql statement and have the result set populate in a table on the same page with the search. I know that I have to do a rowcount. If the rowcount is greater than zero, I will display the table, if it is equal to zero, I will display an error message, that there are no results in the table.

How do I do a row count in JSP?