【Mybatis+springBoot】实现模糊查询

• • pojo
  • 数据库
  • Mapper接口类
  • Service
  • ServiceImpl
  • Mapper.xml配置文件
  • Controller
  • 测试
  • 参考资料

package com.yczxyy.paperfree.dto.jhemr;

import io.swagger.annotations.ApiModelProperty;
import lombok.Data;


@Data
public class JobEmrMonitor {
    @ApiModelProperty(value = "监控代码编号")
    private String MONITOR_ITEM_CODE;
    @ApiModelProperty(value = "监控代码名称")
    private String MONITOR_ITEM_NAME;
}

  
    List getMonitor(String MONITOR_ITEM_NAME);

List getMonitor(String MONITOR_ITEM_NAME);

  @Override
    public List getMonitor(String MONITOR_ITEM_NAME) {
        return dmsZhiKongRuleDao.getMonitor(MONITOR_ITEM_NAME);
    }

   
        select MONITOR_ITEM_CODE MONITOR_ITEM_CODE,
               MONITOR_ITEM_NAME MONITOR_ITEM_NAME
        from dms_monitor
        where 1=1
        
        and MONITOR_ITEM_NAME like concat('%',#{MONITOR_ITEM_NAME},'%')
        

在此 SQL 语句中， where 1=1 是多条件拼接时的小技巧， 后面的条件查询就可以都用 and 了。

@ApiOperation("监控代码/名称 字典")
@PostMapping("getMonitorNameAndCode")
public CommonResult getMonitorNameAndCode(@RequestParam(value="MONITOR_ITEM_NAME", required = false) String MONITOR_ITEM_NAME){
    ArrayList list = new ArrayList<>();
    list=(ArrayList) dmsZhiKongRuleService.getMonitor(MONITOR_ITEM_NAME);
    return CommonResult.success(list);

}

1、https://blog.csdn.net/Rice_kil/article/details/83622160
2、https://blog.csdn.net/m0_48814545/article/details/116569516
3、https://blog.csdn.net/fanminghao/article/details/107544056
4、https://blog.csdn.net/qq_43700885/article/details/104148421