SqlBuilder (MyBatis Dynamic SQL 1.0.0 API)

```
public interface SqlBuilder
```

Method Summary

All Methods Static Methods Default Methods
Modifier and Type	Method and Description
`static <T extends Number> Add<T>`	`add(BindableColumn<T> column1, BindableColumn<T> column2)`
`static JoinCriterion`	`and(BasicColumn joinColumn, JoinCondition joinCondition)`
`static <T> SqlCriterion<T>`	`and(BindableColumn<T> column, VisitableCondition<T> condition)`
`static <T> SqlCriterion<T>`	`and(BindableColumn<T> column, VisitableCondition<T> condition, SqlCriterion<?>... subCriteria)`
`static Avg`	`avg(BasicColumn column)`
`static CountAll`	`count()`
`static Count`	`count(BasicColumn column)`
`static DeleteDSL<DeleteModel>`	`deleteFrom(SqlTable table)`
`static EqualTo`	`equalTo(BasicColumn column)`
`static <T> BatchInsertDSL.IntoGatherer<T>`	`insert(List<T> records)`
`static <T> BatchInsertDSL.IntoGatherer<T>`	`insert(T... records)`
`static <T> InsertDSL.IntoGatherer<T>`	`insert(T record)`
`static InsertSelectDSL.InsertColumnGatherer`	`insertInto(SqlTable table)`
`static <T> IsBetween.Builder<T>`	`isBetween(Supplier<T> valueSupplier1)`
`static <T> IsBetween.Builder<T>`	`isBetween(T value1)`
`static <T> IsEqualToWithSubselect<T>`	`isEqualTo(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsEqualTo<T>`	`isEqualTo(Supplier<T> valueSupplier)`
`static <T> IsEqualTo<T>`	`isEqualTo(T value)`
`static <T> IsGreaterThanWithSubselect<T>`	`isGreaterThan(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsGreaterThan<T>`	`isGreaterThan(Supplier<T> valueSupplier)`
`static <T> IsGreaterThan<T>`	`isGreaterThan(T value)`
`static <T> IsGreaterThanOrEqualToWithSubselect<T>`	`isGreaterThanOrEqualTo(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsGreaterThanOrEqualTo<T>`	`isGreaterThanOrEqualTo(Supplier<T> valueSupplier)`
`static <T> IsGreaterThanOrEqualTo<T>`	`isGreaterThanOrEqualTo(T value)`
`static <T> IsInWithSubselect<T>`	`isIn(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsIn<T>`	`isIn(List<T> values)`
`static <T> IsIn<T>`	`isIn(T... values)`
`static IsInCaseInsensitive`	`isInCaseInsensitive(String... values)`
`static <T> IsLessThanWithSubselect<T>`	`isLessThan(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsLessThan<T>`	`isLessThan(Supplier<T> valueSupplier)`
`static <T> IsLessThan<T>`	`isLessThan(T value)`
`static <T> IsLessThanOrEqualToWithSubselect<T>`	`isLessThanOrEqualTo(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsLessThanOrEqualTo<T>`	`isLessThanOrEqualTo(Supplier<T> valueSupplier)`
`static <T> IsLessThanOrEqualTo<T>`	`isLessThanOrEqualTo(T value)`
`static IsLike`	`isLike(String value)`
`static IsLike`	`isLike(Supplier<String> valueSupplier)`
`static IsLikeCaseInsensitive`	`isLikeCaseInsensitive(String value)`
`static IsLikeCaseInsensitive`	`isLikeCaseInsensitive(Supplier<String> valueSupplier)`
`static <T> IsNotBetween.Builder<T>`	`isNotBetween(Supplier<T> valueSupplier1)`
`static <T> IsNotBetween.Builder<T>`	`isNotBetween(T value1)`
`static <T> IsNotEqualToWithSubselect<T>`	`isNotEqualTo(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsNotEqualTo<T>`	`isNotEqualTo(Supplier<T> valueSupplier)`
`static <T> IsNotEqualTo<T>`	`isNotEqualTo(T value)`
`static <T> IsNotInWithSubselect<T>`	`isNotIn(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsNotIn<T>`	`isNotIn(List<T> values)`
`static <T> IsNotIn<T>`	`isNotIn(T... values)`
`static IsNotInCaseInsensitive`	`isNotInCaseInsensitive(String... values)`
`static IsNotLike`	`isNotLike(String value)`
`static IsNotLike`	`isNotLike(Supplier<String> valueSupplier)`
`static IsNotLikeCaseInsensitive`	`isNotLikeCaseInsensitive(String value)`
`static IsNotLikeCaseInsensitive`	`isNotLikeCaseInsensitive(Supplier<String> valueSupplier)`
`static <T> IsNotNull<T>`	`isNotNull()`
`static <T> IsNull<T>`	`isNull()`
`static Lower`	`lower(BindableColumn<String> column)`
`static Max`	`max(BasicColumn column)`
`static Min`	`min(BasicColumn column)`
`static <T> SqlCriterion<T>`	`or(BindableColumn<T> column, VisitableCondition<T> condition)`
`static <T> SqlCriterion<T>`	`or(BindableColumn<T> column, VisitableCondition<T> condition, SqlCriterion<?>... subCriteria)`
`static QueryExpressionDSL.FromGatherer<SelectModel>`	`select(BasicColumn... selectList)`
`static QueryExpressionDSL.FromGatherer<SelectModel>`	`selectDistinct(BasicColumn... selectList)`
`static SortSpecification`	`sortColumn(String name)`
`static Substring`	`substring(BindableColumn<String> column, int offset, int length)`
`static Sum`	`sum(BasicColumn column)`
`static UpdateDSL<UpdateModel>`	`update(SqlTable table)`
`static Upper`	`upper(BindableColumn<String> column)`
`static <T> WhereDSL`	`where(BindableColumn<T> column, VisitableCondition<T> condition)`
`static <T> WhereDSL`	`where(BindableColumn<T> column, VisitableCondition<T> condition, SqlCriterion<?>... subCriteria)`

