clickhouse JDBC三方包方式连库操作

曾经终败给现在 2022-09-17 03:12 113阅读 0赞

**目录**

引入依赖

新建测试类

运行结果

--------------------

## 引入依赖 ##

<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.createStatement();
    //        statement.executeQuery("create table if not exists test_psl.jdbc_example(day Date, name String, age UInt8) Engine=Log");
    //        System.out.println("create table successfully");
    
    
            //1.batch insert
            PreparedStatement pstmt = connection.prepareStatement("insert into test_psl.jdbc_example values(?, ?, ?)");
            // insert 10 records
            for (int i = 0; i < 10; i++) {
                pstmt.setDate(1, new Date(System.currentTimeMillis()));
                pstmt.setString(2, "panda_" + (i + 1));
                pstmt.setInt(3, 18);
                pstmt.addBatch();
            }
            pstmt.executeBatch();
    
            //3.查询
            String sql = "select * from test_psl.jdbc_example";
            ResultSet rs = statement.executeQuery(sql);
    
            while (rs.next()) {
                // ResultSet 的下标值从 1 开始，不可使用 0，否则越界，报 ArrayIndexOutOfBoundsException 异常
                System.out.println(rs.getDate(1) + ", " + rs.getString(2) + ", " + rs.getInt(3));
            }
    
        }
    }

## 运行结果 ##

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5aSn5pWw5o2u5p625p6E5biIUG9ueQ_size_20_color_FFFFFF_t_70_g_se_x_16][]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5aSn5pWw5o2u5p625p6E5biIUG9ueQ_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/09ff8a5ebf0f45e2a6f0d512ebf53abc.png