Java实现搜索功能代码详解

//示例代码 请求路径为当前页面路径 "/product" 


  
  

@GetMapping("/product")
  public String list(@RequestParam(required = false,defaultValue = "1",name = "p")Integer pageNo,
            @RequestParam(required = false,defaultValue = "")String productName,
            @RequestParam(required = false,defaultValue = "")String place,
            @RequestParam(required = false,defaultValue = "")Integer typeId,
            @RequestParam(required = false,defaultValue = "")BigDecimal minPrice,
            @RequestParam(required = false,defaultValue = "")BigDecimal maxPrice,
            Model model) {
    Map searchParam = new HashMap<>();
    searchParam.put("productName",productName);
    searchParam.put("place",place);
    searchParam.put("typeId",typeId);
    searchParam.put("minPrice",minPrice);
    searchParam.put("maxPrice",maxPrice);
    PageInfo pageInfo = kaolaService.findByPageNo(pageNo,searchParam);
    model.addAttribute("pageInfo",pageInfo);
    return "product/list";
  }

public PageInfo findByPageNo(Integer pageNo, Map searchParam) {
    PageHelper.startPage(pageNo,10);
    List kaolaList = kaolaMapper.findBySearchParamWithType(searchParam);
    return new PageInfo<>(kaolaList);
}

    SELECT
      kaola.*, kaola_type.id AS 'kaolaType.id',
      kaola_type.type_name AS 'kaolaType.typeName',
      parent_id AS 'kaolaType.parentId'
    FROM
      kaola
    INNER JOIN kaola_type ON kaola.type_id = kaola_type.id
    
      
        kaola.product_name LIKE concat('%',#{productName},'%')
      
      
        and kaola.place = #{place}
      
      
        and kaola.type_id = #{typeId}
      
      
        = #{minPrice} ]]>
      
      
        
      
    
    ORDER BY kaola.id DESC

//分页
$('#pagination-demo').twbsPagination({
  totalPages: ${pageInfo.pages},
  visiblePages: 10,
  first:'首页',
  last:'末页',
  prev:'上一页',
  next:'下一页',
  href:"&＃63;productName="+encodeURIComponent('${param.productName}')+"&place="+encodeURIComponent('${param.place}')
  + "&typeId=${param.typeId}&minPrice=${param.minPrice}&maxPrice=${param.maxPrice}&p={{number}}"
});