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);
}
网友评论