【springboot专栏二】 整合连接池HikariCP

目录

一、pom依赖

二、配置yaml属性

三、配置数据源Bean，交给spring管理

四、测试数据源获取

五、也可以不用配置数据源Bean

---

一、pom依赖

springboot默认引入了HiKariCP

<!--数据库驱动-->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.17</version>
        <scope>provided</scope>
    </dependency>

    <!--连接池-->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>

二、配置yaml属性

spring:
  mvc:
    view:
      prefix: /WEB-INF/views2/
      suffix: .jsp
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/springbootdemo?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    username: root
    password: 123456

三、配置数据源Bean，交给spring管理

@Configuration
@EnableConfigurationProperties(JdbcProperties.class)
public class JdbcConfig {
    @Bean
    public HikariDataSource dataSource(JdbcProperties prop){
        System.out.println(prop);
        HikariDataSource dataSource = new HikariDataSource();
        dataSource.setDriverClassName(prop.getDriverClassName());
        dataSource.setJdbcUrl(prop.getUrl());
        dataSource.setUsername(prop.getUsername());
        dataSource.setPassword(prop.getPassword());
        return dataSource;
    }
}

@ConfigurationProperties(prefix="jdbc")
@PropertySource("application.properties")
@Data
public class JdbcProperties {
    String driverClassName;
    String url;
    String username;
    String password;

}

四、测试数据源获取

五、也可以不用配置数据源Bean

直接在yaml里面添加如下配置：

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/springbootdemo?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    username: root
    password: 123456