spring-boot-download-excel-file-mysql-feature-image

Spring Boot: Download Excel file from MySQL database table

The Excel file is a spreadsheet file format created by Microsoft for use with Microsoft Excel. You can use the file to create, view, edit, analyse data, charts, budgets and more. In this tutorial, I will show you how to use Spring Boot to download Excel file from a table in MySQL Database using Apache POI.

Related Posts:
Spring Boot: Upload/Import Excel file data into MySQL Database
Spring Boot Multipart File upload example
How to upload multiple files in Java Spring Boot
Upload/Import CSV file to MySQL Database in Spring Boot

Read More

spring-boot-graphql-mongodb-example-feature-image

Spring Boot + GraphQL + MongoDB example with Spring Data & graphql-java

In this tutorial, we’re gonna build a Spring Boot GraphQL example that will expose CRUD APIs to create, read, update and delete objects in MongoDB database with the help of graphql-java and Spring Data.

Related Post:
Spring Boot with MongoDB CRUD example using Spring Data

More Practice:
Spring Boot + GraphQL + MySQL example with Spring JPA & graphql-spring-boot-starter

Read More

spring-boot-graphql-mysql-crud-apis-feature-image

Spring Boot + GraphQL + MySQL example with Spring JPA & graphql-spring-boot-starter

GraphQL is a query language that offers an alternative model to developing APIs (REST, SOAP or gRPC) with detailed description.

In this tutorial, we’re gonna build a Spring Boot GraphQL example that will expose CRUD Rest APIs to create, read, update and delete objects in MySQL database with the help of graphql-spring-boot-starter and Spring Data JPA.

Related Post: Spring Boot, Spring Data JPA – Building Rest CRUD API example

Deployment: Deploy Spring Boot App on AWS – Elastic Beanstalk

Read More

Spring Boot, MongoDB: JWT Authentication with Spring Security

This tutorial helps you build a Spring Boot Authentication (Login & Registration) & role-based Authorization example with JWT, Spring Security and Spring Data MongoDB. You’ll know:

  • Appropriate Flow for User Signup & User Login with JWT Authentication
  • Spring Boot Application Architecture with Spring Security
  • How to configure Spring Security to work with JWT
  • How to define Data Models and association for Authentication and Authorization
  • Way to use Spring Data MongoDB to interact with MongoDB Database

More Practice:
Spring Boot JWT Authentication with Spring Security, Spring Data JPA & MySQL/PostgreSQL
Spring Boot + GraphQL + MongoDB example with Spring Data & graphql-java
Spring Boot with MongoDB CRUD example using Spring Data

Read More

spring-boot-rest-xml-example-feature-image

Spring Boot Rest XML example – Web service with XML Response

In this Spring Boot tutorial, I will show you a Restful Web service example in that Spring REST Controller can receive/consume XML Request Body and return XML Response instead of JSON. We also use Spring Data JPA to interact with database (MySQL/PostgreSQL).

More Practice:
Spring Boot, Spring Data JPA – Building Rest CRUD API example
Spring Boot + GraphQL + MySQL example

Read More

spring-boot-upload-files-to-database-feature-image

Spring Boot Upload/Download File to/from Database example

In this tutorial, I will show you how to upload and download files to/from database with a Spring Boot Rest APIs. We also use Spring Web MultipartFile interface to handle HTTP multi-part requests.

This Spring Boot App works with:
Angular Client
Vue Client / Vuetify Client
React Client / React Hooks Client

Related Posts:
How to upload multiple files in Java Spring Boot
Spring Boot: Upload/Import Excel file data into MySQL Database
Spring Boot: Upload/Import CSV file data into MySQL Database

Deployment: Deploy Spring Boot App on AWS – Elastic Beanstalk

Read More

spring-data-jpa-sort-order-by-multiple-columns-feature-image

Spring Data JPA Sort/Order by multiple Columns | Spring Boot

In previous tutorial, we’ve known how to build Spring Boot Rest CRUD Apis with Spring Data JPA. Today I will show you how to sort/order result by multiple Columns in Spring Boot with Spring Data JPA. You also know way to apply sorting and paging together.

Related Posts:
Spring Boot, Spring Data JPA – Rest CRUD API example
Spring Boot Pagination & Filter example | Spring JPA, Pageable
Spring Boot @ControllerAdvice & @ExceptionHandler example

More Practice:
Spring Boot Token based Authentication with Spring Security & JWT

Read More