com.gitee.cardoon.ms.db.multiple.builder

类 Builder

java.lang.Object

com.gitee.cardoon.ms.db.multiple.builder.Builder

直接已知子类:

CompareBuilder, ConditionBuilder

public class Builder
extends Object

字段概要

字段

限定符和类型	字段和说明
protected Boolean	end 结束条件判断
protected Map<String,Object>	parameter 参数
protected List<String>	querySqlList sql列表
protected Boolean	start 开始条件判断

构造器概要

构造器

限定符	构造器和说明
protected	Builder()

方法概要

限定符和类型	方法和说明
protected void	andSql(boolean condition) 并且
protected void	andSql(boolean condition, Builder builder) 并且
protected void	betweenSql(boolean condition, String function, Builder builder, Object leftValue, Object rightValue) 在两者之间
protected void	betweenSql(boolean condition, String function, String tableNickName, String column, Object leftValue, Object rightValue) 在两者之间
static CompareBuilder	compare() 比较
static ConditionBuilder	condition() 条件
protected void	endSql() end
protected void	eqSql(boolean condition, String function, Builder builder, Object value) 相等
protected void	eqSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, Builder rightBuilder) 相等
protected void	eqSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, String rightTableNickName, String rightColumn) 相等
protected void	eqSql(boolean condition, String function, String tableNickName, String column, Object value) 相等
protected void	eqSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, Builder rightBuilder) 相等
protected void	eqSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, String rightTableNickName, String rightColumn) 相等
protected void	existsSql(boolean condition, MultipleWrapper wrapper) 存在sql
protected void	funcSql(String function, Builder builder) 获取方法sql
protected void	geSql(boolean condition, String function, Builder builder, Object value) 大于等于
protected void	geSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, Builder rightBuilder) 大于等于
protected void	geSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, String rightTableNickName, String rightColumn) 大于等于
protected void	geSql(boolean condition, String function, String tableNickName, String column, Object value) 大于等于
protected void	geSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, Builder rightBuilder) 大于等于
protected void	geSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, String rightTableNickName, String rightColumn) 大于等于
Map<String,Object>	getParameter() 获取查询参数
String	getQuerySql(String connector) 获取查询sql
List<String>	getQuerySqlList() 获取查询字段
protected void	gtSql(boolean condition, String function, Builder builder, Object value) 大于
protected void	gtSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, Builder rightBuilder) 大于
protected void	gtSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, String rightTableNickName, String rightColumn) 大于
protected void	gtSql(boolean condition, String function, String tableNickName, String column, Object value) 大于
protected void	gtSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, Builder rightBuilder) 大于
protected void	gtSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, String rightTableNickName, String rightColumn) 大于
protected void	inSql(boolean condition, String function, Builder builder, Collection<?> value) 在范围内
protected void	inSql(boolean condition, String function, String tableNickName, String column, Collection<?> value) 在范围内
protected void	isNotNullSql(boolean condition, String function, Builder builder) 不为空
protected void	isNotNullSql(boolean condition, String function, String tableNickName, String column) 不为空
protected void	isNullSql(boolean condition, String function, Builder builder) 空
protected void	isNullSql(boolean condition, String function, String tableNickName, String column) 空
protected void	leSql(boolean condition, String function, Builder builder, Object value) 小于等于
protected void	leSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, Builder rightBuilder) 小于等于
protected void	leSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, String rightTableNickName, String rightColumn) 小于等于
protected void	leSql(boolean condition, String function, String tableNickName, String column, Object value) 小于等于
protected void	leSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, Builder rightBuilder) 小于等于
protected void	leSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, String rightTableNickName, String rightColumn) 小于等于
protected void	likeLeftSql(boolean condition, String function, Builder builder, Object value) 从左模糊查询
protected void	likeLeftSql(boolean condition, String function, String tableNickName, String column, Object value) 从左模糊查询
protected void	likeRightSql(boolean condition, String function, Builder builder, Object value) 从右模糊查询
protected void	likeRightSql(boolean condition, String function, String tableNickName, String column, Object value) 从右模糊查询
protected void	likeSql(boolean condition, String function, Builder builder, Object value) 模糊
protected void	likeSql(boolean condition, String function, String tableNickName, String column, Object value) 模糊
protected void	ltSql(boolean condition, String function, Builder builder, Object value) 小于
protected void	ltSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, Builder rightBuilder) 小于
protected void	ltSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, String rightTableNickName, String rightColumn) 小于
protected void	ltSql(boolean condition, String function, String tableNickName, String column, Object value) 小于
protected void	ltSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, Builder rightBuilder) 小于
protected void	ltSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, String rightTableNickName, String rightColumn) 小于
protected void	neSql(boolean condition, String function, Builder builder, Object value) 不等
protected void	neSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, Builder rightBuilder) 不等
protected void	neSql(boolean condition, String leftFunction, Builder leftBuilder, String rightFunction, String rightTableNickName, String rightColumn) 不等
protected void	neSql(boolean condition, String function, String tableNickName, String column, Object value) 不等
protected void	neSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, Builder rightBuilder) 不等
protected void	neSql(boolean condition, String leftFunction, String leftTableNickName, String leftColumn, String rightFunction, String rightTableNickName, String rightColumn) 不等
protected void	notBetweenSql(boolean condition, String function, Builder builder, Object leftValue, Object rightValue) 不在两者之间
protected void	notBetweenSql(boolean condition, String function, String tableNickName, String column, Object leftValue, Object rightValue) 不在两者之间
protected void	notExistsSql(boolean condition, MultipleWrapper wrapper) 不存在sql
protected void	notInSql(boolean condition, String function, Builder builder, Collection<?> value) 不在范围内
protected void	notInSql(boolean condition, String function, String tableNickName, String column, Collection<?> value) 不在范围内
protected void	notLikeLeftSql(boolean condition, String function, Builder builder, Object value) 不在从左模糊查询
protected void	notLikeLeftSql(boolean condition, String function, String tableNickName, String column, Object value) 不在从左模糊查询
protected void	notLikeRightSql(boolean condition, String function, Builder builder, Object value) 不在从右模糊查询
protected void	notLikeRightSql(boolean condition, String function, String tableNickName, String column, Object value) 不在从右模糊查询
protected void	notLikeSql(boolean condition, String function, Builder builder, Object value) 不在模糊范围内
protected void	notLikeSql(boolean condition, String function, String tableNickName, String column, Object value) 不在模糊范围内
protected void	orSql(boolean condition) 或者
protected void	orSql(boolean condition, Builder builder) 或者
protected void	otherwiseSql(Object value) else
protected void	whenSql(Builder builder, Object value) when

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

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

