美文网首页
Spring Data Jpa 分页条件查询

Spring Data Jpa 分页条件查询

作者: 用户zzzzzz | 来源:发表于2019-02-20 14:38 被阅读0次

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);
}

相关文章

网友评论

      本文标题:Spring Data Jpa 分页条件查询

      本文链接:https://www.haomeiwen.com/subject/xalhyqtx.html