File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Data Update Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Data Update" Watch "Data Update" New topic

Data Update

Ekrem Altintas

Joined: Dec 20, 2005
Posts: 14
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?

Akin Demir

Joined: Jul 08, 2005
Posts: 9
cumle.executeUpdate("Update kelimeler set sayi="+artir);

Jeff Albertson
Ranch Hand

Joined: Sep 16, 2005
Posts: 1780
Do you realize that an UPDATE statement without a WHERE clause will update all records in the table?

There is no emoticon for what I am feeling!
Consider Paul's rocket mass heater.
subject: Data Update
It's not a secret anymore!