| 限定符和类型 | 方法和说明 |
|---|---|
<T> int |
DefaultSqlContext.delete(Class<T> entityClass,
Consumer<GenericWhereCondition> condition) |
<T> int |
DefaultSqlContext.update(T entity,
Consumer<GenericWhereCondition> condition) |
<T> int |
DefaultSqlContext.updateSelective(T entity,
Collection<Fn<T,?>> forcedFields,
Consumer<GenericWhereCondition> condition) |
<T> int |
DefaultSqlContext.updateSelective(T entity,
Consumer<GenericWhereCondition> condition) |
| 限定符和类型 | 方法和说明 |
|---|---|
<T> int |
SqlContext.delete(Class<T> entityClass,
Consumer<GenericWhereCondition> condition)
根据指定的条件删除数据库中的记录。
|
<T> int |
SqlContext.update(T entity,
Consumer<GenericWhereCondition> condition)
根据指定条件更新实体对象的所有字段。
|
<T> int |
SqlContext.updateSelective(T entity,
Collection<Fn<T,?>> forcedFields,
Consumer<GenericWhereCondition> condition)
根据指定条件更新实体对象的非空字段,并强制更新指定的字段。
|
<T> int |
SqlContext.updateSelective(T entity,
Consumer<GenericWhereCondition> condition)
根据指定条件更新实体对象的非空字段。
|
| 限定符和类型 | 方法和说明 |
|---|---|
default C |
Condition.andCondition(boolean isEffective,
Consumer<GenericWhereCondition> nestedCondition)
根据条件添加一组条件,并且运算。
|
default C |
Condition.andCondition(Consumer<GenericWhereCondition> nestedCondition)
添加一组条件,并且运算。
|
default C |
Condition.orCondition(boolean isEffective,
Consumer<GenericWhereCondition> nestedCondition)
根据条件添加一个嵌套条件,或运算。
|
default C |
Condition.orCondition(Consumer<GenericWhereCondition> nestedCondition)
添加一个嵌套条件,或运算。
|
| 限定符和类型 | 类和说明 |
|---|---|
class |
MysqlWhereCondition |
class |
OracleWhereCondition |
| 限定符和类型 | 方法和说明 |
|---|---|
GenericWhereCondition |
GenericWhereCondition.andBetween(AggregateFunction function,
Object start,
Object end) |
GenericWhereCondition |
GenericWhereCondition.andBetween(Column column,
Object start,
Object end) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.andBetween(Fn<T1,F> field1,
Fn<T2,F> startField,
Fn<T2,F> endField) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andBetween(Fn<T,F> fn,
Object start,
Object end) |
GenericWhereCondition |
GenericWhereCondition.andCondition(Consumer<GenericWhereCondition> nestedCondition) |
GenericWhereCondition |
GenericWhereCondition.andEqualTo(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andEqualTo(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andEqualTo(Column column,
Column column2) |
GenericWhereCondition |
GenericWhereCondition.andEqualTo(Column column,
Object value) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.andEqualTo(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andEqualTo(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andEqualTo(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andEqualTo(Object value,
ColumFunction columFunction) |
GenericWhereCondition |
GenericWhereCondition.andExists(SelectDsl nestedSelect) |
GenericWhereCondition |
MysqlWhereCondition.andFindInSet(Column column,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andFindInSet(Column column,
Object value) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.andFindInSet(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andFindInSet(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.andFindInSet(Fn<T,F> fn,
Object item) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andFindInSet(Fn<T,F> fn,
Object item) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.andFindInSet(Fn<T,F> fn,
Object item,
String separator) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andFindInSet(Fn<T,F> fn,
Object item,
String separator) |
GenericWhereCondition |
GenericWhereCondition.andFunction(ColumFunction columFunction) |
GenericWhereCondition |
GenericWhereCondition.andGreaterThan(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andGreaterThan(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andGreaterThan(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andGreaterThan(Column column,
Column column2) |
GenericWhereCondition |
GenericWhereCondition.andGreaterThan(Column column,
Object value) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.andGreaterThan(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andGreaterThan(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andGreaterThan(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andGreaterThan(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andGreaterThanOrEqualTo(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andGreaterThanOrEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andGreaterThanOrEqualTo(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andGreaterThanOrEqualTo(Column column,
Column column2) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.andGreaterThanOrEqualTo(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andGreaterThanOrEqualTo(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andGreaterThanOrEqualTo(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andGreaterThanOrEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andIn(AggregateFunction function,
Iterable<?> values) |
GenericWhereCondition |
GenericWhereCondition.andIn(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andIn(ColumFunction columFunction,
Iterable<?> values) |
GenericWhereCondition |
GenericWhereCondition.andIn(Column column,
Iterable<?> values) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andIn(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andIn(Fn<T,F> fn,
Iterable<?> values) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andIn(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andIsNotNull(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andIsNotNull(Column column) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andIsNotNull(Fn<T,F> fn) |
GenericWhereCondition |
GenericWhereCondition.andIsNull(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andIsNull(Column column) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andIsNull(Fn<T,F> fn) |
GenericWhereCondition |
GenericWhereCondition.andLessThan(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andLessThan(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andLessThan(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andLessThan(Column column,
Column column2) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.andLessThan(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andLessThan(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andLessThan(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andLessThan(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andLessThanOrEqualTo(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andLessThanOrEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andLessThanOrEqualTo(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andLessThanOrEqualTo(Column column,
Column column2) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.andLessThanOrEqualTo(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andLessThanOrEqualTo(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andLessThanOrEqualTo(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andLessThanOrEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andLike(Column column,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andLike(Fn<T,F> fn,
String pattern) |
GenericWhereCondition |
MysqlWhereCondition.andMatches(Column column,
String value) |
GenericWhereCondition |
GenericWhereCondition.andMatches(Column column,
String regex) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.andMatches(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
OracleWhereCondition.andMatches(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andMatches(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.andMatches(Fn<T,F> fn,
String regex) |
<T,F> GenericWhereCondition |
OracleWhereCondition.andMatches(Fn<T,F> fn,
String regex) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andMatches(Fn<T,F> fn,
String regex) |
GenericWhereCondition |
GenericWhereCondition.andNotBetween(AggregateFunction function,
Object start,
Object end) |
GenericWhereCondition |
GenericWhereCondition.andNotBetween(Column column,
Object start,
Object end) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andNotBetween(Fn<T,F> fn,
Object start,
Object end) |
GenericWhereCondition |
GenericWhereCondition.andNotEqualTo(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andNotEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andNotEqualTo(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.andNotEqualTo(Column column,
Column column2) |
GenericWhereCondition |
GenericWhereCondition.andNotEqualTo(Column column,
Object value) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.andNotEqualTo(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andNotEqualTo(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andNotEqualTo(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andNotEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andNotExists(SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andNotIn(AggregateFunction function,
Iterable<?> values) |
GenericWhereCondition |
GenericWhereCondition.andNotIn(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andNotIn(ColumFunction columFunction,
Iterable<?> values) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andNotIn(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andNotIn(Fn<T,F> fn,
Iterable<?> values) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andNotIn(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.andNotLike(Column column,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.andNotLike(Fn<T,F> fn,
String pattern) |
GenericWhereCondition |
MysqlWhereCondition.limit(int limit) |
GenericWhereCondition |
GenericWhereCondition.limit(int limit) |
GenericWhereCondition |
MysqlWhereCondition.limit(int offset,
int limit) |
GenericWhereCondition |
GenericWhereCondition.limit(int offset,
int limit) |
GenericWhereCondition |
MysqlWhereCondition.matches(LogicalOperatorType logicalOperatorType,
Column column,
String regex) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.matches(LogicalOperatorType logicalOperatorType,
Fn<T,F> fn,
String regex) |
<T,F> GenericWhereCondition |
OracleWhereCondition.matches(LogicalOperatorType logicalOperatorType,
Fn<T,F> fn,
String regex) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.matchesFunction(LogicalOperatorType logicalOperatorType,
Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
OracleWhereCondition.matchesFunction(LogicalOperatorType logicalOperatorType,
Fn<T,F> fn,
ColumFunction columFunction) |
GenericWhereCondition |
GenericWhereCondition.orBetween(AggregateFunction function,
Object start,
Object end) |
GenericWhereCondition |
GenericWhereCondition.orBetween(Column column,
Object start,
Object end) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.orBetween(Fn<T1,F> field1,
Fn<T2,F> startField,
Fn<T2,F> endField) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orBetween(Fn<T,F> fn,
Object start,
Object end) |
GenericWhereCondition |
GenericWhereCondition.orCondition(Consumer<GenericWhereCondition> nestedCondition) |
GenericWhereCondition |
GenericWhereCondition.orEqualTo(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orEqualTo(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orEqualTo(Column column,
Column column2) |
GenericWhereCondition |
GenericWhereCondition.orEqualTo(Column column,
Object value) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.orEqualTo(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orEqualTo(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orEqualTo(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orEqualTo(Object value,
ColumFunction columFunction) |
GenericWhereCondition |
GenericWhereCondition.orExists(SelectDsl nestedSelect) |
GenericWhereCondition |
MysqlWhereCondition.orFindInSet(Column column,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orFindInSet(Column column,
Object value) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.orFindInSet(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orFindInSet(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.orFindInSet(Fn<T,F> fn,
Object item) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orFindInSet(Fn<T,F> fn,
Object item) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.orFindInSet(Fn<T,F> fn,
Object item,
String separator) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orFindInSet(Fn<T,F> fn,
Object item,
String separator) |
GenericWhereCondition |
GenericWhereCondition.orFunction(ColumFunction columFunction) |
GenericWhereCondition |
GenericWhereCondition.orGreaterThan(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orGreaterThan(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orGreaterThan(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orGreaterThan(Column column,
Column column2) |
GenericWhereCondition |
GenericWhereCondition.orGreaterThan(Column column,
Object value) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.orGreaterThan(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orGreaterThan(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orGreaterThan(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orGreaterThan(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orGreaterThanOrEqualTo(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orGreaterThanOrEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orGreaterThanOrEqualTo(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orGreaterThanOrEqualTo(Column column,
Column column2) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.orGreaterThanOrEqualTo(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orGreaterThanOrEqualTo(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orGreaterThanOrEqualTo(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orGreaterThanOrEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orIn(AggregateFunction function,
Iterable<?> values) |
GenericWhereCondition |
GenericWhereCondition.orIn(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orIn(ColumFunction columFunction,
Iterable<?> values) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orIn(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orIn(Fn<T,F> fn,
Iterable<?> values) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orIn(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orIsNotNull(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orIsNotNull(Column column) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orIsNotNull(Fn<T,F> fn) |
GenericWhereCondition |
GenericWhereCondition.orIsNull(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orIsNull(Column column) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orIsNull(Fn<T,F> fn) |
GenericWhereCondition |
GenericWhereCondition.orLessThan(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orLessThan(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orLessThan(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orLessThan(Column column,
Column column2) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.orLessThan(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orLessThan(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orLessThan(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orLessThan(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orLessThanOrEqualTo(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orLessThanOrEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orLessThanOrEqualTo(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orLessThanOrEqualTo(Column column,
Column column2) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.orLessThanOrEqualTo(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orLessThanOrEqualTo(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orLessThanOrEqualTo(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orLessThanOrEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orLike(Column column,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orLike(Fn<T,F> fn,
String pattern) |
GenericWhereCondition |
MysqlWhereCondition.orMatches(Column column,
String value) |
GenericWhereCondition |
GenericWhereCondition.orMatches(Column column,
String regex) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.orMatches(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
OracleWhereCondition.orMatches(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orMatches(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
MysqlWhereCondition.orMatches(Fn<T,F> fn,
String regex) |
<T,F> GenericWhereCondition |
OracleWhereCondition.orMatches(Fn<T,F> fn,
String regex) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orMatches(Fn<T,F> fn,
String regex) |
GenericWhereCondition |
GenericWhereCondition.orNotBetween(AggregateFunction function,
Object start,
Object end) |
GenericWhereCondition |
GenericWhereCondition.orNotBetween(Column column,
Object start,
Object end) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orNotBetween(Fn<T,F> fn,
Object start,
Object end) |
GenericWhereCondition |
GenericWhereCondition.orNotEqualTo(AggregateFunction function,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orNotEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orNotEqualTo(ColumFunction columFunction,
Object value) |
GenericWhereCondition |
GenericWhereCondition.orNotEqualTo(Column column,
Column column2) |
GenericWhereCondition |
GenericWhereCondition.orNotEqualTo(Column column,
Object value) |
<T1,T2,F> GenericWhereCondition |
GenericWhereCondition.orNotEqualTo(Fn<T1,F> field1,
Fn<T2,F> field2) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orNotEqualTo(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orNotEqualTo(Fn<T,F> fn,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orNotEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orNotExists(SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orNotIn(AggregateFunction function,
Iterable<?> values) |
GenericWhereCondition |
GenericWhereCondition.orNotIn(AggregateFunction function,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orNotIn(ColumFunction columFunction,
Iterable<?> values) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orNotIn(Fn<T,F> fn,
ColumFunction columFunction) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orNotIn(Fn<T,F> fn,
Iterable<?> values) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orNotIn(Fn<T,F> fn,
SelectDsl nestedSelect) |
GenericWhereCondition |
GenericWhereCondition.orNotLike(Column column,
Object value) |
<T,F> GenericWhereCondition |
GenericWhereCondition.orNotLike(Fn<T,F> fn,
String pattern) |
GenericWhereCondition |
GenericWhereCondition.sql(String sql) |
| 限定符和类型 | 方法和说明 |
|---|---|
GenericWhereCondition |
GenericWhereCondition.andCondition(Consumer<GenericWhereCondition> nestedCondition) |
GenericWhereCondition |
GenericWhereCondition.orCondition(Consumer<GenericWhereCondition> nestedCondition) |
| 限定符和类型 | 字段和说明 |
|---|---|
protected Consumer<GenericWhereCondition> |
ParseWhereHandler.condition |
| 限定符和类型 | 方法和说明 |
|---|---|
protected GenericWhereCondition |
ParseWhereHandler.applyGenericWhereCondition(SchemaProperties schemaProperties) |
| 构造器和说明 |
|---|
ParseWhereHandler(Consumer<GenericWhereCondition> condition) |
| 构造器和说明 |
|---|
EntitiesDeleter(Class<T> entityClass,
Consumer<GenericWhereCondition> condition) |
| 限定符和类型 | 方法和说明 |
|---|---|
default JoinCondition |
JoinCondition.fullJoin(boolean isEffective,
Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.fullJoin(boolean isEffective,
Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.fullJoin(boolean isEffective,
CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
JoinCondition |
JoinCondition.fullJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition)
构建一个 FULL JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.fullJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.fullJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 FULL JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.fullJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.fullJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
JoinCondition |
TableRelation.fullJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition) |
TableRelation<R> |
TableRelation.having(boolean isEffective,
Consumer<HavingCondition<GenericWhereCondition>> condition) |
TableRelation<R> |
TableRelation.having(Consumer<HavingCondition<GenericWhereCondition>> condition) |
default JoinCondition |
JoinCondition.innerJoin(boolean isEffective,
Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.innerJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition)
构建一个 INNER JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.innerJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.innerJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 INNER JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.innerJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.innerJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
JoinCondition |
TableRelation.innerJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.innerJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 INNER JOIN 连接,用于将当前查询与子查询结果关联。
|
JoinCondition |
TableRelation.innerJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.innerJoin(Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 INNER JOIN 连接,用于将当前查询与表函数的结果关联。
|
JoinCondition |
TableRelation.innerJoin(Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.innerJoinUnion(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 INNER JOIN UNION。
|
JoinCondition |
JoinCondition.innerJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN UNION 的核心实现。
|
JoinCondition |
TableRelation.innerJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.innerJoinUnionAll(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 INNER JOIN UNION ALL。
|
JoinCondition |
JoinCondition.innerJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN UNION ALL 的核心实现。
|
JoinCondition |
TableRelation.innerJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.join(boolean isEffective,
Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.join(boolean isEffective,
Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.join(boolean isEffective,
CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
default JoinCondition |
JoinCondition.join(boolean isEffective,
SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.join(boolean isEffective,
Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 JOIN:当 isEffective 为 true 时执行 JOIN,否则忽略该 JOIN。
|
default JoinCondition |
JoinCondition.join(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN 的别名方法。
|
default JoinCondition |
JoinCondition.join(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN 的别名方法,允许指定表别名。
|
default JoinCondition |
JoinCondition.join(CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
default JoinCondition |
JoinCondition.join(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition)
使用嵌套查询的 INNER JOIN 方法。
|
default JoinCondition |
JoinCondition.join(Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition)
使用表函数和条件进行 INNER JOIN。
|
default JoinCondition |
JoinCondition.joinUnion(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 INNER JOIN UNION。
|
default JoinCondition |
JoinCondition.joinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN UNION。
|
default JoinCondition |
JoinCondition.joinUnionAll(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 INNER JOIN UNION ALL。
|
default JoinCondition |
JoinCondition.joinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN UNION ALL。
|
default JoinCondition |
JoinCondition.leftJoin(boolean isEffective,
Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.leftJoin(boolean isEffective,
Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.leftJoin(boolean isEffective,
CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
default JoinCondition |
JoinCondition.leftJoin(boolean isEffective,
SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.leftJoin(boolean isEffective,
Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.leftJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition)
构建一个 LEFT JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.leftJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.leftJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 LEFT JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.leftJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.leftJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
JoinCondition |
TableRelation.leftJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.leftJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 LEFT JOIN 连接,用于将当前查询与子查询结果关联。
|
JoinCondition |
TableRelation.leftJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.leftJoin(Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 LEFT JOIN 连接,用于将当前查询与表函数的结果关联。
|
JoinCondition |
TableRelation.leftJoin(Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.leftJoinUnion(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 LEFT JOIN UNION。
|
JoinCondition |
JoinCondition.leftJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
LEFT JOIN UNION 的核心实现。
|
JoinCondition |
TableRelation.leftJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.leftJoinUnionAll(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 LEFT JOIN UNION ALL。
|
JoinCondition |
JoinCondition.leftJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
LEFT JOIN UNION ALL 的核心实现。
|
JoinCondition |
TableRelation.leftJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.rightJoin(boolean isEffective,
Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.rightJoin(boolean isEffective,
Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.rightJoin(boolean isEffective,
CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
default JoinCondition |
JoinCondition.rightJoin(boolean isEffective,
SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.rightJoin(boolean isEffective,
Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.rightJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition)
构建一个 RIGHT JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.rightJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.rightJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 RIGHT JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.rightJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.rightJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
JoinCondition |
TableRelation.rightJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.rightJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 RIGHT JOIN 连接,用于将当前查询与子查询结果关联。
|
JoinCondition |
TableRelation.rightJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.rightJoin(Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 RIGHT JOIN 连接,用于将当前查询与表函数的结果关联。
|
JoinCondition |
TableRelation.rightJoin(Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.rightJoinUnion(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 RIGHT JOIN UNION。
|
JoinCondition |
JoinCondition.rightJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
RIGHT JOIN UNION 的核心实现。
|
JoinCondition |
TableRelation.rightJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.rightJoinUnionAll(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 RIGHT JOIN UNION ALL。
|
JoinCondition |
JoinCondition.rightJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
RIGHT JOIN UNION ALL 的核心实现。
|
JoinCondition |
TableRelation.rightJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
TableRelation<?> |
JoinCondition.where(boolean isEffective,
Consumer<GenericWhereCondition> condition) |
TableRelation<R> |
TableRelation.where(boolean isEffective,
Consumer<GenericWhereCondition> condition) |
TableRelation<?> |
JoinCondition.where(Consumer<GenericWhereCondition> condition)
追加 WHERE 条件。
|
TableRelation<R> |
TableRelation.where(Consumer<GenericWhereCondition> condition) |
| 限定符和类型 | 方法和说明 |
|---|---|
Consumer<HavingCondition<GenericWhereCondition>> |
SelectSpecification.getHavingCondition() |
Consumer<GenericWhereCondition> |
SelectSpecification.getWhereCondition() |
| 限定符和类型 | 方法和说明 |
|---|---|
void |
SelectSpecification.setHavingCondition(Consumer<HavingCondition<GenericWhereCondition>> havingCondition) |
void |
SelectSpecification.setWhereCondition(Consumer<GenericWhereCondition> whereCondition) |
| 限定符和类型 | 方法和说明 |
|---|---|
Consumer<GenericWhereCondition> |
SelfJoin.getOnCondition() |
Consumer<GenericWhereCondition> |
TableFunctionJoin.getOnCondition() |
Consumer<GenericWhereCondition> |
LeftJoin.getOnCondition() |
Consumer<GenericWhereCondition> |
CrossJoin.getOnCondition() |
Consumer<GenericWhereCondition> |
RightJoin.getOnCondition() |
abstract Consumer<GenericWhereCondition> |
JoinTable.getOnCondition() |
Consumer<GenericWhereCondition> |
FromJoin.getOnCondition() |
Consumer<GenericWhereCondition> |
InnerJoin.getOnCondition() |
Consumer<GenericWhereCondition> |
UnionJoin.getOnCondition() |
Consumer<GenericWhereCondition> |
NestedJoin.getOnCondition() |
Consumer<GenericWhereCondition> |
FullJoin.getOnCondition() |
| 构造器和说明 |
|---|
EntitiesUpdater(Collection<Object> entities,
Fn<?,?>[] forcedFields,
Consumer<GenericWhereCondition> condition) |
| 限定符和类型 | 方法和说明 |
|---|---|
static <T extends GenericWhereCondition> |
SqlUtils.matchDialectCondition(SqlDialect sqlDialect,
Version version,
Map<String,TableAliasMapping> aliasTableMap,
String dataSourceName) |
Copyright © 2024–2026 Dynamic-SQL. All rights reserved.