Druid初体验

Druid初体验
- 官方介绍
- 下载链接
- 编译代码
- 新建数据
- 运行单元测试

Druid初体验官方介绍

Druid是Java语言中最好的数据库连接池。Druid能够提供强大的监控和扩展功能。

下载链接

Druid下载链接
https://github.com/alibaba/druid

对应版本：1.2.8

把代码下载下来，然后点击标签，切到1.2.8版本

编译代码

mvn install -Dmaven.test.skip=true -Dmaven.javadoc.skip=true -Drat.skip=true -Dcheckstyle.skip=true

新建数据

启动本地数据库
新建数据库 druid_test_db

运行单元测试

找到 com.alibaba.druid.pool.mysql.MySqlTest
修改数据库ip和用户名、密码

protected void setUp() throws Exception {
        dataSource = new DruidDataSource();
        dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/druid_test_db?allowMultiQueries=true");
        dataSource.setUsername("root");
        dataSource.setPassword("");
        dataSource.setFilters("log4j");
        dataSource.setValidationQuery("SELECT 1");
        dataSource.setTestOnBorrow(true);
        dataSource.setTestWhileIdle(true);
    }

运行单元测试

发现报错，不支持的时区

2022-05-09 23:45:08,972 [ERROR] DruidDataSource:2840 - create connection SQLException, url: jdbc:mysql://127.0.0.1:3306/druid_test_db?allowMultiQueries=true, errorCode 0, state 01S00
java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.

数据库连接加上 &serverTimezone=GMT%2B8

dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/druid_test_db?allowMultiQueries=true&serverTimezone=GMT%2B8");

再次运行单元测试，日志如下

2022-05-09 23:48:56,928 [INFO ] ClickHouseDriver:42 - Driver registered
2022-05-09 23:48:56,977 [INFO ] DruidDataSource:998 - {dataSource-1} inited
2022-05-09 23:48:57,606 [DEBUG] Connection:132 - {conn-10001,procId-73} connected
2022-05-09 23:48:57,634 [DEBUG] Connection:132 - {conn-10001} pool-connect
----------- : class com.mysql.cj.jdbc.ConnectionImpl
2022-05-09 23:48:57,665 [DEBUG] Statement:137 - {conn-10001, stmt-20000} created
2022-05-09 23:48:57,692 [DEBUG] Statement:137 - {conn-10001, stmt-20000} executed. 26.419 millis. select 1;select 1
2022-05-09 23:48:57,695 [DEBUG] ResultSet:142 - {conn-10001, stmt-20000, rs-50000} open
2022-05-09 23:48:57,697 [DEBUG] ResultSet:142 - {conn-10001, stmt-20000, rs-50000} Header: [1]
2022-05-09 23:48:57,700 [DEBUG] ResultSet:142 - {conn-10001, stmt-20000, rs-50001} open
2022-05-09 23:48:57,701 [DEBUG] ResultSet:142 - {conn-10001, stmt-20000, rs-50001} Header: [1]
2022-05-09 23:48:57,701 [DEBUG] ResultSet:142 - {conn-10001, stmt-20000, rs-50001} closed
2022-05-09 23:48:57,701 [DEBUG] Statement:137 - {conn-10001, stmt-20000} closed
2022-05-09 23:48:57,702 [DEBUG] Connection:132 - {conn-10001} pool-recycle
2022-05-09 23:48:57,702 [INFO ] DruidDataSource:2071 - {dataSource-1} closing ...
2022-05-09 23:48:57,704 [DEBUG] Connection:132 - {conn-10001} closed
2022-05-09 23:48:57,705 [INFO ] DruidDataSource:2144 - {dataSource-1} closed

Process finished with exit code 0

说明单元测试运行成功

Druid初体验

Java相关栏目本月热门文章