mybatis-plus 实现多条件映射关系查询（范围查询）

1. 案例效果图

根据时间、人均花费、出行天数查询

2. 接收前台传过来的参数

package com.yy.springboot.query;

import lombok.Getter;
import lombok.Setter;

@Setter
@Getter
public class TravelQuery extends  QueryObject{
   
    private String orderBy = "1";
    private Integer travelTimeType = -1;
    private Integer consumeType = -1;
    private Integer dayType = -1;
}

3. 设计条件类

package com.yy.springboot.query;

import lombok.Data;

import java.util.HashMap;
import java.util.Map;

@Data
public class TravelCondition {
   
    private Integer min;
    private Integer max;
    public static final Map<Integer, TravelCondition> DAY_MAP = new HashMap<>();       // 天数
    public static final Map<Integer, TravelCondition> CONSUME_MAP = new HashMap<>(