MysqlWhereCondition (dynamic-sql2 0.0.4 API)

java.lang.Object
- com.dynamic.sql.core.condition.WhereCondition
- - com.dynamic.sql.core.condition.impl.dialect.GenericWhereCondition
  - - com.dynamic.sql.core.condition.impl.dialect.MysqlWhereCondition

All Implemented Interfaces:

Condition, FunctionCondition, NestedCondition, HavingCondition
```
public class MysqlWhereCondition
extends GenericWhereCondition
```

Field Summary
- Fields inherited from class com.dynamic.sql.core.condition.impl.dialect.GenericWhereCondition
  aliasTableMap, condition, dataSourceName, isFirstBuild, parameterBinder, version

Constructor Summary

Constructors
Constructor and Description

MysqlWhereCondition(Version version, Map<String,String> aliasTableMap, String dataSourceName)

Constructors
Constructor and Description
`MysqlWhereCondition(Version version, Map<String,String> aliasTableMap, String dataSourceName)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`<T,F> FunctionCondition`	`andFindInSet(Fn<T,F> fn, ColumFunction columFunction)`
`<T,F> Condition`	`andFindInSet(Fn<T,F> fn, Object item)` 添加字段在指定集合中条件，并且运算（使用 FIND_IN_SET 函数）。
`<T,F> Condition`	`andFindInSet(Fn<T,F> fn, Object item, String separator)` 添加字段在指定集合中条件，并且运算（使用 FIND_IN_SET 函数），并指定分隔符。
`<T,F> FunctionCondition`	`andMatches(Fn<T,F> fn, ColumFunction columFunction)`
`<T,F> Condition`	`andMatches(Fn<T,F> fn, String regex)` 添加字段匹配正则表达式条件，并且运算。
`Condition`	`limit(int limit)` 限制查询结果的返回行数
`Condition`	`limit(int offset, int limit)` 限制查询结果的返回行数
`<T,F> Condition`	`matches(LogicalOperatorType logicalOperatorType, Fn<T,F> fn, String regex)`
`<T,F> FunctionCondition`	`matchesFunction(LogicalOperatorType logicalOperatorType, Fn<T,F> fn, ColumFunction columFunction)`
`<T,F> FunctionCondition`	`orFindInSet(Fn<T,F> fn, ColumFunction columFunction)`
`<T,F> Condition`	`orFindInSet(Fn<T,F> fn, Object item)` 添加字段在指定集合中条件，或运算（使用 FIND_IN_SET 函数）。
`<T,F> Condition`	`orFindInSet(Fn<T,F> fn, Object item, String separator)` 添加字段在指定集合中条件，或运算（使用 FIND_IN_SET 函数），并指定分隔符。
`<T,F> FunctionCondition`	`orMatches(Fn<T,F> fn, ColumFunction columFunction)`
`<T,F> Condition`	`orMatches(Fn<T,F> fn, String regex)` 添加字段匹配正则表达式条件，或运算。
`protected SqlDialect`	`sqlDialect()`

Methods inherited from class com.dynamic.sql.core.condition.impl.dialect.GenericWhereCondition
andBetween, andBetween, andBetween, andCondition, andEqualTo, andEqualTo, andEqualTo, andEqualTo, andEqualTo, andEqualTo, andEqualTo, andEqualTo, andExists, andGreaterThan, andGreaterThan, andGreaterThan, andGreaterThan, andGreaterThan, andGreaterThan, andGreaterThanOrEqualTo, andGreaterThanOrEqualTo, andGreaterThanOrEqualTo, andGreaterThanOrEqualTo, andGreaterThanOrEqualTo, andGreaterThanOrEqualTo, andIn, andIn, andIn, andIn, andIn, andIn, andIsNotNull, andIsNull, andLessThan, andLessThan, andLessThan, andLessThan, andLessThan, andLessThan, andLessThanOrEqualTo, andLessThanOrEqualTo, andLessThanOrEqualTo, andLessThanOrEqualTo, andLessThanOrEqualTo, andLessThanOrEqualTo, andLike, andNotBetween, andNotBetween, andNotEqualTo, andNotEqualTo, andNotEqualTo, andNotEqualTo, andNotEqualTo, andNotEqualTo, andNotExists, andNotIn, andNotIn, andNotIn, andNotIn, andNotIn, andNotLike, executeFunctionToString, getParameterBinder, getWhereConditionSyntax, logicalOperatorType, logicalOperatorType, orBetween, orBetween, orBetween, orCondition, orEqualTo, orEqualTo, orEqualTo, orEqualTo, orEqualTo, orEqualTo, orEqualTo, orExists, orGreaterThan, orGreaterThan, orGreaterThan, orGreaterThan, orGreaterThan, orGreaterThan, orGreaterThanOrEqualTo, orGreaterThanOrEqualTo, orGreaterThanOrEqualTo, orGreaterThanOrEqualTo, orGreaterThanOrEqualTo, orGreaterThanOrEqualTo, orIn, orIn, orIn, orIn, orIn, orIsNotNull, orIsNull, orLessThan, orLessThan, orLessThan, orLessThan, orLessThan, orLessThan, orLessThanOrEqualTo, orLessThanOrEqualTo, orLessThanOrEqualTo, orLessThanOrEqualTo, orLessThanOrEqualTo, orLessThanOrEqualTo, orLike, orNotBetween, orNotBetween, orNotEqualTo, orNotEqualTo, orNotEqualTo, orNotEqualTo, orNotEqualTo, orNotEqualTo, orNotExists, orNotIn, orNotIn, orNotIn, orNotIn, orNotIn, orNotLike

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - MysqlWhereCondition
```
public MysqlWhereCondition(Version version,
                           Map<String,String> aliasTableMap,
                           String dataSourceName)
```
- Method Detail
  - sqlDialect
```
protected SqlDialect sqlDialect()
```
    Overrides:
    
    sqlDialect in class GenericWhereCondition
  - andMatches
```
public <T,F> Condition andMatches(Fn<T,F> fn,
                                  String regex)
```
    Description copied from interface: Condition
    
    添加字段匹配正则表达式条件，并且运算。
    
    Specified by:
    
    andMatches in interface Condition
    
    Overrides:
    
    andMatches in class GenericWhereCondition
    
    Type Parameters:
    
    T - 实体类类型
    
    F - 字段类型
    
    Parameters:
    
    fn - 用于获取字段值的函数
    
    regex - 正则表达式模式
    
    Returns:
    
    当前 Condition 实例
  - orMatches
```
public <T,F> Condition orMatches(Fn<T,F> fn,
                                 String regex)
```
    Description copied from interface: Condition
    
    添加字段匹配正则表达式条件，或运算。
    
    Specified by:
    
    orMatches in interface Condition
    
    Overrides:
    
    orMatches in class GenericWhereCondition
    
    Type Parameters:
    
    T - 实体类类型
    
    F - 字段类型
    
    Parameters:
    
    fn - 用于获取字段值的函数
    
    regex - 正则表达式模式
    
    Returns:
    
    当前 Condition 实例
  - matches
```
public <T,F> Condition matches(LogicalOperatorType logicalOperatorType,
                               Fn<T,F> fn,
                               String regex)
```
  - andMatches
```
public <T,F> FunctionCondition andMatches(Fn<T,F> fn,
                                          ColumFunction columFunction)
```
    Specified by:
    
    andMatches in interface FunctionCondition
    
    Overrides:
    
    andMatches in class GenericWhereCondition
  - orMatches
```
public <T,F> FunctionCondition orMatches(Fn<T,F> fn,
                                         ColumFunction columFunction)
```
    Specified by:
    
    orMatches in interface FunctionCondition
    
    Overrides:
    
    orMatches in class GenericWhereCondition
  - matchesFunction
```
public <T,F> FunctionCondition matchesFunction(LogicalOperatorType logicalOperatorType,
                                               Fn<T,F> fn,
                                               ColumFunction columFunction)
```
  - andFindInSet
```
public <T,F> Condition andFindInSet(Fn<T,F> fn,
                                    Object item)
