Grading Rubric for Project 4 - Fall 2022Grading Rubric for Project 4 - Fall 2022CriteriaRatingsPtsThis criterion is linked to a Learning...

Submit your entire Project4 folder from your Tomcat installation webapps folder. This should include all files necessary to run your three applications. Your webapp folder must be named Project4. Do not submit individual files from this webapp, include the entire Project4 webapp structure from Tomcat.

You provided the 33 required screenshots showing your application's execution of each of the command sequences in the project4rootcommands.sql, project4clientcommands.sql, project4dataentrycommands.sql script files, and the final screenshot from the MySQL Workbench. The assumption for this project is that your "client" has only select privileges on the project4 database and the "root" has all permissions. Your data entry-level user will only use the interface provided via the PreparedStatement interface. This criterion carries the most weight as it is essentially demonstrating that your servlet applications correctly implement the requirements of the project.
Note: You can include the folder of screenshots in the top-level of your Project4 webapp if you would like. Otherwise, submit them as a separate folder and be sure to inform the TAs where your screenshots are located.
See the project document for a complete listing of the exact screenshots needed for this project submission. Be sure to label your screenshots and keep them in the proper order in your submission.

Your front-end pages (for all three applications) must utilize JSP technology (it is not an HTML page) that allows the application to refresh only a portion of the displayed page rather than requiring an entire page refresh. As per the project document, your front-end JSP files for the root-level and client-level users provides the user an "Execute Command" button, a "Reset Form" button, and a "Clear Results" button.The connection to the database is handled by the servlet and must be made via properties file data (resident on Tomcat). The data entry-level user front-end page is also a JSP page, but contains only input template forms for user data entry and does not allow the user to enter SQL commands. The SQL command to insert a new record into the correct table, as per the interface, is executed via a preparedStatement().

If you did the bonus part of the project, be sure to indicate to the TAs that you implemented the bonus version of the business logic in your application. To get full credit for the bonus part, it must be correctly implemented. This means that ONLY those suppliers directly affected by an update have their status values altered. This will be reflected in your screenshots for the project4rootcommands.sql and project4dataentrycommands.sql scripts. Note that these are bonus points and the project itself will count as 100 points like all other projects.