+

Search Tips   |   Advanced Search

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




 

Related


Administrative console buttons
Administrative console page features