java - 如何使用 Spring 数据查找集合中每个字符串的所有匹配项

Question

我有一个字符串集合。我需要在数据库中找到包含该字符串的所有文件名。喜欢完全匹配“LIKE(%KEYWORD%)”；

这是我的方法

  Page<FilePdf> getByFileNameContainingInAndExtension(Collection<String> fileNames, String extension, Pageable pageable);

但这给了我一个异常(exception)

Caused by: org.springframework.data.mapping.PropertyReferenceException: No property containing found for type String! Traversed path: FilePdf.fileName.

更新这是我的存储库

 public interface FilePdfRepository extends JpaRepository<FilePdf, Long> {
    Page<FilePdf> getByFileNameContainingInAndExtension(Collection<String> fileNames, String extension, Pageable pageable);
}

这是我的实体

@Entity
@Table(name = "dlfileentry")
public class FilePdf {
    @Id
    @Column(name = "uuid_")
    private String id;
    @Column(name = "fileentryid")
    private Integer fileEntryId;
    @Column(name = "groupid")
    private Integer groupId;
    @Column(name = "filename")
    private String fileName;
    @Column(name = "folderid")
    private Integer folderId;
    @Column(name = "extension")
    private String extension;
}

Answer 1

使用findBy代替getBy

使用in关键字

 public interface FilePdfRepository extends JpaRepository<FilePdf, Long> {
        Page<FilePdf> findByFileNameInAndExtension(Collection<String> fileNames, String extension, Pageable pageable);
    }

参见文档:https://docs.spring.io/spring-data/jpa/docs/1.11.6.RELEASE/reference/html/