springdatajpa命名规则_spring data jpa 使用方法命名规则查询

按照Spring Data JPA 定义的规则，查询方法以findBy开头，涉及条件查询时，条件的属性用条件关键字连接，要注意的是：条件属性首字母需大写。框架在进行方法名解析时，会先把方法名多余的前缀截取掉，然后对剩下部分进行解析。

Keyword

Sample

JPQL

And

findByLastnameAndFirstname

… where x.lastname = ?1 and x.firstname = ?2

Or

findByLastnameOrFirstname

… where x.lastname = ?1 or x.firstname = ?2

Is,Equals

findByFirstnameIs,

findByFirstnameEquals

… where x.firstname = ?1

Between

findByStartDateBetween

… where x.startDate between ?1 and ?2

LessThan

findByAgeLessThan

… where x.age < ?1

LessThanEqual

findByAgeLessThanEqual

… where x.age ⇐ ?1

GreaterThan

findByAgeGreaterThan

… where x.age > ?1

GreaterThanEqual

findByAgeGreaterThanEqual

… where x.age >= ?1

After

findByStartDateAfter

… where x.startDate > ?1

Before

findByStartDateBefore

… where x.startDate < ?1

IsNull

findByAgeIsNull

… where x.age is null

IsNotNull,NotNull

findByAge(Is)NotNull

… where x.age not null

Like

findByFirstnameLike

… where x.firstname like ?1

NotLike

findByFirstnameNotLike

… where x.firstname not like ?1

StartingWith

findByFirstnameStartingWith

… where x.firstname like ?1 (parameter bound with appended %)

EndingWith

findByFirstnameEndingWith

… where x.firstname like ?1 (parameter bound with prepended %)

Containing

findByFirstnameContaining

… where x.firstname like ?1 (parameter bound wrapped in %)

OrderBy

findByAgeOrderByLastnameDesc

… where x.age = ?1 order by x.lastname desc

Not

findByLastnameNot

… where x.lastname <> ?1

In

findByAgeIn(Collection ages)

… where x.age in ?1

NotIn

findByAgeNotIn(Collection age)

… where x.age not in ?1

TRUE

findByActiveTrue()

… where x.active = true

FALSE

findByActiveFalse()

… where x.active = false

IgnoreCase

findByFirstnameIgnoreCase

… where UPPER(x.firstame) = UPPER(?1)

package com.ytkj.dao;

import com.ytkj.entity.Customer;

import org.springframework.data.jpa.repository.JpaRepository;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;

import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**

* JpaRepository：用来完成基本CRUD操作

* JpaSpecificationExecutor：用于复杂查询(分页等查询操作)

*/

public interface CustomerDao3 extends JpaRepository, JpaSpecificationExecutor {

/**

* 按照Spring Data JPA 定义的规则，查询方法以findBy开头，涉及条件查询时，条件的属性用条件关键字连接，

* 要注意的是：条件属性首字母需大写。框架在进行方法名解析时，会先把方法名多余的前缀截取掉，然后对剩下部分进行解析。

* 方法命名规则查询

* 方法名的约定

* findBy:查询

* 对象中的属性名(首字母大写)：查询的条件

*

*

*/

public Customer findByCustName(String name);

public List findByCustNameLike(String name);

}

importcom.ytkj.dao.CustomerDao3;importcom.ytkj.entity.Customer;importorg.junit.Test;importorg.junit.runner.RunWith;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.test.context.ContextConfiguration;importorg.springframework.test.context.junit4.SpringJUnit4ClassRunner;importjava.util.List;

@RunWith(SpringJUnit4ClassRunner.class)//声明spring提供的单元测试环境

@ContextConfiguration(locations = "classpath:applicationContext.xml")//指定spring容器的配置信息

public classSpringdatajpaMethodTest {

@Autowired

CustomerDao3 customerDao3;

@Testpublic voidfindByName(){

Customer customer= customerDao3.findByCustName("哈哈哈");

System.out.println(customer);

}

@Testpublic voidfindByName2(){

List list = customerDao3.findByCustNameLike("zhe");for (int i=0;i

Customer customer=list.get(i);

System.out.println(customer);

}

}

}

原文：https://www.cnblogs.com/yscec/p/12004187.html