tech.ibit.mybatis.sqlbuilder.sql.support

Interface JoinOnSupport<T>

All Known Subinterfaces:

CountSql, DeleteSql, QuerySql<T>, UpdateSql

All Known Implementing Classes:

CountSqlImpl, DeleteSqlImpl, JoinOnSupportImpl, QuerySqlImpl, UpdateSqlImpl

public interface JoinOnSupport<T>

JoinOn Support

Version:

2.0

Author:

IBIT程序猿

Method Summary

Modifier and Type	Method and Description
T	complexFullJoinOn(Table table, List<CriteriaItem> criteriaItems) `FULL JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
T	complexInnerJoinOn(Table table, List<CriteriaItem> criteriaItems) `INNER JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
T	complexLeftJoinOn(Table table, List<CriteriaItem> criteriaItems) `LEFT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
T	complexRightJoinOn(Table table, List<CriteriaItem> criteriaItems) `RIGHT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
T	fullJoinOn(Table table, List<Column> columnPairs) `FULL JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
T	innerJoinOn(Table table, List<Column> columnPairs) `INNER JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
T	joinOn(JoinOn joinOn) JoinOn操作
T	joinOn(List<JoinOn> joinOns) JoinOn操作
T	joinOn(Table table, List<Column> columnPairs) `JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
T	leftJoinOn(Table table, List<Column> columnPairs) `LEFT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
T	rightJoinOn(Table table, List<Column> columnPairs) `RIGHT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句

Method Detail

joinOn

T joinOn(JoinOn joinOn)

JoinOn操作

Parameters:

joinOn - JoinOn操作

Returns:

SQL对象

joinOn

T joinOn(List<JoinOn> joinOns)

JoinOn操作

Parameters:

joinOns - JoinOn操作列表

Returns:

SQL对象

joinOn

T joinOn(Table table,
         List<Column> columnPairs)

`JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句

Parameters:

table - 需要join的表对象

columnPairs - on相关的"列-对"

Returns:

SQL对象

See Also:

Column

leftJoinOn

T leftJoinOn(Table table,
             List<Column> columnPairs)

`LEFT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句

Parameters:

table - 需要join的表对象

columnPairs - DbColumn pairs

Returns:

SQL对象

See Also:

Column

rightJoinOn

T rightJoinOn(Table table,
              List<Column> columnPairs)

`RIGHT JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句

Parameters:

table - 需要join的表对象

columnPairs - DbColumn pairs

Returns:

SQL对象

See Also:

Column

fullJoinOn

T fullJoinOn(Table table,
             List<Column> columnPairs)

`FULL JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句

Parameters:

table - 需要join的表对象

columnPairs - DbColumn pairs

Returns:

SQL对象

See Also:

Column

innerJoinOn

T innerJoinOn(Table table,
              List<Column> columnPairs)

`INNER JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句

Parameters:

table - 需要join的表对象

columnPairs - DbColumn pairs

Returns:

SQL对象

See Also:

Column

complexLeftJoinOn

T complexLeftJoinOn(Table table,
                    List<CriteriaItem> criteriaItems)

`LEFT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句

Parameters:

table - 需要join的表对象

criteriaItems - 条件

Returns:

SQL对象

complexRightJoinOn

T complexRightJoinOn(Table table,
                     List<CriteriaItem> criteriaItems)

`RIGHT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句

Parameters:

table - 需要join的表对象

criteriaItems - 条件

Returns:

SQL对象

complexFullJoinOn

T complexFullJoinOn(Table table,
                    List<CriteriaItem> criteriaItems)

`FULL JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句

Parameters:

table - 需要join的表对象

criteriaItems - 条件

Returns:

SQL对象

complexInnerJoinOn

T complexInnerJoinOn(Table table,
                     List<CriteriaItem> criteriaItems)

`INNER JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句

Parameters:

table - 需要join的表对象

criteriaItems - 条件

Returns:

SQL对象