Posts

Showing posts with the label Microsoft SQL Server

Spring Boot + Spring Data JDBC + Microsoft SQL Server - Build REST CRUD APIs

Image
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

Spring Boot + Spring Data JPA + Microsoft SQL Server - Build REST CRUD APIs

Image
In this section, we will learn how to develop a REST-style web service with  Spring Boot ,  Spring Data JPA,  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 JPA 3.0.2 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-jpa-sqlserver-crud . Here I selected the  Maven  project - language  Java 17  -  Spring Boot 3.0.2  and