6.3 CREATE A JAVA APPLICATION PROJECT TO ACCESS THE ORACLE DATABASE First let’s create a new Java application project named OracleSelectFaculty using the NetBeans IDE 12. Go to the File|New Project menu item to start this process.
- Select Java with Ant from the Categories panel and Java Application from the Projects panel, and then click on the Next button.
FIGURE 6.5 The finished New Java Application wizard.
- Enter OracleSelectFaculty into the Project Name box and select a desired location to store this project. A suggested location on your machine is C:\Class DB Project\Chapter 6. Uncheck the Create Main Class checkbox, since we need to use our frame to start the project.
Your finished New Java Application wizard is shown in Figure 6.5. Click on the Finish button to create this new Java application project, OracleSelectFaculty.
Next we need to create five JFrame Forms as our graphical user interfaces, LogInFrame, SelectionFrame, FacultyFrame, CourseFrame and StudentFrame, to perform the data queries to five data Tables in our sample database. We also need to create a JDialog as our message box.
6.3.1 Create Graphic User Interfaces
First let’s create the LogInFrame Form window.
Right-click on our new project, OracleSelectFaculty, and select the New|JFrame Form item from the popup menu to open the New JFrame Form panel. Enter the following values in this panel to create the new JFrame Form:
1) LogInFrame in the Class Name box.
2) OracleSelectFacultyPackage in the Package box.
3) Click on the Finish button.
Add the GUI components with the appropriate properties shown in Table 6.1 into this form. You need to drag each component from the Palette Windows and place it in the LogInFrame Form and set up each property in the Properties Windows.
When setting up the property for each component, you need first to click on that component to select it and then go the Properties Window to set up an appropriate property for that component. To set up a Variable Name for each component, you need to right-click on that component and select the Change Variable Name item from the pop-up menu, then enter the desired name in the New Name box for that object. Your finished LogInFrame Form is shown in Figure 6.6.
FIGURE 6.6 The finished LogInFrame Form.
Now let’s create the SelectionFrame Form window.
As we did for the LogIn Form, right-click on our project, OracleSelectFaculty, in the Projects window and select the New|JFrame Form item from the popup menu to open the New JFrame Form panel. Enter SelectionFrame in the Class Name box as the name of our new Frame Form class, and select OracleSelectFacultyPackage from the Package box. Click on the Finish button to complete this creation.
Add the following objects and controls, which are shown in Table 6.2, into this SelectionFrame Form. One point to be noted is that you need to remove all default items located inside the model property of the Combo Box ComboSelection. To do that, click on the ComboSelection combo box from the Design View, and then go the model property and click on the three-dot button to open the model panel. Select all four default items, and press the Delete button from the keyboard to remove all of those items. A preview of the completed SelectionFrame Form should match the one that is shown in Figure 6.7.
Next let’s create our FacultyFrame Form window.
Right-click on our new project, OracleSelectFaculty, in the Projects window and select the New|JFrame Form item to open the New JFrame Form pane. Enter FacultyFrame in the Class Name box as the name of our new Frame Form class, and then select the OracleSelectFacultyPackage from the Package box. Click on the Finish button to complete this creation.
Add the following objects and controls, which are shown in Table 6.3, into the FacultyFrame Form.