| | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import java.lang.reflect.Field; |
| | | import java.lang.reflect.Modifier; |
| | | import java.math.BigDecimal; |
| | | import java.math.BigInteger; |
| | | import java.time.temporal.Temporal; |
| | | import java.util.*; |
| | | |
| | | /** |
| | |
| | | } |
| | | String column = null; |
| | | if (field.isAnnotationPresent(TableField.class)) { |
| | | column = field.getAnnotation(TableField.class).value(); |
| | | TableField tableField = field.getAnnotation(TableField.class); |
| | | if (!tableField.exist()) { |
| | | continue; |
| | | } |
| | | column = tableField.value(); |
| | | } |
| | | if (Cools.isEmpty(column)) { |
| | | column = field.getName(); |
| | |
| | | if (Cools.isEmpty(condition)) { |
| | | return; |
| | | } |
| | | List<String> columns = new ArrayList<>(); |
| | | String keyword = String.valueOf(condition).trim(); |
| | | if (keyword.isEmpty()) { |
| | | return; |
| | | } |
| | | boolean appended = false; |
| | | for (Field field :Cools.getAllFields(cls)){ |
| | | if (Modifier.isFinal(field.getModifiers()) |
| | | || Modifier.isStatic(field.getModifiers()) |
| | |
| | | } |
| | | String column = null; |
| | | if (field.isAnnotationPresent(TableField.class)) { |
| | | column = field.getAnnotation(TableField.class).value(); |
| | | TableField tableField = field.getAnnotation(TableField.class); |
| | | if (!tableField.exist()) { |
| | | continue; |
| | | } |
| | | column = tableField.value(); |
| | | } |
| | | if (Cools.isEmpty(column)) { |
| | | column = field.getName(); |
| | | } |
| | | if (!set.contains(column)) { |
| | | columns.add(column); |
| | | if (supportsLikeSearch(field.getType())) { |
| | | if (!appended) { |
| | | wrapper.andNew(); |
| | | } else { |
| | | wrapper.or(); |
| | | } |
| | | wrapper.like(column, keyword); |
| | | appended = true; |
| | | continue; |
| | | } |
| | | Object exactValue = parseExactSearchValue(field.getType(), keyword); |
| | | if (exactValue != null) { |
| | | if (!appended) { |
| | | wrapper.andNew(); |
| | | } else { |
| | | wrapper.or(); |
| | | } |
| | | wrapper.eq(column, exactValue); |
| | | appended = true; |
| | | } |
| | | } |
| | | } |
| | | if (columns.isEmpty()) { |
| | | return; |
| | | } |
| | | |
| | | private boolean supportsLikeSearch(Class<?> fieldType) { |
| | | return CharSequence.class.isAssignableFrom(fieldType) |
| | | || fieldType == Character.class |
| | | || fieldType == char.class |
| | | || Date.class.isAssignableFrom(fieldType) |
| | | || Temporal.class.isAssignableFrom(fieldType); |
| | | } |
| | | |
| | | private Object parseExactSearchValue(Class<?> fieldType, String keyword) { |
| | | if (!isNumericField(fieldType)) { |
| | | return null; |
| | | } |
| | | for (int i=0;i<columns.size();i++){ |
| | | if (i==0){ |
| | | wrapper.andNew(); |
| | | } else { |
| | | wrapper.or(); |
| | | try { |
| | | BigDecimal numericValue = new BigDecimal(keyword); |
| | | if (fieldType == Integer.class || fieldType == int.class) { |
| | | return numericValue.stripTrailingZeros().scale() <= 0 ? numericValue.intValueExact() : null; |
| | | } |
| | | wrapper.like(columns.get(i), condition); |
| | | if (fieldType == Long.class || fieldType == long.class) { |
| | | return numericValue.stripTrailingZeros().scale() <= 0 ? numericValue.longValueExact() : null; |
| | | } |
| | | if (fieldType == Short.class || fieldType == short.class) { |
| | | return numericValue.stripTrailingZeros().scale() <= 0 ? numericValue.shortValueExact() : null; |
| | | } |
| | | if (fieldType == Byte.class || fieldType == byte.class) { |
| | | return numericValue.stripTrailingZeros().scale() <= 0 ? numericValue.byteValueExact() : null; |
| | | } |
| | | if (fieldType == BigInteger.class) { |
| | | return numericValue.stripTrailingZeros().scale() <= 0 ? numericValue.toBigIntegerExact() : null; |
| | | } |
| | | if (fieldType == Float.class || fieldType == float.class) { |
| | | float value = numericValue.floatValue(); |
| | | return Float.isFinite(value) ? value : null; |
| | | } |
| | | if (fieldType == Double.class || fieldType == double.class) { |
| | | double value = numericValue.doubleValue(); |
| | | return Double.isFinite(value) ? value : null; |
| | | } |
| | | if (fieldType == BigDecimal.class) { |
| | | return numericValue; |
| | | } |
| | | } catch (Exception ignored) { |
| | | return null; |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | private boolean isNumericField(Class<?> fieldType) { |
| | | return Number.class.isAssignableFrom(fieldType) |
| | | || fieldType == byte.class |
| | | || fieldType == short.class |
| | | || fieldType == int.class |
| | | || fieldType == long.class |
| | | || fieldType == float.class |
| | | || fieldType == double.class; |
| | | } |
| | | } |