DB2 Version 10.1 for Linux, UNIX, and Windows

Data retrieval in JDBC applications

In JDBC applications, you retrieve data using ResultSet objects. A ResultSet represents the result set of a query.

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.
Retrieving rows as byte data in JDBC applications
You can use the DB2ResultSet.getDBRowDataAsBytes method to retrieve an entire row from a table as raw bytes, and retrieve the column data from the returned rows.

Parent topic: JDBC interfaces for executing SQL