How do you update a result set?

1.	How do you update a result set?
Answer» ResultSet interface contains a collection of update methods for updating the data of a result set. Each update method has two versions for each data type One that takes in a column name. One that takes in a column index. These methods change the columns of the current row in the ResultSet object, but not in the underlying database. To update your changes to the row in the database, you need to invoke one of the following methods updateRow(), deleteRow(), refreshRow(), cancelRowUpdates(), insertRow()

Answer»

ResultSet interface contains a collection of update methods for updating the data of a result set. Each update method has two versions for each data type

One that takes in a column name.
One that takes in a column index.

These methods change the columns of the current row in the ResultSet object, but not in the underlying database. To update your changes to the row in the database, you need to invoke one of the following methods

updateRow(), deleteRow(), refreshRow(), cancelRowUpdates(), insertRow()

Discussion

No Comment Found

Related InterviewSolutions

What is difference between JDBC, JNDI and Hibernate?
How to Connect to an Excel Spreadsheet using JDBC in Java?
What is Metadata and why should you use it?
Which isolation level prevents dirty read in JDBC, connection class?
What is a "dirty read"?
What are different types of RowSet objects?
What is a RowSet?
What we set the attribute Concurrency in ResultSet?
When you say Class.forName() loads the driver class, does it mean it imports the driver class using import statement?
What does the Class.forName("MyClass") do?

How do you update a result set?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment