Connecting with Spring Boot
Integrating JDBC with the Spring Boot framework allows you to leverage the powerful features of both technologies to build robust and scalable applications. Spring Boot provides a streamlined way to configure and manage database connections, making it easier to work with JDBC.
To connect to a database using Spring Boot and JDBC, follow these steps:
- Include the necessary dependencies in your
pom.xmlfile:
1<dependencies>
2 <!-- Spring Boot Starter JDBC -->
3 <dependency>
4 <groupId>org.springframework.boot</groupId>
5 <artifactId>spring-boot-starter-jdbc</artifactId>
6 </dependency>
7 <!-- Database Driver -->
8 <dependency>
9 <groupId>com.mysql.cj</groupId>
10 <artifactId>mysql-connector-java</artifactId>
11 <version>8.0.26</version>
12 </dependency>
13</dependencies>- Configure the database connection in your
application.propertiesorapplication.ymlfile:
1spring.datasource.url=jdbc:mysql://localhost:3306/mydatabase
2spring.datasource.username=username
3spring.datasource.password=password
4spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver- Inject the
JdbcTemplatebean into your Spring Boot component:
1import org.springframework.beans.factory.annotation.Autowired;
2import org.springframework.boot.SpringApplication;
3import org.springframework.boot.autoconfigure.SpringBootApplication;
4import org.springframework.jdbc.core.JdbcTemplate;
5
6@SpringBootApplication
7public class Main {
8 private final JdbcTemplate jdbcTemplate;
9
10 @Autowired
11 public Main(JdbcTemplate jdbcTemplate) {
12 this.jdbcTemplate = jdbcTemplate;
13 }
14
15 public static void main(String[] args) {
16 SpringApplication.run(Main.class, args);
17 }
18}- Use the
JdbcTemplateto execute SQL queries and interact with the database:
1import org.springframework.beans.factory.annotation.Autowired;
2import org.springframework.jdbc.core.JdbcTemplate;
3import org.springframework.stereotype.Component;
4
5@Component
6public class MyDatabaseService {
7 private final JdbcTemplate jdbcTemplate;
8
9 @Autowired
10 public MyDatabaseService(JdbcTemplate jdbcTemplate) {
11 this.jdbcTemplate = jdbcTemplate;
12 }
13
14 public void fetchData() {
15 String sql = "SELECT * FROM my_table";
16 List<Map<String, Object>> rows = jdbcTemplate.queryForList(sql);
17
18 for (Map<String, Object> row : rows) {
19 System.out.println(row);
20 }
21 }
22}With these steps, you can easily connect to a database using JDBC and Spring Boot. The JdbcTemplate provides a higher-level abstraction for executing SQL queries, making database operations more concise and easier to manage.
Keep in mind that you can configure additional properties for the database connection, such as connection pooling, transaction management, and error handling. Spring Boot simplifies the configuration process and provides default settings that work well for most applications.
In the next screen, we'll explore how to execute queries using JDBC and Spring Boot.
xxxxxxxxxxclass Main { public static void main(String[] args) { // Replace with your Spring Boot JDBC code here }}