EDT:Tutorial: RUI With Database Introduction
|< Previous | Next >|
The web page displays all rows in a database table and lets the user update each one. In addition, the user can add and delete rows.
The technology for developing the web page with EGL Rich UI involves several steps:
- You write the code.
- You deploy all the code to a server such as Apache Tomcat.
- The application both presents data to the user and accesses services that run remotely on a server.
A main benefit of EGL Rich UI is that users can interact with a responsive, local-running web application even as services do background work such as accessing a database.
In this tutorial, the Rich UI application accesses a service that you write and deploy along with the Rich UI application. This kind of service is called an EGL dedicated service. In general, you can use a dedicated service to do tasks that other EGL-generated Java services can do, such as accessing a database or file system. However, the dedicated service is not available to other code unless you redeploy it as an EGL-generated web service.
The benefit of a dedicated service results from its shared deployment with the Rich UI application. If a Rich UI application accesses a web service, your deployment of the application typically requires that you specify the service location. However, if a Rich UI application accesses a dedicated service, your deployment of the application does not require the location detail. Instead, the service will be available wherever you deploy the Rich UI application. <p;>Note: Invocation of a dedicated service is slow in the Rich UI editor, but access is much faster when the application and services are deployed to a server.
The learning objectives are described in [egl_richui_sql_abstract.html Access a database with EGL Rich UI].
This tutorial takes about 3 hours to finish. If you explore other concepts related to this tutorial, it might take longer to complete.
You can create the EGL files you need for this application in one of the following ways:
- Line by line (most helpful) : Complete the individual lessons to explore the code in small, manageable chunks, learning important keywords and concepts. This method also requires the greatest time commitment.
- Finished code files : At the end of each lesson in which you develop logic, you can link to the completed code, which you can copy into the Rich UI editor.
This tutorial is designed for people who know the basic concepts of programming and want experience with EGL Rich UI.
To complete this tutorial, you must have the following tools and components installed on your computer:
- Rational® Business Developer Version 220.127.116.11 or higher.
- A working Internet connection.
You do not need any experience with EGL to complete this tutorial.
You will create a working Rich UI application and database-access service.
Lessons in this tutorial
- 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.
|< Previous | Next >|