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();
    }
  }
}

---

 

---