在pom.xml 增加clickhouse 客户端依赖
<dependency>
<groupId>ru.yandex.clickhouse</groupId>
<artifactId>clickhouse-jdbc</artifactId>
<version>0.2.4</version>
</dependency>
在clickhouse数据库default下创建测试数据表 student
CREATE TABLE student
(
`id` UInt32,
`name` String,
`score` UInt32
)
ENGINE = TinyLog;
测试代码如下:
import com.sun.org.slf4j.internal.Logger;
import com.sun.org.slf4j.internal.LoggerFactory;
import ru.yandex.clickhouse.BalancedClickhouseDataSource;
import ru.yandex.clickhouse.ClickHouseConnection;
import ru.yandex.clickhouse.settings.ClickHouseProperties;
import java.sql.Array;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.*;
public class DataToClickHouse {
private st