Product maintenance with a database using jdbc

Assignment Help JAVA Programming
Reference no: EM132153491

The Project

The following pages present the user interface, operation, and specifications for each project. As you view these pages, remember that each part builds upon the previous parts.

Part_1: Product Maintenance
For this part, you'll create a series of pages that allow you to add, update, or delete a product that's available to the application.

Operation
(1) When the application starts, it displays the Index page. This page contains a link that leads to the Products page that can be used to add, update, or delete products.
(2) To add a new product, the user selects the Add Product button. This displays the Product page with all text fields empty. Then, the user can fill in the text fields and click on the Update Product button to add the product.
(3) To edit an existing product, the user selects the Edit link for the product. This displays the Product page with all existing data for the product displayed. Then, the user can edit any entries and click on the Update Product button to update the data for the existing product.
(4) To delete a product, the user selects the Delete link for the product. This displays the Confirm Delete page. Then, if the user confirms the deletion by selecting the Yes button, the product is deleted and the Products page is displayed to reflect the new data. If the user selects the No button, the Products page is displayed.

Specifications

(1) Use a Product class like the one shown later in this document to store the product data.
(2) Use a ProductIO class like the one shown later in this document to read and write the product data to a text file named products.txt in the WEB-INF directory.
(3) Use a text file like the products.txt file shown later in this document as a starting point for the products that are available to the application.
(4) Use server-side validation to validate all user entries. In particular, make sure the user enters a code, description, and price for each product. In addition, make sure the product's price is a valid double value.
(5) If possible, get the Product.java, ProductIO.java, and product.txt files from your instructor or trainer. Otherwise, you can create these files yourself.

Part_2: Product Maintenance with custom tag validation
For this Part, you'll enhance the application described in Part_1 by adding a custom tag to validate user entries.
Specifications
(1) Use a custom tag to mark empty fields that are required on the Product page with an asterisk.

Part_3: Product Maintenance with a database using JDBC
For this Part, you'll enhance the application described in the previous Parts by modifying it so it uses a database instead of a text file to store the product data. You'll use JDBC to work with the data.
Specifications
(1) Use a class named ProductDB that's in the music.data package to add, update, and delete the products in the Product Maintenance application. This class should use JDBC.
(2) Use a connection pool as described in chapter 12.
(3) Use the music database (available on Moodle for download as DB.zip)

Part_4: Product Maintenance with a database using JPA
For this Part, you'll convert the application in the previous Parts so it uses JPA instead of JDBC to work with a database.
Specifications
(1) Add JPA annotations to the Product class.
(2) Use a class named ProductDB that's in the music.data package to add, update, and delete the products in the Product Maintenance application. This class should use the EclipseLink JPA provider.
(3) Since the EclipseLink JPA provider automatically creates a connection pool, please delete any old code that creates a connection pool for JDBC.
(4) Use the music database (available on Moodle for download as DB.zip)

Part_5: Product Maintenance with SSL and authentication
For this Part, you'll enhance the application described in the previous Parts by modifying it so it uses a secure connection and only allows authorized users (refer to chapters 1-13, 15, and 16 of textbook B)

Specifications

(1) Restrict access to all pages except the Index page. Only allow users in the programmer role and customer service role to access the rest of the pages in the Product Maintenance application. To do that, use the UserPass and UserRole tables in the murach database to define the usernames and passwords for these roles.
(2) Use a secure connection for all pages except the Index page.

Part_6: Product Maintenance within the Music Store web site
For this project, you'll enhance the application described in the previous projects by adding it to the admin section of the Music Store web site. (Prerequisites: 1-13,15, 16, 22 and 23)

Specifications

(1) Add the JSP files for the Product Maintenance application to the admin directory of the Music Store web site.
(2) Add the controller servlet for the Product Maintenance application to the music.admin package of the Music Store web site.
(3) Modify the admin/index.jsp file of the Music Store web site so it includes a button that starts the newly added Product Maintenance application.
(4) Modify all necessary JSP, CSS, Java, and XML files within the Music Store web site so they work with the newly added Product Maintenance application.
(5) In the controller for the Product Maintenance application, use the getRequestURI method to determine which action to process as shown in chapter 22. If the URL doesn't match any actions in your application, use the sendError method of the response object to send a 404 error to the user to indicate that the page isn't available.
(6) Don't break the other applications in the existing Music Store web site.

