spring data jpa中的动态like查询 [英] Dynamic like query in spring data jpa

问题描述

能否在spring data rest中写一个动态查询如下.如果没有，那么如何实现类似的功能:

Can a dynamic query be written in spring data rest as follows. If not then how to achieve a similar functionality:

    @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);

推荐答案

已解决

回购

@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

使用 prop=address 和 prop=screenName 对其进行了测试.工作:)

Tested it with prop=address as well as prop=screenName. Working :)

这篇关于spring data jpa中的动态like查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！