Spring Boot, MSSQL, JPA, Hibernate Rest API Tutorial

Build Restful CRUD API for a simple Note-Taking application using Spring Boot, MSsql, JPA and Hibernate.

Requirements

1. Java - 1.8.x

2. Maven - 3.x.x

3. MS sql - 5.x.x

Steps to Setup

1. Clone the application

git clone https://github.com/gauravs08/spring-boot-mssql-rest-api-tutorial.git

2. Create MS sql database

create database notes_app

3. Change mssql username and password as per your installation

• open src/main/resources/application.properties

• change spring.datasource.username and spring.datasource.password as per your mssql installation

4. Build and run the app using maven

mvn package
java -jar target/easy-notes-1.0.0.jar

Alternatively, you can run the app without packaging it using -

mvn spring-boot:run

The app will start running at http://localhost:8080.

Explore Rest APIs

The app defines following CRUD APIs.

GET /api/notes

POST /api/notes

GET /api/notes/{noteId}

PUT /api/notes/{noteId}

DELETE /api/notes/{noteId}

You can test them using postman or any other rest client.