# CkUtil

**Repository Path**: qvan_001/CkUtil

## Basic Information

- **Project Name**: CkUtil
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-03-12
- **Last Updated**: 2022-01-12

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### 1. 准备工作

数据库的连接属性需要在application.properties中声明：

```properties
spring.clickhouse.address=jdbc:clickhouse://host:port
spring.clickhouse.username=username
spring.clickhouse.password=pasword
spring.clickhouse.db=dbname
spring.clickhouse.socketTimeout=600000
```

值得说的是，由于之前用了mybatis-plus的多数据源配置，所以也做了适配，下面的配置声明也是可以的：

```properties
spring.datasource.dynamic.datasource.clickhouse.url=jdbc:clickhouse://host:port
spring.datasource.dynamic.datasource.clickhouse.username=default
spring.datasource.dynamic.datasource.clickhouse.password=
spring.datasource.dynamic.datasource.clickhouse.driver-class-name=ru.yandex.clickhouse.ClickHouseDriver
```

### 2. 如何使用

该工具包运行sql语句主要有两个方法：

```java
//简单的执行sql语句
ExeCkSql("sql");

//需要创建临时表（保证创建及查询在一个会话中）
CkProperties ckProperties = new CkProperties();
ckProperties.setUuid(GetUUID.getUUID());
//下面的语句是拼接的sql，作用是创建一个临时表并插入
ClickHouseExeSql.exeSql(ckProperties,"create temporary table "+ tab+"(usernum String)");
ClickHouseExeSql.exeSql(ckProperties,"insert into "+ tab+" values "+usSql);

//值得注意的是运行select语句时，返回的是List<Map<String,String>>类型
```