By:
On:
In: Add Oracle JDBC Driver to the Project, Build a Java Class Library, Build a New Java with Ant Project, Code for the Clear Button, Distribute the Application to Other Users, Exams of Oracle, Oracle Certifications
With: 0 Comments

5.3.2   Build a New Java with Ant Project The NetBeans IDE allows you to create and build different projects based on different categories by selecting the right template for your project and completing the remaining wizard steps. First let’s take care of creating a new Java with Ant project. To create a new Java with Ant project under the Apache NetBeans IDE, go to the File|New Project menu item. A New Project wizard is displayed and shown in Figure 5.4. Under the Javawith Ant category, the IDE contains the following standard project templates for Java desktop and Web applications: Let’s give a more detailed discussionRead More →

By:
On:
In: Code for the Clear Button, Exams of Oracle, Oracle Certifications
With: 0 Comments

5.3.2.1.3.2   Code for the Clear Button The function of the Clear button is to clean up all the content in the two TextFields,FirstTextField and LastTextField allow the user to enter a new name. Double-click on the Clear button to open its event handler, and enter the code shown in Figure 5.12 into the event handler. FIGURE 5.12   The code for the ClearButtonActionPerformed() event handler. FIGURE 5.13   The code for the ExitButtonActionPerformed() event handler. When this button is clicked by the user, the setText() method is executed with a null as the argu-ment to clean up the three objects’ contents, FirstTextField, LastTextField and FullNameLabel. 5.3.2.1.3.3   CodeRead More →

By:
On:
In: Add Oracle JDBC Driver to the Project, Code for the Clear Button, Exams of Oracle, Oracle Certifications
With: 0 Comments

5.3.2.2.5   Run the Application Project to Call the Java Library The output of this application program, SumApp.java, is based on arguments that you provide when you run the application. As arguments, you can provide two or more integers, from which the added result will be generated. The adding process will be executed by the Java library file sumapp() located in the SumLibClass library, and the execution result will be returned to and displayed in the main() method in the Java application project SumApp.java. Now let’s run the application. Since this application needs arguments as inputs to the main() method, we have to use an alternativeRead More →

By:
On:
In: Build a Java Class Library, Code for the Clear Button, Exams of Oracle, Oracle Certifications
With: 0 Comments

5.3.2.4   Build a Free-Form Java Project There are also project templates available for free-form Java projects. In so-called free-form proj-ects, the NetBeans IDE uses targets in an existing Ant script to build, run, clean, test and debug your application. If the Ant script does not contain targets for some of these functions, the functions are unavailable for the project. To implement these functions, you write targets either in your Ant script or in a secondary Ant script. In general, it is better to use standard With Existing Sources project templates for import-ing projects. For Eclipse projects, it is best to use the Import Project feature,Read More →

By:
On:
In: Build a New Java with Ant Project, Code for the Clear Button, Exams of Oracle, Oracle Certifications
With: 0 Comments

4) Click on the drop-down arrow from the Driver box and select the Oracle Thin item from the Driver list.5) Click on the Add button to scan and browse to the folder under which our new downloaded Oracle JDBC driver, ojdbc8.jar, is located (C:\Temp); select that driver file; and click on the Open button to add this driver to our driver list. Your finished New Connection Wizard should match the one in Figure 6.2.6) Click on the Next button to open the Customize Connection sub-wizard, as shown in Figure 6.3.7) Enter the following parameters into the associated boxes as the connection elements: a. Enter localhostRead More →

By:
On:
In: Code for the Clear Button, Distribute the Application to Other Users, Exams of Oracle, Oracle Certifications
With: 0 Comments

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. FIGURE 6.5   The finished New Java Application wizard. 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 toRead More →

By:
On:
In: Add Oracle JDBC Driver to the Project, Build a Java Class Library, Code for the Clear Button, Exams of Oracle, Oracle Certifications
With: 0 Comments

6.3.2   Create a Message Box with JDialog Form Class In the opened project, right-click on our project, OracleSelectFaculty, in the Projects win-dow and select the New|OK/Cancel Dialog Sample Form item from the popup menu to open the New JDialog Form dialog box. Enter MsgDialog in the Class Name box as our dialog FIGURE 6.9   The Finished CourseFrame Form window. FIGURE 6.10   Finished StudentFrame Form window. box’s name and select OracleSelectFacultyPackage from the Package box to select it as our package in which our MsgDialog will be developed. Your finished New JDialog Form dialog box should match the one shown in Figure 6.11. Click on theRead More →

By:
On:
In: Build a Java Class Library, Build a New Java with Ant Project, Code for the Clear Button, Exams of Oracle, Oracle Certifications
With: 0 Comments

6.3.3   Add Oracle JDBC Driver to the Project Before we can load and register a JDBC driver, first we need to add the Oracle JDBC Driver we downloaded and installed on our machine as a library file into our current project’s Libraries node to enable our project to find it when it is loaded and registered. Refer to Appendix H to get more details about downloading this JDBC driver. Perform the following steps to finish the JDBC library adding process: 1) Right-click on our project, OracleSelectFaculty, in the Projects window, and select the Properties item from the popup menu to open the Project Properties wizard.Read More →

By:
On:
In: Build a New Java with Ant Project, Code for the Clear Button, Distribute the Application to Other Users, Exams of Oracle, Oracle Certifications
With: 0 Comments

6.3.3.3   Create and Manage the Statement and PreparedStatement Objects The Statement class contains three important query methods with different functions: execute-Query(), executeUpdate() and execute(). For each method, different operations can be performed and different results can be returned. Generally, the execute methods can be divided into two categories: 1) execute methods that need to perform a data query, such as executeQuery(), which returns an instance of ResultSet that contains the queried results, and 2) execute methods that do not perform a data query and only return an integer, such as executeUpdate(). An inter-esting method is execute(), which can be used either way. method and theRead More →

By:
On:
In: Add Oracle JDBC Driver to the Project, Build a Java Class Library, Build a New Java with Ant Project, Code for the Clear Button, Exams of Oracle, Oracle Certifications
With: 0 Comments

6.3.3.4   Use ResultSet Object The ResultSet class contains 25 methods, and the most popular methods used are: The ResultSet object can be created by either executing the executeQuery() or getRe-sultSet() method, which means that the ResultSet instance cannot be created or used without executing a query operation first. Similarly to a Statement object, a Connection object must be first created, and then the Statement component can be created and implemented based on the Connection object to perform a query. The queried result or data is stored in the ResultSet with a certain format, generally in a 2D tabular form with columns and rows. Each columnRead More →