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 →

By:
On:
In: 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

6.3.4   Develop Code for the LogIn Table to Connect to Our Sample Database Now let’s develop the code to load and register the Oracle JDBC Driver in our LogInFrame class. Open the Code Window of the LogInFrame by clicking on the Source tab at the top of the win-dow, and enter the code shown in Figure 6.14 into this window. Let’s have a closer look at this piece of code to see how it works. A. Since all JDBC-related classes and interfaces are located in the java.sql package, we first need to import this package.B. A class instance, con, is declared here since we needRead 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, Distribute the Application to Other Users, Exams of Oracle, Oracle Certifications
With: 0 Comments

6.3.5   Use the PreparedStatement Object to Perform Dynamic Query for the LogIn Table In the Design View of the LogInFrame Form window, double-click on the LogIn button to open its event handler, and enter the code shown in Figure 6.15 into this event handler. Let’s have a closer look at this piece of code to see how it works. A. Two local string variables, username and password, are declared first, since we need to use them to hold the returned query results later.B. An instance of the next Java Frame Form, selFrame, is generated, and this frame form will be displayed if the login processRead More →