e-Commerce Applications Using Oracle8i and Java from Scratch

Accessing JavaStop Using JDBC

In the previous chapter we looked at the connection aspects of JDBC and the various JDBC drivers and their features. In this chapter we will look at how the data in JavaStop can be accessed using JDBC.

Revisiting the Steps to Use JDBC

Let's review the steps required to use JDBC, which we discussed in the previous chapter:

1. Import packages

2. Register JDBC drivers

3. Open a connection to JSTP

4. Create a statement object

5. Execute a query and return a Resultset object

6. Process the Resultset

7. Close the Resultset and statement objects

8. Close the connection

Steps 1, 2, 3, and 8 were discussed in the previous chapter. Let's look at the other steps.

Create a Statement Object

Once a connection to an Oracle database has been made, the next step ...