Modifier and Type | Class and Description |
---|---|
class |
FlagCriteriaItem
标记位查询条件
|
Modifier and Type | Method and Description |
---|---|
static CriteriaItem |
CriteriaItem.getBetweenInstance(IColumn column,
OperatorEnum operator,
Object value,
Object secondValue)
构造between条件
|
static CriteriaItem |
CriteriaItem.getColumnCompareInstance(IColumn column,
OperatorEnum operator,
IColumn secondColumn)
构造两列比较条件
|
CriteriaItem |
Criteria.getItem()
Gets the value of item
|
static CriteriaItem |
CriteriaItem.getMultiValueInstance(IColumn column,
OperatorEnum operator,
Collection<?> values)
构造多值条件
|
static CriteriaItem |
CriteriaItem.getNoValueInstance(IColumn column,
OperatorEnum operator)
构造无值条件
|
static CriteriaItem |
CriteriaItem.getSingleValueInstance(IColumn column,
OperatorEnum operator,
Object value)
构造单值条件
|
Modifier and Type | Method and Description |
---|---|
List<CriteriaItem> |
JoinOn.getCriteriaItems()
Gets the value of criteriaItems
|
Modifier and Type | Method and Description |
---|---|
static Criteria |
Criteria.and(CriteriaItem item)
构造AND条件
|
static Criteria |
Criteria.or(CriteriaItem item)
构造OR条件
|
void |
Criteria.setItem(CriteriaItem item)
Sets the item
|
Modifier and Type | Method and Description |
---|---|
static JoinOn |
JoinOn.full(Table table,
List<Column> columnPairs,
List<CriteriaItem> criteriaItems)
full join on
|
static JoinOn |
JoinOn.inner(Table table,
List<Column> columnPairs,
List<CriteriaItem> criteriaItems)
inner join on
|
static JoinOn |
JoinOn.left(Table table,
List<Column> columnPairs,
List<CriteriaItem> criteriaItems)
left join on
|
static JoinOn |
JoinOn.none(Table table,
List<Column> columnPairs,
List<CriteriaItem> criteriaItems)
join on
|
static JoinOn |
JoinOn.right(Table table,
List<Column> columnPairs,
List<CriteriaItem> criteriaItems)
right join on
|
Modifier and Type | Method and Description |
---|---|
default CriteriaItem |
IColumnCriteriaItemSupport.allFlgs(long flags)
构造全包含标记位条件内容(扩展)
|
default CriteriaItem |
IColumnCriteriaItemSupport.anyFlgs(long flags)
构造全包含任意标记位条件内容(扩展)
|
default CriteriaItem |
IColumnCriteriaItemSupport.between(Object value1,
Object value2)
构造"BETWEEN AND"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.egt(IColumn secondColumn)
构造"大于等于"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.egt(Object value)
构造"大于等于"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.elt(IColumn secondColumn)
构造"小于等于"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.elt(Object value)
构造"小于等于"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.eq(IColumn secondColumn)
构造"相等"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.eq(Object value)
构造"相等"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.gt(IColumn secondColumn)
构造"大于"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.gt(Object value)
构造"大于"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.in(Collection<?> values)
构造"IN"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.isEmpty()
构造"= ''"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.isNotEmpty()
构造"不为空"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.isNotNull()
构造"IS NOT NULL"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.isNull()
构造"IS NULL"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.like(String value)
构造"LIKE"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.lt(IColumn secondColumn)
构造"小于"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.lt(Object value)
构造"小于"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.neq(IColumn secondColumn)
构造"不等"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.neq(Object value)
构造"不等"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.noFlgs(long flags)
构造全不包含标记位条件内容(扩展)
|
default CriteriaItem |
IColumnCriteriaItemSupport.notBetween(Object value1,
Object value2)
构造"NOT BETWEEN AND"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.notIn(Collection<?> values)
构造"NOT IN"条件内容
|
default CriteriaItem |
IColumnCriteriaItemSupport.notLike(String value)
构造"NOT LIKE"条件内容
|
Modifier and Type | Method and Description |
---|---|
CountSql |
CountSqlImpl.andHaving(CriteriaItem havingItem) |
QuerySql<T> |
QuerySqlImpl.andHaving(CriteriaItem havingItem) |
CountSql |
CountSqlImpl.andWhere(CriteriaItem item) |
DeleteSql |
DeleteSqlImpl.andWhere(CriteriaItem item) |
UpdateSql |
UpdateSqlImpl.andWhere(CriteriaItem item) |
QuerySql<T> |
QuerySqlImpl.andWhere(CriteriaItem item) |
CountSql |
CountSqlImpl.orHaving(CriteriaItem havingItem) |
QuerySql<T> |
QuerySqlImpl.orHaving(CriteriaItem havingItem) |
CountSql |
CountSqlImpl.orWhere(CriteriaItem item) |
DeleteSql |
DeleteSqlImpl.orWhere(CriteriaItem item) |
UpdateSql |
UpdateSqlImpl.orWhere(CriteriaItem item) |
QuerySql<T> |
QuerySqlImpl.orWhere(CriteriaItem item) |
Modifier and Type | Method and Description |
---|---|
T |
HavingSupport.andHaving(CriteriaItem havingItem)
`HAVING AND item`语句
|
T |
WhereSupport.andWhere(CriteriaItem item)
`WHERE AND` 语句
|
T |
HavingSupport.orHaving(CriteriaItem havingItem)
`HAVING OR item`语句
|
T |
WhereSupport.orWhere(CriteriaItem item)
`WHERE OR`语句
|
Modifier and Type | Method and Description |
---|---|
T |
JoinOnSupport.complexFullJoinOn(Table table,
List<CriteriaItem> criteriaItems)
`FULL JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
|
T |
JoinOnSupport.complexInnerJoinOn(Table table,
List<CriteriaItem> criteriaItems)
`INNER JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
|
T |
JoinOnSupport.complexLeftJoinOn(Table table,
List<CriteriaItem> criteriaItems)
`LEFT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
|
T |
JoinOnSupport.complexRightJoinOn(Table table,
List<CriteriaItem> criteriaItems)
`RIGHT JOIN table t1 on t1.column1=t0.column2, t1.column3=t0.column4 AND t1.column5=?`语句
|
Modifier and Type | Method and Description |
---|---|
T |
HavingSupportImpl.andHaving(CriteriaItem havingItem) |
T |
WhereSupportImpl.andWhere(CriteriaItem item) |
T |
HavingSupportImpl.orHaving(CriteriaItem havingItem) |
T |
WhereSupportImpl.orWhere(CriteriaItem item) |
Modifier and Type | Method and Description |
---|---|
T |
JoinOnSupportImpl.complexFullJoinOn(Table table,
List<CriteriaItem> criteriaItems) |
T |
JoinOnSupportImpl.complexInnerJoinOn(Table table,
List<CriteriaItem> criteriaItems) |
T |
JoinOnSupportImpl.complexLeftJoinOn(Table table,
List<CriteriaItem> criteriaItems) |
T |
JoinOnSupportImpl.complexRightJoinOn(Table table,
List<CriteriaItem> criteriaItems) |
Copyright © 2020 IBIT程序猿. All rights reserved.