Printing number of records from a ResultSet

[vernon mweetwa]

HI ALL,

I would like to print the number of records from a resultset. What i have now prints the actual details from the database based on the query passed. below is the snippet of code that does that:

ResultSet rs =stmt.executeQuery("Select * from details");
while( rs.next()) {
System.out.print("\n"+rs.getString("firstname")+ " " +rs.getString ("surname"));

the question is how do i factor the above code so that instead of printing the actual details, it prints the number of records from the details table.

thanks
[ March 01, 2005: Message edited by: Mark Spritzler ]

[David Ulicny]

select count(*) from details
[ March 01, 2005: Message edited by: David Ulicny ]

[vernon mweetwa]

how now do i print that count from the method System.out.println().

thanks

[ramprasad madathil]

how now do i print that count from the method System.out.println().

Reading the api may serve better in the long run
Anyways use

resultSet.getInt(1);

ram.

[Mark Spritzler]

Hi Vernon,

Two things.

1. We have a forum called JDBC which is where this thread should be. I am going to move this for you. This forum is for Servlets questions only.

2. You don't need to shout in your Thread Topic title. It is not considered good manners to yell in forums. I am going to edit your title so that it is proper case.

Mark

[Jeanne Boyarsky]

Vernon,
To expand on Ram's answer, you actually need two steps:

resultSet.next();
resultSet.getInt(1);

[Sachin Dere]

Hi,
try this.Put the resultSet in an ArrayList and call size(). this will print you the no of Records in an ArrayList
cheers,
Sachin

[Srinivasa Raghavan]

See vernon needs only the Row count in the result set, so why to get all the records from the database & put it in a arraylist then get it's size.
This query is sufficient right ?

 
[I]
Select count(*) RowCount from Details;[/I]
 
rs.next();
rs.getInt("RowCount");