动态查询弹簧数据jpa

Question

动态查询可以写入弹簧数据休息如下。如果没有，那么如何实现类似的功能：

@Query("select s from Screen s where s.#searchColumn like:searchValue%") 
    @RestResource(path="byString") 
    Page findAll(
      @Param("searchColumn") String searchColumn, 
      @Param("searchValue") String searchValue, 
      Pageable pageable); 

Answer 1

号春数据JPA支持onlyentityName内基于规划环境地政司查询模板

动态查询变量使用：

• Specifications

• Query by Example

• Querydsl Extension

Answer 2

解决

回购

@Query("select o from Screen o where " 
      + "(o.screenName like :val% and :prop = 'screenName') or " 
      + "(o.address like :val% and :prop = 'address')") 
@RestResource(path="byString") 
Page findAll(
     @Param("prop") String prop, 
     @Param("val") String val, 
     Pageable pageable); 

查询：

/api/screens/search/byString?prop=address&val=a 

与丙=地址以及丙=屏幕名进行了测试。工作:)