Spring与Jpa整合(10)

Spring与Jpa整合

Keyword Sample

JPQL snippet x.age > ?1

GreaterThanEq

findByAgeGreaterThanEqual

ual After

findByStartDateAfter

where x.age >= ?1 where x.startDate > ?1

where x.startDate < ?1

where x.age is null where x.age not null where x.firstname like ?1 where x.firstname not like ?1 where x.firstname like ?1 (parameter bound with appended %) where x.firstname like ?1 (parameter bound with prepended %) where x.firstname like ?1 (parameter

Before findByStartDateBefore

IsNull findByAgeIsNull

IsNotNull,Not

findByAge(Is)NotNull

Null Like

findByFirstnameLike

NotLike findByFirstnameNotLike

StartingWith findByFirstnameStartingWith

EndingWith findByFirstnameEndingWith

Containing findByFirstnameContaining