EGL Data Parts and Pages wizard

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 page handlers that you later generate into a set of parts that run under Java Server Faces

• An SQL record part, as well as the related data-item 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 data-item 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, however, if you ask to include each record part in a record-specific library.

You can customize the Web-based utility after the wizard creates it.

Related concepts
Java program, page handler, and library
SQL support

Related tasks
Creating a single-table EGL Web application
Creating, editing, or deleting a database connection for the EGL wizards
Customizing SQL statements in the EGL wizards
Defining Web pages in the EGL Data Parts and Pages wizard