springboot2.1入门系列六集成Hikari连接池

╰+哭是因爲堅強的太久メ 2022-03-25 09:19 302阅读 0赞

本文为Spring Boot2.1系列的第六篇，代码可以从github下载 [https://github.com/yinww/demo-springboot2.git][https_github.com_yinww_demo-springboot2.git]

HiKariCP号称Java平台性能最好的数据库连接池，并且Springboot2.1默认的连接池就是HiKariCP，不需要专门引入相关的依赖，已经自包含了。

与第五篇 [springboot项目使用Mybatis][springboot_Mybatis] 相比，不同之处在于数据源的配置，如下

application.properties

spring.application.name=demo006
    
    # jdbc_config   datasource
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    spring.datasource.url=jdbc:mysql://127.0.0.1:3306/demo006?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&serverTimezone=GMT%2B8
    spring.datasource.username=root
    spring.datasource.password=root
    
    # Hikari will use the above plus the following to setup connection pooling
    spring.datasource.type=com.zaxxer.hikari.HikariDataSource
    spring.datasource.hikari.minimum-idle=5
    spring.datasource.hikari.maximum-pool-size=15
    spring.datasource.hikari.auto-commit=true
    spring.datasource.hikari.idle-timeout=30000
    spring.datasource.hikari.pool-name=UserHikariCP
    spring.datasource.hikari.max-lifetime=1800000
    spring.datasource.hikari.connection-timeout=30000
    spring.datasource.hikari.connection-test-query=SELECT 1
    
    mybatis.typeAliasesPackage=com.yinww.demo.springboot2.demo006.domain
    mybatis.mapperLocations=classpath:mapper/*.xml

启动程序后，添加数据

![20190119190156904.png][]

查看数据库，可以看到数据已经保存成功

mysql> select * from user;
    +----+-----------+
    | id | name      |
    +----+-----------+
    |  1 | 张三丰    |
    +----+-----------+
    1 row in set (0.00 sec)

本文内容到此结束，更多内容可关注公众号：

![2018111718160012.jpg][]

[https_github.com_yinww_demo-springboot2.git]: https://github.com/yinww/demo-springboot2.git
[springboot_Mybatis]: https://blog.csdn.net/bowei026/article/details/86557455
[20190119190156904.png]: /images/20220325/9f03aec2a6e0402b91f9ad60175a230c.png
[2018111718160012.jpg]: /images/20220325/1c128bedfa4c4ae8b1b72d18e0eef204.png