JPA使用@Query注解 简单的分页查询

简单的分页SQL

@Query(nativeQuery = true, value = "SELECT * FROM company_project WHERE (project_code = :projectCode or :projectCode IS NULL) " + "and (project_name = :projectName or :projectName IS NULL)" + "and (status = :status or :status IS NULL) limit :pageNo,:pageSize ") List<CompanyProject> findByQuery(@Param("projectCode")String projectCode, @Param("projectName")String projectName, @Param("status")Boolean status, @Param("pageNo")Integer pageNo, @Param("pageSize")Integer pageSize);