clickhouse 日常使用总结

2,305 阅读1分钟

jdbc操作

jdbc使用preparestatement怎么获取最终得到的sql呢?

    public static ResultSet queryBySql(String sql, Object... params) throws SQLException {
        final PreparedStatement preparedStatement = connection.prepareStatement(sql);
        for (int i = 0; i < params.length; i++) {
            preparedStatement.setObject(i + 1, params[i]);
        }
        final ClickHousePreparedStatementImpl clickHousePreparedStatement = (ClickHousePreparedStatementImpl) preparedStatement;
        final String s = clickHousePreparedStatement.asSql();
        // 这里有api
        log.info("clickhouse sql:{}", s);
        return preparedStatement.executeQuery();
    }