VisualAge for Java supports access to relational databases through
JDBC. You can access relational data in an applet or application by
using the Data Access beans on the Visual Composition Editor beans
palette. Data Access beans include the following:
- The Select bean enables you to run a query and access the result set
returned by the query. You can insert, update, and delete rows in the
result set without writing seperate SQL INSERT, UPDATE and DELETE
statements.
- The Modify bean enables you to run SQL INSERT, UPDATE, or DELETE
statements without first running a query and retrieving its result set.
- The ProcedureCall bean enables you to run a stored procedure passing
values for input parameters and receiving values for output parameters.
If the stored procedure returns one or more result sets, the ProcedureCall
bean gives you access to them, and you can insert, update, or delete rows
within the result sets without writing separate SQL INSERT, UPDATE, and DELETE
statements.
- Four Selector beans provide you with different views of the data
returned. They are:
- CellSelector, which provides a single-value view
- RowSelector, which provides a row view
- ColumnSelector, which provides a column view
- CellRangeSelector, which provides a two-dimensional view
- The DBNavigator bean is a visual bean that you can use with a Select bean
or ProcedureCall bean. The DBNavigator bean provides a set of buttons
that run the SQL statement for the associated nonvisual bean; navigate rows in
the result set; or perform other relational database operations, such as
commit updates to the database.
Before you can use the Data Access beans, you must first use the Quick
Start window to add the Data Access beans feature to VisualAge for Java, and
you must change the class path. For more information on accessing
relational data, refer to the online help.
