Package cc.carm.lib.easysql.api.builder

Interface ConditionalBuilder<B extends ConditionalBuilder<B,T>,T extends SQLAction<?>>

All Superinterfaces:

SQLBuilder

All Known Subinterfaces:

DeleteBuilder, TableQueryBuilder, UpdateBuilder

All Known Implementing Classes:

AbstractConditionalBuilder, DeleteBuilderImpl, TableQueryBuilderImpl, UpdateBuilderImpl

public interface ConditionalBuilder<B extends ConditionalBuilder<B,T>,T extends SQLAction<?>>
extends SQLBuilder

Method Summary

Modifier and Type	Method	Description
B	addCondition(@NotNull java.lang.String[] queryNames, @Nullable java.lang.Object[] queryValues)
B	addCondition(@NotNull java.lang.String queryName, @NotNull java.lang.String operator, @Nullable java.lang.Object queryValue)
default B	addCondition(@NotNull java.lang.String queryName, @Nullable java.lang.Object queryValue)
B	addCondition(@Nullable java.lang.String condition)
B	addNotNullCondition(@NotNull java.lang.String queryName)
default B	addTimeCondition(@NotNull java.lang.String queryName, long startMillis, long endMillis)
B	addTimeCondition(@NotNull java.lang.String queryName, java.util.Date startDate, java.util.Date endDate)
T	build()	将现有条件构建完整的SQL语句用于执行。
B	setConditions(@Nullable java.lang.String condition)
B	setConditions(java.util.LinkedHashMap<@NotNull java.lang.String,@Nullable java.lang.Object> conditionSQLs)
B	setLimit(int limit)	设定取出的条数

Methods inherited from interface cc.carm.lib.easysql.api.SQLBuilder

getManager

Method Detail

build

T build()

将现有条件构建完整的SQL语句用于执行。

Returns:

SQLAction

setLimit

B setLimit(int limit)

设定取出的条数

Parameters:

limit - 条数限制

Returns:

ConditionalBuilder

setConditions

B setConditions(@Nullable
                @Nullable java.lang.String condition)

setConditions

B setConditions(java.util.LinkedHashMap<@NotNull java.lang.String,@Nullable java.lang.Object> conditionSQLs)

addCondition

B addCondition(@Nullable
               @Nullable java.lang.String condition)

addCondition

B addCondition(@NotNull
               @NotNull java.lang.String queryName,
               @NotNull
               @NotNull java.lang.String operator,
               @Nullable
               @Nullable java.lang.Object queryValue)

addCondition

default B addCondition(@NotNull
                       @NotNull java.lang.String queryName,
                       @Nullable
                       @Nullable java.lang.Object queryValue)

addCondition

B addCondition(@NotNull
               @NotNull java.lang.String[] queryNames,
               @Nullable
               @Nullable java.lang.Object[] queryValues)

addNotNullCondition

B addNotNullCondition(@NotNull
                      @NotNull java.lang.String queryName)

addTimeCondition

default B addTimeCondition(@NotNull
                           @NotNull java.lang.String queryName,
                           long startMillis,
                           long endMillis)

addTimeCondition

B addTimeCondition(@NotNull
                   @NotNull java.lang.String queryName,
                   @Nullable
                   java.util.Date startDate,
                   @Nullable
                   java.util.Date endDate)