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: Build a New Java with Ant Project, Exams of Oracle, Oracle Certifications
With: 0 Comments

5.3.2.1.3   Develop the Code for Three Buttons In fact, only three JButton objects need to be coded, since both TextField objects are used to retrieve and hold the user’s input without any other actions in this application. A similar situation holds for JLabel4, which is used to display the run result of this application. In order to give a function to any button, we need to assign an event handler to each to respond to events. In our case, we want to know what happens when a button is pressed either by mouse click-ing or keyboard pressing. So we will use ActionListener to respond toRead 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: Build a Java Class Library, Build a New Java with Ant Project, Exams of Oracle, Oracle Certifications
With: 0 Comments

5.3.2.2.7  Distribute the Application to Other Users Now that you have verified that the application works outside of the IDE, you are ready to distribute the application and allow other users to use it. To distribute the application, perform the following operations: 1) On your system, create a zip file that contains the application JAR file (SumApp.jar) and the accompanying lib folder that contains SumLib.jar.2) Send the file to the people who will use the application. Instruct them to unpack the zip file, making sure that the SumApp.jar file and the lib folder are in the same folder.3) Instruct the users to follow the stepsRead 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: Build a New Java with Ant Project, Distribute the Application to Other Users, Exams of Oracle, Oracle Certifications
With: 0 Comments

6.1  INTRODUCTION TO RUNTIME OBJECT METHOD The Java runtime object method is to develop and build database-accessing operations using run-time Java code without touching JPA Wizards and Entity classes. In other words, no object-to-relational database mapping is needed, and the project can directly access the database using Java code. As we discussed in Chapter 4, to access a database to perform a data query, the following opera-tional sequence should be followed: 1) Load and register the database driver using the DriverManager class and Driver methods.2) Establish a database connection using the Connection object.3) Create a data query statement using the createStatement() method.4) Execute the dataRead 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: 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 Java Class Library, Build a New Java with Ant Project, Distribute the Application to Other Users, Exams of Oracle, Oracle Certifications
With: 0 Comments

6.3.3.2   JDBC Uniform Resource Locators (URLs) A JDBC url provides all information for applications to access a special resource, such as a data-base. Generally, a url contains three parts: protocol name, sub-protocol and subname for the data-base to be connected. Each of these three segments has a different function when they work together to provide unique information for the target database. The syntax for a JDBC url can be presented as: protocol:sub-protocol:subname The protocol name works as an identifier to show what kind of protocol should be adopted when connecting to the desired database. For a JDBC driver, the name of the protocol should beRead 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 →