WaterReport API - Spring Boot & MySQL Dara Service

This project is a Spring Boot-based RESTful API focused on managing data and generating reports related to global water access issues.

Content

• Controller
• DTO
• Entity
• Repository
• Service

Status

🚧 Project under development – Core CRUD functionalities are implemented, but additional features and refinements are in progress.

Diagram ER

Features

• CRUD operations for report management (Create, Read, Update, Delete).
• Data persistence with MySQL.
• RESTful API endpoints for interaction.
• Automatic database schema generation/updates with Hibernate DDL-Auto.
• Secure communication using HTTPS (self-signed for development).

Technologies Used

• Java: JDK 21
• Spring Boot: 3.5.3 (or your specific version)
• Spring Data JPA: For database interaction.
• Hibernate: ORM framework.
• MySQL Connector/J: JDBC driver for MySQL.
• MySQL Database: For data storage (local instance).
• Maven: Build automation tool.
• Swagger UI / OpenAPI: For API documentation and testing.

Prerequisites

Before you begin, ensure you have the following installed:

• Java Development Kit (JDK) 21
• Maven
• MySQL Server (preferably running via Docker)
• Docker Desktop (if using MySQL with Docker)