Attachment:- Project Part.rar

Verified Expert

this is website which have a three module..first module is connectivity with database with insert ,update,delete and display operation ... Second module which have login authetication for only user can do all operation...third module which have html and css style website

Reference no: EM132153491

Questions Cloud

How much faster is the pipelined machine : How much faster is the pipelined machine over the non-pipelined machine assuming no branches are taken?
Supply curves in the healthcare insurance market : Please explain your answer briefly in the language of economics by stating the shift(s) of demand and/or supply curves in the healthcare insurance market.
Supply curves in the gas market : Please explain your answer in the language of economics by stating the possible shift(s) of demand and/or supply curves in the gas market.
Determine which algorithm runs faster : Determine which algorithm runs faster. Show your work; you will need to compute a maximum common point after which one algorithm is better.
Product maintenance with a database using jdbc : MITS5502 Developing Enterprise Systems - enhance the application described in the previous Parts by modifying it so it uses a database instead of a text file
What are two of the best current platforms used for systems : What are two of the best current platforms used for systems integration and how do they compare?
What is the probability that a driver will experience : What is the probability that a driver will experience exactly one dead end spinning event (Think of which probability density function to use)?
What are two-dimensional arrays : Write a code segment that declares a variable to reference an array of integers with 10 rows and 20 columns and assigns this variable a new array object.
Which frequency band will you prefer : There two frequency bands with one locating on 900 MHz and the other one locating on 5 GHz.

Reviews

urv2153491

11/29/2018 11:27:33 PM

Just Exclude part 4, Rest all have to put according to comments: Part 1,2,3 , 5,6 I’m happy with the work you updated and this is what I was expecting , I wanted the screenshots of code run on the system for all the parts except part 4. I got each part of code run screenshot on system & output of that code screenshot to be added. You people are the best. Hey there, ExpertsMind I would like to say that I had the best experience ever of getting my assignment done and submitted before the deadline. If I had to do it then obviously I would have never been able to secure such good marks and also the assignment would have resulted in me getting a zero. It was because of your experts, only that I was able to score the perfect grade.

Write a Review

JAVA Programming Questions & Answers

  Make a row with different string names

How do you make a row with different string names and put a certain amount of space between each one?

  Develop a java program given the width, length and depth

Write the source code for each class in a separate file which must have the same name as the class name together with the extension .java. Remember also that by convention, class names commence with a capital letter.

  How to access to elements of document object model

To limit creation of malicious code, do you believe that access to elements of document object model and some Javascript functionality be limited?

  Write java program that prints asks the user to enter value

Write a Java program that prints asks the user to enter a positive value (1 less than or equal to 200) and print each number up to that line, 1 per line with the following changes (SNAP CRACKLE POP).

  What does the variable x contain

What does the variable x contain at the end of each of these computations? If the code is not legal in Java, say so.

  Change code in java program so that input of floating point

Change code in Java program so that input of floating point values is possible.

  Draw the result of taking the tree in the diagram

Draw the result of taking the tree in the diagram and deleting the root three times using the deletion algorithm from lecture and the web

  How to setup a program to respond to events

Discussing how to setup a program to respond to events from any one of these sources - How do you create the necessary listener class? How do you associate the listener object with the event source?

  Methods prevent us from modularizing a program

QUESTION 1Which is true about methods Methods prevent us from modularizing a program protecting it from fragmentation. Methods allow us to modularize a program.

  Netbeans programming assignment

Design the classes and methods that will go into your program; your grade will be based on how well you do this - how much money is in their account

  Design java application that will read file containing data

Design a Java application that will read a file containing data related to the US. Crime statistics from 1994-2013 - What year was the Murder rate the highest

  Determine the worst-case time complexity

Determine the worst-case time complexity of the following pseudocode algorithm. Assume that DoOtherStuff has a time complexity of O(n) where n = r-l

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd