public class JoinOnSupportImpl<T> extends Object implements SqlSupport<T>, JoinOnSupport<T>, PrepareStatementBuildSupport
Constructor and Description |
---|
JoinOnSupportImpl(T sql)
构造函数
|
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=?`语句
|
<K> JoinOnSupportImpl<K> |
copy(K sql)
对象复制(浅复制)
|
T |
fullJoinOn(Table table,
List<Column> columnPairs)
`FULL JOIN table t1 ON t1.column1=t0.column2, t1.column3=t0.column4`语句
|
ListField<JoinOn> |
getJoinOn()
Join on
|
PrepareStatement |
getJoinOnPrepareStatement(boolean useAlias)
获取预查询SQL对象
|
T |
getSql()
返回sql
|
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`语句
|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
append, append, getPrepareStatement, getPrepareStatement, getPrepareStatement, getPrepareStatement
public JoinOnSupportImpl(T sql)
sql
- sql对象public <K> JoinOnSupportImpl<K> copy(K sql)
K
- sql对象模板sql
- sql对象public T getSql()
SqlSupport
getSql
in interface SqlSupport<T>
public T joinOn(JoinOn joinOn)
JoinOnSupport
joinOn
in interface JoinOnSupport<T>
joinOn
- JoinOn操作public T joinOn(List<JoinOn> joinOns)
JoinOnSupport
joinOn
in interface JoinOnSupport<T>
joinOns
- JoinOn操作列表public T joinOn(Table table, List<Column> columnPairs)
JoinOnSupport
joinOn
in interface JoinOnSupport<T>
table
- 需要join的表对象columnPairs
- on相关的"列-对"Column
public T leftJoinOn(Table table, List<Column> columnPairs)
JoinOnSupport
leftJoinOn
in interface JoinOnSupport<T>
table
- 需要join的表对象columnPairs
- DbColumn pairsColumn
public T rightJoinOn(Table table, List<Column> columnPairs)
JoinOnSupport
rightJoinOn
in interface JoinOnSupport<T>
table
- 需要join的表对象columnPairs
- DbColumn pairsColumn
public T fullJoinOn(Table table, List<Column> columnPairs)
JoinOnSupport
fullJoinOn
in interface JoinOnSupport<T>
table
- 需要join的表对象columnPairs
- DbColumn pairsColumn
public T innerJoinOn(Table table, List<Column> columnPairs)
JoinOnSupport
innerJoinOn
in interface JoinOnSupport<T>
table
- 需要join的表对象columnPairs
- DbColumn pairsColumn
public T complexLeftJoinOn(Table table, List<CriteriaItem> criteriaItems)
JoinOnSupport
complexLeftJoinOn
in interface JoinOnSupport<T>
table
- 需要join的表对象criteriaItems
- 条件public T complexRightJoinOn(Table table, List<CriteriaItem> criteriaItems)
JoinOnSupport
complexRightJoinOn
in interface JoinOnSupport<T>
table
- 需要join的表对象criteriaItems
- 条件public T complexFullJoinOn(Table table, List<CriteriaItem> criteriaItems)
JoinOnSupport
complexFullJoinOn
in interface JoinOnSupport<T>
table
- 需要join的表对象criteriaItems
- 条件public T complexInnerJoinOn(Table table, List<CriteriaItem> criteriaItems)
JoinOnSupport
complexInnerJoinOn
in interface JoinOnSupport<T>
table
- 需要join的表对象criteriaItems
- 条件public PrepareStatement getJoinOnPrepareStatement(boolean useAlias)
useAlias
- 是否使用别名Copyright © 2020 IBIT程序猿. All rights reserved.