ESAKE App

ESAKE App is a desktop application for managing and analyzing data from the Greek Basketball League (ESAKE).
Built with Java Swing for the user interface and SQL for database management, it enables both administrators and guest users to explore teams, players, matches, and league statistics.

✨ Features

• User Roles
  • Admin: create/edit/delete teams, players, leagues; manage fixtures and statistics.
  • Guest: browse teams, players, matches, and standings.
• Match & Statistics Management
  • Input game results and player/team statistics.
  • View statistics by match, player, or team.
• League & Fixtures
  • Create new leagues and generate fixtures automatically.
  • Browse league tables and matchdays.
• Database Integration
  • JDBC-based SQL backend for persistent data storage.
• Intuitive UI
  • Built with NetBeans GUI builder and Swing forms (.form + .java).

🧱 Tech Stack

• Language: Java
• Framework: Swing (NetBeans UI Designer)
• Database: SQL (via JDBC)
• Architecture: MVC-style separation (Controllers, GUI, DBConnect)

🚀 Getting Started

1) Prerequisites

• Java JDK 17 (or 11+)
• NetBeans IDE (recommended, for .form integration)
• SQL database (e.g., MySQL or similar, configured in DBconnect.java)

2) Setup Database Connection

Edit DBconnect.java to configure your database credentials:

String url = "jdbc:mysql://localhost:3306/esake_db";
String username = "your_username";
String password = "your_password";

3) Run the App

• Open the project in NetBeans.
• Build and run Main.java.
• Use the login screen to enter as Admin or Guest.

🧭 Usage

• Admin: Create leagues, add teams and players, generate fixtures, and input match stats.
• Guest: View teams, players, match results, and league standings.

🧩 Notes

• Built as a university project (graded 10/10).
• Primarily for academic/portfolio use; not intended for production deployment.
• Live update functionality supported via DB refresh on new match/stat entries.

📜 License

This project is shared for educational and portfolio purposes.