一、组装参数的学习
首先是查询条件，对于查询条件，需要判断是否从前端传递空值？——怎么处理查询空值？
当然可以一个一个进行判断，但是这样代码会导致很多，可以统一处理，形成一个公共方法。
1、 单个处理的方式：
调用工具方法判空（底层：判断是否是null 和空）
/** UtilValidate类. */
/** Check whether string s is NOT empty. */
public static boolean isNotEmpty(String s) {
return (s != null) && s.length() > 0;
}
/** Check whether collection c is NOT empty. */
public static <E> boolean isNotEmpty(Collection<E> c) {
return (c != null) && !c.isEmpty();
}
/** Check whether charsequence c is NOT empty. */
public static <E> boolean isNotEmpty(CharSequence c) {
return ((c != null) && (c.length() > 0));
}
if (UtilValidate.isNotEmpty(startDate)) {
condList.add(EntityCondition.makeCondition(PackagePrepayFields.REPAY_APP_DATE,
EntityOperator.GREATER_THAN_EQUAL_TO,
startDate));
}
2、多个处理：
多个处理需要知道最终需要的是什么数据结构。反向推导
/** Set a list of EntityCondition objects to be ANDed together as the WHERE clause for the query
*
* NOTE: Each successive call to any of the where(...) methods will replace the currently set condition for the query.
* @param fieldMap - A list of EntityCondition objects to be ANDed together as the WHERE clause for the query
* @return this EntityQuery object, to enable chaining
*/
public <T extends EntityCondition> EntityQuery where(List<T> andConditions) {
this.whereEntityCondition = EntityCondition.makeCondition(andConditions);
return this;
}
从上面的API中，可以看到需要的是List<T>，T必须是EntityCondition的子类或者其本身，暂时先使用EntityCondition，所以返回是List<EntityCondition>。
/**
* 封装查询条件列表
*
* @param arr
* @param context 入参上下文
* @author
*/
public static List<EntityCondition> setConditions(String[] arr, Map<String, ? extends Object> context) {
if (arr == null || arr.length <= 0) {
return null;
}
List<EntityCondition> conditionList = new LinkedList<EntityCondition>();
for (int i = 0; i < arr.length; i++) {
if (context.get(arr[i]) != null && !context.get(arr[i]).equals("")) {
conditionList.add(EntityCondition.makeCondition(arr[i], context.get(arr[i])));
}
}
return conditionList;
}
上述方法中EntityCondition.makeCondition(arr[i],context.get(arr[i]))调用的API如下：
public static <R> EntityExpr makeCondition(String fieldName, R value) {
return new EntityExpr(fieldName, EntityOperator.EQUALS, value);
}
但是针对非EntityOperator.EQUALS的查询条件，需要自己写。
public static <L,R,LL,RR> EntityExpr makeCondition(L lhs, EntityComparisonOperator<LL,RR> operator, R rhs) {
return new EntityExpr(lhs, operator, rhs);
}
3、分页处理
Integer viewIndex = ToolsUtil.paraseObjToInteger(context.get(PackagePrepayFields.VIEW_INDEX), 1);
Integer viewSize = ToolsUtil.paraseObjToInteger(context.get(PackagePrepayFields.VIEW_SIZE), 20);
/**
* 将Object对象转换为Integer
*
* @param obj
* @param def
* @return
* @author
*/
public static Integer paraseObjToInteger(Object obj, Integer def) {
if (obj == null || "null".equals(obj)) {
return def;
}
try {
return Integer.parseInt(obj.toString());
} catch (Exception e) {
throw new RuntimeException("Object{" + obj.toString() + "} parase to Decimal exception!", e);
}
}
再次，是查询要展示的列，查看API，提供两种方式
/** Set the fields to be returned when the query is executed.
*
* Note that the select methods are not additive, if a subsequent
* call is made to select then the existing fields for selection
* will be replaced.
* @param fieldsToSelect - A Set of Strings containing the field names to be selected
* @return this EntityQuery object, to enable chaining
*/
public EntityQuery select(Set<String> fieldsToSelect) {
this.fieldsToSelect = fieldsToSelect;
return this;
} /** Set the fields to be returned when the query is executed.
*
* Note that the select methods are not additive, if a subsequent
* call is made to select then the existing fields for selection
* will be replaced.
* @param fieldsToSelect - Strings containing the field names to be selected
* @return this EntityQuery object, to enable chaining
*/
public EntityQuery select(String...fields) {
this.fieldsToSelect = UtilMisc.toSetArray(fields);
return this;
}
鉴于此代码，包装的更多，使用更简单，public EntityQuery select(String...fields)
String[] columns =
{PackagePrepayFields.CUST_NO, PackagePrepayFields.CUST_NAME, PackagePrepayFields.VEHICLE_NO,
PackagePrepayFields.PLATE_NO, PackagePrepayFields.DOC_NO, PackagePrepayFields.SALE_NAME,
PackagePrepayFields.PENTY_AMT, PackagePrepayFields.PENTY_DEDUCT, PackagePrepayFields.PRIN_AMT,
PackagePrepayFields.AHEAD_AMT, PackagePrepayFields.PAY_MODE, PackagePrepayFields.MAIL_ADDRESS,
PackagePrepayFields.REPAY_APP_DATE, PackagePrepayFields.REPAY_APP_STATUS,
PackagePrepayFields.OPER_NO, PackagePrepayFields.RET_MSG, PackagePrepayFields.REMARK};
当然，我们如果开发过程中，需要再多个地方使用，这块可以提取出来，作为公共方法。
最后我们看一下查询的方法
PagedList<GenericValue> pagedList = EntityQuery.use(delegator)
.select(columns)
.from(PackagePrepayFields.COM_MESSAGE_INFO_TEXT_THREE)
.where(condList)
.cursorScrollInsensitive()
.queryPagedList(viewIndex - 1, viewSize);
result.put("list", pagedList.getData());
result.put("totalSize", pagedList.getSize());
比较一下不分页的
// 不带分页
List<GenericValue> list =EntityQuery.use(delegator)
.select(columns)
.from(PackagePrepayFields.COM_MESSAGE_INFO_TEXT_THREE)
.where(condList)
.queryList();
顺便看一下服务（方法名称）对应XML的配置
入参
<attribute name="viewSize" type="Integer" mode="IN" optional="true" description="条数" />
<attribute name="viewIndex" type="Integer" mode="IN" optional="true" description="页码" />
出参
<attribute name="returnCode" type="Map" mode="OUT" optional="true" description="标准返回状态数据"/>
<attribute name="totalSize" type="Integer" mode="OUT" optional="true" description="返回总条数" /> <--此处注意出参的大小写 -->
