ASA Programming Guide
  JDBC Programming
    JDBC overview

JDBC program structure

The following sequence of events typically occur in JDBC applications:

1. Create a Connection object    Calling a getConnection class method of the DriverManager class creates a Connection object, and establishes a connection with a database.

2. Generate a Statement object    The Connection object generates a Statement object.

3. Pass a SQL statement    A SQL statement that executed within the database environment passes to the Statement object. If the statement is a query, this action returns a ResultSet object.

   The ResultSet object contains the data returned from the SQL statement, but exposes it one row at a time (similar to the way a cursor works).

4. Loop over the rows of the result set    The next method of the ResultSet object performs two actions:

   • The current row (the row in the result set exposed through the ResultSet object) advances one row.

   • A Boolean value (true/false) returns to indicate whether there is, in fact, a row to advance to.

5. For each row, retrieve the values    Values are retrieved for each column in the ResultSet object by identifying either the name or position of the column. You can use the getDate method to get the value from a column on the current row.

Java objects can use JDBC objects to interact with a database and get data for their own use, for example to manipulate or for use in other queries.