java通过jdbc连接clickhouse

先确认我们的ck服务正常，随便做个查询

来到java项目，先引包

<dependency>
   <groupId>ru.yandex.clickhouse</groupId>
   <artifactId>clickhouse-jdbc</artifactId>
   <version>0.2.4</version>
</dependency>

  

 

  
1
  
2
  
3
  
4
  
5
 

jdbc测试

    public void clickHouseTest() throws ClassNotFoundException, SQLException {
        Class.forName("ru.yandex.clickhouse.ClickHouseDriver");
        Connection connection = DriverManager.getConnection("jdbc:clickhouse://*.*.*.*:8123/tutorial", "用户名", "密码");
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery("select count(1) from tutorial.hits_v1");
        while (resultSet.next()) {
            System.out.println("查询结果为：" + resultSet.getString(1));
        }
    }

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
 

结果

文章来源: huangjie.blog.csdn.net，作者：负债程序猿，版权归原作者所有，如需转载，请联系作者。

原文链接：huangjie.blog.csdn.net/article/details/121384103