Method Detail

deleteFrom

static DeleteDSL<DeleteModel> deleteFrom(SqlTable table)

insert

static <T> InsertDSL.IntoGatherer<T> insert(T record)

insert

@SafeVarargs
static <T> BatchInsertDSL.IntoGatherer<T> insert(T... records)

insert

static <T> BatchInsertDSL.IntoGatherer<T> insert(List<T> records)

insertInto

static InsertSelectDSL.InsertColumnGatherer insertInto(SqlTable table)

select

static QueryExpressionDSL.FromGatherer<SelectModel> select(BasicColumn... selectList)

selectDistinct

static QueryExpressionDSL.FromGatherer<SelectModel> selectDistinct(BasicColumn... selectList)

update

static UpdateDSL<UpdateModel> update(SqlTable table)

where

static <T> WhereDSL where(BindableColumn<T> column,
                          VisitableCondition<T> condition)

where

static <T> WhereDSL where(BindableColumn<T> column,
                          VisitableCondition<T> condition,
                          SqlCriterion<?>... subCriteria)

or

static <T> SqlCriterion<T> or(BindableColumn<T> column,
                              VisitableCondition<T> condition)

or

static <T> SqlCriterion<T> or(BindableColumn<T> column,
                              VisitableCondition<T> condition,
                              SqlCriterion<?>... subCriteria)

and

static <T> SqlCriterion<T> and(BindableColumn<T> column,
                               VisitableCondition<T> condition)

and

static <T> SqlCriterion<T> and(BindableColumn<T> column,
                               VisitableCondition<T> condition,
                               SqlCriterion<?>... subCriteria)

and

static JoinCriterion and(BasicColumn joinColumn,
                         JoinCondition joinCondition)

equalTo

static EqualTo equalTo(BasicColumn column)

count
```
static CountAll count()
```

count

static Count count(BasicColumn column)

max
```
static Max max(BasicColumn column)
```

min
```
static Min min(BasicColumn column)
```

avg
```
static Avg avg(BasicColumn column)
```

sum
```
static Sum sum(BasicColumn column)
```

add

static <T extends Number> Add<T> add(BindableColumn<T> column1,
                                     BindableColumn<T> column2)

lower

static Lower lower(BindableColumn<String> column)

substring

static Substring substring(BindableColumn<String> column,
                           int offset,
                           int length)

upper

static Upper upper(BindableColumn<String> column)

isNull
```
static <T> IsNull<T> isNull()
```

isNotNull
```
static <T> IsNotNull<T> isNotNull()
```

isEqualTo

static <T> IsEqualTo<T> isEqualTo(T value)

isEqualTo

static <T> IsEqualTo<T> isEqualTo(Supplier<T> valueSupplier)

isEqualTo

static <T> IsEqualToWithSubselect<T> isEqualTo(Buildable<SelectModel> selectModelBuilder)

isNotEqualTo

static <T> IsNotEqualTo<T> isNotEqualTo(T value)

isNotEqualTo

static <T> IsNotEqualTo<T> isNotEqualTo(Supplier<T> valueSupplier)

isNotEqualTo

static <T> IsNotEqualToWithSubselect<T> isNotEqualTo(Buildable<SelectModel> selectModelBuilder)

isGreaterThan

static <T> IsGreaterThan<T> isGreaterThan(T value)

