SDEV 350 Homework 4 – Secure Coding with Oracle

SDEV 350 Homework 4 – Secure Coding with Oracle
Overview:
This homework provides an opportunity for the student 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.
Assignment: Total 100 points
Using the Schema you developed in Homework 1 for your e-Commerce project, 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.
b.
c.
d.

Inserting a new record into a table using input from the user at run time.
Update an existing record in a table using input from the user at run time.
Deleting an existing record in table using input from the user at run time.
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. The document should be neat, well-organized, wellwritten and contain minimal grammar and spelling errors.
2. A .java file(s) that compiles and runs perfectly for your 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.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.