CSC 3140-W12 Advanced Programming Techniques Project- EAU .

Unit Code Unit Title Semester CSC 3140 Advanced Programming Techniques Fall 2021 Assessment Type Assessment Title Purpose of the assessment (with CLO Mapping) Individual Assignment Accessing and updating a Users table (Servlets and JDBC) This assignment is designed to assess students’ knowledge and skills related to the following learning outcomes: Weight Total Marks Word limit Submission Guidelines 10% of the total assessments 100 NA • All work must be submitted on Moodle by the due date along with a cover page. • The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font and 2.54 cm margins on all four sides of your page with appropriate section headings. • Reference sources must be cited in the text of the report and listed appropriately at the end in a reference list using IEEE or Harvard referencing style. Week-12, 18th November 2021 – submit your report on Moodle and CodePost • Late project submissions will result in a penalty. A one-week late submission results in a 10% deduction on the project marking; while a project submitted between 1 and 2 weeks late will be subject to a 20% deduction on the project marking. Submissions after two weeks will be considered a fail on the project. • Plagiarism is defined as the presentation of another person’s work as your own. This includes copying from books without referencing the material or copying from another student’s work Assessment Details and Submission Guidelines Due Date Late submission Academic Misconduct and Plagiarism Instructor Name Moderator 1. LO-3: Use JDBC drivers and advance programming concepts in database 2. LO-4: Apply server-side technologies using JSP. Dr.Mostafa Kamil Dr Blessy Assignment Description (Servlets and JDBC) Write a servlet that enables the user to update his first name and last names from an HTML form. The servlet performs the following tasks: • Verify that the user filled in all the fields in the HTML form. If the user missed any of these fields, the servlet will show an error message. As shown in figures 2 and 3 below. • Verify the username and password. If the user enters an incorrect username or password servlet will show an error message. As shown in figures 4 and 5 below. • If all user information is entered correctly, Servlet will update the user’s last and first names in the database and show a confirmation message. As shown in Figures 6 and 7 below. Suppose the user information is stored in a database table named users with four columns: firstname, lastname, username and password. The user table is defined as follow : Figure-1: Users table Note: after creating the users table, enter some demo information to be used for testing. Figure-2: User missed one field Figure-3: Servlet error message for missing one or more fields Page 2 of 6 Figure-4: User entered incorrect username or password Figure-5: Servlet shows an error message Figure-6: User entered correct information Page 3 of 6 Figure-7: Servlet shows a confirmation message (LO-3 and LO-4) Submission Requirements 1. Signed Assignment cover sheet. 2. Report a. Cover page. b. Table of contents. c. Introduction d. Project (Servlets and JDBC) i. Analysis and Design 1. Describe the steps for solving the problem (to be submitted on Turnitin). ii. Screenshots of the database (users table). iii. Screenshots of the demo data in the database. iv. Explain the HTML codes. v. Explain the SQL queries used in the project. vi. Explain the JAVA codes. Copy and paste the source code in the word file. Format your code using Courier 10pts. vii. Describe how you test this project; provide samples of the outputs and updated database. viii. Submit the JAVA files on Moodle and codePost. 3. Turnitin report. Marking criteria: Marking criteria is shown in following tables: (Servlets and JDBC) Sections to be included in the report Analysis Design Database Page 4 of 6 Description of the section Describe the problem, including input and output in your own words Describe the major steps of solving the problem. Also, how the design solves the synchronization problem. Database implementation Marks 10 10 10 HTML Design the User interface 10 Database Queries Explain the SQL queries used in the project 20 Coding The code should be fully running. Explain the implementation steps 20 Testing Describe how you test this program with examples 15 Cover page, and table of contents and the organization of the report Write a Cover page, and table of contents, and Ensure everything is typed using a word processor and organized well. Total 5 100 Marking Rubric for Assignment-1: Total Marks 100 Note: The marking rubrics varies for each assignment Mark 80-100 70-79 60-69 50-59