jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes Data Update Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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!
I agree. Here's the link: http://aspose.com/file-tools
subject: Data Update
Similar Threads
Search Problem
Fetching Data From Database
Date / Time problems
If Statement&Equals
Data Insert Problem