PERFORM DATA UPDATE TO ORACLE DATABASE USING THE JAVA RUNTIME OBJECT METHOD – Insert, Update and Delete Data from Databases

7.3  PERFORM DATA UPDATE TO ORACLE DATABASE USING THE JAVA RUNTIME OBJECT METHOD

Usually, we do not need to update a faculty _ id when we update a faculty record, since a better way to do that is to insert a new faculty record and delete the old one. The main reason for this is that a very complicated operational process would be performed if the faculty _ id were updated, since it is a primary key in the Faculty Table and foreign key in the Course and the LogIn Tables. To update a primary key, one needs to update foreign keys first in the child Tables and then update the primary key in the parent Table. This will make our update process very complicated and proneto confusion. In order to avoid this confusion, in this section, we will update a faculty record by changing any column except the faculty _ id, and this is a popular way to update a Table and widely implemented in most database applications.

We still want to work with the Faculty Table in our sample database via the FacultyFrame Form; thus, we do not need to create a brand new project to perform this data update action, but instead we can modify an existing project, OracleInsertFaculty, to make it our new project, OracleUpdateFaculty. Perform the following operations to make our new project:

1) Open Windows Explorer and create a new folder, such as Class DB Project\ Chapter 7, on your root drive if you did not already do this.

2) Open Apache NetBeans 12.4; one can find the project we built in the last section, OracleInsertFaculty, in the Projects window. The other way to find this project is to go to CRC Press ftp site, where it is located in the Class DB Projects\Chapter 7 folder in the Students folder (refer to Figure 1.2 in Chapter 1). You can copy and paste that project to any folder, such as Class DB Projects\Chapter 7, on your computer.

3) Right-click on the project and select the Copy item from the popup menu to open the
Copy Project wizard.
4) Change the project name to OracleUpdateFaculty in the Project Name box.
5) Browse to the folder Class DB Projects\Chapter 7, which was created in step 1, and click on the OK button to select this location as your project location.

6) Click on the Copy button to complete the copy process.

Before we can build code for the Update button event handler, first let’s perform some modifica-tion for the code in the FacultyFrame constructor.