Query

    Used to query data in tables, supports conditions and paging, and supports data types other than databases, such as Excel, CSV, etc.

    The following is a sample code for query, written in Groovy.

import xworker.dataObject.DataObject;
import xworker.dataObject.query.QueryConfig;

def dataObject = new DataObject("xworker.app.monitor.dataobjects.ResMonitorTasks");

def queryConfig = new QueryConfig();
def condition = queryConfig.getCondition();
condition.rlike("name", "Check").and().lt("id", 5);

def pageInfo = queryConfig.getPageInfo();
pageInfo.setLimit(1);

def datas = dataObject.query(actionContext, queryConfig);
for(data in datas){
     println data;
}

 

Copyright ©  2007-2019 XWorker.org  版权所有  沪ICP备08000575号