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: Distribute the Application to Other Users, Exams of Oracle, Oracle Certifications
With: 0 Comments

5.3.2.2   Build a Java Class Library As we mentioned, a Java class library is only a skeleton Java class library without a main class, and it cannot be executed itself; instead, it must be called or used by other Java applications. Similarly FIGURE 5.16   The run result of our project. to other general libraries, a Java class library can be statically or dynamically bound or connected to an application and used as a utility class. Since a Java class library cannot be executed itself, we need to create a Java application project to call or use that Java class library. Therefore, we need to createRead 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: Build a Java Class Library, Distribute the Application to Other Users, Exams of Oracle, Oracle Certifications
With: 0 Comments

5.5   CHAPTER SUMMARY Basic and fundamental knowledge about and implementations of the Apache NetBeans IDE 12 are discussed and presented, with some real example projects, in this chapter. The components and architecture of the Apache NetBeans IDE 12 are introduced and analyzed in detail at the begin-ning of this chapter. Following an overview of Apache NetBeans IDE 12, a detailed discussion and introduction of the Apache NetBeans IDE 12 platform is given. A detailed introduction to and illus-tration of how to download and install the Apache NetBeans IDE 12 are provided in this chapter. Most popular technologies and applications supported by the Apache NetBeans IDERead 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: 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, 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: 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 →

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

6.3.3.4.2   Fetching by Column: When a valid data row has been retrieved, we need to get each column from that row. To do that, a different getXXX() method should be used based on the different data type of the returned data. One can use either the name of the column or the index of that column to get the data value. For example, in our LogIn Table, both the user _ name and the pass _ word are Strings; therefore, a getString() method should be used with the index of each column. A point to be noted is that the first column has an indexRead More →