java使用jdbc连接clickhouse

要在Java中使用JDBC连接ClickHouse，首先需要引入ClickHouse JDBC驱动的依赖包。可以通过在项目的pom.xml文件中添加以下依赖来引入ClickHouse JDBC驱动：

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

然后，根据ClickHouse的连接地址、用户名和密码，使用JDBC连接ClickHouse数据库。以下是一个简单的示例代码：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ClickHouseExample {
    public static void main(String[] args) 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));
        }
    }
}

这段代码首先加载ClickHouse数据库的JDBC驱动，然后通过DriverManager获取数据库连接。接下来，创建一个Statement对象，并使用executeQuery方法执行SQL查询语句。最后，通过ResultSet对象遍历查询结果并进行处理。

需要注意的是，需要将代码中的"用户名"和"密码"替换为实际的登录信息，并将"*.*.*.*"替换为ClickHouse数据库的IP地址或域名。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [java通过jdbc连接clickhouse](https://blog.csdn.net/qq_33709582/article/details/121384103)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *3* [使用Jdbc的方式连接Clickhouse](https://blog.csdn.net/u011652364/article/details/113875395)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]