cn.hutool.db.sql

Class SqlUtil

java.lang.Object

cn.hutool.db.sql.SqlUtil

public class SqlUtil
extends Object

SQL相关工具类，包括相关SQL语句拼接等

Since:

4.0.10

Author:

looly

Constructor Summary

Constructors

Constructor and Description
SqlUtil()

Method Summary

Modifier and Type	Method and Description
static String	blobToStr(Blob blob, Charset charset) Blob字段值转字符串
static Condition[]	buildConditions(Entity entity) 通过实体对象构建条件对象
static String	buildEqualsWhere(Entity entity, List<Object> paramValues) 构件相等条件的where语句 如果没有条件语句，泽返回空串，表示没有条件
static String	buildLikeValue(String value, Condition.LikeType likeType, boolean withLikeKeyword) 创建LIKE语句中的值，创建的结果为： 1、LikeType.StartWith: '%value' 2、LikeType.EndWith: 'value%' 3、LikeType.Contains: '%value%' 如果withLikeKeyword为true，则结果为： 1、LikeType.StartWith: LIKE '%value' 2、LikeType.EndWith: LIKE 'value%' 3、LikeType.Contains: LIKE '%value%'
static String	clobToStr(Clob clob) Clob字段值转字符串
static Blob	createBlob(Connection conn, byte[] data) 创建Blob对象
static Blob	createBlob(Connection conn, InputStream dataStream, boolean closeAfterUse) 创建Blob对象
static String	formatSql(String sql) 格式化SQL
static String	rowIdToString(RowId rowId) 将RowId转为字符串
static Date	toSqlDate(Date date) 转换为Date
static Timestamp	toSqlTimestamp(Date date) 转换为Timestamp

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SqlUtil

public SqlUtil()

Method Detail

buildEqualsWhere

public static String buildEqualsWhere(Entity entity,
                                      List<Object> paramValues)

构件相等条件的where语句
如果没有条件语句，泽返回空串，表示没有条件

Parameters:

entity - 条件实体

paramValues - 条件值得存放List

Returns:

带where关键字的SQL部分

buildConditions

public static Condition[] buildConditions(Entity entity)

通过实体对象构建条件对象

Parameters:

entity - 实体对象

Returns:

条件对象

buildLikeValue

public static String buildLikeValue(String value,
                                    Condition.LikeType likeType,
                                    boolean withLikeKeyword)

创建LIKE语句中的值，创建的结果为：

 1、LikeType.StartWith: '%value'
 2、LikeType.EndWith: 'value%'
 3、LikeType.Contains: '%value%'
 

如果withLikeKeyword为true，则结果为：

 1、LikeType.StartWith: LIKE '%value'
 2、LikeType.EndWith: LIKE 'value%'
 3、LikeType.Contains: LIKE '%value%'
 

Parameters:

value - 被查找值

likeType - LIKE值类型 Condition.LikeType

withLikeKeyword - 是否包含LIKE关键字

Returns:

拼接后的like值

formatSql

public static String formatSql(String sql)

格式化SQL

Parameters:

sql - SQL

Returns:

格式化后的SQL

rowIdToString

public static String rowIdToString(RowId rowId)

将RowId转为字符串

Parameters:

rowId - RowId

Returns:

RowId字符串

clobToStr

public static String clobToStr(Clob clob)

Clob字段值转字符串

Parameters:

clob - Clob

Returns:

字符串

Since:

3.0.6

blobToStr

public static String blobToStr(Blob blob,
                               Charset charset)

Blob字段值转字符串

Parameters:

blob - Blob

charset - 编码

Returns:

字符串

Since:

3.0.6

createBlob

public static Blob createBlob(Connection conn,
                              InputStream dataStream,
                              boolean closeAfterUse)

创建Blob对象

Parameters:

conn - Connection

dataStream - 数据流，使用完毕后关闭

closeAfterUse - 使用完毕是否关闭流

Returns:

Blob

Since:

4.5.13

createBlob

public static Blob createBlob(Connection conn,
                              byte[] data)

创建Blob对象

Parameters:

conn - Connection

data - 数据

Returns:

Blob

Since:

4.5.13

toSqlDate

public static Date toSqlDate(Date date)

转换为Date

Parameters:

date - Date

Returns:

Date

Since:

3.1.2

toSqlTimestamp

public static Timestamp toSqlTimestamp(Date date)

转换为Timestamp

Parameters:

date - Date

Returns:

Timestamp

Since:

3.1.2