如何在IntelliJ中使用Spring建立MySQL数据库连接？

<dependencies>
    <!-- 其他依赖 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.26</version>
    </dependency>
</dependencies>

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

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

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

@Component
public class DatabaseExample {

    private final JdbcTemplate jdbcTemplate;

    @Autowired
    public DatabaseExample(DataSource dataSource) {
        this.jdbcTemplate = new JdbcTemplate(dataSource);
    }

    // 在该类中可以使用jdbcTemplate执行数据库操作
    // 例如：执行查询操作
    public void queryData() {
        String sql = "SELECT * FROM mytable";
        List<Map<String, Object>> result = jdbcTemplate.queryForList(sql);
        // 处理查询结果
    }

    // 其他数据库操作方法...
}