Perform Data Manipulation Using the UpdaTable ResultSet Object 3 – Insert, Update and Delete Data from Databases

I. For the image column, the system method updateBytes() must be used to insert or update a faculty image in the Faculty Table.

J. The insertRow() method is executed to update this change to the database. That is, this data update will not happen until the next Commit command is executed.

FIGURE 7.18   The new inserted faculty record.

K. The moveToCurrentRow() method is optional, and it returns the cursor of the ResultSet to its original position before this data insertion was performed.

L. The catch block is used to track and collect any possible exception for this data insertion action.

Now let’s build and run the project to test the data insertion 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 pro-cess 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 button to query a faculty record. For example, select the faculty member Ying Bai to query and display this record.

Modify the content of the seven text fields, as shown in Figure 7.18, which is equivalent to a new faculty record:

• Faculty ID: D55280
• Faculty Name: Charles David
• Title: Assistant Professor
• Office: MTC-335
• Phone: 750–330–3678
• College: University of Alabama
• Email: [email protected]

• fimage: David.jpg

To insert this new record using the JavaUpdaTable ResultSet method, select the Java UpdaTable ResultSet from the Query Method combo box. Then click on the Insert button to perform this data insertion. Browse to the faculty image folder to select the desired image, David.jpg.

FIGURE 7.19   The retrieved new inserted faculty record.

To confirm and validate this data insertion, the easiest way is to use the Select button in the FacultyFrame form. Go to the Faculty Name combo box, and you will find that the new inserted faculty name, Charles David, has been added into this box. Select this new inserted faculty member from that box and select Java executeQuery Method from the Query Method combo box followed by clicking on the Select button to try to retrieve this new inserted faculty record. The returned faculty record is displayed, as shown in Figure 7.19.

Another way to confirm this data insertion is to open the Faculty Table in our sample database. Open the Services window in the NetBeans IDE, expand the Databases node and right-click on our Oracle database connection URL, then select the Connect item to connect to our sample database. You may need to use the password oracle _ 18c to do this connection. Then expand the connected database, CSE _ DEPT, and the Tables node, and right-click on the Faculty Table and select the View Data item. In the opened Faculty Table, you can see that the new inserted faculty member, Charles David, which is highlighted in the Faculty Table, is there, as shown in Figure 7.20.

Click on the Back and the Exit buttons to terminate our project. Generally, it is recommended to remove the new inserted faculty record to keep our database clean and neat, but for now, just keep it, and we can delete this record later when we test our data delete actions with the Java UpdaTable ResultSet method.

Next let’s take care of the data update action using the UpdaTable ResultSet object.

As we did for the data insertion, we still want to use the FacultyFrame form window to update one of faculty members in the Faculty Table in our sample database, CSE _ DEPT.

FIGURE 7.20   The new inserted faculty member.