1.建立springboot項目
建立這個不用說了吧。。。
https://blog.csdn.net/u013294097/article/details/93042544
這兒有建立springboot的教程
2.添加坐标
gradle: gradle與maven轉換,gradle中的字元串,groupId,artifactId,version以冒号隔開的,maven的可以自行轉換
compile 'com.zaxxer:HikariCP:3.1.0'
compile 'mysql:mysql-connector-java:5.1.47'
compile 'org.springframework.boot:spring-boot-starter-jdbc'
maven:
<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
<version>3.1.0</version>
</dependency>
3.在resource下建立一個 application.yml檔案
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiAzNfRHLGZkRGZkRfJ3bs92YsYTMfVmepNHL9MGVPdXUU9UeNRVT3V1MMBjVtJWd0ckW65UbM5WOHJWa5kHT20ESjBjUIF2X0hXZ0xCMx81dvRWYoNHLrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdssmch1mclRXY39CXldWYtlWPzNXZj9mcw1ycz9WL49zZuBnL5kDN4MTMyQTMzIjNwkTMwIzLc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
4.配置好HikariCP的資料源内容
spring:
datasource:
hikari:
jdbc-url: jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8&useSSL=false&allowMultiQueries=true
username: root
password: mysql
driver-class-name: com.mysql.jdbc.Driver
pool-name: principalHikariCP
maximum-pool-size: 5
5.在springboot主程式包建立一個config檔案夾,然後在config下面建立DataSourceConfig.java檔案
6.DataSourceConfig的配置如下:
package com.cyjz.config;
import com.zaxxer.hikari.HikariDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
@Configuration
public class DataSourceOneConfig {
@Bean
@ConfigurationProperties(prefix = "spring.datasource.hikari")
public DataSource dataSource(){
return new HikariDataSource();
}
}
7.配置完成!