```
    Description copied from interface: Condition
    
    添加字段在指定集合中条件，并且运算（使用 FIND_IN_SET 函数）。
    
    Specified by:
    
    andFindInSet in interface Condition
    
    Overrides:
    
    andFindInSet in class GenericWhereCondition
    
    Type Parameters:
    
    T - 实体类类型
    
    F - 字段类型
    
    Parameters:
    
    fn - 用于获取字段值的函数
    
    item - 指定的项目
    
    Returns:
    
    当前 Condition 实例
  - andFindInSet
```
public <T,F> Condition andFindInSet(Fn<T,F> fn,
                                    Object item,
                                    String separator)
```
    Description copied from interface: Condition
    
    添加字段在指定集合中条件，并且运算（使用 FIND_IN_SET 函数），并指定分隔符。
    
    Specified by:
    
    andFindInSet in interface Condition
    
    Overrides:
    
    andFindInSet in class GenericWhereCondition
    
    Type Parameters:
    
    T - 实体类类型
    
    F - 字段类型
    
    Parameters:
    
    fn - 用于获取字段值的函数
    
    item - 指定的项目
    
    separator - 分隔符
    
    Returns:
    
    当前 Condition 实例
  - orFindInSet
```
public <T,F> Condition orFindInSet(Fn<T,F> fn,
                                   Object item)
```
    Description copied from interface: Condition
    
    添加字段在指定集合中条件，或运算（使用 FIND_IN_SET 函数）。
    
    Specified by:
    
    orFindInSet in interface Condition
    
    Overrides:
    
    orFindInSet in class GenericWhereCondition
    
    Type Parameters:
    
    T - 实体类类型
    
    F - 字段类型
    
    Parameters:
    
    fn - 用于获取字段值的函数
    
    item - 指定的项目
    
    Returns:
    
    当前 Condition 实例
  - orFindInSet
```
public <T,F> Condition orFindInSet(Fn<T,F> fn,
                                   Object item,
                                   String separator)
```
    Description copied from interface: Condition
    
    添加字段在指定集合中条件，或运算（使用 FIND_IN_SET 函数），并指定分隔符。
    
    Specified by:
    
    orFindInSet in interface Condition
    
    Overrides:
    
    orFindInSet in class GenericWhereCondition
    
    Type Parameters:
    
    T - 实体类类型
    
    F - 字段类型
    
    Parameters:
    
    fn - 用于获取字段值的函数
    
    item - 指定的项目
    
    separator - 分隔符
    
    Returns:
    
    当前 Condition 实例
  - andFindInSet
```
public <T,F> FunctionCondition andFindInSet(Fn<T,F> fn,
                                            ColumFunction columFunction)
```
    Specified by:
    
    andFindInSet in interface FunctionCondition
    
    Overrides:
    
    andFindInSet in class GenericWhereCondition
  - orFindInSet
```
public <T,F> FunctionCondition orFindInSet(Fn<T,F> fn,
                                           ColumFunction columFunction)
```
    Specified by:
    
    orFindInSet in interface FunctionCondition
    
    Overrides:
    
    orFindInSet in class GenericWhereCondition
  - limit
```
public Condition limit(int limit)
```
    Description copied from interface: Condition
    
    限制查询结果的返回行数
    
    Specified by:
    
    limit in interface Condition
    
    Overrides:
    
    limit in class GenericWhereCondition
    
    Parameters:
    
    limit - 返回的最大行数
    
    Returns:
    
    当前 Condition 实例
  - limit
```
public Condition limit(int offset,
                       int limit)
```
    Description copied from interface: Condition
    
    限制查询结果的返回行数
    
    Specified by:
    
    limit in interface Condition
    
    Overrides:
    
    limit in class GenericWhereCondition
    
    Parameters:
    
    offset - 需要跳过的行数
    
    limit - 返回的最大行数
    
    Returns:
    
    当前 Condition 实例

Class MysqlWhereCondition

Field Summary

Fields inherited from class com.dynamic.sql.core.condition.impl.dialect.GenericWhereCondition

Constructor Summary

Method Summary

Methods inherited from class com.dynamic.sql.core.condition.impl.dialect.GenericWhereCondition

Methods inherited from class java.lang.Object

Constructor Detail

MysqlWhereCondition

Method Detail

sqlDialect

andMatches

orMatches

matches

andMatches

orMatches

matchesFunction

andFindInSet

andFindInSet

orFindInSet

orFindInSet

andFindInSet

orFindInSet

limit

limit