🚀 go-pugleaf

When only using the COUNT funktion, you only get one result. The result of the
count, whether it is 0 or not.

You could do this:

ResultSet rs = stmt.executeQuery("SELECT COUNT(BSBNO) FROM Mytable");
rs.next();
int numbers=rs.getInt(1);

I hope that answers your question.

Gavin Wong wrote:

> 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.