Skip to content

This project has Restful API's that allows us to manage to cricket data in the database using sprint boot JPA and Hibernate. By performing CRUD (Create, Read, Update, Delete) operations on the cricket data

Notifications You must be signed in to change notification settings

ashokravina/Cricket-Team-3

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Given five files,

  • PlayerController.java
  • PlayerRepository.java
  • PlayerJpaService.java
  • PlayerJpaRepository.java
  • Player.java

And also given a database file cricketteam which contains TEAM table.

TEAM Table

Columns Type
playerId INTEGER
playerName TEXT
jerseyNumber INTEGER
role TEXT

Use only team as the table name in both query writing and in the model class within your code.

Completion Instructions

  • Player.java: The Player class should contain the following attributes.

    Attribute Type
    playerId int
    playerName String
    jerseyNumber int
    role String
  • PlayerRepository.java: Create an interface containing the required methods.

  • PlayerJpaService.java: Update the service class with logic for managing player data.

  • PlayerController.java: Create the controller class to handle HTTP requests.

  • PlayerJpaRepository.java: Create an interface that implements the JpaRepository interface.

Implement the following APIs.

API 1

Path: /players

Method: GET

Description:

Returns a list of all players in the team.

Response

[
    {
        "playerId": 1,
        "playerName": "Alexander",
        "jerseyNumber": 5,
        "role": "All-rounder"
    },
   ...
]

API 2

Path: /players

Method: POST

Description:

Creates a new player in the team. The playerId is auto-incremented.

Request

{
  "playerName": "Prince",
  "jerseyNumber": 24,
  "role": "Bowler"
}

Response

{
    "playerId": 12,
    "playerName": "Prince",
    "jerseyNumber": 24,
    "role": "Bowler"
}

API 3

Path: /players/{playerId}

Method: GET

Description:

Returns a player based on the playerId. If the given playerId is not found in the team, raise ResponseStatusException with HttpStatus.NOT_FOUND.

Success Response

{
    "playerId": 1,
    "playerName": "Alexander",
    "jerseyNumber": 5,
    "role": "All-rounder"
}

API 4

Path: /players/{playerId}

Method: PUT

Description:

Updates the details of a player in the team based on the playerId and returns the updated player details. If the given playerId is not found in the team, raise ResponseStatusException with HttpStatus.NOT_FOUND.

Request

{
    "playerName": "Yuvi"
    "jerseyNumber": 12,
    "role": "All-rounder"
}

Success Response

{
    "playerId": 3,
    "playerName": "Yuvi",
    "jerseyNumber": 12,
    "role": "All-rounder"
}

API 5

Path: /players/{playerId}

Method: DELETE

Description:

Deletes a player from the team based on the playerId. If the given playerId is not found in the team, raise ResponseStatusException with HttpStatus.NOT_FOUND.

Do not modify the code in PlayerApplication.java

Do not modify anything in the application.properties file

Do not add any SQL files

About

This project has Restful API's that allows us to manage to cricket data in the database using sprint boot JPA and Hibernate. By performing CRUD (Create, Read, Update, Delete) operations on the cricket data

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages