Building Scalable and High-Performance Java™ Web Applications Using J2EE™ Technology

JDBC Concepts and Objects

When developers use JDBC, they construct SQL statements that can then be executed. These statements are dynamic in the sense that a template-like query string, such as

SELECT name FROM employee WHERE id = ?

can be combined with local data structures so that regular Java objects can be mapped to the bindings in the string (denoted ?). For example, a java.lang.Integer object with the value of 3 can be combined with the template to dynamically form

SELECT name FROM employee WHERE id = 3

The results of execution, if any, are contained in a set returned to the caller. For example, the query may return the following results:

NAME
------
Angela
Andrew
Anthony

We can browse this result set as necessary. This gives us the ...