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: Add Oracle JDBC Driver to the Project, Exams of Oracle, Oracle Certifications
With: 0 Comments

5.3.2.1.1   Add a Graphical User Interface To proceed with building our interface, we need to create a Java container within which we will place the other required GUI components. Generally, the most popular Java GUI containers include: In this project, we will create a container using the JFrame component. We will place the con-tainer in a new package, which will appear within the Source Packages node. Perform the following operations to complete this GUI adding process: 1) In the Projects window, right-click on our new created project, JavaAppProject, and choose the New > JFrame Form menu item from the popup menu.2) Enter JavaAppFrame into theRead More →

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

5.3.2.2.2   Create a Java Application Project Perform the following operations to create a new Java application project: 1) Choose the File > New Project menu item. Under Categories, select Java with Ant. Under Projects, select Java Application. Then click on the Next button.2) Enter SumApp into the Project Name field. Make sure the Project Location is set toC:\Oracle DB Programming\Class DB Projects\Chapter 5.3) Enter sumapp.Main as the main class.4) Ensure that the Create Main Class checkbox is checked.5) Click the Finish button. The SumApp project is displayed in the Projects window, and Main.java opens in the Source Editor. Now we have finished creating two JavaRead More →

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

5.3.2.2.4  Add Code to the Main.java Tab in the Java Application ProjectNow we need to add some code to Main.java. In doing so, you will see the Source Editor’s code completion and code template (abbreviation) features. 1) Select the Main.java tab in the Source Editor. If it isn’t already open, expand SumApp > Source Packages > sumapp in the Projects window and double-click on the itemMain.java.2) Inside the main() method, replace the comment //TODO code application logic here with the following: int result = Sum3) Leave the cursor immediately after Sum. In the next step, you will use code completion to turn Sum into SumLibClass.4)Read 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: Add Oracle JDBC Driver to the Project, Distribute the Application to Other Users, Exams of Oracle, Oracle Certifications
With: 0 Comments

5.3.2.2.6   Build and Deploy the Application The main build command in the NetBeans IDE is the Clean and Build Main Project command. This command deletes previously compiled classes and other build artifacts and then rebuilds the entire project from scratch. Perform the following operations to build the application: 1) Click on the Run > Clean and Build Main Project(SumApp) menu item (Shift-F11).2) Output from the Ant build script appears in the Output window. If the Output window does not appear, you can open it manually by choosing Window > Output.3) When you clean and build your project, the following things occur: a. Output folders thatRead More →

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

FIGURE 6.7   A preview of the created SelectionFrame Form. FIGURE 6.8   A preview of the finished FacultyFrame Form window. One point to be noted is that you need to remove all default items located inside the model prop-erty of the Combo Box ComboName and ComboMethod. To do that, click on the ComboName combo box from the Design View, and then go the model property and click on the three-dot extension button to open the model pane. Select all four default items, and press the Delete button from the keyboard to remove all of those items. Perform similar operations for the ComboMethod. A preview of theRead 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: Add Oracle JDBC Driver to the Project, Build a Java Class Library, Distribute the Application to Other Users, Exams of Oracle, Oracle Certifications
With: 0 Comments

Generally, the JDBC API enables users to access virtually any kind of tabular data source, such as spreadsheets or flat files, from a Java application. It also provides connectivity to a wide scope of Oracle databases. One of the most important advantages of using JDBC is that it allows users to access any kind of relational database in the same way with code, which means that the user can develop one program with the same code to access either an Oracle database or a MySQL database without code modification. The JDBC 3.0 and JDBC 4.0 specifications contain additional features, such as extensions to sup-port variousRead 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 →