AI专业者开发社区 1 号成员
  •  0 回帖  •  2 浏览  •  4 个月前
 

java 数据库连接池HikariCP

HikariCP 数据库连接池，代号：光，表示它非常快。github 地址：https://github.com/brettwooldridge/HikariCP

jar 包下载或 maven 引用地址：http://maven.outofmemory.cn/com.zaxxer/HikariCP/ 或 https://mvnrepository.com/artifact/com.zaxxer/HikariCP

Java 11+ maven artifact:

<dependency>
   <groupId>com.zaxxer</groupId>
   <artifactId>HikariCP</artifactId>
   <version>5.0.1</version>
</dependency>

Java 8 maven artifact (maintenance mode):

<dependency>
   <groupId>com.zaxxer</groupId>
   <artifactId>HikariCP</artifactId>
   <version>4.0.3</version>
</dependency>

Java 7 maven artifact (maintenance mode):

<dependency>
   <groupId>com.zaxxer</groupId>
   <artifactId>HikariCP-java7</artifactId>
   <version>2.4.13</version>
</dependency>

Java 6 maven artifact (maintenance mode):

<dependency>
   <groupId>com.zaxxer</groupId>
   <artifactId>HikariCP-java6</artifactId>
   <version>2.3.13</version>
</dependency>
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
  
import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;
  
/**
 * hikaricp 连接池示例
 * @author sms.reyo.cn
 * 2022-12-12
 */
public class HikariDemo {
  
    public static void main(String[] args) {
         
        //配置文件
        HikariConfig hikariConfig = new HikariConfig();
//        hikariConfig.setJdbcUrl("jdbc:mysql://localhost:3306/mydata");//mysql
        hikariConfig.setJdbcUrl("jdbc:oracle:thin:@localhost:1521:orcl");//oracle
        hikariConfig.setDriverClassName("oracle.jdbc.driver.OracleDriver");
        hikariConfig.setUsername("whg");
        hikariConfig.setPassword("whg");
        hikariConfig.addDataSourceProperty("cachePrepStmts", "true");
        hikariConfig.addDataSourceProperty("prepStmtCacheSize", "250");
        hikariConfig.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");
  
        HikariDataSource ds = new HikariDataSource(hikariConfig);
        Connection conn = null;
        Statement statement = null;
        ResultSet rs = null;
        try{
             
            //创建connection
            conn = ds.getConnection();
            statement = conn.createStatement();
             
            //执行sql
            rs = statement.executeQuery("select 100 s  from dual");
  
            //取数据
            if (rs.next()){
                System.out.println(rs.getString("s"));
            }
             
            //关闭connection
            conn.close();
        }
        catch (SQLException e){
            e.printStackTrace();
        }
  
    }
  
}