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 →

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 →