Programming instructions

120 Lesson 5 Implementing the Browsing and Maintenance Database Functions
Enhancing the Trip Maintenance application
In this lesson, you will make enhancements to the sample Trip Maintenance application
that you created in previous lessons. In Lesson 4, you added buttons to the Trip Detail
page to browse, add, edit, delete or search for records in the database. In this lesson you
will build the action pages that implement the actions for these buttons.
Page flow
You will combine the Trip Detail page and the search pages you built in the previous
lessons with a maintenance action page and a navigation action page you will build in
this lesson. In the final two lessons you will build a Trip Edit page to complete the trip
maintenance facility. The following figure shows the flow of the finished Trip
Maintenance application pages:
Notice that the Trip Detail page is at the center of the Trip Maintenance application.
Depending on the user action, the Trip Detail page navigates the records in the database
or connects to the appropriate page to add, edit, delete, or search for records in the
database.
In order for the application to process the user actions from the Trip Detail page, you
must build the two action pages for the navigation and maintenance functions.
Navigation action page
This navigation action page determines which triprecord displays on the Trip Detail page
after the user presses one of the navigation buttons. There is no HTML output displayed
from this action page. Instead, this page uses dynamic SQL to identify the
tripID that
must display on the Trip Detail page. In this dynamic SQL statement the proper
tripID
is passed as a parameter to the URL then redirects it to the Trip Detail page.
Trip Search page
Trip Search Results page
Trip Detail (main) page
Trip Edit page
Navigation Action page
Maintenance Action page
move first, last,
next, or previous
delete
add or edit