QueryOP.java
1.54 KB
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
package com.hotent.entity.query;
/**
* 查询字段和值的操作类型枚举
* @author heyifan
* @date 2017年12月12日
*/
public enum QueryOP {
EQUAL("EQ","=","等于"),
EQUAL_IGNORE_CASE("EIC","=","等于忽略大小写"),
LESS("LT","<","小于"),
GREAT("GT",">","大于"),
LESS_EQUAL("LE","<=","小于等于"),
GREAT_EQUAL("GE",">=","大于等于"),
NOT_EQUAL("NE","!=","不等于"),
LIKE("LK","like","相似"),
LEFT_LIKE("LFK","like","左相似"),
RIGHT_LIKE("RHK","like","右相似"),
IS_NULL("ISNULL","is null","为空"),
NOTNULL("NOTNULL","is not null","非空"),
IN("IN","in","在...中"),
NOT_IN("NOTIN","not in","不在...中"),
BETWEEN("BETWEEN","between","在...之间");
private String val;
private String op;
private String desc;
QueryOP(String _val,String _op,String _desc){
val = _val;
op=_op;
desc=_desc;
}
public String value(){
return val;
}
public String op(){
return op;
}
public String desc(){
return desc;
}
/**
* 根据运算符获取QueryOp
* @param op
* @return
* QueryOP
* @exception
* @since 1.0.0
*/
public static QueryOP getByOP(String op){
for(QueryOP queryOP:values()){
if(queryOP.op().equals(op)){
return queryOP;
}
}
return null;
}
public static QueryOP getByVal(String val){
// 前端使用了LIKE 正常来说应该是LK 改了前端可能存在不可预测的问题 暂时先这样解决
if("LIKE".equals(val)){
return LIKE;
}
for(QueryOP queryOP:values()){
if(queryOP.val.equals(val)){
return queryOP;
}
}
return null;
}
}