How to update data in database using java

Make the following changes:. When you're done, your form should look something like this one though feel free to rearrange the buttons :. The Integer object has a method called parseInt. In between the round brackets of parseInt, you type the string that you're trying to convert. Now that we have all the data from the Text Fields, we can call the relevant update methods of the ResultSet object:.

There are quite a few different update methods to choose from. The one above uses updateString. But you need the field type from your database table here. So we need three updateString methods and one updateInt. In between the round brackets of the update methods, you need the name of a column from your database though this can be its Index value instead. After a comma you type the replacement data. The update methods just update the ResultSet, however. To commit the changes to the database, you issue an updateRow command:.

Again, we need to wrap it all up in a try … catch statement, just in case something goes wrong. Notice, too, that we've added a message box for a successful update. Run your programme and try it out. Table of Contents. Improve Article. Save Article. Like Article. OracleDriver" ;. Attention reader! Get hold of all the important Java Foundation and Collections concepts with the Fundamentals of Java and Java Collections Course at a student-friendly price and become industry ready.

Recommended Articles. Article Contributed By :. Easy Normal Medium Hard Expert. Writing code in comment? Please use ide. Load Comments. What's New. Most popular in Java.