在这篇文章中，我们将为您详细介绍使用SpringBootCrudRepository过滤数据的内容，并且讨论关于springboot过滤器的相关问题。此外，我们还会涉及一些关于(转)CrudRepos

在这篇文章中，我们将为您详细介绍使用Spring Boot CrudRepository过滤数据的内容，并且讨论关于spring boot 过滤器的相关问题。此外，我们还会涉及一些关于(转) CrudRepository JpaRepository PagingAndSortingRepository 之间的区别、CityESServiceImpl required a bean of type ''org.spring.springboot.repository.CityRepository'' that could not be found.、java – Spring Boot扩展CrudRepository、java – Spring CrudRepository异常的知识，以帮助您更全面地了解这个主题。

• 使用Spring Boot CrudRepository过滤数据（spring boot 过滤器）
• (转) CrudRepository JpaRepository PagingAndSortingRepository 之间的区别
• CityESServiceImpl required a bean of type ''org.spring.springboot.repository.CityRepository'' that could not be found.
• java – Spring Boot扩展CrudRepository
• java – Spring CrudRepository异常

使用Spring Boot CrudRepository过滤数据（spring boot 过滤器）

我有一个简单的REST服务，可通过Spring boot访问数据CrudRepository。

该存储库已经实现了分页和排序功能，如下所示：

public interface FlightRepository extends CrudRepository<Flight, Long> {  List<Flight> findAll(Pageable pageable);}

调用它：

Sort sort = new Sort(direction, ordering);PageRequest page = new PageRequest(xoffset, xbase, sort);return flightRepo.findAll(page);

我还想向此存储库添加过滤（例如，仅返回带有的实体id > 13 AND id <27）。CrudRepository似乎不支持此功能。有什么方法可以实现这一目标，还是我需要使用其他方法？

感谢您的提示！

答案1

一种替代方案，可以通过标准API或QueryDSL使用规范模式，可以解决您在上述注释中必须为每种参数组合创建查询方法的问题。

出于对以下方面的关注，下面概述了两种方法：

对于更大的应用程序，查询方法的数量可能会增加，这是因为-这是第二点-
查询定义了一组固定的条件。为避免这两个缺点，如果您能提出一组可以动态组合以构建查询的原子谓词，这不是很酷吗？

https://spring.io/blog/2011/04/26/advanced-spring-data-jpa-specifications-
and-querydsl/

我发现QueryDSL易于使用。您只需要定义一个接口方法，然后就可以将参数的任意组合传递给谓词。

例如

public interface UserRepository extends PagingAndSortingRepository<User, Long>, QueryDslPredicateExecutor<User> {    public List<User> findAll(Predicate predicate);}

并查询：

repository.findAll(QUser.user.address.town.eq("Glasgow").and(QUser.user.gender.eq(Gender.M)));repository.findAll(QUser.user.address.town.eq("Edinburgh"));repository.findAll(QUser.user.foreName.eq("Jim"));

其中QUser是QueryDSL自动生成的类。

http://docs.spring.io/spring-
data/jpa/docs/current/api/index.html?org/springframework/data/jpa/repository/support/QueryDslRepositorySupport.html

http://www.querydsl.com/static/querydsl/2.1.0/reference/html/ch02s02.html

更新资料

从Spring Data模块的Gosling版本开始，现在支持从Web应用程序中的HTTP参数自动生成谓词。

https://spring.io/blog/2015/09/04/what-s-new-in-spring-data-release-
gosling#querydsl-web-support

(转) CrudRepository JpaRepository PagingAndSortingRepository 之间的区别

@Entity
public class Product { @Id private long id; private String name; // getters and setters } 

@Repository
public interface ProductRepository extends JpaRepository<Product, Long> { Product findByName(String productName); } 

public interface CrudRepository<T, ID extends Serializable> extends Repository<T, ID> { <S extends T> S save(S entity); T findOne(ID primaryKey); Iterable<T> findAll(); Long count(); void delete(T entity); boolean exists(ID primaryKey); } 

public interface PagingAndSortingRepository<T, ID extends Serializable> extends CrudRepository<T, ID> { Iterable<T> findAll(Sort sort); Page<T> findAll(Pageable pageable); } 

Sort sort = new Sort(new Sort.Order(Direction.ASC, "lastName"));
Pageable pageable = new PageRequest(0, 5, sort); 

public interface JpaRepository<T, ID extends Serializable> extends PagingAndSortingRepository<T, ID> { List<T> findAll(); List<T> findAll(Sort sort); List<T> save(Iterable<? extends T> entities); void flush(); T saveAndFlush(T entity); void deleteInBatch(Iterable<T> entities); } 

CityESServiceImpl required a bean of type ''org.spring.springboot.repository.CityRepository'' that could not be found.

