Session application jsp/servlets/mysql

timer Asked: Oct 31st, 2015

Question description

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.
3.Users' interface
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.

Programming Requirements
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.

Tutor Answer

(Top Tutor) Studypool Tutor
School: New York University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors