$29
Project #5 Solution
Create your own unique Web database application that uses servlets and/or JSF and JavaDB JDBC to connect to JavaDB database. The application should allow a user to insert a new record, display the values of all records in a table and search for a specific record based data from two or more columns.
The database table should have at least 6 columns and one primary key of your choice. You may use more than one database table with primary and foreign key constraints or other constraints as needed to make this application your own.
The Web Interface you develop should be easy to use and navigate and include at least one image.
Be sure to use Java EE 7 technologies for this application.
Submission requirements
Deliverables include all project files and a single word (or PDF) document. Scripts for creating the database should also be included. You should zip the project directory in its entirety for submission. The word (or PDF) document should include screen captures showing the successful compiling and running of your project, a title page with your name and project number, IDE name and version, operating system, and instructions how to set up and run your project, and the database name and version.
Each screen capture should be properly labeled, clearly indicating what the screen capture represents.
Submit your files to the Project 5 assignment area no later than the due date listed in your LEO classroom. You should include your name and P5 in your word (or PDF) file submitted (e.g. firstnamelastnameP5.docx or firstnamelastnameP5.pdf)
Grading Rubric:
The following grading rubric will be used to determine your grade:
Attribute
Meets
Does not meet
Creates Web Database
20 points
0 points
Application
Creates a unique Web database
Does not create a unique Web
application that uses servlets
database application that uses
and/or JSF and JavaDB JDBC to
servlets and/or JSF and JavaDB
connect to JavaDB database.
JDBC to connect to JavaDB
database.
Uses Java EE 7 technologies for
this application.
Does not use Java EE 7
technologies for this application.
Functionality
30 points
0 points
Allows a user to insert a new
Does not allow a user to insert a
record,.
new record.
1
Allows a user to display the
Does not allow a user to display
values of all records in a table.
the values of all records in a
table.
Allows a user to search for a
specific record based data from
Does not allow a user to search
two or more columns.
for a specific record based data
from two or more columns.
The web interface is easy to use
and navigate.
The web interface is not easy to
use or navigate.
The web interface includes at
least one image.
The web interface does not
include at least one image.
Database
20 points
0 points
Uses JavaDB as the database
Does not use JavaDB as the
engine.
database engine.
The database table should have
The database table does not
at least 6 columns and one
have at least 6 columns or one
primary key of your choice.
primary key of your choice.
Documentation and project
30 points
0 points
submission
Provides screen capture
Does not provide screen capture
demonstrating the successful
demonstrating the successful
compilation and running on your
compilation and running on your
platform.
platform.
Deliverables include all project
Does not include all project files
files and a single word (or PDF)
and a single word (or PDF)
document.
document as deliverables.
Database Scripts files are
Database Scripts files are
included.
included.
Each screen capture is properly
Each screen capture is not
labeled, clearly indicating what
properly labeled, or clearly
the screen capture represents.
indicating what the screen
capture represents.
Word or pdf includes title page
Word or pdf does not include a
with your name and project
number, IDE name and version,
title page with your name and
operating system, the database
project number, IDE name and
name and version, and
version, operating system,
instructions how to set up and
Database name and version, and
run your project.
instructions how to set up and
run your project.
2
