Example: Using data access beans

package example;
import com.ibm.db.beans.*;
import java.sql.SQLException;

public class DBSelectExample {

 public static void main(String[] args) {

  DBSelect select = null;

  select = new DBSelect();
  try {

   // Set database connection information    select.setDriverName("COM.ibm.db2.jdbc.app.DB2Driver");
   select.setUrl("jdbc:db2:SAMPLE");
   select.setUsername("userid");
   select.setPassword("password");

   // Specify the SQL statement to be executed    select.setCommand("SELECT * FROM DEPARTMENT");

   // Execute the statement and retrieve the result set into the cache    select.execute();

   // If result set is not empty    if (select.onRow()) {
    do {
     // display first column of result set      System.out.println(select.getColumnAsString(1));
     System.out.println(select.getColumnAsString(2));
    } while (select.next());
   }

   // Release the JDBC resources and close the connection 
   select.close();

  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }
}