Welcome
Getting started
Do and Learn
Introducing EGL
In this tutorial, you will learn how to build a simple dynamic web site using EGL. This site has two pages: one to display a list of records in a database and another to allow users to change the data from one of those records.
Resources
This tutorial used the following resources:

Overview
Getting started
- Tutorials
- Do and Learn
  - Introducing EGL
    In this tutorial, you will learn how to build a simple dynamic web site using EGL. This site has two pages: one to display a list of records in a database and another to allow users to change the data from one of those records.
    - Introduction
      In this tutorial, you will learn how to build a simple dynamic web site using EGL. This site has two pages: one to display a list of records in a database and another to allow users to change the data from one of those records.
    - Lesson 1: Setting up EGL
      In this lesson, you will prepare to use EGL by setting up your workspace and enabling the EGL capability.
    - Lesson 2: Create the projects and import the database
      In this lesson, you will create projects to hold your EGL application and add a database to use.
    - Lesson 3: Set up the database connection
      In this lesson, you will connect your project to the database that you imported in the previous lesson.
    - Lesson 4: Create parts to access a database
      In this lesson, you will create the data and logic parts that allow you to access the sample database.
    - Lesson 5: Create a web page
      In this lesson, you will create a web page in the form of a Faces JSP file. In the next lesson, you will add data to this page using the data parts and functions you created in the previous lesson. When the page is finished, it will show a list of every record in the database.
    - Lesson 6: Add data to the page
      In this exercise, you will add data from the database included with this tutorial onto the web page that you created in the previous exercise.
    - Lesson 7: Pass a parameter to another page
      The file allcustomers.jsp lists every row in the database. In the next exercise, you will create a second page that displays the details from one row in the database. In this exercise, you will add a link on the file allcustomers.jsp that sends the user to the detail page. That link also indicates which record to display on the detail page.
    - Lesson 8: Create an update page
      In this exercise, you will create the web page that allows users to update the CUSTOMER table. This page will receive the parameter that the other page passed, display only the record indicated by that parameter, and accept updated information for the record.
    - Summary
      This is the end of the Introducing EGL tutorial.
    - Resources
      This tutorial used the following resources:
      - Completed allcustomers.egl file after lesson 6
        This code is the completed version of the allcustomers.egl file. If you see any errors marked by red X symbols in the file, make sure your code matches this code:
      - Completed updatecustomer.egl file after lesson 8
        This code is the completed version of the updatecustomer.egl file. If you see any errors marked by red X symbols in the file, make sure your code matches this code:
  - Create a hello world program with EGL
    In this tutorial, you will learn how to write and run your first EGL program. Although the program you create will not be powerful or complex, it will demonstrate how an EGL program works.
  - Create a hello world service with EGL
    In this tutorial, you will learn how to build a simple web service with EGL. Then, you will create a client that uses this service.
  - Create a mortgage application with EGL Rich UI
    Create a Rich UI application so that the user can do the following tasks: calculate monthly mortgage payments, given a loan amount and interest rate; display a pie chart that tells the interest and principal for the life of the mortgage; retrieve any of the payment calculations that were provided earlier to the same user; and display a map of the mortgage lenders who have offices in one or another U.S. zip code.
  - Access a database with EGL Rich UI
    In this tutorial, you create a Rich UI application so that the user can access rows in an SQL database.
Installing
Upgrading and migrating
Developing
Samples
Troubleshooting and support
Reference
Glossary
Using the help
Notices for IBM Rational Business Developer documentation

Resources

This tutorial used the following resources:

A sample Derby database, found at the following location:
```
shared_resources/plugins/com.ibm.etools.egl.tutorial0001.doc_version/
   resources/eglderbydb.zip
```
shared_resources

The shared resources directory for your product, such as C:\Program Files\IBM\SDP70Shared on a Windows™ system or /opt/IBM/SDP70Shared on a Linux™ system. If you installed and kept a previous version of an IBM® product containing EGL before installing your current product, you may need to specify the shared resources directory that was set up in the earlier installation.

version

The installed version of the plugin. If more than one is present, use the one with the most recent version number, unless you have a reason to use an older version.
Completed allcustomers.egl file after lesson 6
Completed updatecustomer.egl file after lesson 8

Following are some links to the help system on topics covered in this tutorial: