java.lang.Object

org.apache.ibatis.jdbc.AbstractSQL<T>

Direct Known Subclasses:: SQL

public abstract class AbstractSQL<T> extends Object

Author:: Clinton Begin, Jeff Butler, Adam Gent, Kazuki Shimizu

Nested Class Summary

Nested Classes

Modifier and Type

Class

Description

static interface

AbstractSQL.ForEachConsumer<T,E>

Consumer for 'forEach' operation.
Constructor Summary

Constructors

Constructor

Description

AbstractSQL()
Method Summary

Modifier and Type

Method

Description

T

ADD_ROW()

used to add a new inserted row while do multi-row insert.

T

AND()

<E> T

applyForEach(Iterable<E> iterable, AbstractSQL.ForEachConsumer<T,E> forEachSqlConsumer)

Apply sql phrases that provide by SQL consumer for iterable.

T

applyIf(boolean applyCondition, Consumer<T> sqlConsumer)

Apply sql phrases that provide by SQL consumer if condition is matches.

T

applyIf(BooleanSupplier applyConditionSupplier, Consumer<T> sqlConsumer)

Apply sql phrases that provide by SQL consumer if condition is matches.

T

DELETE_FROM(String table)

T

FETCH_FIRST_ROWS_ONLY(int value)

Set the fetch first rows value.

T

FETCH_FIRST_ROWS_ONLY(String variable)

