Web System Integration and Service development 8 Assignments

This is just part of all the assignments I will give you all 8 of them (Removed by Freelancer.com admin) create a NetBeans Java enterprise project with a JPA entity in the EJB module. When creating theenterprise project, you may omit the Web project module. The JPA entity should be created from a“PRODUCTS” database table (see below). Use the NetBeans IDE derby services interface to create yourdatabase and enter initial data before creating your enterprise [login to view URL] test your JPA code, call it from a Java client (a Java class with a main method). Add the Java clientto your EJB application module. Your code must be able to select and display product data from thePRODUCTS database table based on specific product ids (PID).[login to view URL] a new database named “productdb” containing one table named “PRODUCTS.” This tableshould be defined as [login to view URL] - 8 alphanumeric characters (e.g., P0001000). Make this column the primary [login to view URL] - 20 alphanumeric characters (e.g., circular saw)PQTY - integer value representing quantity on handPPRICE - decimal value with two decimal places (e.g., 129.99)[login to view URL] initial test data into the PRODUCTS table of your database (at least 4 rows of data).[login to view URL] a [login to view URL] file by right-clicking on the EJB module and selecting New->persistence->persistence-unit. This will create a [login to view URL] file in the Configuration Filesfolder of the EJB module. If you also see a [login to view URL] file in the ConfigurationFiles/META-INF folder, delete it. Then, replace the contents of the [login to view URL] file with thestatements given below.(See page 2 below.)[login to view URL] a JPA entity bean from the PRODUCTS table in the productdb [login to view URL] a Java class (with a main method) that will call the JPA code to retrieve desired productdata, and then display the selected product data in an application output window. Add this Javaclass to your EJB module source package. Copy and paste the main method shown below onpage 2 into this new Java class. Make sure you paste the main method “inside” the class codeblock that was generated by NetBeans. You will need to add appropriate code to the mainmethod in order to test the entity bean. Chapter 4 of the Beginning Java EE 7 textbook, thesection titled “Writing the Main Class” provides examples of how to test entity bean [login to view URL] your application with valid and invalid product id values. Your code should display a “NotFound” message if the product id is invalid.