程序包 com.alibaba.nacos.plugin.datasource.mapper.ext

类 WhereBuilder

java.lang.Object

com.alibaba.nacos.plugin.datasource.mapper.ext.WhereBuilder

public final class WhereBuilder
extends Object

Where Builder.

作者:

haiqi.wang

字段概要

字段

修饰符和类型	字段	说明
private final List<Object>	parameters	Parameters.
private final String	sql	Base sql.
private final StringBuilder	where	Where Conditional.

构造器概要

构造器

构造器	说明
WhereBuilder(String sql)	Default Construct.

方法概要

修饰符和类型	方法	说明
WhereBuilder	and()	Build AND.
MapperResult	build()	Build.
WhereBuilder	eq(String filed, Object parameter)	Build Equals.
WhereBuilder	in(String filed, Object[] parameterArr)	Build IN.
WhereBuilder	like(String filed, Object parameter)	Build LIKE.
WhereBuilder	limit(int startRow, int pageSize)	Build limit.
WhereBuilder	offset(int startRow, int pageSize)	Build offset.
WhereBuilder	or()	Build OR.

从类继承的方法 java.lang.Object

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

字段详细资料

sql

private final String sql

Base sql.

parameters

private final List<Object> parameters

Parameters.

where

private final StringBuilder where

Where Conditional.

构造器详细资料

WhereBuilder

public WhereBuilder(String sql)

Default Construct.

参数:

sql - Sql Script

方法详细资料

and

public WhereBuilder and()

Build AND.

返回:

Return WhereBuilder

or

public WhereBuilder or()

Build OR.

返回:

Return WhereBuilder

eq

public WhereBuilder eq(String filed,
 Object parameter)

Build Equals.

参数:

filed - Filed name

parameter - Parameters

返回:

Return WhereBuilder

like

public WhereBuilder like(String filed,
 Object parameter)

Build LIKE.

参数:

filed - Filed name

parameter - Parameters

返回:

Return WhereBuilder

in

public WhereBuilder in(String filed,
 Object[] parameterArr)

Build IN.

参数:

filed - Filed name

parameterArr - Parameters Array

返回:

Return WhereBuilder

offset

public WhereBuilder offset(int startRow,
 int pageSize)

Build offset.

参数:

startRow - Start row

pageSize - Page size

返回:

Return WhereBuilder

limit

public WhereBuilder limit(int startRow,
 int pageSize)

Build limit.

参数:

startRow - Start row

pageSize - Page size

返回:

Return WhereBuilder

build

public MapperResult build()

Build.

返回:

Return WhereBuilder