Delete a Data Row Using the UpdaTable ResultSet 2 – Insert, Update and Delete Data from Databases

Now let’s build and run the project to test the data delete function.

Click on the Clean and Build Main Project button to build the project, and click on the Run Main Project button to run it.

Enter a suiTable username and password, such as jhenry and test, to complete the login process and open the FacultyFrame form window. Make sure that the Java executeQuery Method has been selected from the Query Method combo box. Then click on the Select but-ton to query any faculty record or information, such as a faculty member named Charles David.

To test the data delete function using the UpdaTable ResultSet, select the Java UpdaTable ResultSet from the Query Method combo box. Then click on the Delete button to try to delete this selected faculty member from our sample database. To simplify this data delete action and avoid a completed recovery process, in this case, we try to delete a faculty member, Charles David, since this faculty member is a new one inserted in Section 7.5.2.1 without other related records in any child Tables. Select that faculty member from the Faculty Name combo box, and click on the Delete button to remove this faculty member from our sample database.

Click on the Back and the Exit buttons to terminate our project.

To confirm and validate this data delete action, one can go to the Faculty Name combo box to check this faculty member. It can be seen that this faculty member has been removed from the faculty name list. Another way to confirm the data delete is to open the Faculty Table in our sample database CSE _ DEPT. To do that, first open the Services window in the NetBeans IDE, expand the Databases node, right-click on our Oracle database connection URL and select the Connect item to connect to our sample database. You may need to use our password, oracle _ 18c, to do this connection. Then expand the connected database, CSE _ DEPT, and the Tables node; right-click on the Faculty Table; and select View Data for this Table. In the opened Faculty Table, you can find that the faculty member Charles David has been deleted from the Faculty Table.

Our data delete function is successful.

A complete project, OracleUpdaTableDelete, that contains the data insert, update and delete functions using the UpdaTable ResultSet object can be found in the folder Class DB Projects\ Chapter 7 located in the Students folder at the CRC Press ftp site (refer to Figure 1.2 in Chapter 1).

Next let’s discuss how to perform data manipulation using the Callable statement.