Java-SpringBoot-项目整合MySQL（依赖与配置文件）

pom.xml

<!--集成mysql数据库-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.26</version>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
    <version>2.6.1</version>
</dependency>

application.yaml

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/sys?characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
    username: admin
    password: 785!Bz*@sl#dm

ApplicationTests.java (测试连接)

@SpringBootTest
class ApplicationTests {
    
    @Autowired
    DataSource dataSource;

    @Test
    void test1() throws SQLException {
        System.out.println(dataSource.getConnection());
        //打印内容：HikariProxyConnection@269853881 wrapping com.mysql.cj.jdbc.ConnectionImpl@1acb74ad
    }
}