背景：

springboot项目，使用mybatis-plus，实现模糊查询

public interface BedequipmentMapper extends BaseMapper<Bedequipment> {
    List<Bedequipment> getEquipmentFrontList(Page<Bedequipment> page,EquipmentQuery equipmentQuery);
}

            parameterType="cn.moonmark.equipmentservice.entity.vo.EquipmentQuery"
            resultType="cn.moonmark.equipmentservice.entity.Bedequipment">
        SELECT
            a.bedEquipmentId,
            a.wirelessMAC,
            a.bedBehaviorTime,
            a.bedBehaviorVersion,
            a.isBed,
            b.bedUpgradeTypeName
        FROM bedequipment a
            LEFT JOIN bedupgradetype b ON a.upgradeType = b.bedUpgradeTypeId
        <where>
            <if test="bedEquipmentId != null and bedEquipmentId != ''">
                and a.bedEquipmentId like concat('%',#{bedEquipmentId},'%')
            </if>
            ...
        </where>
        ORDER BY a.bedBehaviorTime DESC
    </select>

报错点：

BindingException: Parameter 'bedEquipmentId ' not found. Available parameters are [arg1, arg0, param1, param2]

根据报错内容，可以大致知道是参数识别问题。

经过测试，单个参数不影响查询，多个参数会报错。

所以需要在List<Bedequipment> getEquipmentFrontList(Page<Bedequipment> page,EquipmentQuery equipmentQuery);的参数前添加注解 @param

@Component(value = "BedequipmentMapper")
public interface BedequipmentMapper extends BaseMapper<Bedequipment> {
    List<BedequipmentResult> getEquipmentFrontList(Page<BedequipmentResult> page, 
                                                   @Param("query") EquipmentQuery equipmentQuery);
}

即可。