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