🚀 go-pugleaf

Hi,
 This should work :
 PreparedStatement ps = connection.prepareStatement("SELECT COUNT(*)
FROM MyTable");
 ps.executeQuery();
 rs = ps.getResultSet();
 long aCount = 0L;
 if (rs.next()) {
   aCount = rs.getLong(1);
 }

 where aCount would be the number of records you are looking for.

Happy JDBCing

Balaji
In article <uRhK3.4157$lE.22937@ozemail.com.au>,
  "Gavin Wong" <gavinthwong@ozemail.com.au> 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.
>
>


Sent via Deja.com http://www.deja.com/
Before you buy.