Retrieving Data Using JDBC

Retrieve data through the JDBC API by implementing the following three steps:

  1. Obtain a driver and establish a connection to a database.

  2. Send an SQL statement to the database and retrieve data.

  3. Assign the data returned from the database to local variables.

The following sections introduce methods you can use to implement each of the three steps used to retrieve data through the JDBC API while you write an example bean, the DatabaseAccess bean, shown in Listing 14.1.


The DataAccess bean is hard coded to use a JDBC-ODBC Bridge text driver configured with the directory selected containing the database text files. See the previous section, "Setting Up an ODBC Driver," for more information.

Listing 14.1 Source code for ...

Get JavaBeans Unleashed now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.