Example: Using data access beans in Version 5.0
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();
}
}
}

Administrative console buttons
Administrative console page features
Searchable topic ID:
newdatbeans
Last updated: Jun 21, 2007 4:55:42 PM CDT
WebSphere Application Server Network Deployment, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/rdat_newdatbeans.html