Mail-tracker is a JavaFX desktop application connected to a MySQL database.
The project includes a user authentication and registration system, as well as database-driven functionality for analyzing users and messages (letters). Users can log in, register, and execute different SQL-based queries through a graphical interface.
The application is built using JavaFX with FXML and follows a simple MVC-like structure (Controllers, Models, Database layer).
- User registration system
- User login authentication
- MySQL database integration
- Display of users and messages
- SQL query-based statistics:
- User information list
- Longest message
- Shortest message
- User who sent the smallest message
- Users without messages
- Scene switching (Login / Registration / Main app)
- Simple UI animations (Shake effect)
Users can register and log in using credentials stored in the MySQL database.
The application executes SQL queries to:
- Retrieve all users
- Find longest/shortest messages
- Identify users without messages
- Analyze message statistics
The application uses JavaFX scenes and allows switching between:
- Login page
- Registration page
- Main dashboard
The project uses a MySQL schema (new_schema) with tables:
-
users- idusers
- firstname
- lastname
- username
- password
- location
- gender
-
letters- sender_username
- message_text
This project was created for learning purposes to practice:
- JavaFX development
- MySQL database integration
- JDBC queries
- UI design with FXML
- basic MVC architecture