Updating table with integer values using jdbc in servlets
Following is the example, which makes use of the Result Set. TYPE_SCROLL_INSENSITIVE described in the Result Set tutorial.This example would explain INSERT, UPDATE and DELETE operation on a table.
)"; Prepared Statement statement = connection.prepare Statement(sql); Blob(1, input Stream); statement.execute Update(); package net.codejava.jdbc; import
The page should process the submission, and you should see your comments appear in the table.
Check the database table using the table editor; you should find that the comments have been saved there.
ID: 100, Age: 38, First: Zara, Last: Ali ID: 102, Age: 55, First: Zaid, Last: Khan ID: 103, Age: 50, First: Sumit, Last: Mittal ID: 104, Age: 40, First: John, Last: Paul Goodbye!
In this section we will discuss how can we insert a data into the table.
Search for updating table with integer values using jdbc in servlets:
It should be noted that tables you are working on should have Primary Key set properly.