Clickhouse工具类

Java实现ClickHouse数据库操作工具类,

八五年的湘哥

已于 2023-07-06 17:52:27 修改

阅读量541

点赞数

CC 4.0 BY-SA版权

文章标签： clickhouse 开发语言数据库

于 2023-07-04 10:54:18 首次发布

本文链接：https://blog.csdn.net/huxiang19851114/article/details/131530505

import com.paratera.console.datasync.constans.DataSyncConstants;
import lombok.extern.slf4j.Slf4j;
import org.springframework.amqp.rabbit.core.RabbitTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Component;

import javax.annotation.Resource;
import java.sql.;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.;

/**

clickhouse 工具类

*/
@Slf4j
@Component
public class ClickHouseUtils {

@Value("${clickhouse.url}")
private String url;

@Resource(name = "clickhouseConnection")
private Connection connection;

/**
 * 执行无返回sql
 *
 * @param sql
 */
public void execSQL(String sql) {
    log.debug("clickhouse 执行sql：" + sql);
    try (Statement statement = connection.createStatement()) {
        statement.execu