Here is an example code of how to execute native SQL query with some parameters in JPA / Spring Boot. First we need use Spring Boot's EntityManagerFactory bean. We can simply use @Autowired annotation to make this available in our class. Then create new EntityManager session, execute the native SQL and finally close …

Sometime we want our user to download some file from our web application that is developed in Spring MVC or Spring Boot. To achieve this the main trick is to send the Content-Disposition http header before sending the data. Here is an example of a Controller class with just one method that take the name of a jpg image …

In web server application, sending image data to client browser is quite common job. This can be easily achieved in Spring or Spring boot MVC Controller. Key things here is to specify proper Content-Type such as image/png or whatever and then return the raw binary data of the image. Here is a sample code to demonstrate …

Here we will see how to build a sample full stack web application using Spring Boot, Spring JPA with database like PostgreSQL, MySQL or Oracle Thymeleaf and Gradle. This example is very similar with my other example regarding Spring boot with H2 database: Spring Boot H2 data source with Thymeleaf using Gradle The …

In this example, we will see how to build a simple web application in Spring boot with Thymeleaf as template engine and H2 database as embedded or in-memory database. Gradle has been used as build and dependency management tool. We will create a sample Student Information System where we can enter Student record in one …

The CrudRepository interface provides the CRUD functionality in Spring JPA. It comes with default definitions of methods to execute common operations like find, save and delete records. To work with a domain class, we need to inherit the CrudRepository to create a new interface corresponding to the domain class. Here …