Skip to content

JPA CRUD Project

Application Overview

This weeks homework is going to perform simple CRUD on a single table database of your choosing.

Learning Objectives

Below are a list of objectives that we see the JPACrud application reinforcing.

  • Creating a SQL database and subsequent tables.
  • Configuring a JPA project.
  • Mapping Entities to SQL tables.
  • Creating JUnit tests to ensure our JPA mappings are correct.
  • Integrating a Spring MVC project with a JPA project.
  • Performing basic CRUD operations.
  • Deploying an application to AWS

Project Requirement

You'll push your project to a Github repo named JPACRUDProject. Be sure to include a README.md detailing the technologies used as well as the purpose of the application.

  • Your project utilizes a MySQL database to manipulate data. For this project you are only required to have a single table and entity.

  • The MySQL table is mapped to a valid JPA Entity and tested to ensure the mappings are working correctly.

  • A Spring project allows for a user to perform basic CRUD operations on your entity via a web interface.

  • Your project and database are deployed to your AWS instance.

Stretch Goals

Try as many of these as you like, but ONLY after you've completed, tested, and COMMITTED your working application that meets the requirements.

  • Perform CRUD operations on more that one entity. We will learn about relationships and joining tables with JPA next week so for now you will not be able to handle foreign key relationships.

Grading

This is a graded project. You are expected to have your project completed by the start of class on Monday morning.

You will be given either a pass or fail based on whether your code works and meets the above specified requirements.

If the project does meet these specifications, you will be given a 1 for this week's project.

If the project does not work, you will be given a 0 for this week's project.

If you get a zero on the project, you can upgrade to a score of .5 if you turn in a working project by the start of class on the following Monday morning AND notify an instructor that you wish to get partial credit.

To turn in a project, you must push it to GitHub. You must include a README.md that describes how to run your program. Include an overview of the class structure you chose to use.

Up -- Next