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

Completed Posted Oct 7, 2015 Paid on delivery
Completed Paid on delivery

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.

Java MySQL Oracle SQL

Project ID: #8638169

About the project

13 proposals Remote project Active Oct 8, 2015

Awarded to:

paulprabhakarand

Hi, I am an expert on java based technologies, having more than 10 years of experience in the software industry. Have developed many applications using Java, Servlets, JSP, JDBC, Struts, Spring, Hibernate, XML, Rest More

$50 USD in 1 day
(52 Reviews)
5.9

13 freelancers are bidding on average $99 for this job

eperfections

A proposal has not yet been provided

$111 USD in 3 days
(540 Reviews)
7.6
ankit0803

I am experienced programmer. Please find my attached resume for more details about my past projects and experience.

$10 USD in 1 day
(7 Reviews)
4.9
anuragiitk

I am an IITK graduate, 9 year experienced software professional and I have got top notch developers in my team, who have got experience across a span of technologies. The members in my team have worked with top notch t More

$105 USD in 1 day
(24 Reviews)
5.6
pddkhanhhm

A proposal has not yet been provided

$700 USD in 15 days
(1 Review)
0.0
jannatwatts

i have done a project in java and sql on employee tracking system in last 6 months for a company using jdbc.

$25 USD in 1 day
(0 Reviews)
0.0
upalavivek

A proposal has not yet been provided

$25 USD in 3 days
(0 Reviews)
0.0
pcsglobalpvtltd

Hey, we are expertise in Java, MySQL, Oracle, SQL since 5+ years we can do it. If you have any query with us, please feel free to contact us on chat. It is our responsibility to complete your project as per your requir More

$20 USD in 1 day
(0 Reviews)
0.0
sravanthimutyala

I have Strong Knowledge on SQL ,Strored Procedures and Good at java ,I already done this type of project previously.I am always try to give my best .

$35 USD in 2 days
(0 Reviews)
0.0
epicinfotech

We have a strong team of proficient people who are creative thinkers, strategists, designers & developers with great skills and over 5 to 10 year experience in development. We can deliver innovative, secure and scalabl More

$35 USD in 7 days
(0 Reviews)
0.0
venkat4143

A proposal has not yet been provided

$134 USD in 1 day
(0 Reviews)
0.0