Project Name

• CMPE321 Introduction to Database Systems - Final Project
• Bogazici University

Contributors

• Kübra Aksu - https://github.com/kubraaksux
• Ilgaz Er - https://github.com/ilgazer

Application

This project is a web application developed using Java with the Spring Boot framework. It utilizes MySQL as the database management system and relies on java.sql package for database connectivity. The user interface is implemented using basic HTML templates. The development environment for this project is IntelliJ IDEA, and the primary technologies used include HTML, MySQL, and Java with Spring Boot.

Tech Stack

• Spring Boot: Backend framework.
• Java: Primary language.
• MySQL: Database.
• HTML/CSS: Frontend.
• Gradle: Build tool.

Getting Started

Prerequisites

Make sure you have the following tools and dependencies installed on your system before proceeding:

• Java: Ensure you have Java Development Kit (JDK) installed.
• MySQL: Set up a MySQL database.
• Gradle: Install Gradle build tool.

Installation

Clone the repository

git clone <repository_url>

Start up a mysql server on localhost:3306 with username and password root.

Execute createTables.sql

Backend (Java Spring)

Make sure that the Java version is at least Java 19

Start MySQL server (command may vary based on your system)

brew services start mysql

Navigate to the directory

Compile project using ./gradlew bootRun

• ./gradlew build
• ./gradlew bootRun

Run

Navigate to http://localhost:8080/