Managing data with updatable result sets


show more Managing data with updatable result sets provides you with in-depth training on Developer. Taught by David Gassner as part of the Java Database Integration with JDBC show less
please wait ...

Managing data with updatable result sets

I have shown so far how to do inserts, updates, and deletes using SQL statements and the prepared statement object. There's an alternative in JDBC the updatable result set, where you get a result set from the database and market as updatable, then change the data directly in the result set. You can do inserts, updates, and deletes with this approach. Whether it's a good idea depends on your circumstances and your database management system. Not all database management system supports updatable result sets, and if you're working with a very large result set, it can cause performance issues.

But in a small-scale application, or when you're only dealing with one row at a time, an updatable result set programming approach can be useful, I'll demonstrate how to update a row of data using an updatable result set. I'm working in a project called UpdatableRS. The state of this project is similar to the update exercise that I did previously, there is an update method with an SQL st...

Managing data with updatable result sets
Video duration: 6m 6s 2h 51m Intermediate

Viewers:

Managing data with updatable result sets provides you with in-depth training on Developer. Taught by David Gassner as part of the Java Database Integration with JDBC

Subject:
Developer
Software:
Java
Author:
please wait ...