Project.Demo.mp4

Hello I have developed this called Sports Management System using Spring Boot, Spring JPA, MySQL, JSP.

This Spring Boot project is a sports management system designed to handle player information and administrative tasks. It features endpoints for adding, updating, listing, and deleting player records, with validation for player details like age and ranking. The application supports authentication for admin users, ensuring secure access to player management functionalities. Admins can log in, view a dashboard, and manage players' data through various forms and actions. The system also includes functionalities to select and display top players based on different criteria, such as ODI, T20, and Test formats. The project uses JSP for front-end views and leverages Spring Security for authentication and authorization.

I have used entities Admin, Player, Ranks. Since RANK is a reserved keyword in MySQL we cant use it so we use RANKS. Player entity has player name, age, department. Ranks entity has each player's rank in each format (T20, Test, ODI).

STEPS TO RUN THE PROJECT:

1. Download the zip file and extract the file. Open in either VS Code or Eclipse or IntelliJ.

2. navigate to src/main/resources/application.properties.

   2.1 Create a Database on your wish (spring.datasource.url=jdbc:mysql://localhost:PORT_NUMBER/DBname)

   2.2 Change username and password (spring.datasource.username= USERNAME), (spring.datasource.password= PASSWORD)

   2.3 Check out the PlayerDetails file in root folder. You can use that to upload in database for Player and Ranks table.

3. Open terminal and enter this command (./mvnw spring-boot:run)

ENDPOINTS:

PlayerController Endpoints

GET /addPlayer URL: http://localhost:8080/addPlayer Method: GET Description: Displays the form to add a new player. Requires Authentication: Yes

POST /addPlayer URL: http://localhost:8080/addPlayer Method: POST Description: Adds a new player. Requires Authentication: Yes

GET /listPlayers URL: http://localhost:8080/listPlayers Method: GET Description: Lists all players. Requires Authentication: No

GET /deletePlayer URL: http://localhost:8080/deletePlayer Method: GET Description: Displays the form to delete a player. Requires Authentication: Yes

POST /deletePlayer URL: http://localhost:8080/deletePlayer Method: POST Description: Deletes a player based on ID. Requires Authentication: Yes

GET /pickTopPlayers URL: http://localhost:8080/pickTopPlayers Method: GET Description: Displays the form to pick top players. Requires Authentication: No

GET /getTop11 URL: http://localhost:8080/getTop11 Method: GET Description: Lists the top 11 players based on the specified criteria (ODI, T20, Test). Requires Authentication: No

GET /updatePlayer
URL: http://localhost:8080/updatePlayer Method: GET Description: Displays the form to update a player's details. Requires Authentication: Yes

POST /updatePlayer
URL: http://localhost:8080/updatePlayer Method: POST Description: Updates a player's details based on the specified type (age, department). Requires Authentication: Yes

AdminLoginController Endpoints

GET / URL: http://localhost:8080/ Method: GET Description: Displays the login page.

POST / URL: http://localhost:8080/ Method: POST Description: Processes the admin login. Requires Authentication: No (for the login process itself)

GET /index URL: http://localhost:8080/index Method: GET Description: Displays the index page after successful login. Requires Authentication: Yes

GET /logout URL: http://localhost:8080/logout Method: GET Description: Logs out the admin and invalidates the session. Requires Authentication: No (ends the session)