1.先看一下报错信息
在这里插入图片描述
2.我的dao层的代码是这么写的

@Repository
public interface DatasRepository extends Neo4jRepository<Datas, Long> {

    @Query(value = "MATCH (e:Datas) WHERE e.dbName = $dbName RETURN e ORDER BY e.dbName, e.name SKIP $skip LIMIT $limit")
    Page<Datas> findByDbName(@Param("dbName") String dbName, Pageable pageable);

}

3.一直提示我说需要一个count query,查了好多资料最后发现正确的写法是这样的:

@Repository
public interface DatasRepository extends Neo4jRepository<Datas, Long> {

    @Query(value = "MATCH (e:Datas) WHERE e.dbName = $dbName RETURN e ORDER BY e.dbName, e.name SKIP $skip LIMIT $limit",
            countQuery = "MATCH (e:Datas) WHERE e.dbName = $dbName RETURN count(e)")
    Page<Datas> findByDbName(@Param("dbName") String dbName, Pageable pageable);

}

这样问题就解决了

更多推荐