Superhero Project - Spring Boot with JDBC Template

A Superhero sightings web application, developed in five days as part of a four-people group, during our Wiley Edge Trainee Program.

Group

@catalina-kalman @DominiqueAMWalker @hodanhassan2408 and @junocchi

Tech

• Java Spring Boot with JDBC Template
• HTML
• CSS
• MySQL
• Eclipse and MySQL Workbench
• Project Management: Trello

System functionalities

With the rising popularity of superhero movies, there has been a heightened awareness of superheroes in our midst. The frequency of superhero sightings is increasing at an alarming rate. Given this development, the Hero Education and Relationship Organisation (HERO) has asked our company to develop a database and data layer for their new superhero sightings web application.

For our MVP we completed the following functionalities:

• It keeps track of all superhero information.
• Heroes have names, descriptions, and a superpower.
• Heroes are affiliated with one or more superhero organisations.
• It keeps track of all location information:
• Locations have names, descriptions, address information, and latitude/longitude coordinates.
• It keeps track of all superhero's organisation information:
• The Organisations have names, descriptions, and address/contact information.
• The Organisations have members.
• A user can record a superhero sighting for a particular location and date. The system reports all of the superheroes sighted at a particular location. The system reports all locations where a particular superhero has been seen. The system reports all sightings (hero and location) for a particular date. The system reports all of the members of a particular organisation. The system reports all of the organisations a particular superhero belongs to.

After the MVP we completed the following system functionalities:

• Have a screen to create, view all, view one, edit, and delete superheroes in the system.
• Have a screen to create, view, edit, and delete superpowers in the system.
• Have a screen to create, view, edit, and delete locations in the system.
• Have a screen to create, view, edit, and delete superhero organizations in the system.
• Have a screen to create, view, edit, and delete superhero sightings (including superhero, location, and time) in the system.
• Have a home page that displays general information about the application, navigation to all the other pages, and a newsfeed of the latest 10 sightings in the database.

TDD

By prioritizing TDD, we ensured the reliability and stability of our application, instilling confidence in our team and stakeholders. Below is an example of the test cases we wrote for Superheroes: