java advance 4

Application Requirements

You have decided that it would be beneficial to change your application from a desktop application to a Java Web application. Investigate how you could use J2EE technologies such as JDBC, JSP, Hibernate, EJBs, Servlets, JSF, or XML to develop a Java Web application that will allow a user to create, read, update, and delete records in product and customer tables of the store database. The schema provided earlier in the course must be used.

Applying the J2EE technologies of your choice, create an application that runs in a Web page, and connect to the MySQL store database. You may reuse some of the code developed in the earlier tasks. Your application must now run in a Web page and not run as a desktop application.

Please use the user ID and password provided by your instructor in the code that connects to the database:

Login: ctuonline
Password: student

Design Document Requirements

Update your design document to reflect a Java Web application that will allow a user to create, read, update, and delete records in product and customer tables of the store database for an online store. Provide a description of the system architecture, including diagrams of all components and tiers including presentation, application, business logic, data access, and data storage. Diagrams should be drawn using UML notation. Please note that your design document will also serve as  your Key Assignment Draft in the next Discussion Board assignment.

Users Manual Requirements

Provide a user’s manual that explains how to start and use your application. If your instructor cannot run your application, you will not receive credit for this assignment. Use the schema provided earlier in the course for the product and customer tables. Include a SQL script file to build the store database with populated tables for the product and customer. Include any MySQL username and password required to run your application. Include screenshots if necessary to convey your instructions.