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

Completado Publicado Oct 7, 2015 Pagado a la entrega
Completado Pagado a la entrega

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

Nº del proyecto: #8638169

Sobre el proyecto

13 propuestas Proyecto remoto Activo Oct 8, 2015

Adjudicado a:

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 Más

$50 USD en 1 día
(52 comentarios)
5.9

13 freelancers están ofertando un promedio de $99 por este trabajo

eperfections

A proposal has not yet been provided

$111 USD en 3 días
(540 comentarios)
7.6
ankit0803

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

$10 USD en 1 día
(7 comentarios)
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 Más

$105 USD en 1 día
(24 comentarios)
5.6
pddkhanhhm

A proposal has not yet been provided

$700 USD en 15 días
(1 comentario)
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 en 1 día
(0 comentarios)
0.0
upalavivek

A proposal has not yet been provided

$25 USD en 3 días
(0 comentarios)
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 Más

$20 USD en 1 día
(0 comentarios)
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 en 2 días
(0 comentarios)
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 Más

$35 USD en 7 días
(0 comentarios)
0.0
venkat4143

A proposal has not yet been provided

$134 USD en 1 día
(0 comentarios)
0.0