使用 Spring CrudRepository 进行不区分大小写的查询

问题描述

使用 Spring CrudRepository 查询；我想选择具有名称"属性的DeviceType"实体.但是以下查询选择区分大小写的权利.我如何使它不区分大小写.谢谢.

With Spring CrudRepository Query; I want to select "DeviceType" entities with it's "name" property. But following query select the entitles on case sensitive manner. How I make it case insensitive way. Thanks.

public interface DeviceTypeRepository extends CrudRepository<DeviceType, Integer>, JpaSpecificationExecutor<DeviceType> {

    public Iterable<DeviceType> findByNameContaining(String name);

}  

推荐答案

正如@Peter 在评论中提到的那样，只需添加 IgnoreCase:

Exactly as @Peter mentioned in the comment, just add IgnoreCase:

public interface DeviceTypeRepository 
    extends CrudRepository<DeviceType, Integer>, JpaSpecificationExecutor<DeviceType> {

    public Iterable<DeviceType> findByNameContainingIgnoreCase(String name);
}  

见文档 获取方法名称中所有受支持关键字的列表.

See documentation for a list of all supported keywords inside method names.

这篇关于使用 Spring CrudRepository 进行不区分大小写的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！