clickhouse jdbc dem

最新推荐文章于 2023-11-08 20:10:31 发布

原创最新推荐文章于 2023-11-08 20:10:31 发布 · 153 阅读

0 ·

CC 4.0 BY-SA版权

clickhouse 专栏收录该内容

4 篇文章

订阅专栏

这段代码展示了如何通过Java连接Clickhouse数据库并执行批量插入操作。它创建了一个PreparedStatement，设置参数并添加到批处理中，最后执行批处理将数据插入到`new_db.myTest`表中。

public class ClickhouseConn {
    public static void main(String[] args) throws SQLException {
        Connection connection = DriverManager.getConnection("jdbc:clickhouse://hadoop105:8123","default","000000");

        PreparedStatement pstmt = connection.prepareStatement("INSERT INTO new_db.myTest VALUES(?, ?, ?)");

        for (int i = 0; i < 10; i++) {
            pstmt.setString(1, "Zhang" + i);
            pstmt.setInt(2,i);
            pstmt.setString(3, "guangxi" +1);
            pstmt.addBatch();
        }
        pstmt.executeBatch();
    }
}