This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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!
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Data Update
It's not a secret anymore!