Data retrieval in JDBC applications - IBM DB2 9.7 for Linux, UNIX, and Windows

Retrieving data from tables using the Statement.executeQuery method
To retrieve data from a table using a SELECT statement with no parameter markers, you can use the Statement.executeQuery method.

Retrieving data from tables using the PreparedStatement.executeQuery method
To retrieve data from a table using a SELECT statement with parameter markers, you use the PreparedStatement.executeQuery method.

Making batch queries in JDBC applications
The IBM® Data Server Driver for JDBC and SQLJ provides a IBM Data Server Driver for JDBC and SQLJ-only DB2PreparedStatement interface that lets you perform batch queries on a homogeneous batch.

Learning about a ResultSet using ResultSetMetaData methods
You cannot always know the number of columns and data types of the columns in a table or result set. This is true especially when you are retrieving data from a remote data source.

Characteristics of a JDBC ResultSet under the IBM Data Server Driver for JDBC and SQLJ
The IBM Data Server Driver for JDBC and SQLJ provides support for scrollable, updatable, and holdable cursors.