idea项目怎么连接mysql数据库

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>版本号</version>
</dependency>

spring.datasource.url=jdbc:mysql://localhost:3306/数据库名
spring.datasource.username=用户名
spring.datasource.password=密码
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/数据库名
    username: 用户名
    password: 密码
    driver-class-name: com.mysql.jdbc.Driver

import java.sql.*;

public class UserDao {
    private Connection connection;

    public UserDao() {
        // 建立数据库连接
        try {
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名", "用户名", "密码");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void queryData() {
        try {
            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery("SELECT * FROM 表名");
            while (resultSet.next()) {
                // 处理查询结果
                String columnName = resultSet.getString("列名");
                // ...
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

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