字段详细资料

parameter

protected Map<String,Object> parameter

参数

querySqlList

protected List<String> querySqlList

sql列表

start

protected Boolean start

开始条件判断

end

protected Boolean end

结束条件判断

构造器详细资料

Builder

protected Builder()

方法详细资料

compare

public static CompareBuilder compare()

比较

返回:

condition

public static ConditionBuilder condition()

条件

返回:

getParameter

public Map<String,Object> getParameter()

获取查询参数

返回:

getQuerySqlList

public List<String> getQuerySqlList()

获取查询字段

返回:

getQuerySql

public String getQuerySql(String connector)

获取查询sql

参数:

connector -

返回:

funcSql

protected void funcSql(String function,
                       Builder builder)

获取方法sql

参数:

function -

builder -

whenSql

protected void whenSql(Builder builder,
                       Object value)

when

参数:

builder -

value -

otherwiseSql

protected void otherwiseSql(Object value)

else

参数:

value -

endSql

protected void endSql()

end

eqSql

protected void eqSql(boolean condition,
                     String function,
                     String tableNickName,
                     String column,
                     Object value)

相等

参数:

condition -

function -

tableNickName -

column -

value -

eqSql

protected void eqSql(boolean condition,
                     String function,
                     Builder builder,
                     Object value)

相等

参数:

condition -

function -

builder -

value -

eqSql

protected void eqSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

相等

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightTableNickName -

rightColumn -

eqSql

protected void eqSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

相等

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightTableNickName -

rightColumn -

eqSql

protected void eqSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     Builder rightBuilder)

相等

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightBuilder -

eqSql

protected void eqSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     Builder rightBuilder)

相等

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightBuilder -

neSql

protected void neSql(boolean condition,
                     String function,
                     String tableNickName,
                     String column,
                     Object value)

不等

参数:

condition -

function -

tableNickName -

column -

value -

neSql

protected void neSql(boolean condition,
                     String function,
                     Builder builder,
                     Object value)

不等

参数:

condition -

function -

builder -

value -

neSql

protected void neSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

不等

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightTableNickName -

rightColumn -

neSql

protected void neSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

不等

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightTableNickName -

