1.maven依赖<dependency> <groupId>com.github.housepower</groupId> <artifactId>clickhouse-native-jdbc</artifactId> <version>2.5.2</version></dependency>2.编码Class.forName("com.github.housepower.jdbc.ClickHouseDriver");Connection connection = DriverManager.getConnection("jdbc:clickhouse://192.168.60.131:9000");Statement statement = connection.createStatement();statement.executeQuery("create table test.example(day Date, name String, age UInt8) Engine=Log");PreparedStatement pstmt = connection.prepareStatement("insert into test.example values(?, ?, ?)");// insert 10 recordsfor (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();Statement statement = connection.createStatement();String sql = "select * from test.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));}
