Package org.apache.ibatis.jdbc
Class AbstractSQL<T>
java.lang.Object
org.apache.ibatis.jdbc.AbstractSQL<T>
- Direct Known Subclasses:
SQL
- Author:
- Clinton Begin, Jeff Butler, Adam Gent, Kazuki Shimizu
-
Nested Class Summary
Modifier and TypeClassDescriptionstatic interface
Consumer for 'forEach' operation. -
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionADD_ROW()
used to add a new inserted row while do multi-row insert.AND()
<E> T
applyForEach
(Iterable<E> iterable, AbstractSQL.ForEachConsumer<T, E> forEachSqlConsumer) Apply sql phrases that provide by SQL consumer for iterable.Apply sql phrases that provide by SQL consumer if condition is matches.applyIf
(BooleanSupplier applyConditionSupplier, Consumer<T> sqlConsumer) Apply sql phrases that provide by SQL consumer if condition is matches.DELETE_FROM
(String table) FETCH_FIRST_ROWS_ONLY
(int value) Set the fetch first rows value.FETCH_FIRST_ROWS_ONLY
(String variable) Set the fetch first rows variable string(e.g.From.abstract T
getSelf()
Group by.Having.INNER_JOIN
(String join) INNER_JOIN
(String... joins) Inner join.INSERT_INTO
(String tableName) INTO_COLUMNS
(String... columns) Into columns.INTO_VALUES
(String... values) Into values.Join.LEFT_OUTER_JOIN
(String join) LEFT_OUTER_JOIN
(String... joins) Left outer join.LIMIT
(int value) Set the limit value.Set the limit variable string(e.g.OFFSET
(long value) Set the offset value.Set the offset variable string(e.g.OFFSET_ROWS
(long value) Set the offset rows value.OFFSET_ROWS
(String variable) Set the offset rows variable string(e.g.OR()
Order by.OUTER_JOIN
(String join) OUTER_JOIN
(String... joins) Outer join.RIGHT_OUTER_JOIN
(String join) RIGHT_OUTER_JOIN
(String... joins) Right outer join.Select.SELECT_DISTINCT
(String columns) SELECT_DISTINCT
(String... columns) Select distinct.Sets the.toString()
<A extends Appendable>
AusingAppender
(A a) Where.
-
Constructor Details
-
AbstractSQL
public AbstractSQL()
-
-
Method Details
-
getSelf
-
UPDATE
-
SET
-
SET
Sets the.- Parameters:
sets
- the sets- Returns:
- the t
- Since:
- 3.4.2
-
INSERT_INTO
-
VALUES
-
INTO_COLUMNS
Into columns.- Parameters:
columns
- the columns- Returns:
- the t
- Since:
- 3.4.2
-
INTO_VALUES
Into values.- Parameters:
values
- the values- Returns:
- the t
- Since:
- 3.4.2
-
SELECT
-
SELECT
Select.- Parameters:
columns
- the columns- Returns:
- the t
- Since:
- 3.4.2
-
SELECT_DISTINCT
-
SELECT_DISTINCT
Select distinct.- Parameters:
columns
- the columns- Returns:
- the t
- Since:
- 3.4.2
-
DELETE_FROM
-
FROM
-
FROM
From.- Parameters:
tables
- the tables- Returns:
- the t
- Since:
- 3.4.2
-
JOIN
-
JOIN
Join.- Parameters:
joins
- the joins- Returns:
- the t
- Since:
- 3.4.2
-
INNER_JOIN
-
INNER_JOIN
Inner join.- Parameters:
joins
- the joins- Returns:
- the t
- Since:
- 3.4.2
-
LEFT_OUTER_JOIN
-
LEFT_OUTER_JOIN
Left outer join.- Parameters:
joins
- the joins- Returns:
- the t
- Since:
- 3.4.2
-
RIGHT_OUTER_JOIN
-
RIGHT_OUTER_JOIN
Right outer join.- Parameters:
joins
- the joins- Returns:
- the t
- Since:
- 3.4.2
-
OUTER_JOIN
-
OUTER_JOIN
Outer join.- Parameters:
joins
- the joins- Returns:
- the t
- Since:
- 3.4.2
-
WHERE
-
WHERE
Where.- Parameters:
conditions
- the conditions- Returns:
- the t
- Since:
- 3.4.2
-
OR
-
AND
-
GROUP_BY
-
GROUP_BY
Group by.- Parameters:
columns
- the columns- Returns:
- the t
- Since:
- 3.4.2
-
HAVING
-
HAVING
Having.- Parameters:
conditions
- the conditions- Returns:
- the t
- Since:
- 3.4.2
-
ORDER_BY
-
ORDER_BY
Order by.- Parameters:
columns
- the columns- Returns:
- the t
- Since:
- 3.4.2
-
LIMIT
Set the limit variable string(e.g."#{limit}"
).- Parameters:
variable
- a limit variable string- Returns:
- a self instance
- Since:
- 3.5.2
- See Also:
-
LIMIT
Set the limit value.- Parameters:
value
- an offset value- Returns:
- a self instance
- Since:
- 3.5.2
- See Also:
-
OFFSET
Set the offset variable string(e.g."#{offset}"
).- Parameters:
variable
- a offset variable string- Returns:
- a self instance
- Since:
- 3.5.2
- See Also:
-
OFFSET
Set the offset value.- Parameters:
value
- an offset value- Returns:
- a self instance
- Since:
- 3.5.2
- See Also:
-
FETCH_FIRST_ROWS_ONLY
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:
-
FETCH_FIRST_ROWS_ONLY
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
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:
-
OFFSET_ROWS
Set the offset rows value.- Parameters:
value
- an offset rows value- Returns:
- a self instance
- Since:
- 3.5.2
- See Also:
-
ADD_ROW
used to add a new inserted row while do multi-row insert.- Returns:
- the t
- Since:
- 3.5.2
-
usingAppender
-
applyIf
Apply sql phrases that provide by SQL consumer if condition is matches.- Parameters:
applyCondition
- iftrue
apply sql phrasessqlConsumer
- a consumer that append sql phrase to SQL instance- Returns:
- a self instance
- Since:
- 3.5.15
- See Also:
-
applyIf
Apply sql phrases that provide by SQL consumer if condition is matches.- Parameters:
applyConditionSupplier
- if supplier returntrue
apply sql phrasessqlConsumer
- a consumer that append sql phrase to SQL instance- Returns:
- a self instance
- Since:
- 3.5.15
- See Also:
-
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 iterableforEachSqlConsumer
- a consumer that append sql phrase to SQL instance- Returns:
- a self instance
- Since:
- 3.5.15
-
toString
-