ClickHouse Java JDBC连接

xsjCoding

已于 2022-02-22 16:51:02 修改

阅读量1.6k

点赞数

分类专栏： ClickHouse 文章标签： ClickHouse

于 2022-02-22 16:49:52 首次发布

本文链接：https://blog.csdn.net/xushijie89/article/details/123072090

版权

ClickHouse 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

该代码示例展示了如何在Java中通过pom.xml引入clickhouse-jdbc依赖，然后利用ClickHouseDataSource建立连接，执行SQL查询并获取结果。程序从'172.16.131.56:8123'的'db_name'数据库的'table_name_col'表中获取所有数据，并将结果存储为HashMap列表。

摘要由CSDN通过智能技术生成

pom.xml文件

        <dependency>
            <groupId>com.clickhouse</groupId>
            <artifactId>clickhouse-jdbc</artifactId>
            <version>0.3.2-patch5</version>
        </dependency>

package com.tools;

import com.clickhouse.jdbc.ClickHouseDataSource;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Properties;

public class ClickHouse {
    public static void main(String[] args) throws SQLException {
        String url = "jdbc:clickhouse://172.16.131.56:8123/db_name";
        Properties properties = new Properties();
        // optionally set connection properties
        // properties.setProperty("clickhouse", "clickhouse");

        List<Map<String, Object>> list = new ArrayList<>();

        ClickHouseDataSource dataSource = new ClickHouseDataSource(url, properties);
        try (Connection conn = dataSource.getConnection();
             Statement stmt = conn.createStatement();
             ResultSet resultSet = stmt.executeQuery("select * from table_name_col")) {
            ResultSetMetaData resultsMetaData = resultSet.getMetaData();
            while (resultSet.next()) {
                Map<String, Object> row = new HashMap<>();
                for (int i = 1; i <= resultsMetaData.getColumnCount(); i++) {
                    row.put(
	                    resultsMetaData.getColumnName(i), 
	                    resultSet.getObject(resultsMetaData.getColumnName(i))
                    );
                }
                list.add(row);
            }
            System.out.println(list);
        }
    }
}