Project :. Manage Stages for a Training Session
In this project, you need to develop a web application to manage members' training stages during a
training session. When a member signs in at this web application, there are four stages listed, and the
member's finished stages are marked. When the member clicks the training button, the training
material will be provided for the next training stage until the member completes the whole training
You need to create a database called training that contains two tables: member and
1.The member table has five fields: member_id, username, password, stage_number,
practice_number, where the member_id field has the auto-increment integer values used as
the primary key.
2.The page_visit table has three fields: browser_id, browser_name, hit, where the
browser_id field has the auto-increment integer values used as the primary key. You need to count
the number of hits for the following browsers: Firefox, Chrome, IE, Safari, Others.
Based on your own understanding, you design your users' interface. The basic requirement is: If your UI
supports all the features in this project.
1.When a member comes to the web application, a sign-in page is displayed. The member has to sign in
to access the training page.
2.When a member fails the sign-in step, you do not have to show any error message. After the member
passes the sign-in step, you display the main training page.
3.After the member passes the login step, you check the browser type of the member and do the
counting and update the table.
4.The main training page could be very simple, just list all stages in the training session, and all the
stages the current member has passed should be clearly marked. The username of the member
should be displayed on top of the page.
5.There is a training button on the main training page. When the member clicks it, the corresponding
training material is sent to the member for downloading.
6.The four training materials are all binary files. The first three are PDF files, and the last one is a JAR
file. They are stored on the server.
7.When a member clicks the training button, try to open a new browser window or tab for the material to
be downloaded, so that after the download, you can close the window or tab to go back to the system.
When you refresh the page, the member's current status is updated.
8.There is a sign-out button or link on the main training page. When a member clicks it, the session is
destroyed, and it returns to the sign-in page.
Use a session to store the member's 1. information.
2. You use a servlet to handle the binary files for the training materials.
3. Use JSPs to display the login page and the main training page.