 Bean ''validator'' of type [class org.springframework.validation.beanvalidation.LocalValidatorFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-04-08 13:43:40.636  INFO 9300 --- [           main] s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat initialized with port(s): 8080 (http)
2019-04-08 13:43:40.651  INFO 9300 --- [           main] o.apache.catalina.core.StandardService   : Starting service Tomcat
2019-04-08 13:43:40.652  INFO 9300 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet Engine: Apache Tomcat/8.5.11
2019-04-08 13:43:40.765  INFO 9300 --- [ost-startStop-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2019-04-08 13:43:40.765  INFO 9300 --- [ost-startStop-1] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 1407 ms
2019-04-08 13:43:40.883  INFO 9300 --- [ost-startStop-1] o.s.b.w.servlet.ServletRegistrationBean  : Mapping servlet: ''dispatcherServlet'' to [/]
2019-04-08 13:43:40.887  INFO 9300 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: ''characterEncodingFilter'' to: [/*]
2019-04-08 13:43:40.887  INFO 9300 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: ''hiddenHttpMethodFilter'' to: [/*]
2019-04-08 13:43:40.887  INFO 9300 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: ''httpPutFormContentFilter'' to: [/*]
2019-04-08 13:43:40.887  INFO 9300 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: ''requestContextFilter'' to: [/*]
2019-04-08 13:43:40.937  WARN 9300 --- [           main] ationConfigEmbeddedWebApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ''cityRestController'': Unsatisfied dependency expressed through field ''cityService''; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ''cityESServiceImpl'': Unsatisfied dependency expressed through field ''cityRepository''; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type ''org.spring.springboot.repository.CityRepository'' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}
2019-04-08 13:43:40.943  INFO 9300 --- [           main] utoConfigurationReportLoggingInitializer : 

Error starting ApplicationContext. To display the auto-configuration report re-run your application with ''debug'' enabled.
2019-04-08 13:43:41.017 ERROR 9300 --- [           main] o.s.b.d.LoggingFailureAnalysisReporter   : 

***************************
APPLICATION FAILED TO START
***************************

Description:

Field cityRepository in org.spring.springboot.service.impl.CityESServiceImpl required a bean of type ''org.spring.springboot.repository.CityRepository'' that could not be found.

Action:

Consider defining a bean of type ''org.spring.springboot.repository.CityRepository'' in your configuration.

java – Spring Boot扩展CrudRepository

@Repository
public interface FoobarCrudRepo extends CrudRepository<Foobar,Long> {
}

@Repository
public class FoobarDao {

    @PersistenceContext
    EntityManager em;

    public List<Foobar> findFoobarsByDate(Date date) {
        String sql = "select fb from Foobar fb where createdDate > :date";
        ...
        return query.getResultList();
    }
}

@Repository
public abstract class FoobarCrudRepo extends CrudRepository<Foobar,Long> {

    @PersistenceContext
    EntityManager em;

    public List<Foobar> findFoobarsByDate(Date date) {
        String sql = "select fb from Foobar fb where createdDate > :date";
        ...
        return query.getResultList();
    }

}

interface FoobarRepositoryCustom{
    List<Foobar> findFoobarsByDate(Date date);
}

interface FoobarRepository extends CrudRepository<Foobar,Long>,FoobarRepositoryCustom

public class FoobarRespoitoryImpl implements FoobarRepositoryCustom{
    @PersistenceContext private EntityManager em;


    public List<Foobar> findFoobarsByDate(Date date) {
    String sql = "select fb from Foobar fb where createdDate > :date";
    ...
    return query.getResultList();
    }
}

List<Foobar> findByCreatedDateGreaterThan(Date date);

java – Spring CrudRepository异常

@Repository
public interface IUserRepository extends CrudRepository<User,String> {

}

关于使用Spring Boot CrudRepository过滤数据和spring boot 过滤器的介绍已经告一段落，感谢您的耐心阅读，如果想了解更多关于(转) CrudRepository JpaRepository PagingAndSortingRepository 之间的区别、CityESServiceImpl required a bean of type ''org.spring.springboot.repository.CityRepository'' that could not be found.、java – Spring Boot扩展CrudRepository、java – Spring CrudRepository异常的相关信息，请在本站寻找。