Spring JPA查詢，JPA 根據(jù)方法名字查詢詳細(xì)介紹
JPA 的查詢有很多豐富的API，基本能滿足了所有的基本查詢。下面來想細(xì)說說支持的查詢方式。
根據(jù)方法名字生成SQL語句（根據(jù)方法名查詢）。
public interface UserRepository extends Repository<User, Long> {
List<User> findByEmailAddressAndLastname(String emailAddress, String lastname);
}我們將使用JPA criteria API創(chuàng)建一個(gè)查詢，但本質(zhì)上這轉(zhuǎn)換為以下查詢：
select u from User u where u.emailAddress = ?1 and u.lastname = ?2Spring Data JPA 將執(zhí)行屬性檢查并遍歷屬性表達(dá)式中描述的嵌套屬性。下面是 JPA 支持的關(guān)鍵字的概述，以及包含該關(guān)鍵字的方法的本質(zhì)含義。
SQL關(guān)鍵詞想細(xì)介紹
| 關(guān)鍵詞 | Demo | JPQL 語句片段 |
|---|---|---|
| And | findByLastnameAndFirstname | … where x.lastname = ?1 and x.firstname = ?2 |
| Or | findByLastnameOrFirstname | … where x.lastname = ?1 or x.firstname = ?2 |
| Is,Equals | findByFirstname, 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<Age> ages) | … where x.age in ?1 |
| NotIn | findByAgeNotIn(Collection<Age> 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) |
自己可以各種嘗試。
版權(quán)所屬：SO JSON在線解析
原文地址：http://suancuo.cn/blog/295.html
轉(zhuǎn)載時(shí)必須以鏈接形式注明原始出處及本聲明。
如果本文對你有幫助，那么請你贊助我，讓我更有激情的寫下去，幫助更多的人。
