1

zj

2024-06-13 8eea5be3b36875bd4ffe70e6c3a5bb07b1d829bf

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
package com.yami.trading.common.query;
 
import cn.hutool.core.collection.CollectionUtil;
import cn.hutool.core.util.ReflectUtil;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.yami.trading.common.util.RequestUtils;
import org.apache.commons.beanutils.PropertyUtils;
 
import java.lang.reflect.Field;
 
 
public class QueryWrapperGenerator {
 
    public static <T> QueryWrapper<T> buildQueryCondition(T searchObj, Class<T> entityClass) throws Exception{
        QueryWrapper<T> queryWrapper = new QueryWrapper<T>();
 
        Field[] fields = ReflectUtil.getFields ( entityClass );
 
        for (int i = 0; i < fields.length; i++) {
            // 这个是检查类中属性是否含有查询注解
            Field field = fields[i];
            if (field.isAnnotationPresent (Query.class)) {
                // 获取查询注解
                Query annotation = field.getAnnotation (Query.class);
                // 获取查询的字段，如果没设置就使用属性名
                String column = StrUtil.isNotBlank (annotation.tableColumn ()) ? annotation.tableColumn () : StrUtil.toUnderlineCase (field.getName ());
                String fieldName = StrUtil.isNotBlank (annotation.javaField ())? annotation.javaField () : field.getName ();
                // 属性可读且值不为空
                    if (PropertyUtils.getNestedProperty (searchObj, field.getName ()) != null || annotation.type ().equals (QueryType.BETWEEN)) {
                        Object value = PropertyUtils.getNestedProperty (searchObj, fieldName);
                        if (value != null && StrUtil.isNotBlank (value.toString ()) || annotation.type ().equals (QueryType.BETWEEN)) {
                            switch (annotation.type ()) {
                                case EQ:
                                    queryWrapper.eq (column, value);
                                    break;
                                case NE:
                                    queryWrapper.ne (column, value);
                                    break;
                                case GT:
                                    queryWrapper.gt (column, value);
                                    break;
                                case GE:
                                    queryWrapper.ge (column, value);
                                    break;
                                case LT:
                                    queryWrapper.lt (column, value);
                                    break;
                                case LE:
                                    queryWrapper.le (column, value);
                                    break;
                                case BETWEEN: {
                                    Object begin =  RequestUtils.getRequest ().getParameter (  "begin" + StrUtil.upperFirst (fieldName));
                                    Object end =  RequestUtils.getRequest ().getParameter (  "end" + StrUtil.upperFirst (fieldName));
                                    if (begin != null && StrUtil.isNotBlank (begin.toString ()) && end != null && StrUtil.isNotBlank (end.toString ())) {
                                        queryWrapper.between (column, begin, end);
                                    }
                                    break;
                                }
                                case NOTBETWEEN: {
                                    Object begin =  RequestUtils.getRequest ().getParameter (  "begin" + StrUtil.upperFirst (fieldName));
                                    Object end =  RequestUtils.getRequest ().getParameter (  "end" + StrUtil.upperFirst (fieldName));
                                    if (begin != null && StrUtil.isNotBlank (begin.toString ()) && end != null && StrUtil.isNotBlank (end.toString ())) {
                                        queryWrapper.notBetween (column, begin, end);
                                    }
                                    break;
                                }
                                case LIKE:
                                    queryWrapper.like ( column, value );
                                    break;
                                case NOTLIKE:
                                    queryWrapper.notLike ( column, value );
                                    break;
                                case LIKELEFT:
                                    queryWrapper.likeLeft ( column, value );
                                    break;
                                case LIKERIGHT:
                                    queryWrapper.likeRight ( column, value );
                                    break;
 
                                default:
                                    queryWrapper.like (column, value);
 
                            }
                        }
                    }
            }
        }
        return queryWrapper;
    }
 
}