本文共 2063 字，大约阅读时间需要 6 分钟。

package com.lyr.easymybatis.repository;import com.lyr.easymybatis.pojo.po.ApiInfoDemo;import org.springframework.data.domain.Pageable;import org.springframework.data.jpa.repository.JpaRepository;import org.springframework.data.jpa.repository.Query;import org.springframework.data.repository.query.Param;import java.util.List;/** * 参考资料： * https://blog.csdn.net/qq_39264897/article/details/105106375 * * * * @Author lyr * @create 2020/12/14 22:32 */public interface ApiInfoDemoRepository extends JpaRepository
   
     {
      /**    * url like    * or    * title like    * or    * markdownInfo like    *    *    * @param searchText    * @return    */   List
    
      findByUrlContainingOrTitleContainingOrMarkdownInfoContaining(String searchText,String searchText2,String txt);   @Query(value = "select a  from ApiInfoDemo a where a.markdownInfo like %:q%" )   List
     
       searchByTxt(@Param("q") String q);}
     
    
   

分页查询：

package com.lyr.easymybatis.repository;import com.lyr.easymybatis.pojo.po.ApiInfoDemo;import org.springframework.data.domain.Pageable;import org.springframework.data.jpa.repository.JpaRepository;import org.springframework.data.jpa.repository.Query;import org.springframework.data.repository.query.Param;import java.util.List;/** * 参考资料： * https://blog.csdn.net/qq_39264897/article/details/105106375 * * * * @Author lyr * @create 2020/12/14 22:32 */public interface ApiInfoDemoRepository extends JpaRepository
   
     {
      /**    * url like    * or    * title like    * or    * markdownInfo like    *    *    * @param searchText    * @return    */   List
    
      findByUrlContainingOrTitleContainingOrMarkdownInfoContaining(String searchText,String searchText2,String txt);   @Query(value = "select a  from ApiInfoDemo a where a.markdownInfo like %:q%" )   List
     
       searchByTxt(@Param("q") String q,Pageable pageable);}@Test    void queryLLL() {
           System.out.println(                apiInfoDemoRepository                .searchByTxt("world",PageRequest.of(0,10))        );    }
     
    
   

注意：要从 第0页开始，外国人从0开始的