The EGL Data Parts and Pages wizard gives you a convenient way to create
a Web-based utility that lets you maintain a specific table in a relational
database.
The wizard creates these entities:
- A set of PageHandlers that you later generate into a set of parts that
run under Java™ Server Faces
- An SQL record part, as well as the related dataItem parts and library-based
function parts
- A set of JSP files that provide the following Web pages:
- A selection condition page, which accepts selection criteria from
the user
- A list page, which displays multiple rows, based on the user's
criteria
- A create detail page, which lets the user display or insert one
row
- A detail page, which lets the user display, update, or delete one
row
The user first encounters the selection criteria page; but if you
fail to specify the information needed for that page, the user first encounters
the list page, which provides access (in this situation) to every row in the
table.
When working in the wizard, you can do as follows:
- Customize the Web pages described earlier, as by varying the fields displayed
or including links from one page to another.
- Specify the SQL-record key fields that are used to create, read, update,
or delete a row from a given database table or view.
- Customize explicit SQL statements for creating, reading, or updating a
row. (The SQL statement for deleting a row cannot be customized.)
- Specify the SQL-record key fields that are used to select a set of rows
from a given database or view.
- Customize an explicit SQL statement for selecting a set of rows.
- Validate and run each SQL statement
The output includes these files:
- An HTML file (index.html) that invokes the Web application.
- A set of JSP files that provide the Web pages described earlier.
- An EGL source file that contains all the dataItem parts referenced by
the structure items in the SQL record parts.
- For each SQL record part, the wizard also produces two files: one for
the record part itself, one for the related, library-based functions. You
can reduce the number of files if you select the Record and library
in the same file check box.
You can customize the Web-based utility after the wizard creates it.