design and implement a JDBC application that runs both as a stand-alone JDBC application and a stored procedure within Oracle using a PL/SQL wrapper

Secure Coding with Oracle Overview: This work provides an opportunity to write JDBC applications and store those in an Oracle database using a PL/SQL wrapper. The queries will use prepared statements to minimize security concerns. ============================================================== Using the Schema I have developed for the e-Commerce project (the sql code is attached here), design and implement a JDBC application that runs both as a stand-alone JDBC application and a stored procedure within Oracle using a PL/SQL wrapper. Your application should provide JDBC functionality demonstrating a. Inserting a new record into a table using input from the user at run time. b. Update an existing record in a table using input from the user at run time. c. Deleting an existing record in table using input from the user at run time. d. Retrieving records based using input from the user at run time. Note: using input from the user at run time means that the SQL statements should have a parameter(s) that the user enters at run time. Be sure your code works as a standalone Java application and then follow the steps to create PL/SQL wrapper and then demonstrate the same functionality running from within Oracle. =============================================================== Deliverables: 1. Create a word or PDF document that describes your process, steps and results. Be sure to describe your schema and the queries you are using for your application. Provide screen shots showing the successful running of all of your SQL statements and testing your implementation for both the Java application and the PL/SQL implementation. Be sure your testing is comprehensive demonstrating all functionality. Describe and demonstrate why your applications are secure from SQL Injection. 2. A .java file(s) that compiles and runs perfectly for Java application 3. A .sql script file containing all SQL statements you used for this effort. All SQL statements should be in one file with appropriate connect statements to differentiate users who run the script. The script file should contain comments describe each major set of SQL statements. The script should run perfectly without error when executed from the Oracle SQL*PLUS environment. Be sure your Pl/SQL wrapper implementations are within this script.