🚀 go-pugleaf

Dear all,
Could you please tell me how to get the number of records in my database by
using the COUNT sql statement?
Let's say i have a Table call Mytable, the table contains two columns which
are BSBNO and NAME. I would like to know how many BSBNO(of type int) records
have been stored  in my Mytable. So that i wrote the following statement in
my Java JDBC program:

ResultSet rs = stmt.executeQuery("SELECT COUNT(BSBNO) FROM Mytable");
      while (rs.next()) { what should i write here??}


Shall i set:
int n = ResultSet rs = stmt.executeQuery("SELECT COUNT(BSBNO) FROM
Mytable");  ?? can i?
i need to know what's the value of "n".
Please help..Thanks.

with regards,
gavin.