dao层

@Query(nativeQuery =true,value ="SELECT * FROM lims_lamp l " +
" LEFT JOIN  lims_group g ON  l.group_id=g.id " +
" WHERE (?1 IS NULL OR(?1 IS NOT NULL AND l.name=?1 )) " +
" AND( ?2 IS NULL OR(?2 IS NOT NULL AND l.state=?2 )) " +
" AND( ?3 IS NULL OR(?3 IS NOT NULL AND g.name=?3 ))")
Page queryAll(@Param("lampName") String lampName,@Param("lampState") String lampState,@Param("groupName")String groupName, Pageable pageable);

serviceImpl层

public Page queryAll(String lampName, String lampState, String groupName, Pageable pageable) {
    if (StringUtils.isBlank(lampName)){
      lampName=null;
    }
    if (StringUtils.isBlank(lampState)){
      lampState=null;
    }
    if (StringUtils.isBlank(groupName)){
      groupName=null;
    }
    return lampDao.queryAll(lampName,lampState,groupName,pageable);
}