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: 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 →

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

FIGURE 6.19   Code for the getter() method and the Exit button Click event handler. A. The function of the getter() method is: as it is called, the current SelectionFrame object is obtained by returning the this component that is a pointer to the current Frame object. A point to be noted is that the access mode of this method must be public, since we want this method to be called by other objects to get the SelectionFrame object as the project runs.B. In the Exit button Click event handler, a try-catch block is used to check whether the database connection we created in the LogInFrameRead More →