UPDATE

[Bala Krishniah]

I am looking through the resultset and when I get a row of interest, then I want to update a few columns in the same row.
I am wondering whether I have to specify a 'where' clause in the update syntax, since I am looping through and the the row to be updated in the current row....
while( resultset.next() )
{
String status = resultset.getString("STATUS") ;
if( status == 12 )
{
String update = "update tablename set col1='1', col2='sd'";
stmt.executeUpdate(update);
}
}
Will the above 'update' statemet recognize that it has to update the current row?
Thanks!!

[Lars Vegas]

I don't think so!
How should it? The update statement is executed on the database and the database has no idea in which row of the resultSet you are. I think, the whole table will get the specified values in the columns!

[Bala Krishniah]

Thanks Lars Vegas...
Then in hat case I'll specify the current row's Unique id no.
Thanks