clickhouse JDBC三方包方式连库操作

目录

引入依赖

新建测试类

运行结果

---

引入依赖

        <dependency>
            <groupId>com.github.housepower</groupId>
            <artifactId>clickhouse-native-jdbc</artifactId>
            <version>1.6-stable</version>
        </dependency>

新建测试类

package com.sunline.ck;

import java.sql.*;

/**
 * @author psl
 * @create 2021/10/25 14:16
 * @desc  jdbc三方包测试clickhouse
 */
public class JDBCTest {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        Class.forName("com.github.housepower.jdbc.ClickHouseDriver");
        Connection connection = DriverManager.getConnection("jdbc:clickhouse://10.30.202.21:9100","default","123456");

        //1.连库建表
        Statement statement = connection.cr