ClickHouse（三）-JDBC链接查询

最新推荐文章于 2025-11-04 10:50:57 发布

原创最新推荐文章于 2025-11-04 10:50:57 发布 · 4.7k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#Clickhouse #JDBC

Clickhouse 专栏收录该内容

3 篇文章

订阅专栏

本文介绍如何通过Java使用ClickHouse JDBC驱动连接ClickHouse数据库并执行SQL查询，包括依赖配置、连接设置及结果集处理。

pom.xml

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

代码

package com.lsoft.a2oai.ch.test;

import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class ClickHouseTest {
	
	public static void main(String[] args) {
		String sql = "select count(*) count from ratings";
		String address = "jdbc:clickhouse://192.168.0.108:8123/default";
		Connection connection = null;
		Statement statement = null;
		ResultSet results = null;
		try {
			Class.forName("ru.yandex.clickhouse.ClickHouseDriver");
			connection = DriverManager.getConnection(address);
			statement = connection.createStatement();
			results = statement.executeQuery(sql);
			ResultSetMetaData rsmd = results.getMetaData();
			List<Map> list = new ArrayList();
			while (results.next()) {
				Map map = new HashMap();
				for (int i = 1; i <= rsmd.getColumnCount(); i++) {
					map.put(rsmd.getColumnName(i), results.getString(rsmd.getColumnName(i)));
				}
				list.add(map);
			}
			for (Map map : list) {
				System.err.println(map);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (results != null) {
					results.close();
				}
				if (statement != null) {
					statement.close();
				}
				if (connection != null) {
					connection.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}