Data Update

[Ekrem Altintas]

Hello I want to update records on DB.I wrote this statements but when I execute the program, records on the sayi column become 0.Is UPDATE satement wrong?

 
...
int artir=5;
statement cumle;
ResultSet sonuc;
...
sonuc=cumle.executeQuery("Select * from kelimeler");
sonuc.last();
cumle.executeUpdate("Update kelimeler set sayi='artir'");
...

[Akin Demir]

cumle.executeUpdate("Update kelimeler set sayi="+artir);

[Jeff Albertson]

Do you realize that an UPDATE statement without a WHERE clause will update all records in the table?