Accessing data with the Select bean

To access relational data using the Select bean:

  1. Add the Select bean to the Visual Composition Editor surface.
  2. Edit the Select bean properties. The query property allows you to define the following things:
  3. Connect the Select bean to a visual component of your applet or application, such as a button bean. When a user uses the application or applet, and selects the visual component, for example clicks the button, the SQL statement for the Select bean retrieves a result set.

You can also use the Select bean to apply changes that users make to a result row, even deletion of a row, and commit the changes to the database. In these cases, you use update and delete methods provided by the Select bean.