row count in JSP

[Maria Modeste]

I am trying to run an sql statement and have the result set populate in a table on the same page with the search. I know that I have to do a rowcount. If the rowcount is greater than zero, I will display the table, if it is equal to zero, I will display an error message, that there are no results in the table.

How do I do a row count in JSP?

[mohit]

You do not need rowcount for above requirement. Simply check on your resultset object

if( rs.next() )
{
//display the table
}
else
{
//display error msg
}

Regards,
Mohit

[Maria Modeste]

Thanks I'll try it and see if it works. I am really using a while loop as in while (rs.next())

[mohit]

Thanks I'll try it and see if it works. I am really using a while loop as in while (rs.next())

Than do this

if( rs.next() )
{
    do
    {
        //display the table
    }while( rs.next() )
}
else
{
    //display error msg
}

[Maria Modeste]

Thanks a mil, it works!