com.ds.common.database.dao

类 DAOCondition

java.lang.Object

com.ds.common.database.dao.DAOCondition

所有已实现的接口:

Filter, Serializable

public class DAOCondition
extends Object
implements Serializable, Filter

Title: JDS系统管理系统

Description: 用于封装对引擎内部数据进行查询的条件以及对结果集的排序，并 在引擎内部将其作为SQL查询WHERE子句的一部分。也就是说它最终 将被转换成SQL查询条件，例如：

Condition c1 = new Condition(ConditionKey.ACTIVITYINST_STATE, ActivityInst.STATE_RUNNING, Condition.EQUALS);

调用c1.makeConditionString()将返回查询条件 BPM_ACTIVITYINSTANCE.ACTIVITYINST_STATE = 'running'

如果继续进行如下调用：

java.sql.Date date = new java.sql.Date(System.currentTimeMillis()); Condition c2 = new Condition(ConditionKey.ACTIVITYINST_ARRIVEDTIME, date , Condition.LESS_THAN); c1.addCondition(c2, Condition.JOIN_AND); Condition c3 = new Condition(ConditionKey.ACTIVITYINST_STARTTIME, date , Condition.GREATER_THAN); c1.addCondition(c3, Condition.JOIN_OR);

此时调用c1.makeConditionString()将返回查询条件 BPM_ACTIVITYINSTANCE.ACTIVITYINST_STATE = 'running' AND (BPM_ACTIVITYINSTANCE.ARRIVEDTIME < '2003-12-25' OR BPM_ACTIVITYINSTANCE.STARTTIME > '2003-12-25')

如果需要对结果集进行排序，可以进行如下操作：

c1.addOrderBy(new Order(ConditionKey.ACTIVITYINST_STATE, true)); c1.addOrderBy(new Order(ConditionKey.ACTIVITYINST_ARRIVEDTIME, false));

此时调用c1.makeConditionString()将返回查询条件 BPM_ACTIVITYINSTANCE.ACTIVITYINST_STATE = 'running' AND (BPM_ACTIVITYINSTANCE.ARRIVEDTIME < '2003-12-25' OR BPM_ACTIVITYINSTANCE.STARTTIME > '2003-12-25') ORDER BY BPM_ACTIVITYINSTANCE.ACTIVITYINST_STATE ASC,BPM_ACTIVITYINSTANCE.ARRIVEDTIME DESC

Copyright: Copyright (c) 2020

Company: www.justdos.net

版本:

1.0

作者:

wenzhang li

另请参阅:

序列化表格

字段概要

字段

限定符和类型	字段和说明
protected List<DAOCondition>	childConditionList
protected List<JoinOperator>	childJoinTypeList
protected String	conditionKey 条件类型包括：活动状态、活动开始时间、结束时间
protected boolean	isMysql
protected Operator	operator
protected List<Order>	orderByList
Page	page
protected TableInfo	tableInfo
protected Object	value 条件所需的取值，如果Comparator取值为BETWEEN和INCLUDE，该值为java.util.List对象。

方法概要

限定符和类型	方法和说明
void	addCondition(DAOCondition condition, JoinOperator joinType) 在当前条件中添加一个子条件，将使用joinType中定义的方法连接到主查询上
void	addOrderBy(Order order) 添加一个排序条件，将向Sql语句中添加一个Order By子句 注意：只有最上级的Condition主查询可以添加Order，子查询上是不能添加的
String	extractValue(Object value)
boolean	filterObject(Object obj, String systemCode)
List<DAOCondition>	getChildConditionList()
List<JoinOperator>	getChildJoinTypeList()
String	getConditionKey()
Operator	getOperator()
List<Order>	getOrderByList()
Page	getPage()
TableInfo	getTableInfo()
Object	getValue()
boolean	isMysql()
static void	main(String[] args)
String	makeConditionString() 产生查询Sql,引擎内部使用
void	setChildConditionList(List<DAOCondition> childConditionList)
void	setChildJoinTypeList(List<JoinOperator> childJoinTypeList)
void	setConditionKey(String conditionKey)
void	setMysql(boolean mysql)
void	setOperator(Operator operator)
void	setOrderByList(List<Order> orderByList)
void	setPage(Page page)
void	setTableInfo(TableInfo tableInfo)
void	setValue(Object value)

从类继承的方法 java.lang.Object

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

字段详细资料

conditionKey

protected String conditionKey

条件类型包括：活动状态、活动开始时间、结束时间

value

protected Object value

条件所需的取值，如果Comparator取值为BETWEEN和INCLUDE，该值为java.util.List对象。

operator

protected Operator operator

tableInfo

protected TableInfo tableInfo

isMysql

protected boolean isMysql

page

public Page page

childConditionList

protected List<DAOCondition> childConditionList

childJoinTypeList

protected List<JoinOperator> childJoinTypeList

orderByList

protected List<Order> orderByList

方法详细资料

getPage

public Page getPage()

setPage

public void setPage(Page page)

getConditionKey

public String getConditionKey()

setConditionKey

public void setConditionKey(String conditionKey)

getTableInfo

public TableInfo getTableInfo()

setTableInfo

public void setTableInfo(TableInfo tableInfo)

getValue

public Object getValue()

setValue

public void setValue(Object value)

getOperator

public Operator getOperator()

setOperator

public void setOperator(Operator operator)

getChildConditionList

public List<DAOCondition> getChildConditionList()

setChildConditionList

public void setChildConditionList(List<DAOCondition> childConditionList)

getChildJoinTypeList

public List<JoinOperator> getChildJoinTypeList()

setChildJoinTypeList

public void setChildJoinTypeList(List<JoinOperator> childJoinTypeList)

getOrderByList

public List<Order> getOrderByList()

setOrderByList

public void setOrderByList(List<Order> orderByList)

makeConditionString

public String makeConditionString()

产生查询Sql,引擎内部使用

返回:

返回引擎查询用的sql

addOrderBy

public void addOrderBy(Order order)

添加一个排序条件，将向Sql语句中添加一个Order By子句
注意：只有最上级的Condition主查询可以添加Order，子查询上是不能添加的

参数:

order - 一个Order对象。

addCondition

public void addCondition(DAOCondition condition,
                         JoinOperator joinType)

在当前条件中添加一个子条件，将使用joinType中定义的方法连接到主查询上

参数:

condition - 子查询条件

joinType - 连接方法

JOIN_AND - 将使用AND连接子查询

JOIN_OR - 将使用OR连接子查询

extractValue

public String extractValue(Object value)

filterObject

public boolean filterObject(Object obj,
                            String systemCode)

指定者:

filterObject 在接口中 Filter

isMysql

public boolean isMysql()

setMysql

public void setMysql(boolean mysql)

main

public static void main(String[] args)