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, waitappend, append, getPrepareStatement, getPrepareStatement, getPrepareStatement, getPrepareStatementpublic JoinOnSupportImpl(T sql)
sql - sql对象public <K> JoinOnSupportImpl<K> copy(K sql)
K - sql对象模板sql - sql对象public T getSql()
SqlSupportgetSql in interface SqlSupport<T>public T joinOn(JoinOn joinOn)
JoinOnSupportjoinOn in interface JoinOnSupport<T>joinOn - JoinOn操作public T joinOn(List<JoinOn> joinOns)
JoinOnSupportjoinOn in interface JoinOnSupport<T>joinOns - JoinOn操作列表public T joinOn(Table table, List<Column> columnPairs)
JoinOnSupportjoinOn in interface JoinOnSupport<T>table - 需要join的表对象columnPairs - on相关的"列-对"Columnpublic T leftJoinOn(Table table, List<Column> columnPairs)
JoinOnSupportleftJoinOn in interface JoinOnSupport<T>table - 需要join的表对象columnPairs - DbColumn pairsColumnpublic T rightJoinOn(Table table, List<Column> columnPairs)
JoinOnSupportrightJoinOn in interface JoinOnSupport<T>table - 需要join的表对象columnPairs - DbColumn pairsColumnpublic T fullJoinOn(Table table, List<Column> columnPairs)
JoinOnSupportfullJoinOn in interface JoinOnSupport<T>table - 需要join的表对象columnPairs - DbColumn pairsColumnpublic T innerJoinOn(Table table, List<Column> columnPairs)
JoinOnSupportinnerJoinOn in interface JoinOnSupport<T>table - 需要join的表对象columnPairs - DbColumn pairsColumnpublic T complexLeftJoinOn(Table table, List<CriteriaItem> criteriaItems)
JoinOnSupportcomplexLeftJoinOn in interface JoinOnSupport<T>table - 需要join的表对象criteriaItems - 条件public T complexRightJoinOn(Table table, List<CriteriaItem> criteriaItems)
JoinOnSupportcomplexRightJoinOn in interface JoinOnSupport<T>table - 需要join的表对象criteriaItems - 条件public T complexFullJoinOn(Table table, List<CriteriaItem> criteriaItems)
JoinOnSupportcomplexFullJoinOn in interface JoinOnSupport<T>table - 需要join的表对象criteriaItems - 条件public T complexInnerJoinOn(Table table, List<CriteriaItem> criteriaItems)
JoinOnSupportcomplexInnerJoinOn in interface JoinOnSupport<T>table - 需要join的表对象criteriaItems - 条件public PrepareStatement getJoinOnPrepareStatement(boolean useAlias)
useAlias - 是否使用别名Copyright © 2020 IBIT程序猿. All rights reserved.