help needed

[silversurfer2in]

how to check for resultset when the query executed results nothing

eg.
if usename is blah
and query made is
select * from table where username='blahblah'
this query will show 0 results
what will be stored in the resultset at that time....
i want to made a check in this case...

[andy16]

if (myResultSet.next()) {
    // ResultSet is not empty (the user was found); write code here
}

else {
    // Your ResultSet is empty (no user with the given username was found)
}

The next() method on your ResultSet object returns true if there is another row in your ResultSet. Since you have not started looping through it, this is the same as checking whether it is empty or not (that is, checking if there is a first row).

Also, make sure that your username column is unique.

[silversurfer2in]

Thanx a lot

[wzq110120]

china friend
walk...........