How to connect to a database in Spring Boot?

10 months ago

Isabella Edwards

2 minutes

In SpringBoot, connecting to a database typically involves the following steps:

1. Add database driver dependency: Add the necessary database driver dependency to the pom.xml file, for example, for MySQL database you can add the following dependency:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

2. Setting up database connection information: Configure database connection information in the application.properties or application.yml file, including database URL, username, password, etc. For example:

spring.datasource.url=jdbc:mysql://localhost:3306/mydatabase
spring.datasource.username=root
spring.datasource.password=password
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

3. Creating a data source: Spring Boot will automatically create a data source based on the configuration, which can be injected directly using the @Autowired annotation to DataSource object.

4. Performing database operations using JdbcTemplate: You can use Spring’s JdbcTemplate to execute SQL operations, such as:

@Autowired
JdbcTemplate jdbcTemplate;

public void queryData() {
    List<Map<String, Object>> result = jdbcTemplate.queryForList("SELECT * FROM table");
    // 处理查询结果
}

Using Spring Data JPA: If you need a more convenient way to manipulate the database, you can simplify the process by using Spring Data JPA. Just define a Repository interface and inherit the CrudRepository interface to achieve this.

By following the steps above, you can connect to a database and perform database operations in Spring Boot.