SELECT Query
Explore how to use Spring JDBC’s JdbcTemplate to write and execute SELECT queries. Learn to map database rows to Java beans using BeanPropertyRowMapper and manage database interactions with minimal boilerplate. Understand retrieving all records and fetching a record by ID with queryForObject. Gain practical skills to simplify database operations in Spring Boot applications.
We'll cover the following...
JDBC involves a lot of boilerplate code that is required just to get the application working. It is a tedious task to write a simple query using JDBC. There are a number of steps that are required to interact with the database.
The first step is establishing a connection
The second step is creating a prepared statement or query
The third step is to execute the query
The fourth step is looping through the result set to get the objects
The fifth and final step is to close the connection
Spring JDBC support makes interacting with databases easy. Since we are using Spring Boot, the connection part is automatically taken care of and the data source is automatically configured. Likewise, the connection is automatically closed. Spring provides JdbcTemplate, which makes it easy to write and execute a query. It also provides the BeanPropertyRowMapper which maps rows of a table to a bean.
In this lesson, first we will write a query to return all rows from the Player table. We will learn how to map the data coming from the database to a bean in our application. Next, we will modify our query to return the row that matches an input argument.
Defining Player bean
We have created a Player table but we need to define a class Player ...