rightColumn -

neSql

protected void neSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     Builder rightBuilder)

不等

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightBuilder -

neSql

protected void neSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     Builder rightBuilder)

不等

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightBuilder -

gtSql

protected void gtSql(boolean condition,
                     String function,
                     String tableNickName,
                     String column,
                     Object value)

大于

参数:

condition -

function -

tableNickName -

column -

value -

gtSql

protected void gtSql(boolean condition,
                     String function,
                     Builder builder,
                     Object value)

大于

参数:

condition -

function -

builder -

value -

gtSql

protected void gtSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

大于

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightTableNickName -

rightColumn -

gtSql

protected void gtSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

大于

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightTableNickName -

rightColumn -

gtSql

protected void gtSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     Builder rightBuilder)

大于

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightBuilder -

gtSql

protected void gtSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     Builder rightBuilder)

大于

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightBuilder -

geSql

protected void geSql(boolean condition,
                     String function,
                     String tableNickName,
                     String column,
                     Object value)

大于等于

参数:

condition -

function -

tableNickName -

column -

value -

geSql

protected void geSql(boolean condition,
                     String function,
                     Builder builder,
                     Object value)

大于等于

参数:

condition -

function -

builder -

value -

geSql

protected void geSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

大于等于

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightTableNickName -

rightColumn -

geSql

protected void geSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

大于等于

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightTableNickName -

rightColumn -

geSql

protected void geSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     Builder rightBuilder)

大于等于

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightBuilder -

geSql

protected void geSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     Builder rightBuilder)

大于等于

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightBuilder -

ltSql

protected void ltSql(boolean condition,
                     String function,
                     String tableNickName,
                     String column,
                     Object value)

小于

参数:

condition -

function -

tableNickName -

column -

value -

ltSql

protected void ltSql(boolean condition,
                     String function,
                     Builder builder,
                     Object value)

小于

参数:

condition -

function -

builder -

value -

ltSql

protected void ltSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

小于

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightTableNickName -

rightColumn -

ltSql

protected void ltSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

小于

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightTableNickName -

rightColumn -

ltSql

protected void ltSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     Builder rightBuilder)

小于

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightBuilder -

ltSql

protected void ltSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     Builder rightBuilder)

小于

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightBuilder -

leSql

protected void leSql(boolean condition,
                     String function,
                     String tableNickName,
                     String column,
                     Object value)

小于等于

参数:

condition -

function -

tableNickName -

column -

value -

leSql

protected void leSql(boolean condition,
                     String function,
                     Builder builder,
                     Object value)

小于等于

参数:

condition -

function -

builder -

value -

leSql

protected void leSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

小于等于

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightTableNickName -

rightColumn -

leSql

protected void leSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     String rightTableNickName,
                     String rightColumn)

小于等于

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightTableNickName -

rightColumn -

leSql

protected void leSql(boolean condition,
                     String leftFunction,
                     String leftTableNickName,
                     String leftColumn,
                     String rightFunction,
                     Builder rightBuilder)

小于等于

参数:

condition -

leftFunction -

leftTableNickName -

leftColumn -

rightFunction -

rightBuilder -

leSql

protected void leSql(boolean condition,
                     String leftFunction,
                     Builder leftBuilder,
                     String rightFunction,
                     Builder rightBuilder)

小于等于

参数:

condition -

leftFunction -

leftBuilder -

rightFunction -

rightBuilder -

betweenSql

protected void betweenSql(boolean condition,
                          String function,
                          String tableNickName,
                          String column,
                          Object leftValue,
                          Object rightValue)

在两者之间

参数:

condition -

function -

tableNickName -

column -

leftValue -

rightValue -

betweenSql

protected void betweenSql(boolean condition,
                          String function,
                          Builder builder,
                          Object leftValue,
                          Object rightValue)

在两者之间

参数:

condition -

function -

builder -

leftValue -

rightValue -

notBetweenSql

protected void notBetweenSql(boolean condition,
                             String function,
                             String tableNickName,
                             String column,
                             Object leftValue,
                             Object rightValue)

不在两者之间

参数:

condition -

function -

tableNickName -

column -

leftValue -

rightValue -

notBetweenSql

protected void notBetweenSql(boolean condition,
                             String function,
                             Builder builder,
                             Object leftValue,
                             Object rightValue)

不在两者之间

参数:

condition -

function -

builder -

leftValue -

rightValue -

likeSql

