Example: Using data access beans in Version 4.0

package examples;

import com.ibm.db.uibeans.*;
import com.ibm.db.*;
/**
 * This type was created in VisualAge.
 */

public class SelectStatementExample {
/**
 * GenericTest constructor comment.
 */
public SelectStatementExample() {
	super();
}
/**
 * Starts the application.
 * @param args an array of command-line arguments
 */
public static void main(java.lang.String[] args) {
	// Objects

	SelectStatement stmt = new SelectStatement();
	DatabaseConnection conn = new DatabaseConnection();
	StatementMetaData metaData = new StatementMetaData();
	SelectResult result;

	// Set properties for connection
	conn.setDriverName("COM.ibm.db2.jdbc.app.DB2Driver");
	conn.setDataSourceName("jdbc:db2:Sample");
	conn.setUserID("userid");
	conn.setPassword("password");

	// Set SQL statement
	metaData.setSQL("SELECT * FROM DEPARTMENT");

	// Associate connection and metadata with stmt 
	stmt.setConnection(conn);
	stmt.setMetaData(metaData);

	try {
		// Execute SQL statement
		stmt.execute();

		// Process results
		result = stmt.getResult();
		for (int i = 1; i <= result.getNumRows(); i++) {
			System.out.println(result.getColumnValueToString(1));
			System.out.println(result.getColumnValueToString(2));
			result.nextRow();
		}
		
		// Release JDBC resources
		result.close();

		// Close the database connection
		conn.disconnect();

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


Related reference
Administrative console buttons
Administrative console page features



Searchable topic ID:   olddatbeans
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_olddatbeans.html

Library | Support | Terms of Use | Feedback