Package org.apache.ibatis.jdbc

Class AbstractSQL<T>

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