From aa9eeecfa949d2cb7d1fb72f19693b2975be803f Mon Sep 17 00:00:00 2001 From: fengxiang <110431245@qq.com> Date: Wed, 29 Aug 2018 15:25:48 +0800 Subject: [PATCH] 再次最近24小时aqi接口完善 --- src/main/java/com/moral/common/util/ExampleUtil.java | 149 ++++++++++++++++++++++++++++++++++++------------- 1 files changed, 110 insertions(+), 39 deletions(-) diff --git a/src/main/java/com/moral/common/util/ExampleUtil.java b/src/main/java/com/moral/common/util/ExampleUtil.java index 3fe825c..f5f929c 100644 --- a/src/main/java/com/moral/common/util/ExampleUtil.java +++ b/src/main/java/com/moral/common/util/ExampleUtil.java @@ -1,9 +1,12 @@ package com.moral.common.util; +import com.moral.common.bean.Constants; +import com.moral.common.bean.PageBean; import lombok.extern.log4j.Log4j; import tk.mybatis.mapper.entity.Example; -import java.beans.PropertyDescriptor; + import java.io.UnsupportedEncodingException; +import java.lang.reflect.Field; import java.lang.reflect.InvocationTargetException; import java.lang.reflect.Method; import java.net.URLDecoder; @@ -11,49 +14,88 @@ import java.util.HashMap; import java.util.List; import java.util.Map; +import java.util.concurrent.ConcurrentHashMap; @Log4j public class ExampleUtil { - private final static String OR_SPLIT = "or\\|"; - private final static String CRITERIA_SPLIT = "\\|\\|\\|"; - private final static String CONDITION_SPLIT = "\\|\\|"; - private static Map<String, Method> criteriaMethodMap = null; + private final static String SPLIT = "\\|"; + private final static String OR = "_OR"; + private final static String OR_SPLIT = OR+SPLIT; + private final static String CRITERIA = "_CR"; + private final static String CRITERIA_SPLIT = CRITERIA+SPLIT; + private final static String CONDITION = "_CO"; + private final static String CONDITION_SPLIT = CONDITION+SPLIT; + private static Map<String, Method> criteriaMethodMap = new ConcurrentHashMap<>(); + private static void setOrderByClause(Example example,String orderByClause) throws UnsupportedEncodingException, NoSuchFieldException { + orderByClause = URLDecoder.decode(orderByClause,"UTF-8"); + String[] orderBys = orderByClause.split(CRITERIA_SPLIT); + for(String orderBy : orderBys){ + String[] items = orderBy.split(CONDITION_SPLIT); + if(items.length == 2){ + String property = items[0]; + String sort = items[1]; + if(isPropertyOfClass(example.getEntityClass(),property)){ - public static Example generateExample(Class clzz, String params) { - Example example = new Example(clzz); + if("asc".equals(sort)){ + example.orderBy(property).asc(); + }else{ + example.orderBy(property).desc(); + } + } + } + } + } + public static Example generateExample(Class clazz, PageBean page){ + return generateExample(clazz,false,page); + } + public static Example generateExample(Class clazz, boolean isDelete, PageBean page) { + Example example = null; try { - if(StringUtils.isNullOrEmpty(params)){ return example;} - params = URLDecoder.decode(params, "UTF-8"); - if (!StringUtils.isNullOrEmpty(params) && params.startsWith("or|")) { - String[] criteria = params.trim().split(OR_SPLIT); - Example.Criteria criteriaOfExample = example.or(); - for (String criterion : criteria) { - if (!StringUtils.isNullOrEmpty(criterion)) { - String[] conditions = criterion.trim().split(CRITERIA_SPLIT); - for (String condition : conditions) { - if (!StringUtils.isNullOrEmpty(condition)) { - String[] conditionItems = condition.split(CONDITION_SPLIT); - if (conditionItems != null && conditionItems.length > 1) { - //��������� - String methodName = conditionItems[0]; - //��������� - String propertyName = conditionItems[1]; - Method method = getMethod(methodName); - if (method != null && isPropertyOfClass(clzz, propertyName)) { + String params = page.getQueryParams(); + String orderByClause = page.getOrderByClause(); + example = new Example(clazz); + if(!StringUtils.isNullOrEmpty(orderByClause)){ + setOrderByClause(example,orderByClause); + } + if(!StringUtils.isNullOrEmpty(params)){ + params = URLDecoder.decode(params, "UTF-8"); + if (params.startsWith(OR)) { + String[] criteria = params.trim().split(OR_SPLIT); + for (String criterion : criteria) { + // criterion���null���""������ + if(StringUtils.isNullOrEmpty(criterion)) { continue;}; + Example.Criteria criteriaOfExample = example.or(); + if (!StringUtils.isNullOrEmpty(criterion)) { + String[] conditions = criterion.trim().split(CRITERIA_SPLIT); + for (String condition : conditions) { + if (!StringUtils.isNullOrEmpty(condition)) { + String[] conditionItems = condition.split(CONDITION_SPLIT); + if (conditionItems != null && conditionItems.length > 1) { + //��������� + String methodName = conditionItems[0]; + //��������� + String propertyName = conditionItems[1]; + //������������ List values = new ArrayList<Object>(); if (conditionItems.length > 2) { for (int index = 2; index < conditionItems.length; index++) { values.add(conditionItems[index]); } } - invokeMethod(criteriaOfExample,method,propertyName,values); - } + Method method = getExampleMethod(methodName,values.size()+1); + if (method != null && (methodName.equals("andCondition")||isPropertyOfClass(clazz, propertyName))) { + invokeMethod(criteriaOfExample,method,propertyName,values); + } + } } } } } } + } + if(!isDelete) { + addDeletesToExample(example,clazz); } } catch (Exception ex) { log.error(ex.getMessage()); @@ -92,23 +134,52 @@ } ; - - private static boolean isPropertyOfClass(Class clzz, String propertyName) throws NoSuchFieldException { - return clzz.getDeclaredField(propertyName) != null; + /** + * ������������������������ + * @param example + */ + private static void addDeletesToExample(Example example,Class clzz){ + if(isPropertyOfClass(clzz,"isDelete")) { + List<Example.Criteria> criteriaList = example.getOredCriteria(); + if(criteriaList!=null&&criteriaList.size()>0){ + for(Example.Criteria cri : criteriaList){ + boolean isHasIsDelete = false; + for(Example.Criterion con : cri.getCriteria()){ + if( con.getCondition().indexOf("is_delete") >-1) { + isHasIsDelete = true; + break; + } + } + if( !isHasIsDelete) { + cri.andNotEqualTo("isDelete", Constants.IS_DELETE_TRUE); + } + } + }else { + example.or().andNotEqualTo("isDelete",Constants.IS_DELETE_TRUE); + } + } + } + private static boolean isPropertyOfClass(Class clzz, String propertyName){ + for(Field field : clzz.getDeclaredFields()) { + if(field.getName().equals(propertyName)) { + return true; + } + } + return false; } - private static Method getMethod(String methodName) { - if (criteriaMethodMap == null) { - criteriaMethodMap = new HashMap<>(); + private static Method getExampleMethod(String methodName, int paramCount) { + String criteriaMethodKey = methodName+"_"+String.valueOf(paramCount); + Method methodTemp = criteriaMethodMap.get(criteriaMethodKey); + if(methodTemp==null) { Method[] methods = Example.Criteria.class.getMethods(); - for (Method m : methods) { - Method method = criteriaMethodMap.get(m.getName()); - //��������������������������������� - if (method==null||m.getParameterTypes().length>method.getParameterTypes().length){ - criteriaMethodMap.put(m.getName(),m); + for (Method method : methods) { + if(method.getName().equals(methodName)&&method.getParameterCount() == paramCount) { + criteriaMethodMap.put(criteriaMethodKey,method); + return method; } } } - return criteriaMethodMap.get(methodName); + return methodTemp; } } -- Gitblit v1.8.0