You can use the
workbench to generate a number of Java™ objects
to base your applications
on.
Generating pureQuery code from database objects
From a database connection
in the workbench, you can right-click
tables, views, aliases, materialized query tables, and stored procedures
to generate pureQuery code.
Generating pureQuery code from beans
You can generate pureQuery code from a bean that is open
in the Java editor. If a table
corresponding to the bean does not yet exist in the associated database,
you can generate a DDL statement for creating the table.
Generating beans to hold result sets from SQL SELECT statements
You can generate a bean to hold the result set that the
statement returns. You can use an SQL SELECT statement that is in
any string literal in a Java class
that contains a valid SQL SELECT statement, as long as the Java class appears in a Java project that supports pureQuery.
Generating implementation classes with the help of XML configuration files
When you generate an implementation of an
interface, you
can use an XML file to override the SQL annotations in that interface.
The XML file can also override the definition of the corresponding
bean. The workbench can generate the XML file for you and you can
edit it.