tech.ibit.mybatis.sqlbuilder

Class CriteriaItem

java.lang.Object

tech.ibit.mybatis.sqlbuilder.CriteriaItem

All Implemented Interfaces:

PrepareStatementSupplier

Direct Known Subclasses:

FlagCriteriaItem

public class CriteriaItem
extends Object
implements PrepareStatementSupplier

条件内容对象

Version:

1.0

Author:

IBIT程序猿

Constructor Summary

Constructors

Constructor and Description
CriteriaItem(IColumn column, OperatorEnum operator, IColumn secondColumn, Object value, Object secondValue, CriteriaItemValueTypeEnum valueType) 条件对象

Method Summary

Modifier and Type	Method and Description
Criteria	and() 生成and条件
static CriteriaItem	getBetweenInstance(IColumn column, OperatorEnum operator, Object value, Object secondValue) 构造between条件
IColumn	getColumn() Gets the value of column
static CriteriaItem	getColumnCompareInstance(IColumn column, OperatorEnum operator, IColumn secondColumn) 构造两列比较条件
static CriteriaItem	getMultiValueInstance(IColumn column, OperatorEnum operator, Collection<?> values) 构造多值条件
static CriteriaItem	getNoValueInstance(IColumn column, OperatorEnum operator) 构造无值条件
OperatorEnum	getOperator() Gets the value of operator
PrepareStatement	getPrepareStatement(boolean useAlias) 获取预查询SQL对象
IColumn	getSecondColumn() Gets the value of secondColumn
Object	getSecondValue() Gets the value of secondValue
static CriteriaItem	getSingleValueInstance(IColumn column, OperatorEnum operator, Object value) 构造单值条件
Object	getValue() Gets the value of value
CriteriaItemValueTypeEnum	getValueType() Gets the value of valueType
Criteria	or() 生成or条件

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface tech.ibit.mybatis.sqlbuilder.PrepareStatementSupplier

getPrepareStatement

Constructor Detail

CriteriaItem

public CriteriaItem(IColumn column,
                    OperatorEnum operator,
                    IColumn secondColumn,
                    Object value,
                    Object secondValue,
                    CriteriaItemValueTypeEnum valueType)

条件对象

Parameters:

column - 列

operator - 操作符

secondColumn - 第二列

value - 值

secondValue - 第二个值

valueType - 值类型

Method Detail

getNoValueInstance

public static CriteriaItem getNoValueInstance(IColumn column,
                                              OperatorEnum operator)

构造无值条件

Parameters:

column - 列

operator - 操作符

Returns:

条件内容

getColumnCompareInstance

public static CriteriaItem getColumnCompareInstance(IColumn column,
                                                    OperatorEnum operator,
                                                    IColumn secondColumn)

构造两列比较条件

Parameters:

column - 第一列

operator - 操作符

secondColumn - 第二列

Returns:

条件内容

getSingleValueInstance

public static CriteriaItem getSingleValueInstance(IColumn column,
                                                  OperatorEnum operator,
                                                  Object value)

构造单值条件

Parameters:

column - 列

operator - 操作符

value - 值

Returns:

条件内容

getMultiValueInstance

public static CriteriaItem getMultiValueInstance(IColumn column,
                                                 OperatorEnum operator,
                                                 Collection<?> values)

构造多值条件

Parameters:

column - 列

operator - 操作符

values - 值列表

Returns:

条件内容

getBetweenInstance

public static CriteriaItem getBetweenInstance(IColumn column,
                                              OperatorEnum operator,
                                              Object value,
                                              Object secondValue)

构造between条件

Parameters:

column - 列

operator - 操作符

value - 值

secondValue - 第二个值

Returns:

条件内容

getPrepareStatement

public PrepareStatement getPrepareStatement(boolean useAlias)

Description copied from interface: PrepareStatementSupplier

获取预查询SQL对象

Specified by:

getPrepareStatement in interface PrepareStatementSupplier

Parameters:

useAlias - 是否使用别名

Returns:

预查询SQL对象

or

public Criteria or()

生成or条件

Returns:

or条件

and

public Criteria and()

生成and条件

Returns:

and条件

getColumn

public IColumn getColumn()

Gets the value of column

Returns:

the value of column

getOperator

public OperatorEnum getOperator()

Gets the value of operator

Returns:

the value of operator

getSecondColumn

public IColumn getSecondColumn()

Gets the value of secondColumn

Returns:

the value of secondColumn

getValue

public Object getValue()

Gets the value of value

Returns:

the value of value

getSecondValue

public Object getSecondValue()

Gets the value of secondValue

Returns:

the value of secondValue

getValueType

public CriteriaItemValueTypeEnum getValueType()

Gets the value of valueType

Returns:

the value of valueType