/spring-boot-rest-api-postgresql

Plain RESTful Web Service with Spring Boot. Using PostgreSQL database, Hibernate and basic authentication.

Primary LanguageJava

spring-boot-rest-api-postgresql

Disclaimer: This project is originally taken from hendisantika/spring-boot-rest-api-postgresql.

Plain REST API CRUD with Spring Boot and PostgreSQL.

Technology stack:

  • Spring Boot;
  • Spring Web;
  • Spring Data;
  • PostgreSQL database;
  • Hibernate;
  • Spring Security (as basic authentication).
Setup Environment Variables

You will need to setup some environment variables to run this application

BOOKS_API_DB_HOST=
BOOKS_API_DB_PORT=
BOOKS_API_DB_NAME=
BOOKS_API_DB_USERNAME=
BOOKS_API_DB_PASSWORD=
To run this application use:

mvn clean spring-boot:run

The view in the Postman:

Add new Book

POST /api/books

http://localhost:8080/api/books

Add New Book

Get All Books

GET /api/books

http://localhost:8080/api/books

Get All Books

Get Book By Id

GET /api/books/{id}

http://localhost:8080/api/books/{id}

Get Book By Id

Get Book By Name

GET /api/books?name=name

http://localhost:8080/api/books?name=name

Get Book By Name

Delete Book By Id

DELETE /api/books/{id}

http://localhost:8080/api/books/{id}

Delete Book By Id

Delete All Books

DELETE /api/books

http://localhost:8080/api/books

Delete All Books