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 reference
Administrative console buttons
Administrative console page features
Reference topic Reference topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 30, 2013 4:53:43 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-base-dist&topic=newdatbeans
File name: rdat_newdatbeans.html