Spring JdbcClient Example
In this section, we're gonna build a Spring Boot application that use Spring JdbcClient to interact with PostgreSQL database. Spring Framework 6.1 introduced the JdbcClient API. As we all know, Spring Framework 6.1 is part of Spring Boot version 3.2. We can use the Spring JdbcClient interface to define the query, set the parameters, and perform the DB operation, using a fluent API. Fluent APIs are designed to make the code more readable and therefore easier to use. Wiring objects together using method chaining helps accomplish these readability and usability goals. An example for retrieving a Student as a Optional: public Optional < Student > findStudentById ( Long id) { String sql = "select id, name, age, gender, " + "email from students where id = :id" ; return jdbcClient .sql( sql ) .param( "id" , id) .query( Student . class ) .optional(); } What we will build? We will build a s