Welcome
Getting started
Do and Learn
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.
Summary
You completed the Access a database with EGL Rich UI tutorial.

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.
  - 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.
    - Introduction
    - Lesson 1: Plan the application
      Design your application on paper before you begin coding.
    - Lesson 2: Connect to a new Derby database
      Use the Derby open source database manager to handle the data store for the application.
    - Lesson 3: Set up the projects and use the EGL SQL retrieve feature
      Before you write your logic, create two EGL projects, as well as a Record part that is based on the database table.
    - Lesson 4: Create the Rich UI handler
      Start to build the handler by using EGL wizards and then the Rich UI editor.
    - Lesson 5: Create the service
      Create a dedicated service to access the database.
    - Lesson 6: Add code for the service functions
      In EGL, I/O statements such as add and get access data that resides in different kinds of persistent data storage, from file systems to queues to databases. The coding is similar for the different cases.
    - Lesson 7: Create a library of reusable functions
      Create a library to format money values and to associate category numbers with descriptions.
    - Lesson 8: Add variables and functions to the Rich UI handler
      Add source code that supports the user interface.
    - Lesson 9: Complete the code that supports the user interface
      Next, you will complete the single-row layout, as well as the code that supports the Clear and Save buttons.
    - Lesson 10: Install Apache Tomcat
      You can use Apache Tomcat to display the web page and to run the EGL-generated service.
    - Lesson 11: Deploy and test the payment application
      During the deployment process, EGL creates HTML files and server-specific code to match your target environment.
    - Summary
      You completed the Access a database with EGL Rich UI tutorial.
    - Resources
      A variety of resources are available.
Installing
Upgrading and migrating
Developing
Samples
Troubleshooting and support
EGL runtime error messages
Reference
Glossary
Using the help
Notices for IBM Rational Business Developer documentation

Summary

You completed the Access a database with EGL Rich UI tutorial.

You practiced the following skills:

Creating and accessing a relational database.
Creating a library of reusable functions.
Designing and deploying a Rich UI application and a dedicated service.