Football-Database ⚽️

Also available in: Polski

About

Football-Database project for Database Systems at Poznan University of Technology. The application allows managing a database of various football leagues whose entity relationship diagram is shown below:

The main goal of this project was to implement a Java Spring web application that connects to database using JPA and allows the user to add, modify or delete data from database. Additionally, GUI was implemented using Vaadin template. All SQL scripts required to create tables can be found in the resources folder.

Folder Structure

PROJECT_FOLDER
│  README.md
│  README.pl.md
│  pom.xml
└──[frontend]
│  └──[themes] # Contains the custom CSS styles.
└──[src]
   └──[main]
      └──[java]
      └──[resources]
         │  application.properties # Contains springboot configurations and database connection
         └──[META-INF]
            └──[resources]
               └──[sql]
                  │  schema.sql    # Contains DB Script to create tables
                  └──data.sql      # Contains DB Script to insert data (after schema.sql)

Running the application

The application has to be connected to database, therefore you first need to configure connection parameters to your database in the application.properties file and run SQL schema script in this database to create required tables. You can also insert some prepared sample data using SQL data script.

The project is a standard Maven project. To run it from the command line, type mvnw (Windows), or ./mvnw (Mac & Linux), and then open http://localhost:8080 in your browser to see the application.

You can also import the project to your IDE of choice as you would with any Maven project.

Contributors