如何在JpaRepository Spring中找到多个like [英] How to find multiple like in JpaRepository Spring

问题描述

我想在 spring 中使用 JpaRepository 做类似的查询.我找不到路.

i would like to do like query in spring using JpaRepository. i cant find the way.

如果在本机查询中我想要类似的东西

If in native query i want something like

select * from staff where ( 
name like '%param1%' OR
address like '%param1%' OR
staffNo like '%param1%')
order by name limit 10 offset 0

而且我已经成功地将它转换为 JpaRepository 以进行限制和偏移，除了 'like' 函数.我当前的代码:

And i already succeed in convert it into JpaRepository for limit and offset except for 'like' function. My current code:

List<Staff> findByIdNotNull(Pageable pageable);

如何在 JpaRepo 中插入 'multiple like'，我尝试使用 contains 但它即使对一列也不起作用

How to insert 'multiple like' in JpaRepo, i try to use containing but it doesot work even for one column

List<Staff> findByNameContaining(String name, Pageable pageable);

推荐答案

您就快到了.使用多个或查询，如:

You are almost there. Use multiple or queries like:

List<Staff> findByNameContainingOrAddressContainingOrStaffNoContaining(
  String name, String address, int staffNo, Pageable pageable);

通过这种方式，您可以为 like 查询OR 多个条件.确保您具有名为 name、address 和 staffNo 的实体属性.

This way, you can OR more than one conditions for like queries. Make sure you have entity attributes named as name, address and staffNo.

这篇关于如何在JpaRepository Spring中找到多个like的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！