Spring Boot + Spring Data JDBC + Microsoft SQL Server - Build REST CRUD APIs
![Image](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwOuy3zbBm9EJuhNxV6WMHlUjM37gYqDuO6MI2JU77GIcfDiyenWRRYtQkvr2NsshGMxHeEMoJqeE76tmhcD0uhZgcro-EhTzQr5dT2fkUfixwJt8Gp8QfXMU-i3IWAxm1cZGj-G-SrGmP-As_h44C4xT1cAHr7svz50DbCdaP4RRntz0U5d59sYT-xg/w400-h211/SPRINGBOOT-SPRING-DATA-JDBC-SQLSERVER-CRUD.png)
In this section, we will learn how to develop a REST-style web service with Spring Boot , Spring Data JDBC, and Microsoft SQL Server . GitHub repository link is provided at the end of this tutorial. You can download the source code. *Before development, make sure that the Microsoft SQL server is installed on your machine - SQL Server Downloads | Microsoft Technologies used: Spring Boot 3.0.2 Spring Data JDBC Java 17 Maven Microsoft SQL Server Driver Microsoft SQL Server These are APIs that Spring Boot backend App will export: 1. Create database. First, you need to create a database in the Microsoft SQL Server. CREATE DATABASE testdb; 2. Creating a simple spring boot web application: First, open the Spring initializr https://start.spring.io/ Then, Provide the Group and Artifact name. We have provided Group name com.knf.dev.demo and Artifact spring-boot-spring-data-jdbc-sqlserver-crud . Here I selected the Maven project - language Java 17 - Spring Boot 3.0.2 and ad