查询处理类

• 使用json的{}或[]方式进行查询
• 默认传参：matcherFormat

1.实体类查询

• 直接通过entity或params传递查询
• 默认执行and多条件精准查询
• 可以配合查询处理类matcherFormat查询

实体类参数：entity或params

{
    "name" : "名称",
    "value" : 1
}

sql语句

SELECT * FROM `table_name` WHERE `name` = '名称' AND `value` = '1'

2.通用属性匹配器查询

• 通过entity或params传递参数值
• 通过matcherFormat传递通用属性匹配器

实体类参数：entity或params

{
    "name" : "名称",
    "value" : 1
}

序号	查询条件	描述	示例
1	exact	精准查询	name = value
2	contains	模糊查询	name like %value%
3	ignore	忽略查询
4	lowerCase	小写查询	name = LOWER(value)
5	upperCase	大小查询	name = UPPER(value)
6	ignoreCase	忽略大小写查询	name COLLATE utf8_general_ci = value
7	startsWith	开头查询	name like value%
8	endsWith	结尾查询	name like %value
9	in	包含查询（value=['1','2']）	name IN ('1','2')
10	notIn	不包含查询（value=['1','2']）	name NOT IN ('1','2')
11	>、<、>=、<=	数值或时间比较查询	name > value
12	like	模糊查询（自行传入%）	name like value
13	!=	不等于	name <> value
14	isNull	为空	name IS NULL
15	isNotNull	不为空	name IS NOT NULL

查询处理类：matcherFormat

{
    "name":"contains",
    "value":"exact"
}

sql语句

SELECT * FROM `table_name` WHERE `name` like '%名称%' AND `value` = '1'

3.通用属性匹配器传值查询

• 通过matcherFormat传递通用属性匹配器
• 通过{"matcherType":"contains","value":"名称"}传递匹配器和值
• 通过{"matcherType":"contains","value":"名称","field":"name"}传递匹配器和值
• 通过{"matcherType":"contains","value":"名称","field":"extend","json":"$.type"}传递匹配器为json类型

查询处理类：matcherFormat

• 方式一：

{
    "name":{"matcherType":"contains","value":"名称"},
    "value":{"matcherType":"exact","value":"1"}
}

{
    "timeUpdate":{"matcherType":"<","value":"2025-05-29"},
    "timeCreate":{"matcherType":"exact","value":"2025-05-19 18:03:31"}
}

• 方式二：

{
    "无效字段":{"matcherType":"contains","value":"名称","field":"name"},
    "无效字段":{"matcherType":"exact","value":"1","field":"value"}
}

• 方式三：

{
    "无效字段":{"matcherType":"contains","value":"凡图","field":"extend","json":"$.name"},
    "无效字段":{"matcherType":"exact","value":"wxwork","field":"extend","json":"$.type"}
}

sql语句

SELECT * FROM `table_name` WHERE `name` like '%名称%' AND `value` = '1' 
SELECT * FROM `table_name` WHERE (`extend` -> "$.name")  like '%凡图%' AND (`extend` -> "$.type") = 'wxwork'

4.逻辑运算符

• 通过matcherFormat传递对象类型，表示AND组合条件
• 通过matcherFormat传递数组类型，表示OR组合条件

查询处理类：matcherFormat

[
    {
        "value":{"matcherType":"exact","value":"1"}
    },
    {
        "value":{"matcherType":"exact","value":"2"}
    }
]

sql语句

SELECT * FROM `table_name` WHERE `value` = '1' OR `value` = '2'

• 多个逻辑运算符组合

查询处理类：matcherFormat

{
    "name":{"matcherType":"contains","value":"名称"},
    "无效字段":[
        {
            "value":{"matcherType":"exact","value":"1"}
        },
        {
            "value":{"matcherType":"exact","value":"2"}
        }
    ]
}

sql语句

SELECT * FROM `table_name` WHERE `name` like '%名称%' AND  (`value` = '1' OR `value` = '2')