Answers for "how to count row"

Excel sheet count rows

=COUNTIF(RANGE, CONDITION)
Example: =COUNTIF(C1:C30, "Paris")

how to count row

Row number always starts with 1
My last rowNumber is my row count
When I move my cursor to the last location to get rowCount

how to get row count

Get the row count of the ResultSet
Move the pointer to the last row and get the row number

  rs.last();
        int rowCount = rs.getRow();
        System.out.println(rowCount);