isGreaterThan

static <T> IsGreaterThan<T> isGreaterThan(Supplier<T> valueSupplier)

isGreaterThan

static <T> IsGreaterThanWithSubselect<T> isGreaterThan(Buildable<SelectModel> selectModelBuilder)

isGreaterThanOrEqualTo

static <T> IsGreaterThanOrEqualTo<T> isGreaterThanOrEqualTo(T value)

isGreaterThanOrEqualTo

static <T> IsGreaterThanOrEqualTo<T> isGreaterThanOrEqualTo(Supplier<T> valueSupplier)

isGreaterThanOrEqualTo

static <T> IsGreaterThanOrEqualToWithSubselect<T> isGreaterThanOrEqualTo(Buildable<SelectModel> selectModelBuilder)

isLessThan

static <T> IsLessThan<T> isLessThan(T value)

isLessThan

static <T> IsLessThan<T> isLessThan(Supplier<T> valueSupplier)

isLessThan

static <T> IsLessThanWithSubselect<T> isLessThan(Buildable<SelectModel> selectModelBuilder)

isLessThanOrEqualTo

static <T> IsLessThanOrEqualTo<T> isLessThanOrEqualTo(T value)

isLessThanOrEqualTo

static <T> IsLessThanOrEqualTo<T> isLessThanOrEqualTo(Supplier<T> valueSupplier)

isLessThanOrEqualTo

static <T> IsLessThanOrEqualToWithSubselect<T> isLessThanOrEqualTo(Buildable<SelectModel> selectModelBuilder)

isIn

@SafeVarargs
static <T> IsIn<T> isIn(T... values)

isIn

static <T> IsIn<T> isIn(List<T> values)

isIn

static <T> IsInWithSubselect<T> isIn(Buildable<SelectModel> selectModelBuilder)

isNotIn

@SafeVarargs
static <T> IsNotIn<T> isNotIn(T... values)

isNotIn

static <T> IsNotIn<T> isNotIn(List<T> values)

isNotIn

static <T> IsNotInWithSubselect<T> isNotIn(Buildable<SelectModel> selectModelBuilder)

isBetween

static <T> IsBetween.Builder<T> isBetween(T value1)

isBetween

static <T> IsBetween.Builder<T> isBetween(Supplier<T> valueSupplier1)

isNotBetween

static <T> IsNotBetween.Builder<T> isNotBetween(T value1)

isNotBetween

static <T> IsNotBetween.Builder<T> isNotBetween(Supplier<T> valueSupplier1)

isLike
```
static IsLike isLike(String value)
```

isLike

static IsLike isLike(Supplier<String> valueSupplier)

isLikeCaseInsensitive

static IsLikeCaseInsensitive isLikeCaseInsensitive(String value)

isLikeCaseInsensitive

static IsLikeCaseInsensitive isLikeCaseInsensitive(Supplier<String> valueSupplier)

isNotLike

static IsNotLike isNotLike(String value)

isNotLike

static IsNotLike isNotLike(Supplier<String> valueSupplier)

isNotLikeCaseInsensitive

static IsNotLikeCaseInsensitive isNotLikeCaseInsensitive(String value)

isNotLikeCaseInsensitive

static IsNotLikeCaseInsensitive isNotLikeCaseInsensitive(Supplier<String> valueSupplier)

isInCaseInsensitive

static IsInCaseInsensitive isInCaseInsensitive(String... values)

isNotInCaseInsensitive

static IsNotInCaseInsensitive isNotInCaseInsensitive(String... values)

sortColumn

static SortSpecification sortColumn(String name)

Interface SqlBuilder

Method Summary

Method Detail

deleteFrom

insert

insert

insert

insertInto

select

selectDistinct

update

where

where

or

or

and

and

and

equalTo

count

count

max

min

avg

sum

add

lower

substring

upper

isNull

isNotNull

isEqualTo

isEqualTo

isEqualTo

isNotEqualTo

isNotEqualTo

isNotEqualTo

isGreaterThan

isGreaterThan

isGreaterThan

isGreaterThanOrEqualTo

isGreaterThanOrEqualTo

isGreaterThanOrEqualTo

isLessThan

isLessThan

isLessThan

isLessThanOrEqualTo

isLessThanOrEqualTo

isLessThanOrEqualTo

isIn

isIn

isIn

isNotIn

isNotIn

isNotIn

isBetween

isBetween

isNotBetween

isNotBetween

isLike

isLike

isLikeCaseInsensitive

isLikeCaseInsensitive

isNotLike

isNotLike

isNotLikeCaseInsensitive

isNotLikeCaseInsensitive

isInCaseInsensitive

isNotInCaseInsensitive

sortColumn