protected void likeSql(boolean condition,
                       String function,
                       String tableNickName,
                       String column,
                       Object value)

模糊

参数:

condition -

function -

tableNickName -

column -

value -

likeSql

protected void likeSql(boolean condition,
                       String function,
                       Builder builder,
                       Object value)

模糊

参数:

condition -

function -

builder -

value -

notLikeSql

protected void notLikeSql(boolean condition,
                          String function,
                          String tableNickName,
                          String column,
                          Object value)

不在模糊范围内

参数:

condition -

function -

tableNickName -

column -

value -

notLikeSql

protected void notLikeSql(boolean condition,
                          String function,
                          Builder builder,
                          Object value)

不在模糊范围内

参数:

condition -

function -

builder -

value -

likeLeftSql

protected void likeLeftSql(boolean condition,
                           String function,
                           String tableNickName,
                           String column,
                           Object value)

从左模糊查询

参数:

condition -

function -

tableNickName -

column -

value -

likeLeftSql

protected void likeLeftSql(boolean condition,
                           String function,
                           Builder builder,
                           Object value)

从左模糊查询

参数:

condition -

function -

builder -

value -

notLikeLeftSql

protected void notLikeLeftSql(boolean condition,
                              String function,
                              String tableNickName,
                              String column,
                              Object value)

不在从左模糊查询

参数:

condition -

function -

tableNickName -

column -

value -

notLikeLeftSql

protected void notLikeLeftSql(boolean condition,
                              String function,
                              Builder builder,
                              Object value)

不在从左模糊查询

参数:

condition -

function -

builder -

value -

likeRightSql

protected void likeRightSql(boolean condition,
                            String function,
                            String tableNickName,
                            String column,
                            Object value)

从右模糊查询

参数:

condition -

function -

tableNickName -

column -

value -

likeRightSql

protected void likeRightSql(boolean condition,
                            String function,
                            Builder builder,
                            Object value)

从右模糊查询

参数:

condition -

function -

builder -

value -

notLikeRightSql

protected void notLikeRightSql(boolean condition,
                               String function,
                               String tableNickName,
                               String column,
                               Object value)

不在从右模糊查询

参数:

condition -

function -

tableNickName -

column -

value -

notLikeRightSql

protected void notLikeRightSql(boolean condition,
                               String function,
                               Builder builder,
                               Object value)

不在从右模糊查询

参数:

condition -

function -

builder -

value -

inSql

protected void inSql(boolean condition,
                     String function,
                     String tableNickName,
                     String column,
                     Collection<?> value)

在范围内

参数:

condition -

function -

tableNickName -

column -

value -

inSql

protected void inSql(boolean condition,
                     String function,
                     Builder builder,
                     Collection<?> value)

在范围内

参数:

condition -

function -

builder -

value -

notInSql

protected void notInSql(boolean condition,
                        String function,
                        String tableNickName,
                        String column,
                        Collection<?> value)

不在范围内

参数:

condition -

function -

tableNickName -

column -

value -

notInSql

protected void notInSql(boolean condition,
                        String function,
                        Builder builder,
                        Collection<?> value)

不在范围内

参数:

condition -

function -

builder -

value -

isNullSql

protected void isNullSql(boolean condition,
                         String function,
                         String tableNickName,
                         String column)

空

参数:

condition -

function -

tableNickName -

column -

isNullSql

protected void isNullSql(boolean condition,
                         String function,
                         Builder builder)

空

参数:

condition -

function -

builder -

isNotNullSql

protected void isNotNullSql(boolean condition,
                            String function,
                            String tableNickName,
                            String column)

不为空

参数:

condition -

function -

tableNickName -

column -

isNotNullSql

protected void isNotNullSql(boolean condition,
                            String function,
                            Builder builder)

不为空

参数:

condition -

function -

builder -

andSql

protected void andSql(boolean condition,
                      Builder builder)

并且

参数:

condition -

builder -

andSql

protected void andSql(boolean condition)

并且

参数:

condition -

orSql

protected void orSql(boolean condition,
                     Builder builder)

或者

参数:

condition -

builder -

orSql

protected void orSql(boolean condition)

或者

参数:

condition -

existsSql

protected void existsSql(boolean condition,
                         MultipleWrapper wrapper)

存在sql

参数:

condition -

wrapper -

notExistsSql

protected void notExistsSql(boolean condition,
                            MultipleWrapper wrapper)

不存在sql

参数:

condition -

wrapper -