Set the fetch first rows variable string(e.g.

T

FROM(String table)

T

FROM(String... tables)

From.

abstract T

getSelf()

T

GROUP_BY(String columns)

T

GROUP_BY(String... columns)

Group by.

T

HAVING(String conditions)

T

HAVING(String... conditions)

Having.

T

INNER_JOIN(String join)

T

INNER_JOIN(String... joins)

Inner join.

T

INSERT_INTO(String tableName)

T

INTO_COLUMNS(String... columns)

Into columns.

T

INTO_VALUES(String... values)

Into values.

T

JOIN(String join)

T

JOIN(String... joins)

Join.

T

LEFT_OUTER_JOIN(String join)

T

LEFT_OUTER_JOIN(String... joins)

Left outer join.

T

LIMIT(int value)

Set the limit value.

T

LIMIT(String variable)

Set the limit variable string(e.g.

T

OFFSET(long value)

Set the offset value.

T

OFFSET(String variable)

Set the offset variable string(e.g.

T

OFFSET_ROWS(long value)

Set the offset rows value.

T

OFFSET_ROWS(String variable)

Set the offset rows variable string(e.g.

T

OR()

T

ORDER_BY(String columns)

T

ORDER_BY(String... columns)

Order by.

T

OUTER_JOIN(String join)

T

OUTER_JOIN(String... joins)

Outer join.

T

RIGHT_OUTER_JOIN(String join)

T

RIGHT_OUTER_JOIN(String... joins)

Right outer join.

T

SELECT(String columns)

T

SELECT(String... columns)

Select.

T

SELECT_DISTINCT(String columns)

T

SELECT_DISTINCT(String... columns)

Select distinct.

T

SET(String sets)

T

SET(String... sets)

Sets the.

String

toString()

T

UPDATE(String table)

<A extends Appendable> A

usingAppender(A a)

T

VALUES(String columns, String values)

T

WHERE(String conditions)

T

WHERE(String... conditions)

Where.

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

Constructor Details
- AbstractSQL
  
  public AbstractSQL()
Method Details
- getSelf
  
  public abstract T getSelf()
- UPDATE
  
  public T UPDATE(String table)
- SET
  
  public T SET(String sets)
- SET
  
  public T SET(String... sets)
  
  Sets the.
  
  Parameters:
  
  sets - the sets
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- INSERT_INTO
  
  public T INSERT_INTO(String tableName)
- VALUES
  
  public T VALUES(String columns, String values)
- INTO_COLUMNS
  
  public T INTO_COLUMNS(String... columns)
  
  Into columns.
  
  Parameters:
  
  columns - the columns
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- INTO_VALUES
  
  public T INTO_VALUES(String... values)
  
  Into values.
  
  Parameters:
  
  values - the values
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- SELECT
  
  public T SELECT(String columns)
- SELECT
  
  public T SELECT(String... columns)
  
  Select.
  
  Parameters:
  
  columns - the columns
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- SELECT_DISTINCT
  
  public T SELECT_DISTINCT(String columns)
- SELECT_DISTINCT
  
  public T SELECT_DISTINCT(String... columns)
  
  Select distinct.
  
  Parameters:
  
  columns - the columns
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- DELETE_FROM
  
  public T DELETE_FROM(String table)
- FROM
  
  public T FROM(String table)
- FROM
  
  public T FROM(String... tables)
  
  From.
  
  Parameters:
  
  tables - the tables
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- JOIN
  
  public T JOIN(String join)
- JOIN
  
  public T JOIN(String... joins)
  
  Join.
  
  Parameters:
  
  joins - the joins
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- INNER_JOIN
  
  public T INNER_JOIN(String join)
- INNER_JOIN
  
  public T INNER_JOIN(String... joins)
  
  Inner join.
  
  Parameters:
  
  joins - the joins
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- LEFT_OUTER_JOIN
  
  public T LEFT_OUTER_JOIN(String join)
- LEFT_OUTER_JOIN
  
  public T LEFT_OUTER_JOIN(String... joins)
  
  Left outer join.
  
  Parameters:
  
  joins - the joins
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- RIGHT_OUTER_JOIN
  
  public T RIGHT_OUTER_JOIN(String join)
- RIGHT_OUTER_JOIN
  
  public T RIGHT_OUTER_JOIN(String... joins)
  
  Right outer join.
  
  Parameters:
  
  joins - the joins
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- OUTER_JOIN
  
  public T OUTER_JOIN(String join)
- OUTER_JOIN
  
  public T OUTER_JOIN(String... joins)
  
  Outer join.
  
  Parameters:
  
  joins - the joins
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- WHERE
  
  public T WHERE(String conditions)
- WHERE
  
  public T WHERE(String... conditions)
  
  Where.
  
  Parameters:
  
  conditions - the conditions
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- OR
  
  public T OR()
- AND
  
  public T AND()
- GROUP_BY
  
  public T GROUP_BY(String columns)
- GROUP_BY
  
  public T GROUP_BY(String... columns)
  
  Group by.
  
  Parameters:
  
  columns - the columns
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- HAVING
  
  public T HAVING(String conditions)
- HAVING
  
  public T HAVING(String... conditions)
  
  Having.
  
  Parameters:
  
  conditions - the conditions
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- ORDER_BY
  
  public T ORDER_BY(String columns)
- ORDER_BY
  
  public T ORDER_BY(String... columns)
  
  Order by.
  
  Parameters:
  
  columns - the columns
  
  Returns:
  
  the t
  
  Since:
  
  3.4.2
- LIMIT
  
  public T LIMIT(String variable)
  
  Set the limit variable string(e.g. "#{limit}").
  Parameters:
  
  variable - a limit variable string
  
  Returns:
  
  a self instance
  
  Since:
  
  3.5.2
  
  See Also:
  
  OFFSET(String)
- LIMIT
  
  public T LIMIT(int value)
  
  Set the limit value.
  Parameters:
  
  value - an offset value
  
  Returns:
  
  a self instance
  
  Since:
  
  3.5.2
  
  See Also:
  
  OFFSET(long)
- OFFSET
  
  public T OFFSET(String variable)
  
  Set the offset variable string(e.g. "#{offset}").
  Parameters:
  
  variable - a offset variable string
  
  Returns:
  
  a self instance
  
  Since:
  
  3.5.2
  
  See Also:
  
  LIMIT(String)
- OFFSET
  
  public T OFFSET(long value)
  
  Set the offset value.
  Parameters:
  
  value - an offset value
  
  Returns:
  
  a self instance
  
  Since:
  
  3.5.2
  
  See Also:
  
  LIMIT(int)
- FETCH_FIRST_ROWS_ONLY
  
  public T FETCH_FIRST_ROWS_ONLY(String variable)
  
  Set the fetch first rows variable string(e.g. "#{fetchFirstRows}").
  Parameters:
  
  variable - a fetch first rows variable string
  
  Returns:
  
  a self instance
  
  Since:
  
  3.5.2
  
  See Also:
  
  OFFSET_ROWS(String)
- FETCH_FIRST_ROWS_ONLY
  
  public T FETCH_FIRST_ROWS_ONLY(int value)
  
  Set the fetch first rows value.
  Parameters:
  
  value - a fetch first rows value
  
  Returns:
  
  a self instance
  
  Since:
  
  3.5.2
  
  See Also:
  
  OFFSET_ROWS(long)
- OFFSET_ROWS
  
  public T OFFSET_ROWS(String variable)
  
  Set the offset rows variable string(e.g. "#{offset}").
  Parameters:
  
  variable - a offset rows variable string
  
  Returns:
  
  a self instance
  
  Since:
  
  3.5.2
  
  See Also:
  
  FETCH_FIRST_ROWS_ONLY(String)
- OFFSET_ROWS
  
  public T OFFSET_ROWS(long value)
  
  Set the offset rows value.
  Parameters:
  
  value - an offset rows value
  
  Returns:
  
  a self instance
  
  Since:
  
  3.5.2
  
  See Also:
  
  FETCH_FIRST_ROWS_ONLY(int)
- ADD_ROW
  
  public T ADD_ROW()
  
  used to add a new inserted row while do multi-row insert.
  
  Returns:
  
  the t
  
  Since:
  
  3.5.2
- usingAppender
  
  public <A extends Appendable> A usingAppender(A a)
- applyIf
  
  public T applyIf(boolean applyCondition, Consumer<T> sqlConsumer)
  
  Apply sql phrases that provide by SQL consumer if condition is matches.
  Parameters:
  
  applyCondition - if true apply sql phrases
  
  sqlConsumer - a consumer that append sql phrase to SQL instance
  
  Returns:
  
  a self instance
  
  Since:
  
  3.5.15
  
  See Also:
  
  applyIf(BooleanSupplier, Consumer)
- applyIf
  
  public T applyIf(BooleanSupplier applyConditionSupplier, Consumer<T> sqlConsumer)
  
  Apply sql phrases that provide by SQL consumer if condition is matches.
  Parameters:
  
  applyConditionSupplier - if supplier return true apply sql phrases
  
  sqlConsumer - a consumer that append sql phrase to SQL instance
  
  Returns:
  
  a self instance
  
  Since:
  
  3.5.15
  
  See Also:
  
  applyIf(boolean, Consumer)
- applyForEach
  
  public <E> T applyForEach(Iterable<E> iterable, AbstractSQL.ForEachConsumer<T,E> forEachSqlConsumer)
  
  Apply sql phrases that provide by SQL consumer for iterable.
  
  Type Parameters:
  
  E - element type of iterable
  
  Parameters:
  
  iterable - an iterable
  
  forEachSqlConsumer - a consumer that append sql phrase to SQL instance
  
  Returns:
  
  a self instance
  
  Since:
  
  3.5.15
- toString
  
  public String toString()
  
  Overrides:
  
  toString in class Object

Class AbstractSQL<T>

Nested Class Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Details

AbstractSQL

Method Details

getSelf

UPDATE

SET

SET

INSERT_INTO

VALUES

INTO_COLUMNS

INTO_VALUES

SELECT

SELECT

SELECT_DISTINCT

SELECT_DISTINCT

DELETE_FROM

FROM

FROM

JOIN

JOIN

INNER_JOIN

INNER_JOIN

LEFT_OUTER_JOIN

LEFT_OUTER_JOIN

RIGHT_OUTER_JOIN

RIGHT_OUTER_JOIN

OUTER_JOIN

OUTER_JOIN

WHERE

WHERE

OR

AND

GROUP_BY

GROUP_BY

HAVING

HAVING

ORDER_BY

ORDER_BY

LIMIT

LIMIT

OFFSET

OFFSET

FETCH_FIRST_ROWS_ONLY

FETCH_FIRST_ROWS_ONLY

OFFSET_ROWS

OFFSET_ROWS

ADD_ROW

usingAppender

applyIf

applyIf

applyForEach

toString