number of rows Resultset ???

[Bhiku Mhatre]

how do I know number of results fetched by query?? Is there any method in ResultSet class ??

[Rajendar Goud]

Hi
u dont have a method directly which gives u the
Row count by a resultset.u can get the rowcount
in oracle using
count(*)
for a query.
well ,if u want to know the number of records fetched ,then use a local variable and keep it in loop thru
while(rs.next)
variable ++
print out the variable.

Raj

[Elahe Shafie]

See my code:

int rowCount = 0;
    if (rs.next()) {
    rowCount++;
    C_BugList xobj=new C_BugList();
    xobj.setName(rs.getString("name"));
    xobj.setContact(rs.getString("contact"));
    xobj.setBugNumber(rs.getInt("bugNumber"));
    ctx.put("name", xobj );
   }